Timeline for The login already has an account under a different user name
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 4, 2019 at 15:36 | comment | added | Pxtl | Shouldn't this be and type = 'U' to confirm that it's a user or is that redundant? | |
| Feb 22, 2013 at 14:44 | comment | added | Marian | @AaronBertrand Thanks, I've edited the answer to use the new system tables. | |
| Feb 22, 2013 at 14:42 | history | edited | Marian | CC BY-SA 3.0 |
added PS section
|
| Feb 22, 2013 at 14:23 | comment | added | Aaron Bertrand |
I would use sys.server_principals and sys.database_principals. sysusers and syslogins are only there for backward compatibility.
|
|
| Feb 22, 2013 at 9:29 | comment | added | Marian | Guess what: "-E -> Authenticate with current Windows credentials." :-) | |
| Feb 22, 2013 at 9:18 | comment | added | Jack |
Actually, I used the command aspnet_regsql -E -S .\MSSQLSERVER_R2 -ssadd to create the ASPState database. I think probably, I am already set, even though, I even don't realize it in the first place.
|
|
| Feb 22, 2013 at 9:16 | vote | accept | Jack | ||
| Feb 22, 2013 at 9:16 | comment | added | Marian | Have you created the database using that login to connect to the server? If yes, then you're the db owner of it and don't need to create another user. You're already set. | |
| Feb 22, 2013 at 9:06 | comment | added | Jack |
Ok, I see the value dbo being displayed. Strange, I don't remember that I have use the dbo for my account R2Server\AAOUser. Wondering what I should do next.
|
|
| Feb 22, 2013 at 8:06 | history | answered | Marian | CC BY-SA 3.0 |