Share via

No Servers listed under Database Engine in SQL Server 2008 on Windows Server 2008 R2.

  • Article

Question

Saturday, July 10, 2010 6:46 AM

Where to begin. It's late so I hope I can be clear.

I have installed SQL Server 2008. I am running Windows Server 2008 R2. I have installed SQL Server four times and I continue to have issues connecting to the Database Engine. Installation has gone without a problem at least to my knowledge I have not been presented with any errors. I have also created a local administrator account called "spadmin" to use to connect to the SQL Server database and to use with SharePoint 2010. Which brings me to the reason why I want to run SQL Server - I want to evaluate the latest SharePoint Server 2010 and WSS. Unfortunately, I have not been able to go beyond installing SQL Server and connecting to the database, because there is no database instance showing under the Database Engine, except under Integration Services. I have the following services installed:

  • SQL Acitivey Directory Helper Service
  • SQL Full-text-Filder Daemon Launcher
  • SQL Server
  • SQL Server Agent
  • SQL Server Analysis Service
  • SQL Server Browser
  • SQL Server Integration Services 10.0
  • SQL Server Reporting Services
  • SQL Server VSS Writer

Am I missing something? I have been following several online instructions on how to install SQL Server 2008 and I can't seem to find where I may have gone wrong.

After I install SQL Server 2008 am I supposed to see the default instance (MSSQLSERVER) listed under the Database Engine?

OR am I supposed to install a sample database to see a database a server listed under Database Engine?

Any help is really appreciated. I've been at this for a week with no luck! I have even reinstalled the OS!

All replies (14)

Tuesday, July 13, 2010 11:48 AM ✅Answered

Hi,

 

It seems that you have chosen a wrong type of server.

 

In this case, in order to connect to SQL Server Engine, we have to make sure the “Server type” is “Database Engine”, then fill “Server name” with “.” and click “OK”.

 

If anything is unclear, please let me know.

Tuesday, July 13, 2010 3:54 PM ✅Answered

Hi,

Generally, SQL Server Management Studio will *not* scan available server automatically.

In other words, if we want to connect specific instance, we have to fill that text box manually.

As as result, if this textbox is empty, please fill it manually.

Saturday, July 17, 2010 6:31 PM ✅Answered

I found this query and found out I had installed a 32-bit version! ARGGHHHH!

 

SELECT CASE WHEN CHARINDEX('64', CAST(SERVERPROPERTY('Edition') AS
VARCHAR(100))) > 0
THEN 64
ELSE 32
END;

Reinstall #5!

 

Saturday, July 10, 2010 7:41 AM

Hi,

I suggest, after clicking Database engine try using dot (.) or (local) in servername.

Also, while installing SQL 2008, you need to specify the administrator for SQL. If you have not specified, use SA login to conncet.

Hope this helps.

-Chintak.

Saturday, July 10, 2010 1:04 PM

Thanks Chintak.

When I login with (.) I connect but only to the (Integration Services 10.0.3798 - CORP\Administrator)

If I try to login with (local) I get the following error message:

 

*TITLE: Connect to Server
*

Cannot connect to (local).

*
ADDITIONAL INFORMATION:*

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

Connecting to the Integration Services service on the computer "(local)" failed with the following error: "The RPC server is unavailable.
".

This error occurs when the computer host name does not exist, or cannot be reached.

Connecting to the Integration Services service on the computer "(local)" failed with the following error: "The RPC server is unavailable.
".

This error occurs when the computer host name does not exist, or cannot be reached.

*
BUTTONS:*

*OK
*

Also, I have been able to login to the instance I created with the local administrator account but like the above results, I am only seeing the Integration Services. Shouldn't I be seeing more like the Master db? 

 

Tuesday, July 13, 2010 12:56 PM

That's the frustrating part! There is no server listed under "Database Engine!"

I have now uninstalled SQL Server 2008 and will attempt again to reinistall it to see if I missed a step in the initial configuring of SQL Server.

Not that I want to create more issues but I will try downloading and installing SQL Server 2008 R2. Will see if I have the same issue with no Servers appearing under "Databse Engine"

Saturday, July 17, 2010 5:53 PM

I went ahead and installed SQL Server 2008 R2 this time around and ignored Microsoft's recomendation to create separate accounts for SQL server for SharePoint 2010 to run. I used the local admin account and everything installed according to spec.

The issue I am now running when running the SharePoint 2010 Products Configuration Wizard or SharePoint 2010 Management Shell is that I am getting a SQL error when creating a new Server Farm:

SQL Server at [SERVERNAME] is not running 64-bit edition. SharePoint requires the SQL Server to be 64-Bit edition.

My understanding is that SQL Server 2008 R2 is a 64-bit database server. Is it not?

I installed the installation file: SQLFULL2008R2_x86_ENU

I'm going ahead and uninstalling the SQL server edition I have and installing one that I found specifically stating it is 64-bit on this page: http://msdn.microsoft.com/en-us/evalcenter/ff459612.aspx I'll see online if there is a way to find out what version/edition is installed on my system; to verify if it is a 64-bit or 32-bit version.

This is really starting to get confusing.

 

Tuesday, September 7, 2010 8:01 AM

I have same problem. No server in the list. I've chosen the database server, use the administrator acount, try download hotfix but nothing help. Any other ideas? Have someone fixed it?

Tuesday, September 7, 2010 8:10 AM

Hi honbarta,

Please fill the textbox manually.

Meanwhile I would like to recommend that you ask it in a new thread and you will get quicker support.

Regards,
Tom Li

Tuesday, September 7, 2010 8:26 AM

Thx for support.

But i've tried that. I've tried to install server in default settings, fill the textbox with 'MSSQLSERVER', 'local', '.' but nothing work.

Tuesday, September 7, 2010 8:38 AM

Hi honbarta,

Did you install SQL Server Express Edition?

By default, this instance of SQL Server has a instance name:SQLEXPRESS.

Please fill the textbox with ".\SQLEXPRESS" and try again.

Meanwhile please ask it in a new thread, and you will receive quicker support.

Regards,
Tom Li

Monday, June 20, 2011 3:33 PM

Help,

 

I am also experiencing the same problem.  I can log on using (local) but this is not what I want.  I had SQL Express running before this and my login name was the computername\instance ID. 

 

I installed the developer version of SQL and now I can't do that, and when I browse, there is no server under the database engine, the only thing that has a drop down is integration services.  I'm needing this working so I can install CA Total Defense which needs an instance of sql to log in to.

Tuesday, June 21, 2011 8:47 PM

Hello there.

Is the SQL Browser service running?

Also, are there any services stopped? Please go to the SQL Server Configuration Manager (under the Configuration Tools) and check for the services to be started, as well as the protocols to be enabled.

best regards,
Calin 

Friday, June 24, 2011 10:18 PM

It worked. Thanks Tom.