Problem connecting to SQL 2000 on WIndows 2003 via VPN
- From: "Damage" <sandilekse@xxxxxxxxxxx>
- Date: 1 Sep 2005 06:52:54 -0700
I have a problem with connection from my workstation (Windows XP SP2),
where I develop apps using Visual Studio .NET. I have locally instaled
IIS but SQL database is on another server (Windows Server 2003 SP1, SQL
Server 2000) which is conected to domain through VPN connection (VPN
connection is established with SBS server). This (SQL database) server
is also a member of domain.
I use connection string "Data Source=SERVERNAME;initial
catalog=DATABASENAME;User=sa;Password=xxx".
The connection works just fine through Enterprise Manager. It also
works imeddiately when I change connection string to SBS server (which
also has an SQL database). Server is also accesible through file
system. It just doesn't work, when I run this app.
I've tried many variations - DOMAINNAME\\SERVERNAME, with IP etc., to
another server (which is not a member of a domain, doesn't have SP1
installed and is also connected via VPN), but non of them seem to work.
Any suggestions?
.
- Prev by Date: Re: SQL state (error) is 37000
- Next by Date: Re: blob and network packet size
- Previous by thread: Re: Linked Server Connection Problem
- Next by thread: Re: blob and network packet size
- Index(es):
Relevant Pages
|
