I had an issue recently where I needed to connect to a SQL Server 2008 database using SQL Server Management Studio with a specific set of credentials via windows authentication.
You will no doubt have noticed that by default when a user selects windows authentication the username and password fields are greyed out and the username is populated with the user account currently logged in to Windows. This meant that I didn’t have access to the database that I required and I was unable to proceed unless I had a valid SQL Authentication account.
Having spent ten mins looking into this it turns out it is entirely possible to run SQL Management Studio from the command prompt and supply the username and password it should use. Below is the command to do this:
>runas /user:DOMAIN\USERNAME “C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe”
Assuming the path is correct you will be prompted for the password associated with the account and if supplied correctly SQL Management Studio will open with the supplied details populated for windows authentication.