Sql Server Connection issue

[DBDivaAuto]

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???

 

[gmmastros]

did you enable tcp/ip in configuration manager?

https://technet.microsoft.com/en-us/library/hh231672(v=sql.110).aspx

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[DBDivaAuto]

Yes - of course. I think maybe my internal security is still somehow blocking. I am going to write a mini program and stick it on external server and run it and see if it's that.

 

[gmmastros]

Can you show the connection string you are using?

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[DBDivaAuto]

Public Shared connection2 As String = "server=IPaddress,1433;Database=SAPC;User ID=myuser;Password=myPwd;