خطای 262 درsql server 2008

bety ahmadpour

کاربر تازه وارد
تازه وارد
راه رفع خطای 262 در sql server چیست
متن خطا
CREATE DATABASE permission is denied in database master.(microsoft sql server error 262)


خیلی ممنون میشم اگه جواب بدین
 

domer

کاربر تازه وارد
تازه وارد
پاسخ : خطای 262 درsql server 2008

CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262)
SQL Server
>
SQL Server Tools
Question
0
How exactly do I correct this problem on Vista?

TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Create failed for Database 'kkl'. (Microsoft.SqlServer.Express.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476

I have ensured that I am logged into the system as Admin but cannot find where on the Server, I assign my login to the dbcreator group.

I have gone into Security >> Server Roles >> dbcreator. of which I am not a member. On a different system, where all works, however, I am not a member of this group either.

Any suggestions on how to kill this one?

Thanks in Advance.

Klaus

and this fixed my problem:
http://msdn2.microsoft.com/en-us/library/bb326612.aspx

and this fixed my problem:

http://msdn2.microsoft.com/en-us/library/bb326612.aspx


BTW, if you are using Windows Vista which I assume you are....then this problem is easily fixed by running SQLServer as an Administrator

A "CREATE DATABASE permission denied..." can also occur if the SQL service (including MSSQLSERVER or a cluster service account), or installation account, does not have adequate file permissions on the database partition. Check the file permissions of the target partition.

Securing Data and Log Files (SQL Books Online)
http://msdn2.microsoft.com/en-us/library/ms189128.aspx



I'm facing the same issue on windows 2003 server. I'm logged on with my windows account and I am in the local administrators group as well.

I get the error

Create failed for Database 'test1'. (Microsoft.SqlServer.Express.Smo)

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)

CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262
 
بالا