 | |
Connecting to new SQL Server - database engine no local server
microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup
 |
| | Thread Tools | Display Modes |
#81
 
| |||
| |||
|
Re: Connecting to new SQL Server - database engine no local server -
06-16-2008
, 01:39 AM
|
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\Microso ft SQL Server\MSSQL.1\Setup" ? My aim is to ensure this is the right key name for your SQL Server instance. -- Ekrem Önsoy "A." <andy.i (AT) spamblcoker (DOT) org> wrote in message news:eAihogUzIHA.5520 (AT) TK2MSFTNGP06 (DOT) phx.gbl... Under "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microso ft 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" <ekrem (AT) compecta (DOT) com> wrote in message news:E5D9A4E3-2C87-4F5D-BCE1-3C3F950D21F9 (AT) microsoft (DOT) 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. 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\Microso ft 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." <andy.i (AT) spamblcoker (DOT) org> wrote in message news:e5uFNuSzIHA.2360 (AT) TK2MSFTNGP05 (DOT) 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" <ekrem (AT) compecta (DOT) com> wrote in message news:16D17413-FCDF-4011-B23F-94A229ECB7D4 (AT) microsoft (DOT) com... 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." <andy.i (AT) spamblcoker (DOT) org> wrote in message news:eIAMj2gyIHA.2184 (AT) TK2MSFTNGP02 (DOT) phx.gbl... 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. |
#82
| |||
| |||
|
|
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\Microso ft SQL Server\MSSQL.1\Setup" ? My aim is to ensure this is the right key name for your SQL Server instance. -- Ekrem Önsoy "A." <andy.i (AT) spamblcoker (DOT) org> wrote in message news:eAihogUzIHA.5520 (AT) TK2MSFTNGP06 (DOT) phx.gbl... Under "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microso ft 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" <ekrem (AT) compecta (DOT) com> wrote in message news:E5D9A4E3-2C87-4F5D-BCE1-3C3F950D21F9 (AT) microsoft (DOT) 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. 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\Microso ft 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." <andy.i (AT) spamblcoker (DOT) org> wrote in message news:e5uFNuSzIHA.2360 (AT) TK2MSFTNGP05 (DOT) 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" <ekrem (AT) compecta (DOT) com> wrote in message news:16D17413-FCDF-4011-B23F-94A229ECB7D4 (AT) microsoft (DOT) com... 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." <andy.i (AT) spamblcoker (DOT) org> wrote in message news:eIAMj2gyIHA.2184 (AT) TK2MSFTNGP02 (DOT) phx.gbl... 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. |
#83
| |||
| |||
|
|
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\Microso ft SQL Server\MSSQL.1\Setup" ? My aim is to ensure this is the right key name for your SQL Server instance. -- Ekrem Önsoy "A." <andy.i (AT) spamblcoker (DOT) org> wrote in message news:eAihogUzIHA.5520 (AT) TK2MSFTNGP06 (DOT) phx.gbl... Under "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microso ft 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" <ekrem (AT) compecta (DOT) com> wrote in message news:E5D9A4E3-2C87-4F5D-BCE1-3C3F950D21F9 (AT) microsoft (DOT) 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. 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\Microso ft 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." <andy.i (AT) spamblcoker (DOT) org> wrote in message news:e5uFNuSzIHA.2360 (AT) TK2MSFTNGP05 (DOT) 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" <ekrem (AT) compecta (DOT) com> wrote in message news:16D17413-FCDF-4011-B23F-94A229ECB7D4 (AT) microsoft (DOT) com... 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." <andy.i (AT) spamblcoker (DOT) org> wrote in message news:eIAMj2gyIHA.2184 (AT) TK2MSFTNGP02 (DOT) phx.gbl... 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. |
#84
| |||
| |||
|
|
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\Microso ft SQL Server\MSSQL.1\Setup" ? My aim is to ensure this is the right key name for your SQL Server instance. -- Ekrem Önsoy "A." <andy.i (AT) spamblcoker (DOT) org> wrote in message news:eAihogUzIHA.5520 (AT) TK2MSFTNGP06 (DOT) phx.gbl... Under "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microso ft 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" <ekrem (AT) compecta (DOT) com> wrote in message news:E5D9A4E3-2C87-4F5D-BCE1-3C3F950D21F9 (AT) microsoft (DOT) 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. 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\Microso ft 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." <andy.i (AT) spamblcoker (DOT) org> wrote in message news:e5uFNuSzIHA.2360 (AT) TK2MSFTNGP05 (DOT) 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" <ekrem (AT) compecta (DOT) com> wrote in message news:16D17413-FCDF-4011-B23F-94A229ECB7D4 (AT) microsoft (DOT) com... 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." <andy.i (AT) spamblcoker (DOT) org> wrote in message news:eIAMj2gyIHA.2184 (AT) TK2MSFTNGP02 (DOT) phx.gbl... 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. |
#85
| |||
| |||
|
|
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\Microso ft SQL Server\MSSQL.1\Setup" ? My aim is to ensure this is the right key name for your SQL Server instance. -- Ekrem Önsoy "A." <andy.i (AT) spamblcoker (DOT) org> wrote in message news:eAihogUzIHA.5520 (AT) TK2MSFTNGP06 (DOT) phx.gbl... Under "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microso ft 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" <ekrem (AT) compecta (DOT) com> wrote in message news:E5D9A4E3-2C87-4F5D-BCE1-3C3F950D21F9 (AT) microsoft (DOT) 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. 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\Microso ft 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." <andy.i (AT) spamblcoker (DOT) org> wrote in message news:e5uFNuSzIHA.2360 (AT) TK2MSFTNGP05 (DOT) 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" <ekrem (AT) compecta (DOT) com> wrote in message news:16D17413-FCDF-4011-B23F-94A229ECB7D4 (AT) microsoft (DOT) com... 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." <andy.i (AT) spamblcoker (DOT) org> wrote in message news:eIAMj2gyIHA.2184 (AT) TK2MSFTNGP02 (DOT) phx.gbl... 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. |
#86
| |||||||||
| |||||||||
|
|
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. |
Quote:
|
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." <andy.i (AT) spamblcoker (DOT) org> wrote in message news:eIAMj2gyIHA.2184 (AT) TK2MSFTNGP02 (DOT) phx.gbl... |
Quote:
|
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\Microso ft 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." <andy.i (AT) spamblcoker (DOT) org> wrote in message news:e5uFNuSzIHA.2360 (AT) TK2MSFTNGP05 (DOT) phx.gbl... |
Quote:
|
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" <ekrem (AT) compecta (DOT) com> wrote in message news:16D17413-FCDF-4011-B23F-94A229ECB7D4 (AT) microsoft (DOT) com... |
Quote:
|
On Friday, June 13, 2008 7:25 AM A. wrote: Under "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microso ft 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" <ekrem (AT) compecta (DOT) com> wrote in message news:E5D9A4E3-2C87-4F5D-BCE1-3C3F950D21F9 (AT) microsoft (DOT) com... |
Quote:
|
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\Microso ft SQL Server\MSSQL.1\Setup" ? My aim is to ensure this is the right key name for your SQL Server instance. -- Ekrem ?nsoy "A." <andy.i (AT) spamblcoker (DOT) org> wrote in message news:eAihogUzIHA.5520 (AT) TK2MSFTNGP06 (DOT) phx.gbl... |
Quote:
|
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 |
Quote:
|
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\Microso ft SQL Server\MSSQL.1\Setup" I can also see all the installation info as well. /A. "Ekrem ?nsoy" <ekrem (AT) compecta (DOT) com> wrote in message news:AC094CE5-F149-4973-AD0D-C3E035934C10 (AT) microsoft (DOT) com... |
Quote:
|
Submitted via EggHeadCafe - Software Developer Portal of Choice ASP.NET MaskedTextBox Custom Control http://www.eggheadcafe.com/tutorials...m-control.aspx |
#87
| |||
| |||
|
|
I have same problem i cant see any database engines servers. but there is integration server . please help |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.