July 29, 2005 at 10:45 am
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
August 1, 2005 at 8:00 am
This was removed by the editor as SPAM
August 1, 2005 at 8:44 am
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply