Third party MSDE installers

  • Hi,

    This is a two folded question.

    Lets say, I have two SQL servers installed on the same machine. One with a default instance and the second one which is a named instance. So, when I restart my box, first the default instance gets started and then the named instance. Is there a way to set the SQL servers to start in a different order.

    The reason for the above kind of start up is this, we have two SQL servers installed,

    1.) Default

    2.) Third party MSDE named instance.

    Now, when a new third party software is trying to create a database, its being prompted to install in thir party MSDE named instance. And this server isn't allowing to create any new databases.

    So I am thinking, if I change the order in which the SQL servers start, maybe the program will be able to create the new database in default instance without any problem.

    -R

  • This was removed by the editor as SPAM

  • Not 100% sure this would work, but you could try making hte one you want to start 2nd to be a dependancy of the first instance.  We've had issues with a pervasive db and sql instance not starting in the correct order and this has helped to allievate our issues.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

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

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