Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I can't seem to get this to work. I have an IP address for a SQL Server. I have a login and password.

How can I connect to it and work with it?

share|improve this question

migrated from stackoverflow.com Feb 13 '10 at 7:15

This question came from our site for professional and enthusiast programmers.

    
Why can't you get it to work? Do you get an error? –  Rhapsody Feb 11 '10 at 13:07
    
Where is this SQL Server? On the same network as you? –  CodeByMoonlight Feb 11 '10 at 13:10
    
How are you trying to connect? If you're using something like ADO.Net, what does your connection string look like? –  Rowland Shaw Feb 11 '10 at 13:24
    
The sql server is somewhere down town. I'm connecting through the internet. I'm trying to connect with the management studio connect object explorer. The error msg says that the server wasnt found. –  eski Feb 11 '10 at 13:31

2 Answers 2

That is a typical scenario and if you are having trouble there is something off on the server side.

The server may not have tcp/ip exposed. You will want to talk to whomever is responsible for administering the server.

Also, make sure there are no port filters blocking 1433 on your side or server side i.e. firewalls.

share|improve this answer

Check with you hosting provider or the company you're working with and find out what port the server is running on. Once that is known you should be able to use the IP and port number to connect with Management Studio and your username/password.

In the server name field put the IP+comma+Port like so:

4.2.2.2,1433 (assuming your IP is 4.2.2.2 and the port number is 1433)

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.