+ Post New Thread
Results 1 to 7 of 7
Windows Vista Thread, SQL Server Express 2008 in Technical; Hi guys and gals Am trying to play with umbraco on my Vista System but am having problems with SQL ...
  1. #1

    Join Date
    Jun 2007
    Location
    Middlesbrough
    Posts
    143
    Thank Post
    17
    Thanked 10 Times in 10 Posts
    Rep Power
    16

    SQL Server Express 2008

    Hi guys and gals

    Am trying to play with umbraco on my Vista System but am having problems with SQL 2008

    When trying to start the service -SQL Server (SQLEXPRESS) I get the following Error

    The SQL Server (SQLEXPRESS) service terminated with service-specific error 17058 (0x42A2).

    Have tried running as a seperate admin ac (created one called SQLAdmin)

    Still no luck

    Tried a google search to no luck =0(

    Any ideas people??

  2. #2
    Crispin's Avatar
    Join Date
    Dec 2008
    Location
    Essex
    Posts
    361
    Thank Post
    76
    Thanked 28 Times in 25 Posts
    Rep Power
    20
    As you probably already know from google it looks like an account security/permissions issue. Have you played with changing the account, ie. domain account/local etc? Have you checked permission settings?

    Im a novice at sql so apologies if this is obvious stuff, Ive just started getting acquainted with sql2008 while installing mylittlehelpdesk...

  3. Thanks to Crispin from:

    damienharrison (19th February 2009)

  4. #3

    Join Date
    Jun 2007
    Location
    Middlesbrough
    Posts
    143
    Thank Post
    17
    Thanked 10 Times in 10 Posts
    Rep Power
    16
    Hi yeah have tried that, hence creating the new SQLAdmin account with full admin rights etc

    Is just a complete heaqd scratcher - even after a beer (Gentleman Jack - Asda Extra Special Real Ale very very nice 1.50 a bottle or 3 for 4)

    Cheers

  5. #4

    EduTech's Avatar
    Join Date
    Aug 2007
    Location
    Reading
    Posts
    5,047
    Thank Post
    160
    Thanked 913 Times in 716 Posts
    Blog Entries
    3
    Rep Power
    271
    I know some people who have had this problem, and its because another programme is using the port SQL is using.

    I have also come accross where anti virus software is blocking the port and/or software itself, If you have McAfee or similar - disable it and see if you get the same error. If not that - there is something wrong with your network library or conflict with some other software that "steals" network resources required for SQL Server to accept connections.

  6. Thanks to EduTech from:

    damienharrison (20th February 2009)

  7. #5

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,154
    Thank Post
    114
    Thanked 527 Times in 450 Posts
    Blog Entries
    2
    Rep Power
    123
    How are you changing the SQL service account? If you do it in the services MMC then the account will get "log on as a service" right but won't get added to the security group called something like SQLServer2005MSSQLUser$COMPUTERNAME$SQLEXPRESS (probably "2008" for SQL 2008)

    If you change the account in SQL Server config manager then it makes the group changes.

  8. Thanks to srochford from:

    damienharrison (20th February 2009)

  9. #6

    Join Date
    Jun 2007
    Location
    Middlesbrough
    Posts
    143
    Thank Post
    17
    Thanked 10 Times in 10 Posts
    Rep Power
    16
    Cheers, will try have a play tonight (but am being dragged to Makro)

    =0)

  10. #7

    Join Date
    Mar 2009
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Using the First/Last Counter and First/Last Help values from the SQL Server Service\Performance Key do the values align properly with the TITLES database? If not unlodctr / lodctr will be compulsory to correct the Titles database and Performance key values. 642-642

SHARE:
+ Post New Thread

Similar Threads

  1. SQL Server Xpress 2008
    By RobKuwait in forum General Chat
    Replies: 12
    Last Post: 27th July 2009, 01:01 PM
  2. Serco Facility and MS SQL server Express edition
    By cheredenine in forum MIS Systems
    Replies: 19
    Last Post: 19th December 2008, 06:42 PM
  3. SQL Server Management Studio Express
    By Michael in forum Windows
    Replies: 4
    Last Post: 21st May 2008, 05:09 PM
  4. SQL Server 2005 express & Win2k3
    By contink in forum Windows
    Replies: 8
    Last Post: 14th May 2008, 02:56 PM
  5. Search Server 2008 Express
    By cookie_monster in forum Windows
    Replies: 7
    Last Post: 9th March 2008, 11:37 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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