April 13, 2013 at 6:27 am
Here it is. In the last month I got 2 hard drive failure, and did have to reinstall SQL server 2008 R2. The 2 first time, no problem everything went smooth.
After last hard drive failure, I had reinstalled Windows 7 (x64) and SQL server 2008 R2 ... works fine. No problem to connect to the server using Windows authentication. I install SP1 for 2008 r2 and since then I can't anymore connect to the server (on my local machine).
Got error message as below.
I do notice that the SQL server service is stopped. If I restart it, try to connect, it will automatically stop.
Any hints on how to get that situation resolved ...
Thanks
pascal.
TITLE: Connect to Server
------------------------------
Cannot connect to <Machine>\<Instance>.
------------------------------
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=10061&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply