failed to connect to new instance in MSSQL2005

I tried to connect to a new created instance (specifying server\instance)in
MSSQL2005 server with mangement studio in another mssql2005 server. It show
an 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.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance
Specified) (.Net SqlClient Data Provider)'
I have enabled the TCPIP in configuration manager and with allow remote
access enabled.
Any idea on it? Thanks in advance!
Hello,
could be the following:
http://support.microsoft.com/default...b;en-us;307197
regards,
Henk
"stephanie" <stephanie@.discussions.microsoft.com> wrote in message
news:2BD93101-CA8A-47A4-A766-DDC090C9AD5D@.microsoft.com...
>I tried to connect to a new created instance (specifying server\instance)in
> MSSQL2005 server with mangement studio in another mssql2005 server. It
> show
> an 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.
> (provider: SQL Network Interfaces, error: 26 - Error Locating
> Server/Instance
> Specified) (.Net SqlClient Data Provider)'
> I have enabled the TCPIP in configuration manager and with allow remote
> access enabled.
> Any idea on it? Thanks in advance!
>
|||Could be blocked by the firewall, particularly if the SQL Server is running
on Windows XP Professional SP1.
Could be unable to get the port number of the named instance because the SQL
Server Browser Service (on the server computer) is not running, or is
blocked by the firewall.
http://msdn2.microsoft.com/en-us/library/ms345318(en-US,SQL.90).aspx has a
step by step review of some common connectivity issues.
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Henk Steunenberg (Ms)" <stjesp@.hotmail.com> wrote in message
news:OFRCwrWLGHA.1180@.TK2MSFTNGP09.phx.gbl...
> Hello,
> could be the following:
> http://support.microsoft.com/default...b;en-us;307197
> regards,
> Henk
> "stephanie" <stephanie@.discussions.microsoft.com> wrote in message
> news:2BD93101-CA8A-47A4-A766-DDC090C9AD5D@.microsoft.com...
>
|||Thanks for all's reply.
I have studied through the suggestion material and configured in SQL2005 but
the same error is still occur.
While I telnet to servernname with named instance port #, it success.
Any other advise. Thanks in advance!
"Rick Byham [MS]" wrote:

> Could be blocked by the firewall, particularly if the SQL Server is running
> on Windows XP Professional SP1.
> Could be unable to get the port number of the named instance because the SQL
> Server Browser Service (on the server computer) is not running, or is
> blocked by the firewall.
> http://msdn2.microsoft.com/en-us/library/ms345318(en-US,SQL.90).aspx has a
> step by step review of some common connectivity issues.
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Documentation Manager,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
> "Henk Steunenberg (Ms)" <stjesp@.hotmail.com> wrote in message
> news:OFRCwrWLGHA.1180@.TK2MSFTNGP09.phx.gbl...
>
>
|||I have enabled the service 'SQL Server Browers' and now it works
"stephanie" wrote:
[vbcol=seagreen]
> Thanks for all's reply.
> I have studied through the suggestion material and configured in SQL2005 but
> the same error is still occur.
> While I telnet to servernname with named instance port #, it success.
> Any other advise. Thanks in advance!
> "Rick Byham [MS]" wrote:
|||Right. The SQL Server Browser Service receives requests for named instances
and responds with the port number that the instance is listening on. Then
the SQL Server Native Client talks directly to the port.
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"stephanie" <stephanie@.discussions.microsoft.com> wrote in message
news:146E8DB0-DB1E-4C8B-8DF0-C30737B4692E@.microsoft.com...[vbcol=seagreen]
>I have enabled the service 'SQL Server Browers' and now it works
> "stephanie" wrote: