且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

使用SQL Server 2008 R2创建数据库时出错

更新时间:2023-02-07 08:00:07

我猜数据库已经存在,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!!