Re: Connecting to a SQL Server 2005 DB on a Remote Web Server
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Tue, 11 Jul 2006 14:11:43 -0400
Mike Webb wrote:
BobThere is a configuration setting in SQL 2005 Configuration Manager under
thanks for letting me know that this is at least possible. I have now
tried your connection string but get the -2147467259 "SQL Server does
not exist or access denied" message. I have made sure all TCPip ports
needed are opened
If i connect to the same DB via LAN (i.e. using \\servername instead
of IP address) everything is fine.
My DEV environment is VB6 using ADO 2.8
My server (which is currently still in the LAN) is running Windows
Server 2003 Standard Ed. and I am trying to connect to a SQL Server
2005 Express Ed. default instance \SQLExpress, as follows:
cn1string = "Provider=SQLOLEDB; Data Source=213.162.108.132,1433;
Initial Catalog=Bookings; " & _
"Network Library=DBMSSOCN;User ID=sa;Password=whatever;"
the Network Configuration node to allow you to enable tcpip - is it
enabled on your server?
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
.
- References:
- Re: Connecting to a SQL Server 2005 DB on a Remote Web Server
- From: Bob Barrows [MVP]
- Re: Connecting to a SQL Server 2005 DB on a Remote Web Server
- Prev by Date: Re: Connecting to a SQL Server 2005 DB on a Remote Web Server
- Next by Date: Re: Connecting to a SQL Server 2005 DB on a Remote Web Server
- Previous by thread: Re: Connecting to a SQL Server 2005 DB on a Remote Web Server
- Next by thread: Re: Connecting to a SQL Server 2005 DB on a Remote Web Server
- Index(es):
Relevant Pages
|
|
