Connect to Remote SQL SERVER Express 2005 server

I am trying to connect to a remote SQL Express server (using query analyzer)
and I am not able to. If I run SQL Server Managemant Studio I can connect
(using Windows Authentication). I have tried using the IP address of the
server and just the server name but no luck. There is only one instance
running on the server (default). This server is on a different subnet. The
error I receive is: Server: Msg 14, Level 16, State1
[microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
Any ideas?
TimAre you sure the SQL Express instance is the default? It normally installs
as a named instance SQLEXPRESS.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Tim Kelley" <tkelley@.company.com> wrote in message
news:%23jgSL5QzGHA.4104@.TK2MSFTNGP02.phx.gbl...
>I am trying to connect to a remote SQL Express server (using query
>analyzer) and I am not able to. If I run SQL Server Managemant Studio I
>can connect (using Windows Authentication). I have tried using the IP
>address of the server and just the server name but no luck. There is only
>one instance running on the server (default). This server is on a
>different subnet. The error I receive is: Server: Msg 14, Level 16, State1
> [microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
> Any ideas?
> Tim
>|||You are right. When I try connecting using servername/sqlexpress I get the
following error:
[DBNETLIB][ConnectionOpen(Connect)).]SQL Server does not exist or Access
Denied.
Thanks,
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:O9BqpTRzGHA.1292@.TK2MSFTNGP03.phx.gbl...
> Are you sure the SQL Express instance is the default? It normally
> installs as a named instance SQLEXPRESS.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Tim Kelley" <tkelley@.company.com> wrote in message
> news:%23jgSL5QzGHA.4104@.TK2MSFTNGP02.phx.gbl...
>>I am trying to connect to a remote SQL Express server (using query
>>analyzer) and I am not able to. If I run SQL Server Managemant Studio I
>>can connect (using Windows Authentication). I have tried using the IP
>>address of the server and just the server name but no luck. There is only
>>one instance running on the server (default). This server is on a
>>different subnet. The error I receive is: Server: Msg 14, Level 16, State1
>> [microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
>> Any ideas?
>> Tim
>|||How about servername\sqlexpress ? Is the SQLBrowser enabled and running on
the SQL Express server?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Tim Kelley" <tkelley@.company.com> wrote in message
news:O5ps1hRzGHA.996@.TK2MSFTNGP03.phx.gbl...
> You are right. When I try connecting using servername/sqlexpress I get
> the following error:
> [DBNETLIB][ConnectionOpen(Connect)).]SQL Server does not exist or Access
> Denied.
> Thanks,
>
> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
> news:O9BqpTRzGHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Are you sure the SQL Express instance is the default? It normally
>> installs as a named instance SQLEXPRESS.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm
>> "Tim Kelley" <tkelley@.company.com> wrote in message
>> news:%23jgSL5QzGHA.4104@.TK2MSFTNGP02.phx.gbl...
>>I am trying to connect to a remote SQL Express server (using query
>>analyzer) and I am not able to. If I run SQL Server Managemant Studio I
>>can connect (using Windows Authentication). I have tried using the IP
>>address of the server and just the server name but no luck. There is only
>>one instance running on the server (default). This server is on a
>>different subnet. The error I receive is: Server: Msg 14, Level 16,
>>State1
>> [microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
>> Any ideas?
>> Tim
>>
>|||Got the same error. I found a registry entry that fixed the problem.
HKLM\Software\Microsoft\MSSQLServer\Client\ConnectTo.
Added REG_SZ key <servername> with data set to:
<servername>,DBMSSOCN,<servername>,1433
Don't know what this does, but I am able to connect now.
Thanks,
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:uP3wAxRzGHA.2036@.TK2MSFTNGP05.phx.gbl...
> How about servername\sqlexpress ? Is the SQLBrowser enabled and running
> on the SQL Express server?
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Tim Kelley" <tkelley@.company.com> wrote in message
> news:O5ps1hRzGHA.996@.TK2MSFTNGP03.phx.gbl...
>> You are right. When I try connecting using servername/sqlexpress I get
>> the following error:
>> [DBNETLIB][ConnectionOpen(Connect)).]SQL Server does not exist or Access
>> Denied.
>> Thanks,
>>
>> "Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
>> news:O9BqpTRzGHA.1292@.TK2MSFTNGP03.phx.gbl...
>> Are you sure the SQL Express instance is the default? It normally
>> installs as a named instance SQLEXPRESS.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> Use of included script samples are subject to the terms specified at
>> http://www.microsoft.com/info/cpyright.htm
>> "Tim Kelley" <tkelley@.company.com> wrote in message
>> news:%23jgSL5QzGHA.4104@.TK2MSFTNGP02.phx.gbl...
>>I am trying to connect to a remote SQL Express server (using query
>>analyzer) and I am not able to. If I run SQL Server Managemant Studio I
>>can connect (using Windows Authentication). I have tried using the IP
>>address of the server and just the server name but no luck. There is
>>only one instance running on the server (default). This server is on a
>>different subnet. The error I receive is: Server: Msg 14, Level 16,
>>State1
>> [microsoft][ODBC SQL Server Driver][DBNETLIB] Invalid Connection
>> Any ideas?
>> Tim
>>
>>
>