SQL Server 2000 - Registration Failed - ConnectionOpen(Connect())

Question

Post reply

SQL Server 2000 - Registration Failed - ConnectionOpen(Connect())

Vairasamy Arunachalam

SSC-Addicted

Points: 422
More actions
May 31, 2006 at 12:20 am

#172723

Dear Sirs,

I am to submit the following query for ur valuabale solution.

We are having Microsoft SQL Server 2000. When we register the server from the clients machines, it couldn't be registered and also given the reply as follows;

SQL Server Enterprise Manager

? SQL Server regiswtration failed becauseof the connection failure displayed below. Do you want to Register anyway?

SQL Server does not exist or access denied.
ConnectionOpen(Connect))

yes no

Kindly provide a solution to solve it.

with regards
arunachalam vs

Viewing 11 posts - 1 through 10 (of 10 total)

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

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 1

is a connectivity problem (could be anything)

- can you ping the sqlserver ?

- provide a correct userid and password for the connection.

- can you connect to the sqlserver using query analyser ?

- can you connect to the sqlserver when you use the server's IPaddress ?

- is it a default instance or a clustered instance ?

- on which port is it listening ?

- can you connect using ipaddress,portno ?

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Vairasamy Arunachalam SSC-Addicted Points: 422 More actions · Answer 2

Dear Sir,

We couldn't connect thro sql query analyzer. It gives the error message as follows.

"Unable to connect the SQL Server"

with regards

arunachalam vs

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 3

- how are you trying to connect ? Windows authenticated or SQL-authenticated ?

- can you ping the sqlserver ?

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Vairasamy Arunachalam SSC-Addicted Points: 422 More actions · Answer 4

We can ping the sql server m/c.

We try to connect thro sql authenticated.

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 5

Did you check case sensitivity ?

If your server is installed case sensitive, .. your userId and password are also case sensitive !

avoid trailing blancs in passwords !

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Vairasamy Arunachalam SSC-Addicted Points: 422 More actions · Answer 6

yes,

we checked the case sensitive. all are small letters.

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 7

can you see the server in the serverlist when you try to register it in SQLserver management console ?

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Vairasamy Arunachalam SSC-Addicted Points: 422 More actions · Answer 8

It is not listed in the server list.

I've tried as follows in the server machine

1. control panel

-->Administrator Tools --> DataSources(ODBC)-->

get one form as "ODBC Data Source administrator "

and select a tab as "System DSN"

add one new data source by the name TEST for the reqd. sql server with sql authentication by giving username and password.

and then get one more form named as "Microsoft SQL Server Login" and issues the error as

Connection filed

SQL State : 01000

SQL Server Error : 11004

[Microsoft] [ODBC SQL Server Driver][TCP/IP sockets][ConnectionOpen(Connect))]

Connection filed

[Microsoft] [ODBC SQL Server Driver][TCP/IP sockets] Specified SQL Server Not found

.../

Johan Bijnens SSC Guru Points: 135369 More actions · Answer 9

is it running behind a firrewall or in another domain than the client ?

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Abdul Naushad Newbie Points: 7 More actions · Answer 10

If you are running SQL Server2000, i think your problem is due to a registered bug. Check out the below link.

http://support.microsoft.com/kb/306865