Connecting to new SQL Server - database engine no local se..

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" wrote in message

> 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 (<Instance_name>)" in case it's a Named
> Instance).
>
> --
> Ekrem Önsoy
>
>
>
> "A." wrote in message
>
>> 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 server box. In this there is no name, so I choose "Browse for
>> more.."
>> Here I can select the server to connect to. Under "local Servers" I have
>> en entry saying "database Engine" but no servers are listed. I have to
>> choose "Network servers", and browse down to I find the server in
>> Questions. Does this sound right when I'm launching Management Studio
>> from the local server where the database engine is installed?
>> In the SQL Server 2005 Surface Area configuration tool the server is
>> configured for Remote Connections. I've chosen "local and Remote
>> connections." and enabled both TCP/IP and names pipes. The only option
>> that I can connect to under "local servers" are Integration services".
>>
>> /A.
>>
>
 >> Stay informed about: Connecting to new SQL Server - database engine no local se.. 

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.

If you are sure that MSSQL.1 is the key which contains the information about
your installed instance and if you don't have a created String Value for
this instance of SQL Server then you may want to try to create a String
Value under "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\Instance Names\SQL". This String Value' s name is supposed to be
"MSSQLSERVER" (as your SQL Server instance is a Default Instance) and its
value should be "MSSQL.1" (if your scenario matches what I told above)

You can elaborate if you do not want to move on by yourself.

--
Ekrem Önsoy



"A." wrote in message

> 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" wrote in message
>
>> 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 (<Instance_name>)" in case it's a Named
>> Instance).
>>
>> --
>> Ekrem Önsoy
>>
>>
>>
>> "A." wrote in message
>>
>>> 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 server box. In this there is no name, so I choose "Browse for
>>> more.."
>>> Here I can select the server to connect to. Under "local Servers" I have
>>> en entry saying "database Engine" but no servers are listed. I have to
>>> choose "Network servers", and browse down to I find the server in
>>> Questions. Does this sound right when I'm launching Management Studio
>>> from the local server where the database engine is installed?
>>> In the SQL Server 2005 Surface Area configuration tool the server is
>>> configured for Remote Connections. I've chosen "local and Remote
>>> connections." and enabled both TCP/IP and names pipes. The only option
>>> that I can connect to under "local servers" are Integration services".
>>>
>>> /A.
>>>
>>
>
 >> Stay informed about: Connecting to new SQL Server - database engine no local se.. 

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" wrote in message

> 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.
>
> If you are sure that MSSQL.1 is the key which contains the information
> about your installed instance and if you don't have a created String Value
> for this instance of SQL Server then you may want to try to create a
> String Value under "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> Server\Instance Names\SQL". This String Value' s name is supposed to be
> "MSSQLSERVER" (as your SQL Server instance is a Default Instance) and its
> value should be "MSSQL.1" (if your scenario matches what I told above)
>
> You can elaborate if you do not want to move on by yourself.
>
> --
> Ekrem Önsoy
>
>
>
> "A." wrote in message
>
>> 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" wrote in message
>>
>>> 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 (<Instance_name>)" in case it's a Named
>>> Instance).
>>>
>>> --
>>> Ekrem Önsoy
>>>
>>>
>>>
>>> "A." wrote in message
>>>
>>>> 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 server box. In this there is no name, so I choose "Browse for
>>>> more.."
>>>> Here I can select the server to connect to. Under "local Servers" I
>>>> have en entry saying "database Engine" but no servers are listed. I
>>>> have to choose "Network servers", and browse down to I find the server
>>>> in Questions. Does this sound right when I'm launching Management
>>>> Studio from the local server where the database engine is installed?
>>>> In the SQL Server 2005 Surface Area configuration tool the server is
>>>> configured for Remote Connections. I've chosen "local and Remote
>>>> connections." and enabled both TCP/IP and names pipes. The only option
>>>> that I can connect to under "local servers" are Integration services".
>>>>
>>>> /A.
>>>>
>>>
>>
>
 >> Stay informed about: Connecting to new SQL Server - database engine no local se.. 

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." wrote in message

> 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" wrote in message
>
>> 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.
>>
>> If you are sure that MSSQL.1 is the key which contains the information
>> about your installed instance and if you don't have a created String
>> Value for this instance of SQL Server then you may want to try to create
>> a String Value under "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
>> Server\Instance Names\SQL". This String Value' s name is supposed to be
>> "MSSQLSERVER" (as your SQL Server instance is a Default Instance) and its
>> value should be "MSSQL.1" (if your scenario matches what I told above)
>>
>> You can elaborate if you do not want to move on by yourself.
>>
>> --
>> Ekrem Önsoy
>>
>>
>>
>> "A." wrote in message
>>
>>> 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" wrote in message
>>>
>>>> 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 (<Instance_name>)" in case it's a Named
>>>> Instance).
>>>>
>>>> --
>>>> Ekrem Önsoy
>>>>
>>>>
>>>>
>>>> "A." wrote in message
>>>>
>>>>> 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 server box. In this there is no name, so I choose "Browse for
>>>>> more.."
>>>>> Here I can select the server to connect to. Under "local Servers" I
>>>>> have en entry saying "database Engine" but no servers are listed. I
>>>>> have to choose "Network servers", and browse down to I find the server
>>>>> in Questions. Does this sound right when I'm launching Management
>>>>> Studio from the local server where the database engine is installed?
>>>>> In the SQL Server 2005 Surface Area configuration tool the server is
>>>>> configured for Remote Connections. I've chosen "local and Remote
>>>>> connections." and enabled both TCP/IP and names pipes. The only option
>>>>> that I can connect to under "local servers" are Integration services".
>>>>>
>>>>> /A.
>>>>>
>>>>
>>>
>>
>
 >> Stay informed about: Connecting to new SQL Server - database engine no local se.. 

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" wrote in message

> 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." wrote in message
>
>> 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" wrote in message
>>
>>> 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.
>>>
>>> If you are sure that MSSQL.1 is the key which contains the information
>>> about your installed instance and if you don't have a created String
>>> Value for this instance of SQL Server then you may want to try to create
>>> a String Value under "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft
>>> SQL Server\Instance Names\SQL". This String Value' s name is supposed to
>>> be "MSSQLSERVER" (as your SQL Server instance is a Default Instance) and
>>> its value should be "MSSQL.1" (if your scenario matches what I told
>>> above)
>>>
>>> You can elaborate if you do not want to move on by yourself.
>>>
>>> --
>>> Ekrem Önsoy
>>>
>>>
>>>
>>> "A." wrote in message
>>>
>>>> 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" wrote in message
>>>>
>>>>> 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 (<Instance_name>)" in case it's a
>>>>> Named Instance).
>>>>>
>>>>> --
>>>>> Ekrem Önsoy
>>>>>
>>>>>
>>>>>
>>>>> "A." wrote in message
>>>>>
>>>>>> 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 server box. In this there is no name, so I choose "Browse for
>>>>>> more.."
>>>>>> Here I can select the server to connect to. Under "local Servers" I
>>>>>> have en entry saying "database Engine" but no servers are listed. I
>>>>>> have to choose "Network servers", and browse down to I find the
>>>>>> server in Questions. Does this sound right when I'm launching
>>>>>> Management Studio from the local server where the database engine is
>>>>>> installed?
>>>>>> In the SQL Server 2005 Surface Area configuration tool the server is
>>>>>> configured for Remote Connections. I've chosen "local and Remote
>>>>>> connections." and enabled both TCP/IP and names pipes. The only
>>>>>> option that I can connect to under "local servers" are Integration
>>>>>> services".
>>>>>>
>>>>>> /A.
>>>>>>
>>>>>
>>>>
>>>
>>
>
 >> Stay informed about: Connecting to new SQL Server - database engine no local se.. 

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

--
Ekrem Önsoy



"A." wrote in message

> 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" wrote in message
>
>> 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." wrote in message
>>
>>> 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" wrote in message
>>>
>>>> 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.
>>>>
>>>> If you are sure that MSSQL.1 is the key which contains the information
>>>> about your installed instance and if you don't have a created String
>>>> Value for this instance of SQL Server then you may want to try to
>>>> create a String Value under
>>>> "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance
>>>> Names\SQL". This String Value' s name is supposed to be "MSSQLSERVER"
>>>> (as your SQL Server instance is a Default Instance) and its value
>>>> should be "MSSQL.1" (if your scenario matches what I told above)
>>>>
>>>> You can elaborate if you do not want to move on by yourself.
>>>>
>>>> --
>>>> Ekrem Önsoy
>>>>
>>>>
>>>>
>>>> "A." wrote in message
>>>>
>>>>> 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" wrote in message
>>>>>
>>>>>> 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 (<Instance_name>)" in case it's a
>>>>>> Named Instance).
>>>>>>
>>>>>> --
>>>>>> Ekrem Önsoy
>>>>>>
>>>>>>
>>>>>>
>>>>>> "A." wrote in message
>>>>>>
>>>>>>> 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 server box. In this there is no name, so I choose "Browse
>>>>>>> for more.."
>>>>>>> Here I can select the server to connect to. Under "local Servers" I
>>>>>>> have en entry saying "database Engine" but no servers are listed. I
>>>>>>> have to choose "Network servers", and browse down to I find the
>>>>>>> server in Questions. Does this sound right when I'm launching
>>>>>>> Management Studio from the local server where the database engine is
>>>>>>> installed?
>>>>>>> In the SQL Server 2005 Surface Area configuration tool the server is
>>>>>>> configured for Remote Connections. I've chosen "local and Remote
>>>>>>> connections." and enabled both TCP/IP and names pipes. The only
>>>>>>> option that I can connect to under "local servers" are Integration
>>>>>>> services".
>>>>>>>
>>>>>>> /A.
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
 >> Stay informed about: Connecting to new SQL Server - database engine no local se.. 

I have same problem

i cant see any database engines servers.
but there is integration server .
please help

> On Monday, June 09, 2008 4:48 AM A. wrote:

> 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
> server box. In this there is no name, so I choose "Browse for more.."
> Here I can select the server to connect to. Under "local Servers" I have en
> entry saying "database Engine" but no servers are listed. I have to choose
> "Network servers", and browse down to I find the server in Questions. Does
> this sound right when I'm launching Management Studio from the local server
> where the database engine is installed?
> In the SQL Server 2005 Surface Area configuration tool the server is
> configured for Remote Connections. I've chosen "local and Remote
> connections." and enabled both TCP/IP and names pipes. The only option that
> I can connect to under "local servers" are Integration services".
>
> /A.


>> On Tuesday, June 10, 2008 7:37 AM ekre wrote:

>> 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 (<Instance_name>)" in case it's a Named Instance).
>>
>> --
>> Ekrem ?nsoy
>>
>>
>>
>> "A." wrote in message
>>


>>> On Thursday, June 12, 2008 10:36 AM ekre wrote:

>>> 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.
>>>
>>> If you are sure that MSSQL.1 is the key which contains the information about
>>> your installed instance and if you don't have a created String Value for
>>> this instance of SQL Server then you may want to try to create a String
>>> Value under "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
>>> Server\Instance Names\SQL". This String Value' s name is supposed to be
>>> "MSSQLSERVER" (as your SQL Server instance is a Default Instance) and its
>>> value should be "MSSQL.1" (if your scenario matches what I told above)
>>>
>>> You can elaborate if you do not want to move on by yourself.
>>>
>>> --
>>> Ekrem ?nsoy
>>>
>>>
>>>
>>> "A." wrote in message
>>>


>>>> On Friday, June 13, 2008 4:00 AM A. wrote:

>>>> 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" wrote in message
>>>>


>>>>> On Friday, June 13, 2008 7:25 AM A. wrote:

>>>>> 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" wrote in message
>>>>>


>>>>>> On Friday, June 13, 2008 5:39 PM ekre wrote:

>>>>>> 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." wrote in message
>>>>>>


>>>>>>> On Sunday, June 15, 2008 9:18 AM ekre wrote:

>>>>>>> I am out of idea now, hopefully someone else has another solution for this
>>>>>>> problem.
>>>>>>>
>>>>>>> --
>>>>>>> Ekrem ?nsoy


>>>>>>>> On Monday, June 16, 2008 2:39 AM A. wrote:

>>>>>>>> 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" wrote in message
>>>>>>>>


>>>>>>>> Submitted via EggHeadCafe - Software Developer Portal of Choice
>>>>>>>> ASP.NET MaskedTextBox Custom Control
>>>>>>>> http://www.eggheadcafe.com/tutorials/aspnet/39a071cd-9f96-4e81-9346-4e...181d645
 >> Stay informed about: Connecting to new SQL Server - database engine no local se.. 

Gourish Patil ( ) writes:
> I have same problem
>
> i cant see any database engines servers.
> but there is integration server .
> please help

You can always type in the name of the server yourself.
 >> Stay informed about: Connecting to new SQL Server - database engine no local se..