SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 Error 26
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sirmilt
Starting Member

USA
49 Posts

Posted - 05/30/2012 :  20:16:45  Show Profile  Reply with Quote
When I try to run SQL Server 2008 R2 Express I get error 26 indicating that the Server could not be found.
The system worked fine last week and was not used for a week and when I tried it I get the error.

I installed Service Pack 1 and it worked fine, the first time used it,an hour later it produced the same error.

I installed SP2 but still get the error and I don't know where to turn from here.

Can anyone help?

Milt


Milt

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 05/30/2012 :  21:51:07  Show Profile  Reply with Quote
first check if the sql server express service is running by looking into start->run and typing services.msc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

sirmilt
Starting Member

USA
49 Posts

Posted - 05/31/2012 :  00:36:37  Show Profile  Reply with Quote
Thanks for the suggestion. The following SQL services are running:
SQL Active Directory Services
SQL Server(MSSQL Server)
SQL Server(SQLEXPRESS)
SQL Server Agent(MSSQL Server)
SQL Server Agent(SQLEXPRESS)
SQL Server Browser
SQL Server VSS Writer
If I understand what I see(which is probably doubtful)they all seem to be running, Where do I go from here?

Milt

Milt
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 05/31/2012 :  16:09:49  Show Profile  Reply with Quote
which one of these is service for 2008r2?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36845 Posts

Posted - 05/31/2012 :  17:35:46  Show Profile  Visit tkizer's Homepage  Reply with Quote
How are you connecting to the instance, meaning what server name are you using? It sounds like you are using the wrong name.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000