| Author |
Topic |
|
aimer5
Starting Member
8 Posts |
 Posted - 2007-09-17 : 20:45:02
|
| I am running a default instance of SQL Server and a named instance. I was able to connect on client machine via odbc to both instances with no problem. Administrator password has now been changed. I am still able to connect to the default instance but now can't connect to the named instance. I thought it might have something to do with the password change, but if that was the case would I be able to connect to the default instance?? Maybe something in the named instance setup? Like I said I can hit the default instance just fine. Have tried removing the old odbc connection and adding a new one, but still can't connect. Any ideas? Can it be as simple as restarting the server? |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-17 : 20:46:26
|
What happens when you try to connect, are there any errors?
Future guru in the making. |
 |
|
|
aimer5
Starting Member
8 Posts |
Posted - 2007-09-17 : 20:49:59
|
| Yes, I'm home now, so I'm trying to remember. Can't start sspi....not sure if I got that right. Sorry. |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-17 : 20:52:40
|
quote:
Originally posted by aimer5
Yes, I'm home now, so I'm trying to remember. Can't start sspi....not sure if I got that right. Sorry.
Sounds like either you didn't update the password on the service for that instance, or it was updated but the service wasn't restarted.
Future guru in the making. |
|
|
|
aimer5
Starting Member
8 Posts |
Posted - 2007-09-17 : 20:55:45
|
| So if I just go into Security on that instance and change the password I'll be OK? Why wouldn't I have to do that on the default instance? |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-17 : 20:59:27
|
quote:
Originally posted by aimer5
So if I just go into Security on that instance and change the password I'll be OK? Why wouldn't I have to do that on the default instance?
I was actually referring to the service accounts, do you know if the service was running using the account for which the password changed?
Future guru in the making. |
|
|
|
aimer5
Starting Member
8 Posts |
Posted - 2007-09-17 : 21:03:43
|
| so you mean the sa password. Actually I don't know. The person who did the install is now gone. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-09-17 : 21:09:24
|
quote:
Originally posted by aimer5
so you mean the sa password. Actually I don't know. The person who did the install is now gone.
Zoroaster is asking about the windows account that SQL server (both the named instance and the default instance) run under. I am assuming that is the login that you changed. If you changed the SA account only, it would only apply to the instance you changed it on. Since the SA accounts are separate from instance to instance (even on the same box).-ec |
|
|
|
aimer5
Starting Member
8 Posts |
Posted - 2007-09-17 : 21:11:18
|
| Yes the windows account is the one that was changed. |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-17 : 21:18:01
|
quote:
Originally posted by aimer5
Yes the windows account is the one that was changed.
Alright, the default instance and the named instance each have separate services. You may want to check to see if the services for your named instance are set to use the account that had the password changed and ensure that the password is updated and the service restarted. It may be that you have different accounts used for the different services which would explain the disparity.
Future guru in the making. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-09-17 : 21:18:39
|
quote:
Originally posted by aimer5
Yes the windows account is the one that was changed.
did you restart your server or restart both instances of SQL Server after changing the password? If not, then the SQL process is running under a user context that thinks the old password is still valid.Did you update the password in the services control panel for both instances of SQL Server? If you didn't, then the old password will still be in there and the instance will not startup.-ec |
|
|
|
aimer5
Starting Member
8 Posts |
Posted - 2007-09-17 : 21:21:08
|
| OK...I will try that tomorrow. Thanks. |
|
|
|
aimer5
Starting Member
8 Posts |
Posted - 2007-09-17 : 21:29:35
|
| I didn't restart the server or restart both instances of SQL Server after the password change, nor did I update the password in the services control panel for both instances. The admin password change was done remotely from the head of IT in another city because my boss left. So if you please tell me what to do I'll do it. Unfortunately he doesn't deal with SQL Server |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-09-17 : 21:39:40
|
quote:
Originally posted by aimer5
I didn't restart the server or restart both instances of SQL Server after the password change, nor did I update the password in the services control panel for both instances. The admin password change was done remotely from the head of IT in another city because my boss left. So if you please tell me what to do I'll do it. Unfortunately he doesn't deal with SQL Server
Here is a KB article that covers how to do this http://support.microsoft.com/kb/282254-ec |
|
|
|
aimer5
Starting Member
8 Posts |
Posted - 2007-09-17 : 21:51:08
|
| Thanks. |
|
|
|
|
Named Instance of SQL Server 2000