Connecting to server using a static IP

• Erick Gaither-310703

  SSC Veteran

  Points: 222

  More actions

  March 23, 2006 at 12:37 pm

  #90984

  Hello,

  I hope that I can explain this well but if I don't please tell me where I'm not making sense.

  There is a database server outside of our domain/network. We do have access to remote desktop into the server but it requires the use of a static IP address. What I need to do is to allow the Query Analyzer on the local machine to connect to the database server outside of our network. I created a Sql Server account and gave it the appropriate permissions to the database server. I then minimize the remote desktop and try to connect with query analyzer using the sql server account that I created. Query analyer goes through some steps where it verifies that the server is on and running MSSQL Service and then tries to actually connect and then fails saying server does not exist or access denied.

  Ok so where am I going wrong. If I remote into the machine and/or do an nslookup and see the IP address. If the sql server account has the appropriate access. . .

  What am I missing?

  Thanks in advance,

  E

• TimS

  Ten Centuries

  Points: 1165

  More actions

  March 23, 2006 at 2:39 pm

  #628471

  It the server setup to use TCP/IP connections?

  What port is it using?

  Is there a firewall? If so, is the above port open?

  Can you connect locally using the below as server name?

  tcp:127.0.0.1,1433

  1433 is the port number.

  If 127.0.0.1 works try replacing it with the static IP address?

  Tim S