使用SQL Server 2008 R2创建数据库时出错 [英] Error in creating a database using sql server 2008 R2

问题描述

嗨 我是一名学生，当我完成asp.net课程时，我安装了Micorsoft sql server 2008 R2，现在我正在对sql课程进行介绍，我想到使用同一台sql服务器来创建数据库和创建表，但是我拥有出现以下错误

标题:Microsoft SQL Server Management Studio
------------------------------
数据库课程"创建失败. (Microsoft.SqlServer.Smo)
要获取帮助，请单击:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+(((KJ_RTM).100402-1540+)&EvtSrc=Microsoft .SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText& amp; EvtID = Create + Database& amp; LinkId = 20476
------------------------------
其他信息:
执行Transact-SQL语句或批处理时发生异常. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
CREATE DATABASE权限在数据库"master"中被拒绝. (Microsoft SQL Server，错误:262)
要获得帮助，请单击:http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476
------------------------------
按钮:
OK
------------------------------

解决方案

我猜数据库已经存在，U可以通过尝试给您尝试创建的数据库提供不同的名称来尝试，或者从以下位置删除该数据库:

C:\ Program Files \ Microsoft SQL Server \ MSSQL.1 \ MSSQL \ Data

假设您的SQL Server安装在c:drive

希望这会有所帮助:)

有关更多查询，请在此处评论！！

Hi I am a student I installed the Micorsoft sql server 2008 R2 when I did my asp.net course now I am doing a introduction to sql course I thought of using the same sql server to create a database and to create a table but I having the following error

TITLE: Microsoft SQL Server Management Studio
------------------------------
Create failed for Database ''course''. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1540+)&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.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=10.50.1600&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------

解决方案

I guess the database, already exists, U can try by giving different name to the database you are trying to create, or remove the database from this location:

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data

assuming that your sql server is installed on c: drive

hope this helps :)

for further queries comment here!!

这篇关于使用SQL Server 2008 R2创建数据库时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！