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