Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error when attempting to start Local SQL Server Expand / Collapse
Author
Message
Posted Sunday, February 16, 2014 7:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 21, 2014 9:00 AM
Points: 3, Visits: 16
I'm a newbie taking an online SQL Server 2012 class. I can't move past the first section b/c I can't get my SQL server to start.

I've opened port 1433 in the Config Manager (error: The request failed or the service did not respond in a timely fashion.)

My Shared Memory Protocol is enabled, I've confirmed that the Server is allowed in Windows Firewall, I've configured the SQL Server to allow remote connections, I've started the SQL Browser with success......

I also receive the error message that (The MSSQL$SQLEXPRESS service on .... started and then stopped (Object Explorer)).

I feel like I've done everything I can think of based on online videos and forums on the MS site. I'm getting nowhere. Can anyone here think of anything that I haven't done? I'll greatly appreciate your help.

Thanks, Lisa

EDIT to above post:

I uninstalled and reinstalled SQL Server Express 2012 and get the following failures:
Database Engine Services
SQL Server Replication
I think this the the core of my issue. Any thoughts on how to remedy this?
Post #1541904
Posted Monday, February 17, 2014 10:38 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:11 PM
Points: 6,466, Visits: 13,921
lmpotthoff (2/16/2014)
I'm a newbie taking an online SQL Server 2012 class. I can't move past the first section b/c I can't get my SQL server to start.

I've opened port 1433 in the Config Manager (error: The request failed or the service did not respond in a timely fashion.)

My Shared Memory Protocol is enabled

SQL Server browser is not required for a default instance using port 1433, in fact if you install just a default instance the browser service is not installed. Shared memory protocol is used by local connections only and likely not required.

lmpotthoff (2/16/2014)
I've confirmed that the Server is allowed in Windows Firewall, I've configured the SQL Server to allow remote connections

This has nothing to do with the services not starting, might stop you connecting in remotely though


lmpotthoff (2/16/2014)
I also receive the error message that (The MSSQL$SQLEXPRESS service on .... started and then stopped (Object Explorer)).

So you have express installed then, a named instance will invoke the SQL Browser.


Look through the Windows application log and post details of any errors relating to the service not starting


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1542225
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse