SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 sql server 2008 error: “A network-related"
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

learningsql00
Starting Member

28 Posts

Posted - 07/09/2012 :  18:47:06  Show Profile  Reply with Quote
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-Bit

Eeverything 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...


Edited by - learningsql00 on 07/09/2012 18:47:42

tkizer
Almighty SQL Goddess

USA
37143 Posts

Posted - 07/09/2012 :  18:49:27  Show Profile  Visit tkizer's Homepage  Reply with Quote
You'll need to find the error in the Application Log in Event Viewer. We need that to help. Try starting the service and then immediately see what entries were posted to the AppLog.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

learningsql00
Starting Member

28 Posts

Posted - 07/09/2012 :  19:05:03  Show Profile  Reply with Quote
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...

Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37143 Posts

Posted - 07/09/2012 :  19:07:48  Show Profile  Visit tkizer's Homepage  Reply with Quote
Yikes! I hope you have backups of all of the databases. You need to restore master for starters. Books Online has details. It isn't a newbie type thing though, FYI.

What happened? I don't know. You'll need to research the event log entries around the time the problem started. My guess is you've got disk problems.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

learningsql00
Starting Member

28 Posts

Posted - 07/09/2012 :  19:10:36  Show Profile  Reply with Quote
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

Edited by - learningsql00 on 07/09/2012 19:12:28
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37143 Posts

Posted - 07/09/2012 :  19:20:47  Show Profile  Visit tkizer's Homepage  Reply with Quote
1) No.
2) You could try to rebuild it. Take a look at the rebuild master topic in Books Online. I can't remember if you'll lose your password or not. BOL should have details.
3) I would use the BOL document.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

learningsql00
Starting Member

28 Posts

Posted - 07/09/2012 :  19:27:44  Show Profile  Reply with Quote
1) Is there any solution to get the backup or recover my other database ? Please helppp, this is VERY IMP

2) What is BOL document ? please provide me the link of tutorial to follow ?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37143 Posts

Posted - 07/09/2012 :  19:35:31  Show Profile  Visit tkizer's Homepage  Reply with Quote
Books Online is the SQL Server help documentation. Hopefully you installed it when you installed SQL Server.

You can try this article: http://blogs.msdn.com/b/psssql/archive/2008/08/29/how-to-rebuild-system-databases-in-sql-server-2008.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

learningsql00
Starting Member

28 Posts

Posted - 07/09/2012 :  19:41:13  Show Profile  Reply with Quote
1) Is there any solution to get the backup or recover my other database ? Please helppp, this is VERY IMP

2) 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 MSSQLSERVER
The service name is invalid.

More help is available by typing NET HELPMSG 2185.


C:\Users\PC>net start "SQL Server (SQLEXPRESS)" /f /m
The 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 ?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37143 Posts

Posted - 07/09/2012 :  19:50:11  Show Profile  Visit tkizer's Homepage  Reply with Quote
Did you look at the article I posted?

You need to call Microsoft. Without backups though, I'm not sure how this is going to turn out.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

learningsql00
Starting Member

28 Posts

Posted - 07/09/2012 :  19:53:12  Show Profile  Reply with Quote
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 ?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37143 Posts

Posted - 07/09/2012 :  20:01:45  Show Profile  Visit tkizer's Homepage  Reply with Quote
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 Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

learningsql00
Starting Member

28 Posts

Posted - 07/09/2012 :  21:56:34  Show Profile  Reply with Quote
thank you for your help, I will post back the results here after trying the above mentioned things.
Go to Top of Page

learningsql00
Starting Member

28 Posts

Posted - 07/10/2012 :  16:31:10  Show Profile  Reply with Quote
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 ?

Edited by - learningsql00 on 07/10/2012 16:32:22
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37143 Posts

Posted - 07/10/2012 :  16:32:35  Show Profile  Visit tkizer's Homepage  Reply with Quote
It's almost always a hardware issue and specifically a disk problem. You'll need to run hardware diagnostics and review the event log at the time the event first occurred.

Glad to hear everything is working again.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

learningsql00
Starting Member

28 Posts

Posted - 07/10/2012 :  16:46:58  Show Profile  Reply with Quote
thank you very much for your help and time tkizer, i deeply appreciate it
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37143 Posts

Posted - 07/10/2012 :  16:47:30  Show Profile  Visit tkizer's Homepage  Reply with Quote
You're welcome, glad to help.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

bhaskarareddy
Starting Member

7 Posts

Posted - 07/13/2012 :  19:50:13  Show Profile  Reply with Quote
hi

we may need to enable the tcp/ip properties


http://csharpektroncmssql.blogspot.in/2012/04/network-related-or-instance-specific.html
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37143 Posts

Posted - 07/14/2012 :  18:08:49  Show Profile  Visit tkizer's Homepage  Reply with Quote
quote:
Originally posted by bhaskarareddy

hi

we may need to enable the tcp/ip properties




What does enabling tcp/ip have to do with a corrupted master database?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.22 seconds. Powered By: Snitz Forums 2000