sql server does not exist or acees denied

Question

Post reply

sql server does not exist or acees denied

cr_mit06001-1129443

SSC Enthusiast

Points: 149
More actions
July 17, 2009 at 8:56 pm

#75505

Hi every one
I am in big problem I have a data base server MS SqL Server 2000 on Windows server 2003 I am using Local Autehentication method means when I login to system I enter the correct username and password of Admin. After this I could easily login and start Sql Server using the Enter prize manager. And Sql Server and Sql server agent were set to auto start with os. There was no need to give any further user name or password.It was all well. But suddenly one day when I tried to re login, the system displayed the message that " One of the service or driver failed during start up...." I clicked ok and when I try to connect Sql Server using Sql Server enterprise manager it gave me the message "[DBNETLIB][ConnectionOpen(Connect()] Sql Server does not exist or access denied" Waiting for your instructions.... to resolve this problem
Regards

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

ps. One Orange Chip Points: 29422 More actions · Answer 1

can you verify if the sql server service is running or not?

Pradeep Singh

Lowell SSC Guru Points: 323518 More actions · Answer 2

I agree with Pradeep ; the issue appears that the service is not running.

log into the server, go to control panel/Administrative Tools/Services, and try to start the SQL service again. IF you get an error, it might be that the account being used to run the service had it's password changed, or something more serious on the server...but it is all at the Server level before SQL server starts.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 3

Be sure that you check the Windows Event Log (System) to see why it didn't start. There should be an entry that gives you a reason.

cr_mit06001-1129443 SSC Enthusiast Points: 149 More actions · Answer 4

Thanks for cosidering my problem....

Yes I veriefied tha Sql server service is not running when I try to start the service it gives the message that " MSSQL service started then stopped.Some services stop automatically if they have no work to do...

When I try to start MSSQL server agent service It gives the message that " Dependency srevice or group failed to start"

When I open the properties of MSSQL SERVER or MSSQL SERVER AGENT and click on the dependency tab it gives message " WMI not found"

please help me further"

ps. One Orange Chip Points: 29422 More actions · Answer 5

I've not faced WMI problem yet. may be you should reinstall it.

THIS url should help you.

Pradeep Singh

RTaylor2208 SSChampion Points: 13298 More actions · Answer 6

Other than the WMI error, could it be that the SQL Server Service (MSSQLSERVER if its a deafult instance) is configured to use a windows account to run the service. If so the account password may have been changed or expired so when the service tries to start it fails. An error message indicating this should appear in the SQL Log and the Event Viewer application log.

MCITP SQL 2005, MCSA SQL 2012