Remote database connection through internet still not working

I am trying to have a ADO OLEDB connection by the UDL tool. However, it
still reports that there is no SQL server or no permission to access the
server. How can I test whether there was no contact at all or was it a
permission issue ?
I also use a forward URL which is routed by the DNS to the server IP adress.
Could that be the problem ? I enforced not to use the internet IP adress
because the router establishes a LAN connecion (both server and client
resides on same LAN) and doesn't connect through the internet as I figured
out.
Which steps should i perform in the right sequence in order to find the
problem ?
regards,
OscarHi,
I have the same problem but I just want to connect the SQL Server database
in my Windows2003 Server std webserver on my local entreprise manager...
No firewall between the two machines...
Thanks
LJ
www.eztree-msdn.com
"Oscar" <oku@.xs4all.nl> a crit dans le message de
news:4057ab71$0$28004$e4fe514c@.dreader17
.news.xs4all.nl...
> I am trying to have a ADO OLEDB connection by the UDL tool. However, it
> still reports that there is no SQL server or no permission to access the
> server. How can I test whether there was no contact at all or was it a
> permission issue ?
> I also use a forward URL which is routed by the DNS to the server IP
adress.
> Could that be the problem ? I enforced not to use the internet IP adress
> because the router establishes a LAN connecion (both server and client
> resides on same LAN) and doesn't connect through the internet as I figured
> out.
> Which steps should i perform in the right sequence in order to find the
> problem ?
> regards,
> Oscar
>

Remote Connection to SQl Server Express Via ADO

Dear All,

I have TWO PCs, one of them having SQL Server 2005 Express

i get sure the TCP is enables , Active, Remote conneciton is enabled via TCP only

from VS2005 (C#) i can add new sqlconnection contorl and configure it with any of the installed DBs

but when i got to the Other PC with VS2005 as well, i can't configure it

all i can do is to see the server inthe server list.. but NO databases are retieved at all in the Select database drop down menu

any solution or suggestion

Do you use window authentication? Maybe there is a problem with that. Why don't you try creating a database user and try logging in with it?