I installed SQL Server 2008 on a workstation running windows 7 SP1. I am trying to connect to the server through the internet using a static IP address and port 1433.
I can connect with this IP address on the same working station through the server management studio. However, when I try connection with a connection string from a remote computer, I get error 40.
If I enter a wrong user or wrong database name, I get a different error, which makes me think that the connection string connects to the server and can identify the database and the user, but does not continue to open the database. My connection string:
Data Source=***.***.**.**,1433;Initial Catalog=Hospital;Integrated
Security=False;User ID=*****;Password=******