I have developed an application in vs.net and have an sql express version on
one of my computers (Actually both computers).
How do I connect to this database from the other machine (workgroup, not
dedicated server)
When I try to connect through the Add Connection I get the message
'An error has occured while establishing a connection to the server. When
connecting to SQL Server 2005,
this failure may be caused by the fact under the default settings SQL Server
does not allow remote connections.
(Provider: SQL Network Interface, error: 26 -Error locating Server/Instance
Specified)'
reidarTHi
Can you connect using SQLCMD? It could be that you have not enable remote
connections with SqlSAC.exe! When you connect you should be able to specify
the machine name\Instance or the IP address\Instance in your connection
string. If you can connect using the IP address and not the hostname you may
need to add it to your hosts file.
John
"reidarT" wrote:
> I have developed an application in vs.net and have an sql express version
on
> one of my computers (Actually both computers).
> How do I connect to this database from the other machine (workgroup, not
> dedicated server)
> When I try to connect through the Add Connection I get the message
> 'An error has occured while establishing a connection to the server. When
> connecting to SQL Server 2005,
> this failure may be caused by the fact under the default settings SQL Serv
er
> does not allow remote connections.
> (Provider: SQL Network Interface, error: 26 -Error locating Server/Instanc
e
> Specified)'
> reidarT
>
>|||reidarT wrote:
> I have developed an application in vs.net and have an sql express version
on
> one of my computers (Actually both computers).
> How do I connect to this database from the other machine (workgroup, not
> dedicated server)
> When I try to connect through the Add Connection I get the message
> 'An error has occured while establishing a connection to the server. When
> connecting to SQL Server 2005,
> this failure may be caused by the fact under the default settings SQL Serv
er
> does not allow remote connections.
> (Provider: SQL Network Interface, error: 26 -Error locating Server/Instanc
e
> Specified)'
> reidarT
>
Use the Surface Area Configuration tool to enable remote connections...
Tracy McKibben
MCDBA
http://www.realsqlguy.com
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment