Hi

Just installed a new SQL Server 2005 server. And have some questions related
to the connection window in Management Studio.
When I Launch Management Studio I choose the server I will connect to in the...

Hello Andy,

SQL Server Database Engine may not be installed during SQL Server Setup. To
ensure if this is true or false, you must open SQL Server Configuration
Manager and check out "SQL Server 2005 Services" node to see installed SQL
Server services.

Tell us what SQL Server services are installed. If you can see the Database
Engine (which looks like "SQL Server (MSSQLSERVER)" if it's a Default
Instance or "SQL Server ()" in case it's a Named Instance).

--
Ekrem Önsoy

"A." spamblcoker.org> wrote in message
news:eIAMj2gyIHA.2184@TK2MSFTNGP02.phx.gbl...

The engine must be installed, since under Network Servers I see the server
name, and can connecto to that, I'm also able to connect to "localhost"
"Server_Name" and "." from the server name field

The services that are installed are:

SQL Server Integration Serives
SQl Server Fulltext Search (MSSQLSERVER)
SQL Server(MSSQLSERVER)
SQL Server Analysis Services(MSSQLSErver)
SQWL Reporting serives (MSSQLSERVER)
SQL Server Browser
SQL Server Agent (MSSQLSERVER)

"Ekrem Önsoy" compecta.com> wrote in message
news:16D17413-FCDF-4011-B23F-94A229ECB7D4@microsoft.com...

This is not normal at all.

The installed instance names of SQL Server is saved under the following
registry key: (The list which shows up when you click "Browse for more..."
and then "Browse for Servers" window pops up and you expand the "Database
Engine" node in the "Local Servers" tab.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance
Names\SQL

Will you check this list to find out if your MSSQLSERVER (Default Instance)
is listed under that node or not?

And can you tell me if you have the following key existed?
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1

It's supposed to be MSSQL.1 if this is the first time you install a SQL
Server instance and your SQL Server Instance's records should be under this
key. You can stroll under this key to find out information about your
installed SQL Server instance.

Under "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance
Names\SQL" I have an entry of type Name "MSSQLSERVER and data "MSSQL.1 ( a
string value with the name MSSQLServer and value MSSQL.1)

I have the following key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
SQL Server\MSSQL.1

Can this be related to a user right problem under Windows 2008?

/A

"Ekrem Önsoy" compecta.com> wrote in message
news:E5D9A4E3-2C87-4F5D-BCE1-3C3F950D21F9@microsoft.com...

Sorry, I don't know if (particularly) Windows Server 2008 has anything to do
with this issue. However, if your account would not have enough rights to
those registry paths then you would experience other problems as well. But
you may want to check if your account has read permission for this
(HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance
Names\SQL) path. Because this is (AFAIK) the only place SQL Server instance
list is read.

However, do you see your installed SQL Server instance's info under MSSQL.1?
For example do you see the installation info under
"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup" ?
My aim is to ensure this is the right key name for your SQL Server instance.

--
Ekrem Önsoy

"A." spamblcoker.org> wrote in message
news:eAihogUzIHA.5520@TK2MSFTNGP06.phx.gbl...

My account has read rights for
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance
Names\SQL. The account is a member of the "Adminstrators" group, which has
both Full controll and Read rights.
Under "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.1\Setup" I can also see all the installation info as well.

/A.

"Ekrem Önsoy" compecta.com> wrote in message
news:AC094CE5-F149-4973-AD0D-C3E035934C10@microsoft.com...

I'm out of idea now, hopefully someone else has another solution for this
problem.

--
Ekrem Önsoy

"A." spamblcoker.org> wrote in message
news:ugJ7uu3zIHA.4004@TK2MSFTNGP03.phx.gbl...