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

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

Quote:

Originally Posted by Purple

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|||Can you connect to the database when you are inside the Lan or have you no connection to the database server at all ?

Purple|||

Quote:

Originally Posted by Purple

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

Quote:

Originally Posted by Purple

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

Quote:

Originally Posted by Purple

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