Error when attempting to start Local SQL Server

  • 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?

  • 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" 😉

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply