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 |
|
fqiao70
Yak Posting Veteran
52 Posts |
 Posted - 2004-04-07 : 15:24:33
|
| Hi allI have SQL server instance running on clustered servers( node1 & node2) I have to create a local user (node1\user) to use the database, I want to know when failed over how to solve it without changing to node2\user?????????Thanks a millon! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-07 : 16:11:11
|
| You should be using a domain user and not a local account. The domain user would have local admin privileges on both nodes.Tara |
 |
|
|
fqiao70
Yak Posting Veteran
52 Posts |
Posted - 2004-04-07 : 18:50:28
|
| I have to use local users that application maual says. I have a virtual name, can it be created like virtualnode\user? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-04-07 : 19:01:12
|
| I do not believe so. What application requires a local user? A domain account that is a member of the local users group behaves the same as a local user.Tara |
|
|
|
fqiao70
Yak Posting Veteran
52 Posts |
Posted - 2004-04-08 : 17:53:57
|
| It's actually a DMZ web server needs local user, it doesn't belong to domainThanks |
|
|
|
|
|
|
local user for cluster