Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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
 
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 6:28am
Comments
ryanb31 at 1-May-13 11:29am
   
Your service is not likely running. Look in services and make sure SQL is running.
engr.hinaiqbal at 1-May-13 11:47am
   
from where to check that the services are running or not
ryanb31 at 1-May-13 11:50am
   
Admin Tools, Services.
engr.hinaiqbal at 1-May-13 12:01pm
   
SQL Server(SQLEXPRESS) has the status started but SQL Server(MSSQLSERVER) has no status
ryanb31 at 1-May-13 12:04pm
   
It's your server. I don't know which one is right or wrong.
engr.hinaiqbal at 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
ryanb31 at 1-May-13 12:24pm
   
Sounds like you need to turn on SQL Server(MSSQLSERVER)
engr.hinaiqbal at 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
ryanb31 at 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.
engr.hinaiqbal at 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
ryanb31 at 1-May-13 14:11pm
   
So, do you remember which SQL to use then?
engr.hinaiqbal at 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
ryanb31 at 1-May-13 14:18pm
   
I know it does not start. I asked you to find the error. Look in th event viewer.
engr.hinaiqbal at 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:


<Provider Name="Service Control Manager" Guid="{555908d1-a6d7-4695-8e1e-26931d2012f4}" EventSourceName="Service Control Manager" />
7024
0
2
0
0
0x8080000000000000

39906


System
Awais-PC



SQL Server (MSSQLSERVER)
%%3417

ryanb31 at 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?
richcb at 1-May-13 11:29am
   
Is "local" the name of your server or db engine?
engr.hinaiqbal at 1-May-13 11:46am
   
local is the sever name
ThePhantomUpvoter at 1-May-13 11:30am
   
Did you bother to check if the services are running? Did you check your event logs?

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

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[^]
  Permalink  
v3
Comments
engr.hinaiqbal at 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
ProgramFOX at 1-May-13 12:24pm
   
I updated my answer.
engr.hinaiqbal at 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
ProgramFOX at 2-May-13 11:21am
   
Try net start MSSQLSERVER

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

  Print Answers RSS
0 OriginalGriff 350
1 Jochen Arndt 150
2 Richard MacCutchan 135
3 PIEBALDconsult 110
4 Sergey Alexandrovich Kryukov 104
0 OriginalGriff 6,055
1 DamithSL 4,621
2 Maciej Los 4,087
3 Kornfeld Eliyahu Peter 3,500
4 Sergey Alexandrovich Kryukov 3,294


Advertise | Privacy | Mobile
Web04 | 2.8.141220.1 | Last Updated 1 May 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100