如何在MS SQL 2005中创建数据库? [英] How to Create Database in MS SQL 2005 ?

问题描述

数据库"DatabaseName"的创建失败

CREATE DATABASE权限在数据库"master"中被拒绝. (.Net SqlClient数据提供程序)

程序位置:

在System.Data.SqlClient.SqlConnection.OnError(SqlException异常，布尔值breakConnection)
在System.Data.SqlClient.SqlInternalConnection.OnError(SqlException异常，布尔值breakConnection)
在System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
在System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior，SqlCommand cmdHandler，SqlDataReader dataStream，BulkCopySimpleResultSet bulkCopyHandler，TdsParserStateObject stateObj)
在System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName，Boolean async)
在System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult结果，字符串methodName，布尔sendToPipe)
在System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
在Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand，ExecutionTypes执行类型)



请逐步告诉我解决此问题的方法...

Create failed for Database "DatabaseName"

CREATE DATABASE permission denied in database ''master''. (.Net SqlClient Data Provider)

Program Location:

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)



Please tell me step by step to solve this problem...

推荐答案

您 http: //blogs.msdn.com/b/dparys/archive/2009/09/17/create-database-permission-denied-in-database-master-my-fix.aspx [ http://www.sqlservercurry.com/2008/04/resolving-create-database- Permission.html

Did you google [^]with the error message?

The first few links itself looks promising to me.

http://blogs.msdn.com/b/dparys/archive/2009/09/17/create-database-permission-denied-in-database-master-my-fix.aspx[^]

http://www.sqlservercurry.com/2008/04/resolving-create-database-permission.html

您需要以具有数据库创建权限的用户身份登录-目前，您的ID不允许这样做.
请咨询您的DBA并分配权限，或分配新的临时ID.

You need to log in as a user you has database creation permissions - at present your ID does not allow it.
Check with your DBA and get permissions assigned, or a new, temporary ID allocated.

这篇关于如何在MS SQL 2005中创建数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！