Tuesday, February 14, 2012

Connect with TCP

Hello,
I hope I'm posting this in the right group.
I'm trying to connect to a network server running Sql Server 2005 Express
from vb 2005. I can connect to it when I use:
DATA SOURCE=<servername>\SQLEXPRESS;INITIAL CATALOG=<cat>;Integrated
Security=SSPI;
However I need to be able to connect to it from the internet using TCP. I
have openned port 1433 on my firewall. I have set the server to allow remote
connections and it still comes back with an error when i trie to connect. I
have even tried using this on my local network. Here is my connection string
:
Data Source=192.168.0.xxx,1433;Network Library=DBMSSOCN;Initial
Catalog=<cat>;User ID=<user>;Password=<password>;
Any help would be appreciated.Figured it out. Might help if I use the correct IP Address!
"Jason" wrote:

> Hello,
> I hope I'm posting this in the right group.
> I'm trying to connect to a network server running Sql Server 2005 Express
> from vb 2005. I can connect to it when I use:
> DATA SOURCE=<servername>\SQLEXPRESS;INITIAL CATALOG=<cat>;Integrated
> Security=SSPI;
> However I need to be able to connect to it from the internet using TCP. I
> have openned port 1433 on my firewall. I have set the server to allow remo
te
> connections and it still comes back with an error when i trie to connect.
I
> have even tried using this on my local network. Here is my connection stri
ng:
> Data Source=192.168.0.xxx,1433;Network Library=DBMSSOCN;Initial
> Catalog=<cat>;User ID=<user>;Password=<password>;
> Any help would be appreciated.
>

No comments:

Post a Comment