November 3, 2015 at 4:14 am
Hello,
I really don't work with SQL Server much. I had to move some servers from one building to another and set them back up. After booting up the SQL Server (2000) and went into Server Manager I saw that the databases did not load up/get connected to. And I mean none of the databases, Master, the production database, or any other default databases. I'm certain it is a login issue with the current configuration.
I do know the local user account credentials that have always been used to log into the server. I also know the domain admin account credentials. What I do not know is the sa account, or if that account has ever been used by the server manager to connect to the databases. I don't know which authentication method has been used in the past (Windows only or SQL Server) but neither one of them are currently working for me.
I right click on Local and connect and try to connect using the either of the 2 log in account I know and it tells me to right click on Local and check the registration properties. When I do that all I see are 2 computers on the network that have nothing to do with the server or databases.
I have switched between SQL Server and Windows authentication in Server Manager from the Tools menu. Nothing.
The one thing I just thought of was to right click on the SQL service and look there. I'll try that but not sure what I will find different.
I know I'm not giving a great deal of info here, but it's all I have. I'm not real experienced with sql server configuration. Nobody in the office knows anything at all about it to help me. I did not install or configure this server. It was done by a company that has been out of business now for years. I'm really on my own without much to go on. I do work at this office once every year or 2 so my familiarity with what goes on there is minimal.
All I can say is that there is nothing listed under Local. I know the main log in account for that server and the domain admin. And I have checked the physical database file location and it is there and sql server manager is configured correctly to find that database file. I think backups of the database are non-existent.
If anyone can help with the basic troubleshooting of connecting to the databases I would really appreciate it.
Thanks
November 4, 2015 at 1:22 pm
Anybody have any ideas on this?? I was hoping it would be something simple that many people could help with. Any help would really be appreciated.
November 13, 2015 at 4:45 am
It looks like a network issue. When the servers were moved were they patched into a cabinet that is correctly patched to a switch that in turn can communicate with the domain?
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 13, 2015 at 4:24 pm
I appreciate the reply!! I managed to get a hold of someone who know more than me about it, and that lives a lot closer to the site. He went over and got it fixed. I appreciate it.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply