Forums (Obsolete)

Old Forums

Installation and deployment Questions on installation, system configuration and deployment to the live server.

Version 4.x > Installation and deployment > Error creating database

View modes:

Member

finnsquib-yahoo.co - 3/8/2009 10:57:41 AM

Error creating database

Im having trouble getting past step 2 of the Kentico tutorial. I just get this error.

An error occured when creating database: [DataConnection.ExecuteQuery]: Query: CREATE DATABASE [Cards] COLLATE SQL_Latin1_General_CP1_CI_AS: caused exception: CREATE DATABASE permission denied in database 'master'.
Creating a new database Cards

Im using Microsoft SQL server 2008. I have connected using windows authentication.

Could someone please help?

Member

asdf-asdf - 3/8/2009 4:23:21 PM

RE:Error creating database

You will need to have proper permission to make changes into SQL Server 2008.

The easy way is as follows:
Create a new login (user) in security tab (SQL Server 2008 Management) - this is the user of which is your application pool for CMS running (default NETWORK SERVICE)
Create a database - for example kenticoDB
And grant a db_owner permission for this database to user you have created a step ago.

or
enable mixed authentication for SQL server and create a user who has ability to create a database sa account for developing purposes. Or create databse and grant the user db_owner role for production use.


Member	finnsquib-yahoo.co - 3/10/2009 9:10:54 AM RE:Error creating database Thanks. That sorted it. Everything is going fine now. You aved my sanity.


Member	finnsquib-yahoo.co - 3/10/2009 9:11:58 AM RE:Error creating database Saved my sanity even.

Top