If you have added new user and same will not able to create the database on SQL server 2008 due to "“CREATE DATABASE permission denied in database 'master'...” then follow the steps...
1. Click the Start button, point to All Programs, click Microsoft SQL Server, right-click SQL Server Management Studio, and then click Run as administrator.
2. Connect to an instance of SQL Server.
3. Click Security, right-click Logins, and then click domainname\username.
4. Click to Properties and Select Server Roles
5. Select the sysadmin check box, and then click OK.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment