March 23, 2006 at 12:37 pm
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
March 23, 2006 at 2:39 pm
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply