|
|
Posted by Mike on 08/07/06 14:25
Yes, the SQL Browser service is running. I restarted it just to make
sure. Has there been updates to BOL since May 2006? That is the date
of my SQL 2005 installation. I will download the latest, thanks,
Mike
Erland Sommarskog wrote:
> 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
Navigation:
[Reply to this message]
|