CODEWITHSUNDEEP
sql-server-2008
LeBlaireau
LeBlaireau

Reputation: 17467

Cannot create SQL Server 2008 database

I am trying to create a database and I get the error belowenter image description here

Upvotes: 0

Views: 4236

Answers (3)

Darshana
Darshana

Reputation: 2548

Go to SQL Server -> Security -> Logins and create a new login with all permissions and roles.

Upvotes: 0

Diego
Diego

Reputation: 36126

you need permission to create a database. The simplest solution would be to connect with a user that inherits a login that has permission to create databases

Which user are you using to connect to the database?

right click you login and check if you have access to make yourself a dbcreator:

enter image description here

Upvotes: 1

ansari1988
ansari1988

Reputation: 21

Solution for Microsoft SQL Server, Error: 262

Click on Start -> Click in Microsoft SQL Server 2005 Now right click on SQL Server Management Studio Click on Run as administrator Now the problem is solved. This is the actual process to login to our SQL server 2005 as an administrator with all the administrative rights. But I think in Microsoft SQL Server 2005 express edition we do not need to go through the above process.

Upvotes: 0

Related Questions