Have a look at these:
http://www.datamasker.com/SSE2005_NetworkCfg.htm Configuring Express
for Remote Access
https://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx Configuring Remote Access
--
Andrew J. Kelly SQL MVP
[quoted text, click to view] "Shyam" <Shyam@discussions.microsoft.com> wrote in message
news:657FDFE3-4F22-46AC-84FE-B70ABE89906B@microsoft.com...
> Hi all,
>
> I receive the following error while try to connect to local database and
> the
> error pops up,as soon as i open the SQL Mgmt studio.
> Any help would be really helpful.
>
> Thanks in Advance,
> Shyam
>
>
> TITLE: Connect to Database Engine
> ------------------------------
>
> Cannot connect to XYZ\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)
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------
>