Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
 Posted - 2006-04-11 : 04:59:14
|
| let's say I have 2 instances created on a machineso we address them as serverA\instance1 and serverA\instance2i already did some searching but it seems the answer eludes me...i will be able to remove instance2 but what i want is to retain instance1 as default...so when i connect, i'd connect to serverA instead of serverA\instance1is this possible? without reinstalling the sql server? or changing the entry in the sysservers do it?TIA--------------------keeping it simple... |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-04-11 : 12:09:24
|
| Jen,You have 2 named instances. Why do you have serverA\instance1 and serverA\instance2 Instead of instance1 and serverA\instance2 ?I don't think it is possible.------------------------I think, therefore I am - Rene Descartes |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-04-11 : 12:27:34
|
| default is disabledok thanks ravilobo, just looking for an easy way out--------------------keeping it simple... |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-04-11 : 12:58:17
|
| there is no way that I know of to convert a named instance to a default instance. Even if there was some kind of hack to do this I think A new install of SQL as a default instance is probably the safest way to go.After installing the new instance, you could just detach/attach all your databases. If you install the same service pack, you could copy over the MSDB datafiles while offline so your jobs and DTS are back in place. There is also a script that we use (I got from this forum) to script out logins/passwords/default databases/etc. so you can migrate all the users over very easily. EDIT:Ok, I found the script. Derrick L. modified the sp_revlogin procedure microsoft created to also set the default database. get it here: http://sqlteam.com/forums/topic.asp?TOPIC_ID=35143 -ec |
|
|
|
|
|
|
transfer instance?