Connection over Internet

Is it possible to connect EM to a remote server that is not on a LAN or WAN?
Thanks.
Hi
You would need to start EM on the machine itself if there are no network
connections.
John
"Vik" wrote:

> Is it possible to connect EM to a remote server that is not on a LAN or WAN?
> Thanks.
>
>
|||Hi
The previous reply assumed that there isn't a VPN connection! If there is
then you should be able to connect it if the ports correct ports are open on
the firewall. http://support.microsoft.com/kb/287932
You could also try using the web administrator
http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:14E75EEC-6134-43BF-AE4D-56C4D74E28BF@.microsoft.com...[vbcol=seagreen]
> Hi
> You would need to start EM on the machine itself if there are no network
> connections.
> John
> "Vik" wrote:
sqlsql

Connection over internet

I need to connect to a sql server through the internet.
Inside the LAN everything works great, but if try to connect from a pc
outside the lan over the internet I get an error message saying SQLstate
01000 and SQL state 08001 error 17.
What's wrong ?
Thank You since now to anyone can help me
Bye
Paolo
Gian,
How are you addressing the SQL Server? The external IP address should be
different to the one on your LAN. I personally would not be comfortable
with my SQL Server accessible over the internet.
1. Make sure that the correct ports are open on your firewall.
2. Check that SQL Server is listening on TCP/IP, and the port number
3. For named instances set up an alias and "hard code" the port using
the Server Network Utility.
4. Do not allow access through port 1434 on the firewall.
Take a look at this article also:
Potential causes of the "SQL Server does not exist or access denied"
error message
http://support.microsoft.com/?id=328306
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Gian Paolo Piscopo wrote:
> I need to connect to a sql server through the internet.
> Inside the LAN everything works great, but if try to connect from a pc
> outside the lan over the internet I get an error message saying SQLstate
> 01000 and SQL state 08001 error 17.
> What's wrong ?
> Thank You since now to anyone can help me
> Bye
> Paolo
>
|||Hi
There are a few things you'll have to check.
1. Have you got a route from your external PC into the SQL server.? If you
connect via an IP address, you'll have to make sure that this IP address has
a route through your FireWall. If you connect via a name, you'll have to
make sure that this name is bound to the correct IP address.
2. Have you opened the right ports in your FireWall? By default SQL server
uses port 1433, so you need to have a rule in your FireWall that allows this
traffic.
Also, it might help if you tell how you try to connect to the server - with
EM, QA or an application?
Regards
Steen
Gian Paolo Piscopo wrote:
> I need to connect to a sql server through the internet.
> Inside the LAN everything works great, but if try to connect from a pc
> outside the lan over the internet I get an error message saying
> SQLstate 01000 and SQL state 08001 error 17.
> What's wrong ?
> Thank You since now to anyone can help me
> Bye
> Paolo

Connection over internet

I need to connect to a sql server through the internet.
Inside the LAN everything works great, but if try to connect from a pc
outside the lan over the internet I get an error message saying SQLstate
01000 and SQL state 08001 error 17.
What's wrong '
Thank You since now to anyone can help me
Bye
PaoloGian,
How are you addressing the SQL Server? The external IP address should be
different to the one on your LAN. I personally would not be comfortable
with my SQL Server accessible over the internet.
1. Make sure that the correct ports are open on your firewall.
2. Check that SQL Server is listening on TCP/IP, and the port number
3. For named instances set up an alias and "hard code" the port using
the Server Network Utility.
4. Do not allow access through port 1434 on the firewall.
Take a look at this article also:
Potential causes of the "SQL Server does not exist or access denied"
error message
http://support.microsoft.com/?id=328306
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Gian Paolo Piscopo wrote:
> I need to connect to a sql server through the internet.
> Inside the LAN everything works great, but if try to connect from a pc
> outside the lan over the internet I get an error message saying SQLstate
> 01000 and SQL state 08001 error 17.
> What's wrong '
> Thank You since now to anyone can help me
> Bye
> Paolo
>|||Hi
There are a few things you'll have to check.
1. Have you got a route from your external PC into the SQL server.? If you
connect via an IP address, you'll have to make sure that this IP address has
a route through your FireWall. If you connect via a name, you'll have to
make sure that this name is bound to the correct IP address.
2. Have you opened the right ports in your FireWall? By default SQL server
uses port 1433, so you need to have a rule in your FireWall that allows this
traffic.
Also, it might help if you tell how you try to connect to the server - with
EM, QA or an application?
Regards
Steen
Gian Paolo Piscopo wrote:
> I need to connect to a sql server through the internet.
> Inside the LAN everything works great, but if try to connect from a pc
> outside the lan over the internet I get an error message saying
> SQLstate 01000 and SQL state 08001 error 17.
> What's wrong '
> Thank You since now to anyone can help me
> Bye
> Paolo

Connection over internet

I need to connect to a sql server through the internet.
Inside the LAN everything works great, but if try to connect from a pc
outside the lan over the internet I get an error message saying SQLstate
01000 and SQL state 08001 error 17.
What's wrong '
Thank You since now to anyone can help me
Bye
PaoloGian,
How are you addressing the SQL Server? The external IP address should be
different to the one on your LAN. I personally would not be comfortable
with my SQL Server accessible over the internet.
1. Make sure that the correct ports are open on your firewall.
2. Check that SQL Server is listening on TCP/IP, and the port number
3. For named instances set up an alias and "hard code" the port using
the Server Network Utility.
4. Do not allow access through port 1434 on the firewall.
Take a look at this article also:
Potential causes of the "SQL Server does not exist or access denied"
error message
http://support.microsoft.com/?id=328306
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Gian Paolo Piscopo wrote:
> I need to connect to a sql server through the internet.
> Inside the LAN everything works great, but if try to connect from a pc
> outside the lan over the internet I get an error message saying SQLstate
> 01000 and SQL state 08001 error 17.
> What's wrong '
> Thank You since now to anyone can help me
> Bye
> Paolo
>|||Hi
There are a few things you'll have to check.
1. Have you got a route from your external PC into the SQL server.? If you
connect via an IP address, you'll have to make sure that this IP address has
a route through your FireWall. If you connect via a name, you'll have to
make sure that this name is bound to the correct IP address.
2. Have you opened the right ports in your FireWall? By default SQL server
uses port 1433, so you need to have a rule in your FireWall that allows this
traffic.
Also, it might help if you tell how you try to connect to the server - with
EM, QA or an application?
Regards
Steen
Gian Paolo Piscopo wrote:
> I need to connect to a sql server through the internet.
> Inside the LAN everything works great, but if try to connect from a pc
> outside the lan over the internet I get an error message saying
> SQLstate 01000 and SQL state 08001 error 17.
> What's wrong '
> Thank You since now to anyone can help me
> Bye
> Paolo

Connection over Internet

Is it possible to connect EM to a remote server that is not on a LAN or WAN?
Thanks.Hi
You would need to start EM on the machine itself if there are no network
connections.
John
"Vik" wrote:
> Is it possible to connect EM to a remote server that is not on a LAN or WAN?
> Thanks.
>
>|||Hi
The previous reply assumed that there isn't a VPN connection! If there is
then you should be able to connect it if the ports correct ports are open on
the firewall. http://support.microsoft.com/kb/287932
You could also try using the web administrator
http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en
John
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:14E75EEC-6134-43BF-AE4D-56C4D74E28BF@.microsoft.com...
> Hi
> You would need to start EM on the machine itself if there are no network
> connections.
> John
> "Vik" wrote:
>> Is it possible to connect EM to a remote server that is not on a LAN or
>> WAN?
>> Thanks.
>>

connection failed when using IP address

I am trying to connect to MSDE 2000a server over the internet. I have check
and open the ports on my router pointing it to my server (1433 & 1434). But
I am still not able to connect. (Check log and port is 1433)
Does anyone know what I can try or do to resolve this problem (I have all th
e latest patches)?Hi,
Execute "srvnetcn.exe" from command prompt from the server running MSDE. In
the display scrren,
verify that tcp/ip and named pipes are enabled for the MSDE instance. If
not, enable them and then stop and
start MSDE service and try again.
Thanks
Hari
MCDBA
"dee" <anonymous@.discussions.microsoft.com> wrote in message
news:D6817B6C-6392-4BC6-9D8A-A80D9400A264@.microsoft.com...
> I am trying to connect to MSDE 2000a server over the internet. I have
check and open the ports on my router pointing it to my server (1433 &
1434). But I am still not able to connect. (Check log and port is 1433)
> Does anyone know what I can try or do to resolve this problem (I have all
the latest patches)?

connection failed when using IP address

I am trying to connect to MSDE 2000a server over the internet. I have check and open the ports on my router pointing it to my server (1433 & 1434). But I am still not able to connect. (Check log and port is 1433)
Does anyone know what I can try or do to resolve this problem (I have all the latest patches)?
Hi,
Execute "srvnetcn.exe" from command prompt from the server running MSDE. In
the display scrren,
verify that tcp/ip and named pipes are enabled for the MSDE instance. If
not, enable them and then stop and
start MSDE service and try again.
Thanks
Hari
MCDBA
"dee" <anonymous@.discussions.microsoft.com> wrote in message
news:D6817B6C-6392-4BC6-9D8A-A80D9400A264@.microsoft.com...
> I am trying to connect to MSDE 2000a server over the internet. I have
check and open the ports on my router pointing it to my server (1433 &
1434). But I am still not able to connect. (Check log and port is 1433)
> Does anyone know what I can try or do to resolve this problem (I have all
the latest patches)?

Connecting via Internet to an SQL-Server

Hi everyone, i created a web site in ASP with a connection to an Sql-Server database. All of this is on a web server. I made an administration site in parallel to put in soime new article but i need more. I need to be able to communicate with Sql-Server from my office with a VB 6 application. I don't have any problem with a lan connection over our network to test my app but and don't have any idea how to easily connect the remote database who lives outside the network.

Ghislain TanguayI created a web site in ASP with a connection to an Sql-Server database. ... I don't have any idea how to easily connect the remote database who lives outside the network.

There are several ways to do it. If your firewall and so forth will permit the traffic to go through, you can connect to any server if you know its IP-address.

But you should never use an un-encrypted connection when the Internet is your channel! SSL tunneling, Virtual Private Networking (VPN), and so-forth will provide a reasonably secure communications vehicle for your traffic. You'll find info on these topics at support.microsoft.com or msdn.microsoft.com.|||Child's play. The server name is the IP Address or URL. Also, your database has to support SQL Server authentication: Where you can get away with not specifying a User ID and Password on your network, you're going to have to specify one on the 'net.

ServerName: 256.256.256.256 or MyServer.Domain.Com.
Password: "XXXXXXXX"
UserID: "XXXXXXXXX"

It wouldn't hurt to change the default port to something other than 1433: Sql Server is a high risk on that port.|||You can use the Client Network Utility as well.

Go To Client Network Utility. Go to Alias Tab.
Click on ADD. Provide a Alias Name, and the Server IP address or the URL as Server Name under the Connection Parameters Section. (Netowrk Libraries can be Named Pipes)

Thats it. When you go to Enterprise Manager, you can register that server by its Alias name.

Connecting to SQL Server via Proxy

Hi,
I connect to internet using a proxy server in the office but I cannot
register the SQL Server that is on web site host.
Any help would be greatly appreciated.
Leila
Have a look at these two...
http://www.microsoft.com/technet/arc...y/proxyfx.mspx
http://support.microsoft.com/default...b;en-us;216415
Peter
"The best argument against democracy is a five-minute conversation with the
average voter."
Winston Churchill
"Leila" wrote:

> Hi,
> I connect to internet using a proxy server in the office but I cannot
> register the SQL Server that is on web site host.
> Any help would be greatly appreciated.
> Leila
>
>

Connecting to SQL Server via Proxy

Hi,
I connect to internet using a proxy server in the office but I cannot
register the SQL Server that is on web site host.
Any help would be greatly appreciated.
LeilaHave a look at these two...
http://www.microsoft.com/technet/archive/proxy/proxyfx.mspx
http://support.microsoft.com/default.aspx?scid=kb;en-us;216415
Peter
"The best argument against democracy is a five-minute conversation with the
average voter."
Winston Churchill
"Leila" wrote:
> Hi,
> I connect to internet using a proxy server in the office but I cannot
> register the SQL Server that is on web site host.
> Any help would be greatly appreciated.
> Leila
>
>

Connecting to SQL Server via Proxy

Hi,
I connect to internet using a proxy server in the office but I cannot
register the SQL Server that is on web site host.
Any help would be greatly appreciated.
LeilaHave a look at these two...
http://www.microsoft.com/technet/ar...xy/proxyfx.mspx
http://support.microsoft.com/defaul...kb;en-us;216415
Peter
"The best argument against democracy is a five-minute conversation with the
average voter."
Winston Churchill
"Leila" wrote:

> Hi,
> I connect to internet using a proxy server in the office but I cannot
> register the SQL Server that is on web site host.
> Any help would be greatly appreciated.
> Leila
>
>

Connecting to SQL SERVER over the Internet comes up with access denied error

I have set up an MSDE SQL Server in my Win XP Pro PC and am able to connect to it on the host PC, and over my LAN. However, when I try to connect to it over the Internet my connection is refused with the following message:
SQL server does not exist or access denied. ConnectionOpen (Connect())
Some background:
I have router/NAT firewall and have opened port 1433 (I have even tried a DMZ to the SQL Server machine). The Router is definitely going to the SQL Server PC! I am fairly certain that the connection string is correct.
Any help would be most gratefully received.

Try connecting to the SQL Server from your web server and make sure you can connect from there. If not, you will need to get a dedicated connection the server.
Are you using an aliased connection name for the server like DBServer or something instead of the IP? If so, make sure it is in DNS or your web servers host file.

Nick|||

Hi

Sorry for the delay... Had to shoot off elsewhere... Does this mean I have to have web services up and running on the PC that is hosting the SQL Database?

Thanks

Paul

|||

It Depends. How are your web pages connecting to your sql server? Do you have 2 seperate boxes, one for web site other for sql server, or is it all on one server? Can you show your connection string to your server (remove the user name password info)?

Nick

|||

Currently done have a web server at all! I am just trying to connect to the SQL database using an internet connection. I can use either a direct IP or NO-IP.com to connect to the PC. Its once I'm on the PC that I get kicked out by the SQL server.

Thanks

Paul

|||

It sounds like you can make a connection to the server, but cant get authorization into the server? Try this:

Start>Control Panel>Admin Tools>Data Sources(ODBC)>System DSN>Add>SQL Server.
In the name, enter anything you want. For the server, enter the IP address and click next. Depending on how you connect (either with windows NT or SQL Server info into the machine, you will need to check the corresponding radio button. If you use NT and a different user name for SQL, uncheck the checkbox and enter your credentials and click next. If something is incorrect, it will tell you here. If not, you can make a good connection to your server. Let me know what it returns.
Nick

|||

Hi! i'm having the same issue as Paul. I added the new datasource and it came up with this error:
Microsoft SQL Server ODBC Driver Version 03.85.1025

Running connectivity tests...

Attempting connection
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.

TESTS FAILED
i'm doing everything through NT auth and i'm on 2 servers. My work won't allow me to have an IIS and a SQL server on the same machine.
Any help would be great! thanks
Joel

|||The Network configuration of SQL Server can be accessed at the Server properties in Enterprise Manager, if you don't have access tell who have access to configure it. Let me explain you are connecting to SQL Server through either Named Pipes, NWLink IPX/SPX, Apple Talk, Banya Vine and VIA but not TCP/IP so you or who have access have to make the changes in the Network Configuration section of Enterprise Manager. Hope this helps.

connecting to sql server over the internet

Hi friends,
I want to connecting my sql server over internet, can I
used nat in windows 2000 instead of proxy server ?
Thanks.I've normally used hardware based routers but there's no reason that either
solution you describe shouldn't work (at least that I can think of)
SQL will work fine with NAT from a hardware based solution.
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"kresna rudy kurniawan" <anonymous@.discussions.microsoft.com> wrote in
message news:080f01c3b8a6$7a306620$a301280a@.phx.gbl...
> Hi friends,
> I want to connecting my sql server over internet, can I
> used nat in windows 2000 instead of proxy server ?
> Thanks.

Connecting to SQL server Over Internet/ Phone line etc.

Hi,
I am have an application that is running on table PC and connecting to SQL server using wireless network. But I want to be able also connected to the SQL server from other locations. Is there a way to do that? Without changing all my routines with web se
rvices? I am looking for a way for example to change basically MyConnection if possible.
Any help/ Article will be greatly appreciated
Thanks
Lisa
In order for the application to work you need to be authenticated on the
wireless network. This really has nothing to do with SQL Server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Hi Kevin,
Well the application work in 802.11g network.. but I want now it be able to work outside the wireless network say view phone line connection or Internet. That is my question. Any help will be appreciated.
Regards
Lisa
|||Hi Lisa,
The same rules apply. If you're going to allow access via phone line,
then as long as the application can recover from a dropped line, there's no
reason why you couldn't do this. There may be some tcp parameters that you
might need to adjust to account for the slow line speed. You could also
experiment with changing the packetsize in SQL to 512.
Across the internet, you have much more bandwidth. The connection quality
and stability relies on the ISP provider.
Hope this helps
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Connecting to SQL server Over Internet/ Phone line etc.

In order for the application to work you need to be authenticated on the
wireless network. This really has nothing to do with SQL Server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.Hi Kevin,
Well the application work in 802.11g network.. but I want now it be able to
work outside the wireless network say view phone line connection or Internet
. That is my question. Any help will be appreciated.
Regards
Lisa|||Hi Lisa,
The same rules apply. If you're going to allow access via phone line,
then as long as the application can recover from a dropped line, there's no
reason why you couldn't do this. There may be some tcp parameters that you
might need to adjust to account for the slow line speed. You could also
experiment with changing the packetsize in SQL to 512.
Across the internet, you have much more bandwidth. The connection quality
and stability relies on the ISP provider.
Hope this helps
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Connecting to SQL Server OVer Internet

I know it is possible to establish a connection to an SQL Server over
the Internet via Enterprise Manager. My question is, how secure is this
connection? Is there a best practices document for this type of
connection?

Here is my scenario:

We are looking to outsource our web hosting. Currently, we upload
client sensitive data to our SQL Server databases within our internal
network. If we outsource, the SQL server will be on a different
network. We are behind a firewall here and the dedicated hosted SQL
Server will also be behind a firewall. Is the Enterprise Manager
connection succeptable to hackers? If so any reccomendations on how to
accomplish this would be appreciated.

Another scenario is connecting to the SQL Server through a DSN. Can
this be accomplished from inside our network to outsourced server? How
secure would that connection be?

Thanks in Advance.As an ISP with over 700 sites connecting to various SQL and mySQL databases,
I can tell you that there are many ways to accomplish this. The most common
method that we use is SQL replication. Assuming that your new ISP has a SQL
Server they can setup replication and sync the data. This scenario will
allow you (the publisher) to control which tables can be accessed by the
subscriber (your Internet Service Provider).
Another method would be for you to write the communication layer and expose
it to your ISP via .NET web service or COM+.

-Greg

On 2/10/05 1:58 PM, in article
1108061917.584144.223910@.c13g2000cwb.googlegroups. com, "Matt"
<matt_marshall@.manning-napier.com> wrote:

> I know it is possible to establish a connection to an SQL Server over
> the Internet via Enterprise Manager. My question is, how secure is this
> connection? Is there a best practices document for this type of
> connection?
> Here is my scenario:
> We are looking to outsource our web hosting. Currently, we upload
> client sensitive data to our SQL Server databases within our internal
> network. If we outsource, the SQL server will be on a different
> network. We are behind a firewall here and the dedicated hosted SQL
> Server will also be behind a firewall. Is the Enterprise Manager
> connection succeptable to hackers? If so any reccomendations on how to
> accomplish this would be appreciated.
> Another scenario is connecting to the SQL Server through a DSN. Can
> this be accomplished from inside our network to outsourced server? How
> secure would that connection be?
> Thanks in Advance.|||Thank you for your reply Greg. Is SQL Replication secure?|||On 2/10/05 2:48 PM, in article
1108064886.517091.265990@.l41g2000cwc.googlegroups. com, "Matt"
<matt_marshall@.manning-napier.com> wrote:

> Thank you for your reply Greg. Is SQL Replication secure?

I haven't had a security breech (*knock on wood*).
I think just like anything else it's as secure as long as the service packs
are all up to date.

-Greg|||"Matt" <matt_marshall@.manning-napier.com> wrote in message
news:1108061917.584144.223910@.c13g2000cwb.googlegr oups.com...
> I know it is possible to establish a connection to an SQL Server over
> the Internet via Enterprise Manager. My question is, how secure is this
> connection? Is there a best practices document for this type of
> connection?
> Here is my scenario:
> We are looking to outsource our web hosting. Currently, we upload
> client sensitive data to our SQL Server databases within our internal
> network. If we outsource, the SQL server will be on a different
> network. We are behind a firewall here and the dedicated hosted SQL
> Server will also be behind a firewall. Is the Enterprise Manager
> connection succeptable to hackers? If so any reccomendations on how to
> accomplish this would be appreciated.
> Another scenario is connecting to the SQL Server through a DSN. Can
> this be accomplished from inside our network to outsourced server? How
> secure would that connection be?
> Thanks in Advance.

If you are worried about it being secure, then why not set up a VPN
connection between the two sites. This is really quite straight forward with
Windows.

Brian.

www.cryer.co.uk/brian|||Thanks Brian. Can you point me in the direction of establishing a VPN?
The server will be a 2003 server running SQL Server.

Brian Cryer wrote:
> "Matt" <matt_marshall@.manning-napier.com> wrote in message
> news:1108061917.584144.223910@.c13g2000cwb.googlegr oups.com...
> > I know it is possible to establish a connection to an SQL Server
over
> > the Internet via Enterprise Manager. My question is, how secure is
this
> > connection? Is there a best practices document for this type of
> > connection?
> > Here is my scenario:
> > We are looking to outsource our web hosting. Currently, we upload
> > client sensitive data to our SQL Server databases within our
internal
> > network. If we outsource, the SQL server will be on a different
> > network. We are behind a firewall here and the dedicated hosted SQL
> > Server will also be behind a firewall. Is the Enterprise Manager
> > connection succeptable to hackers? If so any reccomendations on how
to
> > accomplish this would be appreciated.
> > Another scenario is connecting to the SQL Server through a DSN. Can
> > this be accomplished from inside our network to outsourced server?
How
> > secure would that connection be?
> > Thanks in Advance.
> If you are worried about it being secure, then why not set up a VPN
> connection between the two sites. This is really quite straight
forward with
> Windows.
> Brian.
> www.cryer.co.uk/brian