search

Month: November 2016


Create Microsoft SQL Azure Database Read-Only User

Posted by in Microsoft Azure, Microsoft SQL

To create a login (server wide account) which uses a simple username + password combination for SQL authentication: CREATE LOGIN¬†ReadOnlyUserName¬†WITH PASSWORD = ‘strong_password’; NOTE: This allows the user to connect using SQL Management Studio. It is not required if the user only needs to connect to a specific database.   To create a user to…


Determine Microsoft SQL Azure Version

Posted by in Uncategorized

To determine the MSSQL version: SELECT @@version


close
search

Hi, guest!

settings

menu