sql server 2008 r2 issue

Question

0.00/5 (No votes)

See more:

I have installed sql server 2008 r2 on a remote server having windows web server 2008.
The problem is whenever I start management studio and log in the screen shows "instance specific or network related error". I have noticed that the mssql service is not running. I try to start the service but that can't be done also.
Kindly help me with this issue

Posted 7-Apr-11 20:27pm

Muhammad Waqas Iqbal

Add a Solution

2 solutions

Solution 2

I got help from a peer of mine and found out that VIA protocol was enabled which was the cause of this problem. You can view this by opening the sql server configuration manager->sql server network configuration-> Protocols for MSSQL server

Posted 7-Apr-11 21:08pm

Muhammad Waqas Iqbal

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)

Wendelius · Accepted Answer · 2011-04-07T20:33:00

First, check both WIndows Event Log on the server and see what error is happening when you start the Sql Server.

Also have a look at the Sql Server ErrorLog (typically located in the instance home directory under MSSQL\LOG). The errorlog file should contain more detailed information about the problem.