Re: SQL Logins using local user accounts on a clustered instance.
From: Uttam Parui[MS] (uttamkp_at_online.microsoft.com)
Date: 07/21/04
- Previous message: Uttam Parui[MS]: "Re: sql server 2000 clustering montoring"
- In reply to: Rodney R. Fournier [MVP]: "Re: SQL Logins using local user accounts on a clustered instance."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 21 Jul 2004 16:27:04 GMT
Srini.
Here is some testing that I did for you.
I just created a local NT account on the node where the virtual instance of SQL Server 2000 was currently running. Say node1. The NT user is node1\test. SQL virtual instance is running on node1. I opened Enterprise
Manager and was able to add the user node1\test. I was able to give it access to pubs db. Then I opened QA; logged in as node1\test and was able to execute commands.Then I moved the SQL virtual instance to
node2 and tried running the same commands from the QA that I opened previously. It failed with the error that you got. I moved SQL virtual instance back to node1 and once again the commands ran successfully.
I tried creating a local NT login on node2--- called node2\test. I was able to add it to SQL server but both are two different logins although their names are the same. I leave the rest of the testing for you.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
- Previous message: Uttam Parui[MS]: "Re: sql server 2000 clustering montoring"
- In reply to: Rodney R. Fournier [MVP]: "Re: SQL Logins using local user accounts on a clustered instance."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
