sql server connect: SQL Server Management Studio don't see local SQL Server 2005 Devel -- sql server connect

SQL Server Management Studio don't see local SQL Server 2005 Devel

Mrgud
10/29/2007 4:59:00 AM

sql server connect: SQL Server Management Studio don't see local SQL Server 2005 Developer
Edition x64 on Vista Ultimate x64

Hi,
I have strange problem with SQL Server Management Studio on Vista Ultimate
x64. Nothing change after installing all newest service packs or hot fixes.
I have two running SQL servers on my local machine and all surrounding SQL
services running as well. I have turn on TCP/IP and Named pipes on both of
this servers. Actually I have reinstalled second server after first one
wasn't contactable in any way... After finished installation of second one
and after applying service packs I turn on SQL Server Management Studio and
still nothing in local servers pane when Browsing for servers to connect but
in network servers after few seconds I see one of my local servers (first one
installed) and one SQL Server 2000 on other machine (on this one I can't
connect because of time out error). Also when browsing for servers in Local
Servers I see my machine in Integration Services. Only difference between
this running services is that Integration service log on as Network Service
and all other SQL services log on as Local System account and on SQL Server
that is invisible I have also SQL Server Reporting Services running.
Services looks like this:
Name Status Startup type Log On As
SQL Server (KONGORA) Started Automatic
Local System
SQL Server(MSSQLSERVER) Started Automatic Local
System
SQL Server Active Directory Hel Automatic
Network Service
SQL Server Agent (KONGORA) Started Automatic Local
System
SQL Server Agent (MSSQLSERVER) Started Automatic Local
System
SQL Server Analysis Services (KONG Started Automatic Local
System
SQL Server Analysis Services (MSSQL Started Automatic Local
System
SQL Server Browser Started Automatic
Local System
SQL Server Full Text Search (KONG Started Automatic Local
System
SQL Server Full Text Search (MSSQL Started Automatic Local
System
SQL Server Integration Services Started Automatic
Network Service
SQL Server Reporting Services (MSSQL Started Automatic Local
System
SQL Server VSS Writer Started Automatic
Local System

Thanks

Stjepan

RE: SQL Server Management Studio don't see local SQL Server 2005 D

Mrgud
10/30/2007 2:23:01 AM

Well, I can connect to server instance KONGORA that is installed first and
this one I see in network server list but to instance MSSQLSERVER I can't
even connect.Both of this instances are on my local machine.

What could be wrong? :)

[quoted text, click to view]

RE: SQL Server Management Studio don't see local SQL Server 2005 D

Mrgud
10/30/2007 2:27:01 AM

Well, I can connect to local instance KONGORA that is first one installed and
this one I see in network database list. On instance MSSQLSERVER I can't
connect at all. Both instances are local instances and both instances I can
administer in Configuration tools...

[quoted text, click to view]

RE: SQL Server Management Studio don't see local SQL Server 2005 Devel

weilu NO[at]SPAM online.microsoft.com
10/30/2007 2:32:33 AM

Hello Stjepan,

I understand that you could not get the local server listed in the server
lists.

Could you please let me know whether you could connect to the local
instance?

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.