Recently moved our SMS2.0 SP2 SQL server to another server.
This server is running SQL2K and I have remote control problems. (Security rights deny access to client).
I understand this may be due to case-sensitive sort order although it doesn't appear to be case sensistive.
My problem is that I want to move it back to the original SQL server and it tells me I can't because it is "... already in use by another SMS site and for performance reasons cannot ..."
Any ideas would be much appreciated!
This server is running SQL2K and I have remote control problems. (Security rights deny access to client).
I understand this may be due to case-sensitive sort order although it doesn't appear to be case sensistive.
My problem is that I want to move it back to the original SQL server and it tells me I can't because it is "... already in use by another SMS site and for performance reasons cannot ..."
Any ideas would be much appreciated!