Posted by Erland Sommarskog on 08/04/06 22:13

Mike (mjorlando@campsystems.com) writes:
> Thanks for your response Stu, After checking SQL Server 2005 Surface
> Area Configuration it looks like the option for "Local and Remote
> Connections" was already selected. I checked under "Database Engine"
> under both "View by Instance" and "View by Component" and it seems the
> same. I even clicked on "Local connections only" then back to "Local
> and Remote Connections" just to make sure the setting was recognized
> when hitting "Apply". Then restarted SQL Server (2005) service. Still
> unable to access this instance from the other server. Do I need to use
> another tcp/ip port for the second instance? I remember reading this
> somewhere, but when I tried to use port 1435 because UDP port 1434 is
> supposedly disabled in SQL 2005, I still cannot connect.

Have you checked that the SQL Browser service is running? You control it
from the SQL Configuration Management tool.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: SQL Server 2005 Express to SQL Server 2005 Standard
• Prev in forum: Re: Any help?
• Thread view: Re: Accessing SQL2005 as a Second Instance to SQL2000

[Reply to this message]