Question

  Asked: Mar 25 2008   3:35 PM GMT
  Asked by: Praya


Database Creation


Create Database error ( No i.d. #), SQL Server installation, SQL Server errors, SQL Server 2005

Recieving an error for database creation permission for sql 2005. Please advise

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



To troubleshoot the problem more information is required.
Can you provide the error message[(s)/B]?


    Is the Database name you are using only letters and numbers?
    The location you are choosing for the database files, can you go there with Explorer and create a file with notepad?
    What local group(s) are you a member of?
    Is the computer a Domain Member?
    Did you install SQL2005 on this computer?


Regular users can not create databases on the server without special permissions. Normally this means being a member of the sysadmin role or the database creators role. The CREATE DATABASE permission can be granted specifically to all the creating of databases without the additional rights being granted.

As was stated above, more information is needed to fix this problem. What's the error you are getting?
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register