I am facing problem in creating database in the SQL server.

Posted Date: 10 Feb 2012 Posted By:: Anji Member Level: Bronze Member Rank: 3048 Points: 2 Responses: 2

Hi,

I have installed the SQL server successfully, while when tried to create own database then it denied to execute the command for the creation of database. Reflecting that master database disallowed the creation of new database.

Suggest me how to rectify this error.

Regards,

Responses

#656670 Author: Asheej T K Member Level: Diamond Member Rank: 2 Date: 10/Feb/2012 Rating: Points: 4
Hi, It seems you don't have permission to create database. Follow below steps, 1. Open SQL Server Management Studion and Connect to the database using windows authentication or by using admin account 2. Expand the Security and then Logins 3. Double Clic on the login id you wanted to give database creation previlege 4. From the General section select all Database role Membership and click OK 5. Disconnect the database and relogin by the user id you have give permission and try to create the database. Regards, Asheej T K Microsoft MVP[ASP.NET/IIS] DotNetSpider MVM Dotnet Galaxy

#656711 Author: Anji Member Level: Bronze Member Rank: 3048 Date: 10/Feb/2012 Rating: Points: 1
Thanks Asheej, for providing me the solution. I will try to follow the instruction. If face any problem then will let you know. Regards, Adi

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : Repeat Group Header in each row SSRS
	Previous : How to get combine data in sql
	Return to Discussion Forum
	Post New Message
	Category:

Related Messages

Active Members
Today

Last 7 Days

more...

Awards & Gifts

Email subscription

Talk to Webmaster Tony John