Cannot connect to an express instance in Management Studio

When I try to connect to a default Express instance in Management Studio at
the machine (Windows XP SP2) where the instance is installed, I'm getting th
e
following error:
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.
(provide: SQL Network Interfaces, error: 26 - Error Locating Server/Instance
Specified) (Microsoft SQL Server)
Additional information:
1. The following Network Protocols are enabled: Shared Memory, Named Pipes,
TCP/IP thru Configuration Manager
2. SQL Server Express default instance is running using NT
AUTHORITY\NetworkService.
3. SQL Server Browser service is not running.
4. Has tried to disable Windows Firewall
5. Can connect to the instance in ODBC Administrator using System DSN thru
Named Pipes or TCP/IP.
Can such error caused by not having sufficient memory so the system is
running kind of slow?Peter (Peter@.discussions.microsoft.com) writes:
> When I try to connect to a default Express instance in Management Studio
> at the machine (Windows XP SP2) where the instance is installed, I'm
> getting the following error:
Just a check: did you explicitly install SQL Server Express as a
default instance? (Since by default Express is installed as a named
instance.)
How do you specify the instance when you try to connect?

> Can such error caused by not having sufficient memory so the system is
> running kind of slow?
I would not really think this is an issue? How much memory is there in the
box althogether? How much is used by other applications?
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Hi Erland,
I actually want to say the default named instance (SQLEXPRESS).
Peter
"Erland Sommarskog" wrote:

> Peter (Peter@.discussions.microsoft.com) writes:
> Just a check: did you explicitly install SQL Server Express as a
> default instance? (Since by default Express is installed as a named
> instance.)
> How do you specify the instance when you try to connect?
>
> I would not really think this is an issue? How much memory is there in the
> box althogether? How much is used by other applications?
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
>|||Peter (Peter@.discussions.microsoft.com) writes:
> I actually want to say the default named instance (SQLEXPRESS).
And you specify it as .\SQLEXPRESS in MgmtStudio?
Can you connect to it through SQLCMD?
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx