| Author |
Topic |
|
learningsql00
Starting Member
28 Posts |
 Posted - 2012-07-09 : 18:47:06
|
I am using SQL Server Management 2008 R2 Express and getting this Error:“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: Shared Memory Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)”OS: Windows 7 SP1 32-BitEeverything was working fine and suddenly my asp.net application working, to troubleshoot the problem i thought let me see the database and I am unable to connect to my database.Tried everything, here are a few screenshots from my machine:    please help me... |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
learningsql00
Starting Member
28 Posts |
Posted - 2012-07-09 : 19:05:03
|
Here are the screenshots:   Does that means the master database has been corrupted or something ?How this happened ? everything was working fine and suddenly this problem started...Please help me to resolve this issue... |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
learningsql00
Starting Member
28 Posts |
Posted - 2012-07-09 : 19:10:36
|
| I do not have backup of my databases :(1) If I copy the "DATA" folder, will it work (if i try to restore the databases on different servers to recover the databases)2) Is it possible to replace the "master" database ? If yes, will is change the password for my "sa" login too ? because i guess sa login saves into master ?3) is this right solution ? http://www.techrepublic.com/article/recover-the-master-database-in-sql-server/5025441 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
learningsql00
Starting Member
28 Posts |
Posted - 2012-07-09 : 19:27:44
|
| 1) Is there any solution to get the backup or recover my other database ? Please helppp, this is VERY IMP2) What is BOL document ? please provide me the link of tutorial to follow ? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
learningsql00
Starting Member
28 Posts |
Posted - 2012-07-09 : 19:41:13
|
| 1) Is there any solution to get the backup or recover my other database ? Please helppp, this is VERY IMP2) I am trying this in cmd (command prompt) and getting this-------------------------------Microsoft Windows [Version 6.1.7601]Copyright (c) 2009 Microsoft Corporation. All rights reserved.C:\Users\PC>net start MSSQLSERVERThe service name is invalid.More help is available by typing NET HELPMSG 2185.C:\Users\PC>net start "SQL Server (SQLEXPRESS)" /f /mThe SQL Server (SQLEXPRESS) service is starting.The SQL Server (SQLEXPRESS) service could not be started.A service specific error occurred: 3417.More help is available by typing NET HELPMSG 3547.C:\Users\PC>-------------------------------I am trying this above because I want to start the SQL SERVER – Start SQL Server Instance in Single User Mode. but seems when I do this:Go to SQL Server Configuration Manager and click on SQL Server 2005 Services. Click on desired SQL Server instance and right click go to properties. On the Advance table enter param ‘-m;‘ before existing params in Startup Parameters box.In order for changes to affect, I need to restart the service, but the problem is service is not started, and I can't start the service of SQLEXPRESS at all, I get error message.any help ? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
learningsql00
Starting Member
28 Posts |
Posted - 2012-07-09 : 19:53:12
|
| Yes, I am reading...quick questions : 1) the last option is to reinstall the sql server 2008 rs express ?2) If I re-install the sql server (over-write) on current one, will "DATA" folder will be saved in that case ? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2012-07-09 : 20:01:45
|
| Reinstalling it will rebuild master. You'll want to grab your user database files just in case they are recoverable. I can't make any guarantees that you'll get your databases back. That's what backups are for.Save your mdf and ldf files for the user databases. But whatever caused this issue in the first place needs to be addressed. You've likely got a hardware problem as SQL Server just doesn't do this on its own.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
learningsql00
Starting Member
28 Posts |
Posted - 2012-07-09 : 21:56:34
|
| thank you for your help, I will post back the results here after trying the above mentioned things. |
|
|
|
learningsql00
Starting Member
28 Posts |
Posted - 2012-07-10 : 16:31:10
|
| so I ended up re-installing the sql server on the machine and now everything is working fine. I was able to recover the data from .mdf files from the previously installed sql server. Now I just had to attach the .mdf file and it is working."tkizer", i have a quick question - This kind of issue only occur when there is a problem in a disk ? or there could be any other reason for this issue ? I know its hard to tell but according to your experience what do you think ? any other guesses other than disk problem ? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
learningsql00
Starting Member
28 Posts |
Posted - 2012-07-10 : 16:46:58
|
| thank you very much for your help and time tkizer, i deeply appreciate it |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
bhaskarareddy
Starting Member
7 Posts |
Posted - 2012-07-13 : 19:50:13
|
| hiwe may need to enable the tcp/ip propertieshttp://csharpektroncmssql.blogspot.in/2012/04/network-related-or-instance-specific.html |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
sql server 2008 error: “A network-related"