Wow, two months of having to put up with these adds.   My pages just lock some times with these adds.   

Well if SQL Lightspeed is going to screw up...

All

Got it to work. 

It will not work just by checking the standard SQL Server raido button as that will default to the instance that is named the same as the server. ...

My server is configured to accept remote connections. 

TCPIP is enabled

The the ports are open between the machines, but I will try to use the a port setting on the machine.

Thanks

Eric...

Most likely not the problem but you need a new version of the procedure if your working with SQL Server 2005.

Thanks, worked like a charm

We have the same problem when some of my developers insist on using their debugging tools in production.  

The locks start blocking transactions, and the CPU goes down to almost...

One more thing to look at.....

http://support.microsoft.com/default.aspx?scid=kb;en-us;906892

OK, the hardware is the same......wondering if somthing needs a new driver???  Just to be sure, I would test the raw machine performance on both machines using a benchmarking tool.  ...

We had the clients install the FREE 2005 express edition and they now have access to the databases.

Are you using the same hard drives for each install instance?

Johann

There is an old MS bug that gives the same error message.  I dont think that this will help, but might be worth a read. http://support.microsoft.com/kb/833710/

Assuming that the above...

This works, even though it is different from SQL 2000.

It will tell you if you need to reconfigure, and give you a success when it is done

Both of you have a good idea of the metadata, but I have a pratcical security issue along the same line. 

I have a several production databases.  We have client...

I have no idea of what the problem is, but a few things to try.

1. Can you log into the reporting server using the SA password and access the data?  This...

Thanks to all.

The servers are all 2005, so the MS fix didnt work.  By the way, I did have that issue on some of my other machines and the fix works wonderfully.

I...