Rdysan
asked on
SQL Server question - How do I start SQL Server Enterprise Manager?
Hi there,
I am trying to check or reset my SQL server password. According to these instructions below, it would seem to be quite easy:
******
To reset the sa password, you can make the following:
1. Login to the SQL Server box as the Administrator.
2. Run SQL Server Enterprise Manager.
3. Right-click the server name and choose 'Edit SQL Server Registration properties'.
4. Choose 'Use Windows authentication' and click OK button.
5. Expand a server, expand a Security and click Logins.
6. Double-click the sa login and specify new password on the General tab.
******
Howver, I can't seem to find a way to get into or run the SQL Server Enterprise Manager. Can anyome tell me where this is located (i.e. start\program\administarti
Alternatively, is there a command I can use in the dos prompt box, like the "msconfig" command to bring up the Manager?
Thanks!
I am trying to check or reset my SQL server password. According to these instructions below, it would seem to be quite easy:
******
To reset the sa password, you can make the following:
1. Login to the SQL Server box as the Administrator.
2. Run SQL Server Enterprise Manager.
3. Right-click the server name and choose 'Edit SQL Server Registration properties'.
4. Choose 'Use Windows authentication' and click OK button.
5. Expand a server, expand a Security and click Logins.
6. Double-click the sa login and specify new password on the General tab.
******
Howver, I can't seem to find a way to get into or run the SQL Server Enterprise Manager. Can anyome tell me where this is located (i.e. start\program\administarti
Alternatively, is there a command I can use in the dos prompt box, like the "msconfig" command to bring up the Manager?
Thanks!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Ok guys,
I appreciate that this answers the q, but to be cheeky, this brings up the SQL Service Manager box, but (looking at the info above to change a pw) I'm not sure how I use it.
There are two drop down boxes (Server and Services) neither of which has anything in or in dropdown. Then there is the Refresh Services tab, and the Star, Pause and Stop.
Ther's a piccie of a PC with a white circle and the box "auto start service when OS starts" is not ticked.
Under that it says
Not Connected - \\
Is SQL running or not? There doesn't seem to be any way to run through the instructions to change the pw here.
Any ideas?
Thanks!
I appreciate that this answers the q, but to be cheeky, this brings up the SQL Service Manager box, but (looking at the info above to change a pw) I'm not sure how I use it.
There are two drop down boxes (Server and Services) neither of which has anything in or in dropdown. Then there is the Refresh Services tab, and the Star, Pause and Stop.
Ther's a piccie of a PC with a white circle and the box "auto start service when OS starts" is not ticked.
Under that it says
Not Connected - \\
Is SQL running or not? There doesn't seem to be any way to run through the instructions to change the pw here.
Any ideas?
Thanks!
That is not SQL Enterprise Manager. That is SQL Service Manager.
The original path for the .MSC file was correct for a default installation.
C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC
You may need to change the folder location if SQL was installed to another location.
Also, is it possible that someone moved the .MSC file from that location to their desktop instead of creating a shortcut?
Are you a local admin on the machine? Try searching for that file "SQL Server Enterprise Manager.MSC"
The original path for the .MSC file was correct for a default installation.
C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC
You may need to change the folder location if SQL was installed to another location.
Also, is it possible that someone moved the .MSC file from that location to their desktop instead of creating a shortcut?
Are you a local admin on the machine? Try searching for that file "SQL Server Enterprise Manager.MSC"
ASKER
Hi robrandon,
I am a local admin on the machine (i.e. I am at the server and logged in as Administrator). I don't think it's possible that someone moved the file. We are a small company (one server, 2 standalones and 3 mobiles) and I'm the only one with any real PC knowledge (albeit paltry). I did a search for 'SQL Server Enterprise Manager.MSC' but the system says it can't find it. Searched system and hidden files as well, BTW.
The reason for the query is that we are having a new phone system installed which includes software that integrates with Outlook and allows TAPI dialling from within OL. When the phone chap tried to install the software it needed SQL server to run and couldn't open SQL server on this machine. He brought his own copy of SQL server to install but said he thought we had it on the server already and thus didn't want to mess up whatever SQL does on our machine.
see
https://www.experts-exchange.com/questions/21298876/SQL-Server-password-problems-wrt-NEC-MyPhone-installation.html
if you need more. No one has responded to that question - maybe I posted it in the wrong place!
I am a local admin on the machine (i.e. I am at the server and logged in as Administrator). I don't think it's possible that someone moved the file. We are a small company (one server, 2 standalones and 3 mobiles) and I'm the only one with any real PC knowledge (albeit paltry). I did a search for 'SQL Server Enterprise Manager.MSC' but the system says it can't find it. Searched system and hidden files as well, BTW.
The reason for the query is that we are having a new phone system installed which includes software that integrates with Outlook and allows TAPI dialling from within OL. When the phone chap tried to install the software it needed SQL server to run and couldn't open SQL server on this machine. He brought his own copy of SQL server to install but said he thought we had it on the server already and thus didn't want to mess up whatever SQL does on our machine.
see
https://www.experts-exchange.com/questions/21298876/SQL-Server-password-problems-wrt-NEC-MyPhone-installation.html
if you need more. No one has responded to that question - maybe I posted it in the wrong place!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you have the MSDE version, than you DON'T have the SQL Enterprise Manager !!!!
Best Regards !
Best Regards !
The default SA password for MSDE is null
For MSDE you can change the SA password by...
From the command prompt use the command line version of the graphical SQL query analyzer called Osql.Exe by typing the following:
Osql -P
At this point you are now in the Command line Query analyzer and will be presented with the 1> prompt.
From here type the following:
Exec Sp_Password NULL, newpassword, ‘Sa’
Then press the ‘Enter’ or return key to execute the command.
You are then presented with the 2> prompt. From here type the word Go and press the Enter key once again.
The Qsql utility will inform you that the password was changed and you will once again be presented with the 1> prompt.
Type the word ‘Quit’ to exit the utility and be returned to the C:\ Prompt.
Then type ‘Exit’ as normal to close the command prompt window.
Hope this helps,
-J
For MSDE you can change the SA password by...
From the command prompt use the command line version of the graphical SQL query analyzer called Osql.Exe by typing the following:
Osql -P
At this point you are now in the Command line Query analyzer and will be presented with the 1> prompt.
From here type the following:
Exec Sp_Password NULL, newpassword, ‘Sa’
Then press the ‘Enter’ or return key to execute the command.
You are then presented with the 2> prompt. From here type the word Go and press the Enter key once again.
The Qsql utility will inform you that the password was changed and you will once again be presented with the 1> prompt.
Type the word ‘Quit’ to exit the utility and be returned to the C:\ Prompt.
Then type ‘Exit’ as normal to close the command prompt window.
Hope this helps,
-J
ASKER
Thanks everyone - I'm back at home now but will check this on the server in the office tomorrow and report back
Cheers.....rdysan
Cheers.....rdysan
ASKER
Hi again all,
Well, I looked in Add/Remove Programs and "Microsoft SQL Server Desktop Engine (SBS Monitoring)" is there along with "Microsoft SQL Server Desktop Engine (SHAREPOINT)". so I guess it is MSDE hat is installed.
I tried to change the p/w, as per Juice841's instructions and when I input Osql -P it comes back with:
Error: No User selected. Try with -U or -E switches
I tried with the -U switch and it returned:
Error: Invalid usage of parameter -U
I tried with the -E switch and it thought about it for a couple of seconds and then returned:
[Shared Memory]SQL server does not exist or access denied
[Shared Memory]ConnectionOpen <Connect<>>
Bearing in mind the phone chap can install the basic version of SQL what are the chances that it will mess something up with MSDE? Any ideas whether the two can happily co-inhabit?
robradon - the PC is running Acronis TrueImage - could this be what MSDE is there for? Other than that the system is pretty simple. Just SBS Server 2003 Standard, Office 2003 and a couple of normal progs (Acrobat etc.).
Many thanks everyone! I really appreciate the help!
rdysan
Well, I looked in Add/Remove Programs and "Microsoft SQL Server Desktop Engine (SBS Monitoring)" is there along with "Microsoft SQL Server Desktop Engine (SHAREPOINT)". so I guess it is MSDE hat is installed.
I tried to change the p/w, as per Juice841's instructions and when I input Osql -P it comes back with:
Error: No User selected. Try with -U or -E switches
I tried with the -U switch and it returned:
Error: Invalid usage of parameter -U
I tried with the -E switch and it thought about it for a couple of seconds and then returned:
[Shared Memory]SQL server does not exist or access denied
[Shared Memory]ConnectionOpen <Connect<>>
Bearing in mind the phone chap can install the basic version of SQL what are the chances that it will mess something up with MSDE? Any ideas whether the two can happily co-inhabit?
robradon - the PC is running Acronis TrueImage - could this be what MSDE is there for? Other than that the system is pretty simple. Just SBS Server 2003 Standard, Office 2003 and a couple of normal progs (Acrobat etc.).
Many thanks everyone! I really appreciate the help!
rdysan
Do you have Sharepoint installed? Sharepoint uses MSDE.
Maybe you can try logging on with your administrator credentials:
Osql -U Administrator -P <your administrator password>
See if that gets you in to a prompt. If it does, just post back. I wouldn't change any passwords yet.
Maybe you can try logging on with your administrator credentials:
Osql -U Administrator -P <your administrator password>
See if that gets you in to a prompt. If it does, just post back. I wouldn't change any passwords yet.
ASKER
Hi robrandon,
Tried that and it thought about it for 30 seconds or so and then returned:
[Shared Memory]SQL server does not exist or access denied
[Shared Memory]ConnectionOpen <Connect<>>
Do you know what this means, or what it's trying to tell me?
Cheers...rdysan
Tried that and it thought about it for 30 seconds or so and then returned:
[Shared Memory]SQL server does not exist or access denied
[Shared Memory]ConnectionOpen <Connect<>>
Do you know what this means, or what it's trying to tell me?
Cheers...rdysan
I'm guessing either the user doesn't exist or the password is bad.
Try Administrator again with a blank password. Also try your DomainName\Administrator with that password and with a blank password.
Try Administrator again with a blank password. Also try your DomainName\Administrator with that password and with a blank password.
ASKER
Hi robrandon,
This all results in the same error (as above). So, final question, if I may. If thuis phone chap installs SQL proper (as we seem to be thinking that I only have this MSDE), what are the possibilities it could cause problems with the system?
many thanks!
This all results in the same error (as above). So, final question, if I may. If thuis phone chap installs SQL proper (as we seem to be thinking that I only have this MSDE), what are the possibilities it could cause problems with the system?
many thanks!
Oh boy. Not sure at all. I have had more than one instance of SQL installed on a single box before, but neither of them were MSDE. I don't want to lead you into doing something wrong. Sorry.
ASKER
Hi robrandon,
I'm going to close this now. Thanks very much for all your help. I don't think there is a cut and dried answer here, but really appreciate your help.
Cheers....Rdysan
I'm going to close this now. Thanks very much for all your help. I don't think there is a cut and dried answer here, but really appreciate your help.
Cheers....Rdysan
ASKER
Thanks for getting back to me. No, I don't have microsoft sql server visible in start >programs>.
However, following your paths I have
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlma
should I run this? Is this the SQL server interface?
Thanks!