SQL Server does not exist or access denied

Question

Post reply

SQL Server does not exist or access denied

bhushan damle

SSC Journeyman

Points: 96
More actions
January 24, 2005 at 3:08 am

#102363

my sql server 7 stopped working suddenly.
the error is "SQL Server does not exist or access denied", when i try to connect Server.
Please suggest solutions urgently

Viewing 9 posts - 1 through 8 (of 8 total)

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

Umesh Chaphekar SSC Veteran Points: 237 More actions · Answer 1

Hi,

I think is information is insufficient for a reply.

Can you tell me whether you are trying to connect from a client machine or are u working on the server itself.

Was there anything installed on the server. check the event logs. check if the mssql service is running or not.

Any more information that you can provide will be of great help.

Rgds,

Umesh

Umesh Chaphekar

--Every minute you waste someone gains on you ---

bhushan damle SSC Journeyman Points: 96 More actions · Answer 2

Thanks for the reply. I am working on the server itself & the sql service is running already. The problem is that my server named "XYZ" is not running. i.e., when I connect the server by right clicking on the Server icon, the message box appears that says "SQL Server does not ewxist or access denied. I want to know that how this can be repaired or how can I take backup of my all databases those are inside that sql server. Please help....

Umesh Chaphekar SSC Veteran Points: 237 More actions · Answer 3

Hi,

Let me know if you are able to connect using query analyser.

Also try to connect using the Ip of the machine instead of the name.

Check if the server is registered in the client network utility.

umesh

Umesh Chaphekar

--Every minute you waste someone gains on you ---

PBirch SSCrazy Eights Points: 8493 More actions · Answer 4

Is the server set up for Mixed Authentication, or only SQL Server?

Quand on parle du loup, on en voit la queue

Maciej Gapinski Newbie Points: 5 More actions · Answer 5

Are you able to connect your server when you call (local) server instead ofXYZ ?

bhushan damle SSC Journeyman Points: 96 More actions · Answer 6

Thanks u all for the responses. I tried to connect thru query analyser too but there is same error " Server does not exist or access denied" & also it is not connecting with "local".

what can i don now in this situation?

can I backup my data in anyways??

Umesh Chaphekar SSC Veteran Points: 237 More actions · Answer 7

Hi,

Not sure why ur server is down and am not sure as to whether you will be able to backup your data or not.

I can suggest that you copy the .mdf and .ldf files of all the databases to tape or any other location.

You can then reinstall the sql server and then attach the datafiles and logfiles to get back your data.

Upon doing that take full backups.

Hope that helps....

Regards,

Umesh Chaphekar

--Every minute you waste someone gains on you ---

bhushan damle SSC Journeyman Points: 96 More actions · Answer 8

thanks that suggestion must help, i am trying it...

i am going to reinstall my sql server now.