DBDivaAuto
IS-IT--Management
I have an internal and external SQL Server. The External is working great. I am able to write and read to/from...
The Internal has an IP address and port, I have created Windows users on the server and gave those users security permissions of db.owner / admin. I set up the Connection to reflect the port, allow remote connections, etc (this server works for another piece of appware so I know it's possible), checked the firewall and set rules for the TCP/UDP.
I can Telnet and ODBC into the server from the outside fine. However, when using a connection string in VB/ASP .net it will not work with the IP address/sa credentials (same credentials that do work with Telnet and ODBC). I have also turned on the SQL Server Browser.
Anything I could be missing???
The Internal has an IP address and port, I have created Windows users on the server and gave those users security permissions of db.owner / admin. I set up the Connection to reflect the port, allow remote connections, etc (this server works for another piece of appware so I know it's possible), checked the firewall and set rules for the TCP/UDP.
I can Telnet and ODBC into the server from the outside fine. However, when using a connection string in VB/ASP .net it will not work with the IP address/sa credentials (same credentials that do work with Telnet and ODBC). I have also turned on the SQL Server Browser.
Anything I could be missing???