Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shekhar_dba
Starting Member
39 Posts |
 Posted - 2006-11-20 : 14:32:25
|
| hi guru'sI am new to sql server ... i have install sql server 2000 and register local host in it a week ago. today when i login my system then found that sql server is not runing. it gives the following errorA connection could not be established to local host.Reason: sql server does not exist or accss denied.connectionOpen (connect ()).. i have also checked all the properties of server but dibnt find any thing wrong.... please advice what should i do to rectify this problem.thanksshekhar |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-11-20 : 14:39:02
|
| Is the MSSQL service running? |
 |
|
|
shekhar_dba
Starting Member
39 Posts |
Posted - 2006-11-20 : 14:41:03
|
no service is not running. it shows stop sign. i have refresh it many times but same results..quote:
Originally posted by mcrowley
Is the MSSQL service running?
|
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-11-20 : 15:10:08
|
| What happens when you try to start the service? |
|
|
|
shekhar_dba
Starting Member
39 Posts |
Posted - 2006-11-20 : 15:11:57
|
it gives the same error messege .... sql server does not exists or access denied (connectionOpen ())quote:
Originally posted by mcrowley
What happens when you try to start the service?
|
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-11-20 : 15:42:29
|
| So, you go to Control Panel->Administrative tools->services, scroll down the list to MSSQLServer, hit start, and it comes up with that error? What is in the SQL Server errorlog? |
|
|
|
monty
Posting Yak Master
130 Posts |
Posted - 2006-11-22 : 00:24:32
|
| Hi Shekhar,1)first check whether there is any connectivity or not.2)then click start->run->type services.msc and then scroll down to see if your MSSql server service is up followed by sql server agent service... make sure the start up account has admin rights...let me know if this helps ...else list the steps which you have tried out in detail, i shall try to dig in further.its me monty |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-11-22 : 01:56:29
|
| When you installed MS SQL, did you choose mixed authentication or windows.And if you chose, mixed, did you at anytime change the password ? This could cause login failure |
|
|
|
|
|
|
server error (connection open)