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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2005-10-10 : 06:57:33
|
| i need for security reasons to change the default database from master to something else - how do i do that?thnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-10-10 : 07:35:28
|
| What have you tried ?Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
 |
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2005-10-10 : 07:46:01
|
| i have moved the location of the master to another placebut can i rename it too and the DB will work ok?thnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-10-11 : 00:12:06
|
| the system databases are a must for sql server to work, if you remove/rename the master database, see what happens...--------------------keeping it simple... |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-10-11 : 01:06:16
|
quote:
Originally posted by pelegk2
i have moved the location of the master to another placebut can i rename it too and the DB will work ok?
WOW! Where did you come up with that idea? I NEVER would have thought of moving the master database. What ecactly are you trying to accomplish? Just trying to direct users to a different database when they initially login? That's what I think of when you talk abou the default database. In which case, I would have gone searching through SQL Server Books online, under the subject default database of login and you'll find just the thing to solve your woes.---------------------------EmeraldCityDomains.com |
|
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2005-10-11 : 01:48:59
|
| AjarnMark i change the default database for all users if thats what you mean:) Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-10-11 : 05:14:42
|
"What have you tried ?"Are you glad you asked?  Kristen |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-10-11 : 12:51:03
|
quote:
Originally posted by pelegk2
AjarnMark i change the default database for all users if thats what you mean:)
Yes, that's exactly what I meant. What did you mean by "I have moved the location of the master..."---------------------------EmeraldCityDomains.com |
|
|
|
|
|
|
default database