May 13, 2009 at 5:09 am
Apologies for the first post stating it was SQL 2005, it is in fact SQL 2000.
Our Network administrator has just moved a Dev server containing SQL Server 2000 from a workgroup onto a domain.
We can still connect to this server if we are on the server itself, however if we attempt to remote login to the server it will not allow us to login from enterprise manager/Management Studio or by any other method.
I believe there is some access/rights issue here that needs to be sorted out or some internal systable entry that needs updating.
Does anyone have any pointers or tips?
May 13, 2009 at 5:18 am
Update we can now connect using enterprise manager, and query analyser but users that have SQL Server Management Studio cannot connect which is now the main cause of our problems.
May 13, 2009 at 5:34 am
Post your error messages, everything you see.
May 13, 2009 at 6:54 am
Did the actual machine name change as a part of moving it onto the domain?
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply