Error connecting to sql db on another computer

When I try to connect to an sql express db on another machine, I get this
message
TITLE: Connect to Server
--
Cannot connect to REIDARNOTEBOOK\SQLEXPRESS.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005,
this failure may be caused by the fact that under the default settings SQL
Server does not allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating
Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click:
http://go.microsoft.com/fwlink?Prod...-1&LinkId=20476
BUTTONS:
OK
The connection between the 2 machines are OK, I can connect to a SQL2000 db,
but not an sql express db
reidarTAnd do you allow "remote connections" as the error message said, don't you?
"reidarT" <reidar@.eivon.no> wrote in message
news:O%23iA%230tuGHA.4888@.TK2MSFTNGP05.phx.gbl...
> When I try to connect to an sql express db on another machine, I get this
> message
> TITLE: Connect to Server
> --
> Cannot connect to REIDARNOTEBOOK\SQLEXPRESS.
> --
> ADDITIONAL INFORMATION:
> An error has occurred while establishing a connection to the server. When
> connecting to SQL Server 2005,
> this failure may be caused by the fact that under the default settings SQL
> Server does not allow remote connections.
> (provider: SQL Network Interfaces, error: 26 - Error Locating
> Server/Instance Specified) (Microsoft SQL Server, Error: -1)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...-1&LinkId=20476
> --
> BUTTONS:
> OK
> The connection between the 2 machines are OK, I can connect to a SQL2000
> db,
> but not an sql express db
> reidarT
>|||reidarT wrote:
> When I try to connect to an sql express db on another machine, I get this
> message
> TITLE: Connect to Server
> --
> Cannot connect to REIDARNOTEBOOK\SQLEXPRESS.
> --
> ADDITIONAL INFORMATION:
> An error has occurred while establishing a connection to the server. When
> connecting to SQL Server 2005,
> this failure may be caused by the fact that under the default settings SQL
> Server does not allow remote connections.
> (provider: SQL Network Interfaces, error: 26 - Error Locating
> Server/Instance Specified) (Microsoft SQL Server, Error: -1)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...-1&LinkId=20476
> --
> BUTTONS:
> OK
> The connection between the 2 machines are OK, I can connect to a SQL2000 d
b,
> but not an sql express db
> reidarT
>
Use the Surface Area Configuration Tool to allow remote connections.
They are disabled by default.
Tracy McKibben
MCDBA
http://www.realsqlguy.com

Error connecting to sql db on another computer

When I try to connect to an sql express db on another machine, I get this
message
TITLE: Connect to Server
--
Cannot connect to REIDARNOTEBOOK\SQLEXPRESS.
--
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005,
this failure may be caused by the fact that under the default settings SQL
Server does not allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating
Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
--
BUTTONS:
OK
The connection between the 2 machines are OK, I can connect to a SQL2000 db,
but not an sql express db
reidarTAnd do you allow "remote connections" as the error message said, don't you?
"reidarT" <reidar@.eivon.no> wrote in message
news:O%23iA%230tuGHA.4888@.TK2MSFTNGP05.phx.gbl...
> When I try to connect to an sql express db on another machine, I get this
> message
> TITLE: Connect to Server
> --
> Cannot connect to REIDARNOTEBOOK\SQLEXPRESS.
> --
> ADDITIONAL INFORMATION:
> An error has occurred while establishing a connection to the server. When
> connecting to SQL Server 2005,
> this failure may be caused by the fact that under the default settings SQL
> Server does not allow remote connections.
> (provider: SQL Network Interfaces, error: 26 - Error Locating
> Server/Instance Specified) (Microsoft SQL Server, Error: -1)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
> --
> BUTTONS:
> OK
> The connection between the 2 machines are OK, I can connect to a SQL2000
> db,
> but not an sql express db
> reidarT
>|||reidarT wrote:
> When I try to connect to an sql express db on another machine, I get this
> message
> TITLE: Connect to Server
> --
> Cannot connect to REIDARNOTEBOOK\SQLEXPRESS.
> --
> ADDITIONAL INFORMATION:
> An error has occurred while establishing a connection to the server. When
> connecting to SQL Server 2005,
> this failure may be caused by the fact that under the default settings SQL
> Server does not allow remote connections.
> (provider: SQL Network Interfaces, error: 26 - Error Locating
> Server/Instance Specified) (Microsoft SQL Server, Error: -1)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
> --
> BUTTONS:
> OK
> The connection between the 2 machines are OK, I can connect to a SQL2000 db,
> but not an sql express db
> reidarT
>
Use the Surface Area Configuration Tool to allow remote connections.
They are disabled by default.
Tracy McKibben
MCDBA
http://www.realsqlguy.com