SQL SERVER 2008 + SP1/SSMS error...

Question

User-354420814 posted

Hello I'm having difficulties with a clean SQL Server 2008 + SP1 (64 bit) install.

I'm using Windows 7 Ultimate 64 bit with VS2010. The Microsoft SQL Server 2008 Service Pack 1 (KB968369) is installed via Windows Update.

I installed SQL Server Management Studio (64 bit) via the Microsoft website.

When I open SSMS and try to login with Windows Authentication to (local)/localhost/[computername] I get the following error:

Details
Product:	SQL Server
ID:	2
Source:	MSSQLServer
Version:	10.0
Component:	SQLEngine
Message:	An error has occurred while establishing a connection to the server. When connecting to SQL Server, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)
   
Explanation
SQL Server did not respond to the client request because the server is probably not started.

   
User Action
Make sure that the server is started.

   
   
Version:	9.0
Component:	SQLEngine
Message:	An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)
   
Explanation
SQL Server did not respond to the client request because the server is probably not started.

   
User Action
Make sure that the server is started.

I don't understand this because I opened the inbound/outbound ports for 1433/1434.

As wel as inbound/outbound exceptions for the programs

%ProgramFiles%\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn\sqlservr.exe

%ProgramFiles% (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe

The configuration manager is configured as follows:

 

Microsoft SQL Server 2008 Service Pack 1 (KB968369)

Installatiedatum: ‎6-‎5-‎2010 16:20

Installatiestatus: voltooid

Type update: optioneel

This service pack upgrades SQL Server 2008 to SQL Server 2008 Service Pack 1 (SP1). This service pack upgrades all SQL Server 2008 instances and all components installed by SQL Server 2008 Setup. This service pack upgrades all editions of SQL Server 2008. If you need additional installation options, you should download this service pack at the Microsoft Download Center. For more information, see Microsoft Knowledge Base article 968369.

Meer informatie: 

http://support.microsoft.com/kb/968369

Help en ondersteuning: 

http://support.microsoft.com

This is the error in SMSS again It's irritating me for days now please help me to get rid of It: