Enable User without Login

Posted by Chris Straw on April 25, 2013 in Database, SQL Server |

This is a little tricky in the syntax. ┬áIf you have a SQL User without Login that is showing disabled, you have to grant it connect access, since there isn’t a SQL login.

Grant Connect To [SQLUserNameHere]


Leave a Reply

Your email address will not be published. Required fields are marked *

Copyright © 2011-2020 Chris Straw All rights reserved.
This site is using the Desk Mess Mirrored theme, v2.5, from BuyNowShop.com.