| Author |
Message |
    
Dustin Carlson (fishwest)
New member
Username: fishwest
Post Number: 3
Registered: 02-2010
| | Posted on Wednesday, July 28, 2010 - 04:41 pm: | 
|
Hi-
This is probably more of a SQL question than it is a BT questions, but here goes:
When I try to add a user (that does exist in the SQL logins folder), I get an error that "The login already has an account under a different user name." I have attached a screenshot of the error. I guess what I am asking for is...is there a way to clean that user out?
Thank you!
Dustin
Fishwest |
Clark Frazier (cfrphoto)
Senior Member
Username: cfrphoto
Post Number: 2533
Registered: 03-2005
| | Posted on Wednesday, July 28, 2010 - 07:59 pm: |
|
Dustin,
I don't know for sure how this may have occurred. The following link may be useful: http://social.msdn.microsoft.com/forums/en-US/sqlsecurity/thread/9faf79d0-f4b6-4b6c-9505-68cd2ec636af/ or you can execute the following SQL from a SQL Server Management Studio Query Window:
sp_helplogins 'domain\account'
It appears that you may have set some SQL Server administrative accounts. Instead, I would recommend setting up your Windows login (using integrated security) as the administrator and do not assign SQL Server user accounts more privileges than necessary for running Blackthorne using the BTData database. Also, check schema ownership. Absent a compelling reason, it should always be dbo to avoid problems with multi-user database access.
Clark
cfrphoto |
|
Closed: New threads not accepted on this page 
