This post is a response to this month's T-SQL Tuesday prompt created by Arun Sirpal . Adam Machanic created T-SQL Tuesday as a way for SQL users to share ideas about interesting topics. This month's topic is "Your Technical Challenges Conquered" .
DBA Skills 101: SQL Logins
While writing last week's post about efficiently scripting database objects , I decided to make progress towards my 2018 learning goals by figuring out what database permissions were needed for running SQL Server Management Studio's "Generate Scripts" tool.
I thought it would be best to start with a clean slate so I created a new SQL login and database user so that I could definitively figure out which permissions are needed.
Normally I use Windows Authentication for my logins, but this time I thought "since I'm getting crazy learning new things, let me try creating a SQL Login instead."
After I created my login, I decided to test connecting to my server before digging into the permissions. Result?
I can't connect!
That's right, I tried to connect and I got this very detailed error message