| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2006-08-28 : 00:31:19
|
| Dear experts,i'm getting problem with sql server 2000. actually i changed the service from automatic to manual, right from that day,sql server is not working on my machine.when i checkd in the properties of sql server registration, it is showing some around 8 letter password. actually i will connect with sa and password sa.where should i change the password? is there any other solution?or is it better to uninstall and install again? if so what about my databases?please help me in this regard |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-08-28 : 01:06:18
|
| The service activation shouldn't have anything to do with your SA password. Enterprise Manager or SQL Server Service Manager should be able to tell you if the service is running. If it isn't running, try manually starting it then checking the NT event logs for clues as to why it failed. You shouldn't need to re-install unless you really mess things up.HTH,Tim |
 |
|
|
panthagani
Yak Posting Veteran
58 Posts |
Posted - 2006-08-28 : 01:06:47
|
| Can you elaborate by what you mean by 'not working'? As per what I understand,if SQL server service is not starting when you try to start it, what error do you get? Also, is the account being used a local admin on the server? |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2006-08-28 : 04:11:59
|
| the sql server is not running actually.while trying to start it, it is saying that, "connection could not be established to dev489(it is my server name)""sql server is not exist or access denied". it is also saying "connectionOpen(connect())...""please verify sql server is running and check your registration properties"actually i registerd sql server. |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-08-28 : 04:17:00
|
quote:
Originally posted by sunsanvin
the sql server is not running actually.while trying to start it, it is saying that, "sql server is not existing or access denied". actually i registerd sql server
did you installed it with the windows authentication or both? are you trying to login from same other computer or from the local computer?try login via windows authentication mode?Chirag |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2006-08-28 : 04:29:23
|
| even i tried to login in windows authentication mode.it is saying the same as sql server not exists or access denied |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2006-08-28 : 04:40:21
|
| i installed in both mode.and i'm trying to loging from the local system |
|
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2006-08-28 : 04:49:59
|
| is the MSSQL service running? what credential does the MSSQL SERvice have..is it automatic or manualVic |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-08-28 : 04:53:47
|
| Authentication mode doesn't matter at this level. You need to get the service running properly first. |
|
|
|
panthagani
Yak Posting Veteran
58 Posts |
Posted - 2006-08-28 : 04:58:52
|
| If SQL server credentials (registration) is showing an 8 letter password, looks like SQL Server service is running under a domain account? If so, check if that account is locked or password got changed recently or if the provided password is wrong. |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2006-08-28 : 05:17:37
|
| hi timmy,i didnt get you.how can i make the service running?i'm trying for that only.actually, in services, masqlserver is in "starting" condition. not in "started". i think the problem is with services |
|
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2006-08-28 : 06:32:09
|
| control panel-->admin tools-->services Right click the services and see the Log on properties..all so enable the option to set automatic start upVic |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-08-28 : 17:58:08
|
| Then have a look at the Event log because there will be some info in there as to why it's not starting.Did you change the account under which the service runs? If so, this new account may not have the required permissions. |
|
|
|
|
where should i change password