Specify the port along with the IP address e.g. 192.168.1.2,1433.
Where 1433 is the port. Also verify that SQL server allows mixed authentication and the specified port is opened if the conenction is made across the firewall.
Friday, February 10, 2012
Connect to SQL Server 2000 over Internet
I have a SQL Server running at a webserver, that has a public IP. I have been trying to connect to the server over Internet, by ODBC, but can't get it to work. I get the message 'Not a trusted connection'. Any tips that can help ?Is it a SYstemDSN or User DSN?|||It is a User DSN|||
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment