SQL Server 2008 cannot connect to Database Engine

I don't know how to do this. I opened my SQL Server and connected using Windows Authentication at 10am. Until now, it does not go to the "Explorer".

I checked the services. The SQL Server Browser is running as well as the SQL Server Service. I restarted the service, but this did not solve the problem.

What should I do?

Below is the screen shot of the error.

(note the Server name has bee removed intentionally, I am actually using a server name)

Here开发者_运维问答's regarding the services I mentioned earlier

Do you mean that you can't see any databases listed in the Object Explorer? If so, click 'Connect' and choose to connect to a Database Engine. This should then list the server in that list.

Or if it is there, maybe it just needs to be expanded?

I assume that connection was working earlier? Maybe you could try to access server using dedicated administrator connection? Here is a brief description:

http://msdn.microsoft.com/en-us/library/ms178068.aspx

Another thing worth checking are protocols used for communication with server (shared mem, named pipes, tcp/ip, via) - check whether they haven't been disabled.

Maybe there is something also with your domain? If you use domain credentials, then maybe SQL Server has problems communicating with it.

If connection was not working before, then check whether you have approved windows authentication access.

In the SQL server configuration manager, there is an item called SQL server network configuration, under protocols, I selected the properties of the TCP/IP protocol. There is a tab "IP Addresses" there, and at the bottom of the list is an entry called IPAll. In my case the TCP port was empty. I entered the SQL standard port 1433 in there and I was able to connect.

This should work!!!

Regards Mohammed

The server name should be PCNAME\SQLEXPRESS or PCNAME\MSSQLSERVER