dubbi47
asked on
Lost access to SQL 2000 database Management
We recently RE-Configured our network (removed ALL servers and wkstns from one domain and created a new one). Previous support person set it up incorrectly as well as having some problems with AD that we could not fix.
We have a Microsoft SQL 2000 server running on one of the member servers (windows 2003 std). The SQL services are running and the custom software appears to be working.. HOWEVER, when we start the Enterprise Management console, the SQL server and databases do not appear. How do we reconnect so that we can access and manage the databases? Can we create a new group without causing a problem the current services that are running? I am not familiar with the working of sql2000.
We have a Microsoft SQL 2000 server running on one of the member servers (windows 2003 std). The SQL services are running and the custom software appears to be working.. HOWEVER, when we start the Enterprise Management console, the SQL server and databases do not appear. How do we reconnect so that we can access and manage the databases? Can we create a new group without causing a problem the current services that are running? I am not familiar with the working of sql2000.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I agree... it was a LONG time ago... I inherited this problem... We are trying to move to SQL 2008 but I still need this server and access to it for a bit longer...
When I start the Enterprise Manager, it shows NO SQL servers. (Microsoft SQL Servers, Server Group, No items). There is no option to LOGIN. Would that be in the Server group? Can I create a new server group without causing the database to stop working... I have people working and do not want disrupt the daily activities...
When I start the Enterprise Manager, it shows NO SQL servers. (Microsoft SQL Servers, Server Group, No items). There is no option to LOGIN. Would that be in the Server group? Can I create a new server group without causing the database to stop working... I have people working and do not want disrupt the daily activities...
ASKER
jacko72 - Thank you... Can I do this during working hours, or should I wait until everyone is off the system?
It won't affect users at all so it can be done during working hours
Hopefully, I am on the right track....
Is the SQL server set to be "mixed mode authentication"? This means logins can be accepted from AD and SQL server specific logins.
I suspect the application you have is using SQL authentication, when you run Enterprise Manager as your NT account, it has no rights to show you the databases.
Do you know the SQL login and password that the application uses?
When you get this, open enterprise manager, log in as "Sql Authentication" I think it is called, rather than Windows authentication and put in the sa login and PW if you know it, or try the application SQL username and PW.
I hope this helps.
T