In SQL Server 2014 Management Studio, click the Security folder for the library SQL Server instance.
Right-click Logins and select New login.
For Login name, enter “dotnetapp”.
For the Authentication method, click SQL Server Authentication.
For Password, enter a password of your choice. Don't enable the Enforce password policy option.
Change the Default Database to be the “bookshelf” database you previously created.
In the left side of the New login dialog, click User Mapping and complete the following steps:
a. For the bookshelf database, click the Map checkbox.
b. Under Database role membership for: bookshelf, click all of the roles except for the following:
• db_denydatareader
• db_denydatawriter
To create the new database login account, click OK.
The user you created is set to use SQL Server authentication so SQL Server needs to be configured to allow this authentication method. In SQL Server 2014 Management Studio right-click the Library SQL Server instance you created and select Properties.
In the left-side menu of the Server Properties dialog, click Security.
For the Server Authentication setting, select SQL Server and Windows Authentication mode, and then click OK.
To restart the SQL Server service, right-click the Library SQL Server instance and select Restart.
Join MindStick Community
You need to log in or register to vote on answers or questions.
We use cookies to ensure you have the best browsing experience on our website. By using our site, you
acknowledge that you have read and understood our
Cookie Policy &
Privacy Policy.
Configure the SQL Server
a. For the bookshelf database, click the Map checkbox.
b. Under Database role membership for: bookshelf, click all of the roles except for the following:
• db_denydatareader
• db_denydatawriter