Error while opening SQL Server

Question

0.00/5 (No votes)

See more:

While connecting the SQL Server I am geting the following error
I am using SQL Server 2008
If anybody know the reason behind this error please let me know also specify me with the solution if possible

CSS

TITLE: Connect to Server
------------------------------

Cannot connect to NEENA-PC\SQLEXPRESS.

------------------------------
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Posted 6-Mar-13 7:14am

NeenaM

Add a Solution

Comments

[no name] 6-Mar-13 13:28pm

Which part is unclear to you? Is the server running? Is the server "NEENA-PC\SQLEXPRESS"? Did you configure it to allow remote connections? Did you follow the given link and read/do what it said? Is the server on the network? Are you on the same network?

NeenaM 6-Mar-13 13:36pm

I have been using it for last six months it was connecting. I got this error few days back

Mike Meinz 6-Mar-13 13:47pm

Is SQL Server Express 2008 running on the same PC as the program or a server?

Can you access the database server using SQL Server Management Studio?

In SQL Server Configuration Manager, check to be sure that the SQL Server Browser running and that the SQL Server (SQLEXPRESS) is running.

If you right-click on SQL Server (SQLEXPRESS) in SQL Server Configuration Manager, and check the Properties, Advanced tab - Does the Instance ID say MSSQLxx.SQLExpress?

In a CMD window, if you PING NEENA-PC, do you get a response?

[no name] 6-Mar-13 14:06pm

And what does that have to do with anything? Just because it was working and does not work anymore does not mean that you do not have to go find out what happened or what changed.

ZurdoDev 6-Mar-13 14:42pm

It means it can't connect to the database. You'll have to examine it to figure out why.

1 solution

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)

Maciej Los · Accepted Answer · 2013-03-06T08:47:00

Solution 1

Start here: How to: Start an Instance of MS SQL Server?[^]
There you'll find more informations...

Posted 6-Mar-13 8:47am

Maciej Los