#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    25
    Rep Power
    0

    annoying problem


    my client is running SQL on win98 machines, MS SQL will not startup when he reboots his machine. I have seen that the option is ticked, what do i have to do for it to automatically start ?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Location
    BC, Canada
    Posts
    32
    Rep Power
    11
    While I don;t use SQL on 98 (nor do I think it is a good idea). I *believe* (never actually tested) you need to have the SQL Server Service Manager in the startup folder of the start menu. it will start SQL for you.

    If the computers require that a user logs on, SQL will not start untill after logging on.
  4. #3
  5. Banned ;)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Nov 2001
    Location
    Woodland Hills, Los Angeles County, California, USA
    Posts
    9,625
    Rep Power
    4247
    See this: http://www.schemamania.org/jkl/books...8_ar_sa_43.htm

    You'll need to start the database engine and the agent together. Hope this helps . Unfortunately, I've never run SQL Server on a non NT class OS, so that's the best I can come up with.
    Up the Irons
    What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
    "Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
    Down with Sharon Osbourne

    "I wouldn't hire a butcher to fix my car. I also wouldn't hire a marketing firm to build my website." - Nilpo

IMN logo majestic logo threadwatch logo seochat tools logo