Post reply

sql instances not running

  • May 26, 2009 at 10:53 pm

    #137984

    Hi experts,

    one of our user having sql2000 exp edition(default instance) and sql2005 dev edition(named instance)

    when i restart the system named instance is not running

    then i checked in services.msc

    i stopped default instace services then i started named instance services

    now it is running

    but i want to know why named instance services are stopping if i restart the machine

    please give your valuble solution to fix this issue permanently

    Thanks in advance

  • May 27, 2009 at 12:12 am

    #1000350

    Have you set it to START "Automatic"ally. ?

  • May 27, 2009 at 1:30 am

    #1000379

    Thanks for u r reply

    pls give me clear solution or with any link

    where i need to do (start automatically) for both default and named instance.

    Thanks

  • May 27, 2009 at 1:50 am

    #1000383

    You will find that option on the Properties of the Services.

    Under 'General' properties you can set 'Start UpType' to 'Automatic'....

    for recovery u can follow below steps:

    Rightclick on the properties and you will find different tabs...

    Go to 'Recovery' tab and the in the 'First Failure' section you need to there you need to set up

  • May 28, 2009 at 5:01 am

    #1001313

    thanks for reply

    i did same thing but iam getting error

    PFA...

    some times i try to connect remote instance iam getting this errors

    pls reply

    thanks in advance

  • May 28, 2009 at 5:14 am

    #1001319

    Do both instances use different port numbers?

  • May 28, 2009 at 9:44 am

    #1001523

    Go to sql surface area configurations then switch to service select automaticaly from start mode. click apply and ok.


    - Pradyothana     http://www.msqlserver.com

  • May 28, 2009 at 10:23 am

    #1001559

    Pardon me if you have already answered this, but which instance (or instances) of SQL Server are you unable to connect to remotely?

Viewing 8 posts - 1 through 7 (of 7 total)

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