Sql server 2008 r2 not starting from Services

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

, +

Many days ago i installed SQL server 2008 R2 after that i installed VS2012 professional.
now i am trying to Login SQL Server i getting this error which is the routine 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)

usually i go to services and start sqlexpress from there but surprisingly i failed there also to start it and get this error

Windows could not start the sql server(SQLEXPRESS) on local computer. For more  inforamation, review system event log. ...

what is this i also open Event log but dont know whats going on . i search alot but didnt find right solution remember when i checked sql server services from sql configuration i also got this

remoter procedure call failed...

Posted 1-Sep-13 20:12pm

Muhamad Faizan Khan

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2013-09-01T20:39:00

Solution 2

Probably, it's the order in which you installed things.
VS uses SQL and it installs it's own version (which I don't think is complete from previous experience).

I haven't installed VS2012 - I'm still on 2010- but I had similar problems with 2010 and 2008.

The best suggestion I can make is: uninstall both VS and SQL and install then in the opposite order.

Posted 1-Sep-13 20:39pm

OriginalGriff

Comments

Muhamad Faizan Khan 2-Sep-13 2:51am

but the sir my sqlserver was working fine

phil.o · Answer 2 · 2013-09-01T20:35:00

Solution 1

For more inforamation, review system event log. ...

Check for System Log, and report errors related to SQL server instance. There is no way to find out what is going on if you do not do this research in the first place. We (you) need at least an error number to start from.

Posted 1-Sep-13 20:35pm

phil.o

Comments

OriginalGriff 2-Sep-13 4:09am

Reason for my vote of one: this is not a solution, it is a comment - and there is a mechanism for asking for such information that does not remove a question from the "unanswered" list.
Please use it in future! ;)

phil.o 2-Sep-13 6:03am

You're right ; I guess my eyes weren't opened enough on this monday morning :)
Anyway, I can see that we still don't have any error number to work with ; and I'm not in the mood for guessing problems today.