I've had some 18456 errors in attempting to log into MSSQL databases I've created as described here and here. I think I may have sabotaged a login by renaming a database. I don't know what I've screwed up really, but I have figured out how to start over from scratch:
In Microsoft SQL Server Management Studio, create a login under Security, making it sysadmin, then create a database under Databases. When creating the database, set users and specify your login as a user. That is all. Don't worry about creating users at the database itself.
No comments:
Post a Comment