×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Sql Server Connection issue

Sql Server Connection issue

Sql Server Connection issue

(OP)
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???


RE: Sql Server Connection issue

(OP)
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.

RE: Sql Server Connection issue

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

RE: Sql Server Connection issue

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close