Is it possible to connect to my local SQL Server 2005 database from a
remote web server? If yes, what ConnectionStrin g do I use?
Thanks,
Ron
remote web server? If yes, what ConnectionStrin g do I use?
Thanks,
Ron
-
-
Re: Connect To Local SQL Server DB From Remote Server
RN1 wrote:This should be helpful:Is it possible to connect to my local SQL Server 2005 database from a
remote web server? If yes, what ConnectionStrin g do I use?
>
Thanks,
>
Ron
How to configure SQL Server 2005 to allow remove connections:
How to configure Express to accept remote connections:
--
Göran Andersson
_____
-
Re: Connect To Local SQL Server DB From Remote Server
Sure, but the server will need to connect to your machine IP address. Are
they on the same local network?
--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
"RN1" <rn5a@rediffmai l.comwrote in message
news:bdc038ee-2af5-429d-b637-b70b579d0926@n3 3g2000pri.googl egroups.com...Is it possible to connect to my local SQL Server 2005 database from a
remote web server? If yes, what ConnectionStrin g do I use?
>
Thanks,
>
Ron
Comment
-
Re: Connect To Local SQL Server DB From Remote Server
On Aug 20, 6:39 pm, Göran Andersson <gu...@guffa.co mwrote:Thanks Goran for the prompt response. I had already gone through the 2RN1 wrote:>Is it possible to connect to my local SQL Server 2005 database from a
remote web server? If yes, what ConnectionStrin g do I use?>Thanks,>Ron
This should be helpful:
>
How to configure SQL Server 2005 to allow remove connections:http://support.microsoft.com/default...b;EN-US;914277
>
How to configure Express to accept remote connections:http://blogs.msdn.com/sqlexpress/arc...05/415084.aspx
>
--
Göran Andersson
_____http://www.guffa.com
articles before posting my question. Actually my main intention is to
connect to a remote SQL Server 2005 dataabse from my local SSMS but am
not able to do so inspite of following all the steps that have been
stated in the 2 articles (& numerous other articles as well). I even
tried telnetting to the remote SQL Server but it generates an error
saying that "could not open port 1433".
This is the reason why I want to connect to my local SQL Server 2005
DB from the remote web server which is why I need the ConnectionStrin g
to connect to my local SQL Server DB from the remote web server. As
such, to connect to my local SQL Server 2005 DB from my local web
server, I use the following ConnectionStrin g in ASP.NET pages:
sqlConn = New SqlConnection(" Data Source=RON\SQLE XPRESS;Initial
Catalog=MyDB;In tegrated Security=True")
But the above won't work with the ASP.NET pages in the remote web
server. I have gone through the ConnectionStrin gs at www.connectionstrings.com
but couldn't find anything relevant.
Could you please help me out with the ConnectionStrin g?
Thanks,
Ron
Comment
-
Re: Connect To Local SQL Server DB From Remote Server
On Aug 20, 6:40 pm, "Eliyahu Goldin"
<REMOVEALLCAPIT ALSeEgGoldD...@ mMvVpPsS.orgwro te:Sure, but the server will need to connect to your machine IP address. Are
they on the same local network?
>
--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]http://msmvps.com/blogs/egoldinhttp://usableasp.net
>
"RN1" <r...@rediffmai l.comwrote in message
>
news:bdc038ee-2af5-429d-b637-b70b579d0926@n3 3g2000pri.googl egroups.com...
>
>
>>Is it possible to connect to my local SQL Server 2005 database from a
remote web server? If yes, what ConnectionStrin g do I use?>Thanks,>Ron- Hide quoted text -
- Show quoted text -Sorry I didn't get you. What do you mean by "server" here - local SQL>Sure, but the server will need to connect to your machine IP address. Are
>they on the same local network?
Server, local web server, remote SQL Server or remote web server?
Ron
Comment
-
Re: Connect To Local SQL Server DB From Remote Server
RN1 wrote:Do you have any firewalls, on your computer, between your computer andOn Aug 20, 6:39 pm, Göran Andersson <gu...@guffa.co mwrote:>>RN1 wrote:>This should be helpful:>>Is it possible to connect to my local SQL Server 2005 database from a
>>remote web server? If yes, what ConnectionStrin g do I use?
>>Thanks,
>>Ron
>>
>How to configure SQL Server 2005 to allow remove connections:http://support.microsoft.com/default...b;EN-US;914277
>>
>How to configure Express to accept remote connections:http://blogs.msdn.com/sqlexpress/arc...05/415084.aspx
>>
>--
>Göran Andersson
>_____http://www.guffa.com
Thanks Goran for the prompt response. I had already gone through the 2
articles before posting my question. Actually my main intention is to
connect to a remote SQL Server 2005 dataabse from my local SSMS but am
not able to do so inspite of following all the steps that have been
stated in the 2 articles (& numerous other articles as well). I even
tried telnetting to the remote SQL Server but it generates an error
saying that "could not open port 1433".
>
This is the reason why I want to connect to my local SQL Server 2005
DB from the remote web server which is why I need the ConnectionStrin g
to connect to my local SQL Server DB from the remote web server. As
such, to connect to my local SQL Server 2005 DB from my local web
server, I use the following ConnectionStrin g in ASP.NET pages:
>
sqlConn = New SqlConnection(" Data Source=RON\SQLE XPRESS;Initial
Catalog=MyDB;In tegrated Security=True")
>
But the above won't work with the ASP.NET pages in the remote web
server. I have gone through the ConnectionStrin gs at www.connectionstrings.com
but couldn't find anything relevant.
>
Could you please help me out with the ConnectionStrin g?
>
Thanks,
>
Ron
the network, or between the network and the server?
Are your computer on the same local network as the server? Otherwise you
have to specify your IP address in the connection string instead of the
computer name "RON".
If you get a local IP adrress by DHCP, you can browse to a site like
http://www.whatismyip.com/ to get your external IP address.
--
Göran Andersson
_____
Comment
-
Re: Connect To Local SQL Server DB From Remote Server
On Aug 20, 8:33 pm, Göran Andersson <gu...@guffa.co mwrote:RN1 wrote:>On Aug 20, 6:39 pm, Göran Andersson <gu...@guffa.co mwrote:RN1 wrote:
>Is it possible to connect to my local SQL Server 2005 database from a
>remote web server? If yes, what ConnectionStrin g do I use?
>Thanks,
>Ron
This should be helpful:>How to configure SQL Server 2005 to allow remove connections:http://support.microsoft.com/default...b;EN-US;914277>How to configure Express to accept remote connections:http://blogs.msdn.com/sqlexpress/arc...05/415084.aspx>--
Göran Andersson
_____http://www.guffa.com>Thanks Goran for the prompt response. I had already gone through the 2
articles before posting my question. Actually my main intention is to
connect to a remote SQL Server 2005 dataabse from my local SSMS but am
not able to do so inspite of following all the steps that have been
stated in the 2 articles (& numerous other articles as well). I even
tried telnetting to the remote SQL Server but it generates an error
saying that "could not open port 1433".>This is the reason why I want to connect to my local SQL Server 2005
DB from the remote web server which is why I need the ConnectionStrin g
to connect to my local SQL Server DB from the remote web server. As
such, to connect to my local SQL Server 2005 DB from my local web
server, I use the following ConnectionStrin g in ASP.NET pages:>sqlConn = New SqlConnection(" Data Source=RON\SQLE XPRESS;Initial
Catalog=MyDB;In tegrated Security=True")>But the above won't work with the ASP.NET pages in the remote web
server. I have gone through the ConnectionStrin gs atwww.connectio nstrings.com
but couldn't find anything relevant.>Could you please help me out with the ConnectionStrin g?>Thanks,>Ron
Do you have any firewalls, on your computer, between your computer and
the network, or between the network and the server?
>
Are your computer on the same local network as the server? Otherwise you
have to specify your IP address in the connection string instead of the
computer name "RON".
>
If you get a local IP adrress by DHCP, you can browse to a site likehttp://www.whatismyip. com/to get your external IP address.
>
--
Göran Andersson
_____http://www.guffa.com- Hide quoted text -
>
- Show quoted text -No>Are your computer on the same local network as the server?
>Otherwise you
>have to specify your IP address in the connection string instead of the
>computer name "RON".I don't get a local IP address by DHCP (I figured this out by running>If you get a local IP adrress by DHCP, you can browse to a site like
>http://www.whatismyip.com/ to get your external IP address.
the command - ipconfig /all - & the output showed that it is not DHCP
enabled). I browsed to www.whatismyip.com & I used the IP address it
generated instead of "RON" in the ConnectionStrin g but I still
couldn't make the ASP.NET page residing in the remote web server
connect to my local SQL Server. It generated an error saying "Error
locating Server/Instance specified".
I also browsed to http://www.chamisplace.com/asp/info.asp?f=ip to
cross-check the IP generated by whatismyip.com but the former
generated the same IP address as the latter.
What could be the problem now?
Thanks,
Ron
Comment
-
Re: Connect To Local SQL Server DB From Remote Server
"RN1" <rn5a@rediffmai l.comwrote in message
news:bdc038ee-2af5-429d-b637-b70b579d0926@n3 3g2000pri.googl egroups.com...What is your local IP address? If it's 192.x.x.x or similar, it won't work.Is it possible to connect to my local SQL Server 2005 database from a
remote web server? If yes, what ConnectionStrin g do I use?
>
Thanks,
>
Ron
That's an internal network address. Are you at home? Do you go through
Comcast or a similar ISP? Probably won't work either. From the remote
machine, at a minimum, it will need to be able to ping your IP. Your SQL
instance needs to be on a hosted server with a public-facing IP address.
Comment
Comment