Can't connect on Local Machine

I am running SQL Server Express on a local machine, when I try to connect to
a server on a local machine I get the message
TITLE: Microsoft SQL Server Management Studio Express
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)
How can I get round this problem?
Thanks
http://sql.veranoest.net/sql_faq.htm#ExpressConnect
Q: I have installed SQL Server Management Studio Express (SSMSE).
How do I connect to the Database Engine?
A: The default installation of SQL Server Express uses an instance
name (SQLExpress). This instance name must be provided to connect
to SQL Server Express by using SSMSE. If you have a instance name
other than SQLExpress, connect by using computer name\instance
name.
To connect SSMSE to a SQL Server 2005 Express Database Engine
instance, follow these steps:
1. In the Connect to Server dialog box, specify one of the
following:
.\sqlexpress
(local)\sqlexpress
server name\sqlexpress
2. Click Enter
__________________________________________________ _______
Vera Noest
MCSE, CCEA, Microsoft MVP - Terminal Server
SQL troubleshooting: http://sql.veranoest.net
___ please respond in newsgroup, NOT by private email ___
=?Utf-8?B?UGF1bCBNZW5kbGVzb2hu?=
<PaulMendlesohn@.discussions.microsoft.com> wrote on 04 nov 2007 in
microsoft.public.sqlserver.connect:

> I am running SQL Server Express on a local machine, when I try
> to connect to a server on a local machine I get the message
> TITLE: Microsoft SQL Server Management Studio Express
> --
> 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)
> How can I get round this problem?
> Thanks
|||Thank you, that was it, this has bugged me for a few weeks and couldn't find
the anwer.
Best regards
Paul
"Vera Noest" wrote:

> http://sql.veranoest.net/sql_faq.htm#ExpressConnect
> Q: I have installed SQL Server Management Studio Express (SSMSE).
> How do I connect to the Database Engine?
> A: The default installation of SQL Server Express uses an instance
> name (SQLExpress). This instance name must be provided to connect
> to SQL Server Express by using SSMSE. If you have a instance name
> other than SQLExpress, connect by using computer name\instance
> name.
> To connect SSMSE to a SQL Server 2005 Express Database Engine
> instance, follow these steps:
> 1. In the Connect to Server dialog box, specify one of the
> following:
> .\sqlexpress
> (local)\sqlexpress
> server name\sqlexpress
> 2. Click Enter
> __________________________________________________ _______
> Vera Noest
> MCSE, CCEA, Microsoft MVP - Terminal Server
> SQL troubleshooting: http://sql.veranoest.net
> ___ please respond in newsgroup, NOT by private email ___
> =?Utf-8?B?UGF1bCBNZW5kbGVzb2hu?=
> <PaulMendlesohn@.discussions.microsoft.com> wrote on 04 nov 2007 in
> microsoft.public.sqlserver.connect:
>
|||You're welcome, Paul, I'm glad that your problem is solved!
__________________________________________________ _______
Vera Noest
MCSE, CCEA, Microsoft MVP - Terminal Server
SQL troubleshooting: http://sql.veranoest.net
___ please respond in newsgroup, NOT by private email ___
=?Utf-8?B?UGF1bCBNZW5kbGVzb2hu?=
<PaulMendlesohn@.discussions.microsoft.com> wrote on 04 nov 2007 in
microsoft.public.sqlserver.connect:
[vbcol=seagreen]
> Thank you, that was it, this has bugged me for a few weeks and
> couldn't find the anwer.
> Best regards
> Paul
> "Vera Noest" wrote: