Results 1 to 4 of 4
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    SQL Server startup problem (SQL Server 2005 Express)

    I have uninstalled SQL Server 2005 which i had working some time ago, when i went to use it part of it had gone, noidea where, i could not start SQL Server 2005 Express.

    I downloaded SQLEXPR32.EXE and installed that a few times between uninstalling it.

    I have it installed and i get the enclosed error.

    Any ideas, cause i have none.
    Attached Images Attached Images

  2. #2
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL Server startup problem (SQL Server 2005 Express)

    Hi Pat,
    Ensure the service is started (which from the error I would think that it is) by opening the Configuration Manager and checking under SQL Server Services.
    How are you trying to access the express server instance? Via SSMSExpress or SSMS? I can't tell from the screen shot.
    Are you trying to connect locally or remotely? If remotely, ensure that remote connections are enabled through the SQL Server Surface Area Configuration for Services and Connections found in the Surface Area Configuration Tool. I use both TCP/IP and named pipes, but I think that only TCP/IP is required.
    What operating system are you using?
    Let's start with these and see where we are.
    Thanks.
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: SQL Server startup problem (SQL Server 2005 Express)

    Thanks Gary, i have solved it, i needed to start it with memory share.

  4. #4
    4 Star Lounger
    Join Date
    Jan 2002
    Location
    Brookings, South Dakota, USA
    Posts
    449
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: SQL Server startup problem (SQL Server 2005 Express)

    Cool. Nice catch.
    <IMG SRC=http://www.wopr.com/w3tuserpics/gdrezek_sig.jpg>
    "Those who dance are considered insane by those who can't hear the music" - George Carlin

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •