June 15, 2012 at 10:01 am
Hi i'm using SQL server 2008 that was working well. Today when i tried to connect with the server it gave me this error
TITLE: Connect to Server
------------------------------
Cannot connect to mrdeveloper.
------------------------------
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
SQL Server is installed on the same PC it was working 2 days ago but now...
Kindly guid me
June 15, 2012 at 5:08 pm
It sounds like the instance is down. Check whether the instance is in fact running via configuration manager, if not check the latest error log to see why it is down, if it was a clean shutdown, restart it.
If you are not sure why it is down, try a restart anyway and investigate from there if it fails to start
---------------------------------------------------------------------
June 18, 2012 at 2:13 am
This was removed by the editor as SPAM
June 18, 2012 at 2:30 am
Open SQL Server Configuration Manager and verify that SQL Server service is running. Also check the account under which service is running is running is not locked and its password is not expired. Ensure TCI/IP protocol is enabled. 🙂
Regards,
Basit A. Farooq (MSC Computing, MCITP SQL Server 2005 & 2008, MCDBA SQL Server 2000)
http://basitaalishan.comJune 18, 2012 at 11:10 am
Actually the reason behind was mdb file was corrupted.:w00t:
June 19, 2012 at 1:59 am
by mdb do you mean msdb?
If the msdb database is corrupted SQL should still start, but SQLAgent won't. MSDB should be recovered from backup
http://msdn.microsoft.com/en-us/library/ms190749(v=sql.100).aspx
---------------------------------------------------------------------
June 19, 2012 at 3:28 am
This was removed by the editor as SPAM
June 19, 2012 at 3:38 am
yes, I guess mdb could mean mdf.
please post enough of the errorlog to show the errors you get on startup.
---------------------------------------------------------------------
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply