A new update. The System Administrator for the client was able to login as either of the user's that were failing and everything worked from his...
The user connected from home using VPN, and still has everything worked fine. It is definitely caused by them being on a different domain, as best as...
I'm hoping this may be a domain issue, the user should test tonight from her home pc, last time she used her work laptop from home.
I VPNed in using this user's login and still did not get this error, but she tried from home and got the same error. Any ideas on what to try would...
just as a test, see if it works if you are an administrator on the box
This for a user logged in via VPN. I have been able to log in locally as this user and it works fine. She has created a very simple report....
Recreated the table, everything is running fast now
3 indexes on target table, no triggers, breaking up the query did not help. I did notice the database(this is a development database) was set to grow...
The following insert query is taking around 7 minutes to handle 4000 rows. The select runs in less than a second. At the end of the run it gets a...
No resolution to this issue, I just had to set the user up on another machine same configuration, everything worked.
When one of our users clicks the ReportBuilder button, it asks him if he wants to run the installation, then nothing seems to happen. There are no...
Yes, since this would be the key that would be queried
Thanks I will give this a try
I have a task where I need to call about 7 stored procedures for each company in our database. The stored procs need to be called in a different...
Make sure you are running dtexec instead of dtsrun if this is a true SSIS package dtexec /DTS "MSDBProcess HubPDS" /SERVER msisql /MAXCONCURRENT " -1...
I'm not thrilled with the solution, but I have everything running now. I just recreated the Website under a different name and everything works.
FYI, this is machine is running SQL Server 2005 Database services and Reporting Services, but also 2000 Database.
I have configured Reporting Services on 2 servers, on one everything runs fine and reports can be generated. On the other, I get the following error...
We were able to resolve this issue. The Network DTC was turned off on Windows 2003.
We have an issue where a COM+ component is calling a Stored Procedure in SQL 2000. The Stored Procedure makes a call to a Linked Server table on a...
Separate names with a comma.
