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