Connection open Error

Question

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

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

David Scotland-132255 SSCertifiable Points: 5599 More actions · Answer 1

The develope & express versions of sql server do not by default allow remote connections.

Start sql server configuration manager, expand sql server network configuration, click protocols for...

Then on right hand side right click tcp/ip and enable then restart the sql server

hth

david

sanRajan SSC Rookie Points: 37 More actions · Answer 2

Thanks David.

I am using Standard edition and tcp/ip is enabled.

Still unable to connect.

David Scotland-132255 SSCertifiable Points: 5599 More actions · Answer 3

Have you checked your firewall rules? as thats the other usual candidate

David

sanRajan SSC Rookie Points: 37 More actions · Answer 4

Firewalls are disabled.

Last week i have installed sucessfully SQL server on another server and moved it to production with out any issues.

Its so weird that this server is giving such errors.

MohammedU SSCoach Points: 19644 More actions · Answer 5

MohammedU
Microsoft SQL Server MVP

sanRajan SSC Rookie Points: 37 More actions · Answer 6

Hey i am running SQL server 2000 sp4.

I have checked all the steps in the troubleshooting and they are configured as listed and still i am unable to connect.

Can some one say what's this error and when do we get?

SQL server does not exist or access denied: connection open: connect()

sanRajan SSC Rookie Points: 37 More actions · Answer 7

I deleted and reinstalled the whole thing, it works now.

Thanks all for your time.