469,337 Members | 5,957 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,337 developers. It's quick & easy.

Remote connection Problem With SQL 2005 Thru VB Application

Hi guys,

Any one is there to help me?

I have problem remotely connecting SQL 2005 thru my VB Aplication.

I have set up a SQL Server 2005 to use for testing before moving to another production server.

I have set it to to allow remote connections and use TCP IP only and have opened TCP port 1433 on the Windows XP firewall and am using the SQL Sever on Port UDP 3544 Also the Server Browser service is running. The server is connected directly to the internet on a static IP (eg. 10.0.0.3)

When I try to connect to the database on another computer it fails.


Thanks for any insight


Riyaz
Aug 15 '07 #1
8 1978
Purple
404 Expert 256MB
Hi Riyaz,

Can you clarify - the remote server is remote ? Do you mean outside your Lan ie on the internet ? Or do you mean remote - not running on your local machine ie localhost ?

Regards Purple
Aug 15 '07 #2
Hi Riyaz,

Can you clarify - the remote server is remote ? Do you mean outside your Lan ie on the internet ? Or do you mean remote - not running on your local machine ie localhost ?

Regards Purple
Dear Purple,

My Server Name is "Server" I need connect Via Internet, out side Lan remotely also would like to connect Lan as well.

Previously I am using SQL 2000 I used following connection string to connect database inside Lan.

OpenConnection = Ado_Open(MSSQLConnString("Server", "xxx", "xxx", "xxxxx"))

Best regards,
Riyaz
Aug 15 '07 #3
Purple
404 Expert 256MB
Can you connect to the database when you are inside the Lan or have you no connection to the database server at all ?

Purple
Aug 15 '07 #4
Can you connect to the database when you are inside the Lan or have you no connection to the database server at all ?

Purple
Hi Parple,


Not yet my first SQL Server 2005 connection i am trying to establish via internet. Also I would like to know connect Lan.

Thanks!

Regards,
Riyaz
Aug 15 '07 #5
Purple
404 Expert 256MB
Hi,

Could I suggest you try it the other way round, if you sort out the connection across the LAN and then have problems via internet we will know its firewall / network issues.

Starting outside the local network we could be chasing problems on network config / security / database.

How are you planning to make the connection from the internet ?

Regards Purple
Aug 15 '07 #6
Hi,

Could I suggest you try it the other way round, if you sort out the connection across the LAN and then have problems via internet we will know its firewall / network issues.

Starting outside the local network we could be chasing problems on network config / security / database.

How are you planning to make the connection from the internet ?

Regards Purple
hi,
here are some details
have set it to to allow remote connections and use TCP IP only and have opened TCP port 1433 on the Windows XP firewall and am using the SQL Sever on Port UDP 3544 Also the Server Browser service is running. The server is connected directly to the internet on a static IP (eg. 10.0.0.3)

thanks and regards
riyaz
Aug 15 '07 #7
Purple
404 Expert 256MB
Hi riyaz,

I suggest you follow my earlier post and get the connection working from inside the Lan first - it will make problem solving when you try from the internet so much simpler, basically we will be left with networking and access issues.

Regards Purple
Aug 15 '07 #8
Hi riyaz,

I suggest you follow my earlier post and get the connection working from inside the Lan first - it will make problem solving when you try from the internet so much simpler, basically we will be left with networking and access issues.

Regards Purple

Hi,

Thanks will try

riyaz
Aug 16 '07 #9

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Mitya Mitriev | last post: by
2 posts views Thread by Tor Inge Rislaa | last post: by
4 posts views Thread by VB Programmer | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.