Connecting to SQL Server Database

[Chopper]

I am trying to connect to a SQL Server Database on a remote server and I get an error on the connection string.

The information I have is the IP Address, the username and password, and the initial catalogue. The error I get is: Specified SQL Server not found. (so, essentially, it cannot locate the SQL Server with the IP address) I am doing this from my PC and I don't even know where the machine with the database is located.

What information do I need to know to get connected to the SQL server rather than the IP Address? i.e. how do I find out the name to reference the server correctly?

Many thanks,

-Chopper

 

[wushutwist]

IP is all you should need. If you are going thru a firewall then you may have some problems unless a certain port is open. Offhand I can't remember which port SQL Server uses.

Have you tried making a DSN to the SQL Server or installed the SQL Server Client software and testing a connection? Wushutwist

 

[Chopper]

Wushutwist,

I do not have any SQL Server software on my PC. I have been trying to test the connection via a .UDL I created on my desktop. I am doing this at another site, so I will have to wait to try anything out. I will investigate the firewall issue, however. Thank you for your reply, and I will post again if there are any additional problems.

-Chopper