Can not connect to database engine

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

my Sql server is working fine but after i restated my Computer and the i opened my sql server 2008 and press the connect button it shows me this error

CSS

TITLE: Connect to Database Engine
------------------------------

Cannot connect to (local).

------------------------------
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

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

------------------------------
BUTTONS:
OK
------------------------------

please help me i have created the database and also i have no recent backup of that database.
all my connections are close

Please help me

Posted 1-May-13 5:28am

hinaiqbal

Add a Solution

Comments

ZurdoDev 1-May-13 11:29am

Your service is not likely running. Look in services and make sure SQL is running.

hinaiqbal 1-May-13 11:47am

from where to check that the services are running or not

ZurdoDev 1-May-13 11:50am

Admin Tools, Services.

hinaiqbal 1-May-13 12:01pm

SQL Server(SQLEXPRESS) has the status started but SQL Server(MSSQLSERVER) has no status

ZurdoDev 1-May-13 12:04pm

It's your server. I don't know which one is right or wrong.

hinaiqbal 1-May-13 12:11pm

there is also one service whose name is server and is used for file,print and namedpipe sharing over the network for this computer and its status is started

When i connect my sql server using .\SQLEXPRESS or Name-PC\SQLEXPRESS it establishes the connection but it does not show my database which i used. and when i want to connect using Name-PC server name or local it generates the above mentioned error

ZurdoDev 1-May-13 12:24pm

Sounds like you need to turn on SQL Server(MSSQLSERVER)

hinaiqbal 1-May-13 12:28pm

when i start this SQL Server(MSSQLSERVER) the message is displayed that windows couldnot start SQL Server(MSSQLSERVER) on Local Computer

ZurdoDev 1-May-13 13:33pm

You need to find the error. Better yet, you need to find the whoever manages this server and ask them.

hinaiqbal 1-May-13 14:10pm

this is my server installed on my local machine and there i installed visual studio 2012 which i used for my project development and for database used SQL Server 2008

ZurdoDev 1-May-13 14:11pm

So, do you remember which SQL to use then?

hinaiqbal 1-May-13 14:18pm

SQL Server(MSSQLSERVER). but it does not start any solution that can solve my problem is appreciated because i am stuck with it and can't do any work.please help me

ZurdoDev 1-May-13 14:18pm

I know it does not start. I asked you to find the error. Look in th event viewer.

hinaiqbal 1-May-13 15:57pm

Log Name: System
Source: Service Control Manager
Date: 5/1/2013 6:39:00 PM
Event ID: 7024
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: Awais-PC
Description:
The SQL Server (MSSQLSERVER) service terminated with service-specific error WARNING: You have until SQL Server (MSSQLSERVER) to logoff. If you have not logged off at this time, your session will be disconnected, and any open files or devices you have open may lose data..
Event Xml:
<event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<system>
<Provider Name="Service Control Manager" Guid="{555908d1-a6d7-4695-8e1e-26931d2012f4}" EventSourceName="Service Control Manager" />
<eventid qualifiers="49152">7024
<version>0
<level>2
<task>0
<opcode>0
<keywords>0x8080000000000000
<timecreated systemtime="2013-05-01T13:39:00.326075300Z">
<eventrecordid>39906
<correlation>
<execution processid="752" threadid="852">
<channel>System
<computer>Awais-PC
<security>

<eventdata>
SQL Server (MSSQLSERVER)
%%3417

ZurdoDev 1-May-13 16:04pm

Search google but it looks like you might have your drive compressed, or at least the folder where the data files are. Did this used to work?

Richard C Bishop 1-May-13 11:29am

Is "local" the name of your server or db engine?

hinaiqbal 1-May-13 11:46am

local is the sever name

[no name] 1-May-13 11:30am

Did you bother to check if the services are running? Did you check your event logs?

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)

Thomas Daniels · Answer 1 · 2013-05-01T05:48:00

Solution 1

Hi,

No instance of SQL Server is running. You can start an instance of SQL Server using the SQL Server Configuration Manager:
http://msdn.microsoft.com/en-us/library/ms190699%28v=sql.100%29.aspx[^]

[Edit]

If the Configuration Manager isn't installed, use the net commands to start an instance of SQL Server:
http://msdn.microsoft.com/en-us/library/ms187598%28v=sql.100%29.aspx[^]

Posted 1-May-13 5:48am

Thomas Daniels

Updated 1-May-13 6:24am

v3

Comments

hinaiqbal 1-May-13 12:15pm

i have seen the link mentioned by you but
On the Start menu, point to All Programs, point to Microsoft SQL Server 2008, point to Configuration Tools, i am unable to see SQL Server Configuration Manager. there is only SQL Server Installation center

Thomas Daniels 1-May-13 12:24pm

I updated my answer.

hinaiqbal 1-May-13 14:12pm

i have used your second link command net start "SQL Server (local)" but it displays that the service name is invalid

Thomas Daniels 2-May-13 11:21am

Try net start MSSQLSERVER