can not connect.

Question

can not connect.

Stacey

SSCommitted

Points: 1766
More actions
January 18, 2007 at 7:33 am

#117070

We have a server (DOG) that I can ping and remote connect to, but I can not connect with SQL Server Management Studio or any other query tool. I know it is somthing simple that I am just not seeing. Any suggestions

Thanks

Stacey W. A. Gregerson

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

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

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 1

Stacey

Are you running SSMS on the server or remotely? If remotely, is there a firewall between the two computers? What is the authentication mode of the server, and how are you trying to connect (trusted Windows login or SQL Server login)? Any error messages?

John

Stacey SSCommitted Points: 1766 More actions · Answer 2

The server is a local server on the inside of the firewall. I have tried both SQL and Windows logins and I can not see it. I can not browse for it either.

Stacey W. A. Gregerson

Rich Hansell SSCrazy Points: 2346 More actions · Answer 3

Rich Hansell

SSCrazy

Points: 2346

January 18, 2007 at 8:14 am

#684023

Can you telnet to the box on port 1433?

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 4

Stacey

If I understand what you're saying, you're trying to connect from a computer on the same network as the server. Have you looked at the Server/Client Network Utilities (or whatever the 2005 equivalent is) to check that they're both using the same protocol? What happens if you try to connect using SSMS on the server?

John

Paul Rubel Ten Centuries Points: 1047 More actions · Answer 5

Make sure Allow Remote Questions is checked in the Connection Properties. You'll have to log on locally.

Stacey SSCommitted Points: 1766 More actions · Answer 6

First i would like to thank all of those that offered help. It turns out that the Network team has been making changes and forgetting to let us know. They will be assisting me in finding out what they have done.

Thanks again for your help.

Stacey W. A. Gregerson

Stacey SSCommitted Points: 1766 More actions · Answer 7

Okay, I can now connect but in the object explorer the status is blank. The indicator next to the server name is blank instead of red or green.

Any ideas?

Stacey W. A. Gregerson

Rich Hansell SSCrazy Points: 2346 More actions · Answer 8

I would first terminal into the box and fire up SSMS locally to see that everything is running correctly. If yes, then I would check that you're access is set up correctly, then I would check the Surface Area Config Manager to make sure you have remote connections enabled (Start\Programs\MSSql 2005\Configuration tools\Surface area config..)You could also check the SQL Server COnfiguration manager to make sure you have TCP\IP and or Named Pipes enabled.

Rich