HighTechTalks DotNet Forums  

Visual studio .net error

Dotnet Academic General Discussions microsoft.public.dotnet.academic


Discuss Visual studio .net error in the Dotnet Academic General Discussions forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
playabill
 
Posts: n/a

Default Visual studio .net error - 03-27-2005 , 01:15 PM






Anyone seen this error message and know how to correct it??

CREATE DATABASE permission denied in database 'master'. Could not attach
database 'bookorder' to file 'C:\Program Files\Microsoft SQL
Server\MSSQL\Data\BookOrder.mdf'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: CREATE DATABASE
permission denied in database 'master'. Could not attach database 'bookorder'
to file 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\BookOrder.mdf'.


This just recently happened. I am able to see Bookorder Database tables in
solution explorer but when I use sql connection to get data into my project
this error comes up. Cant understand why database 'master' is trying to
attach to bookorder.mdf. Get same error when I try to connect to northwind,
pubs or any other databases.
help

windows PRO
MSDE
Visual Studio .NET acad 2003
--
playabill

Reply With Quote
  #2  
Old   
Abdul
 
Posts: n/a

Default RE: Visual studio .net error - 03-30-2005 , 02:23 PM






well,mostly this type of error appears when u use the use master code before
writing create database code.I hope by mistake u ve not written that code.u r
saying it's happening with other dataabses too like northwind.it means there
wont be ne problem in ur log files of sql server if it's showing correct
structure of ur all databases.so now it depends wht code did u write to
connect it with and the username u r using for creating database doesnt ve
rights to create database.
These r some aspects on which u can concentrate.

"playabill" wrote:

Quote:
Anyone seen this error message and know how to correct it??

CREATE DATABASE permission denied in database 'master'. Could not attach
database 'bookorder' to file 'C:\Program Files\Microsoft SQL
Server\MSSQL\Data\BookOrder.mdf'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: CREATE DATABASE
permission denied in database 'master'. Could not attach database 'bookorder'
to file 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\BookOrder.mdf'.


This just recently happened. I am able to see Bookorder Database tables in
solution explorer but when I use sql connection to get data into my project
this error comes up. Cant understand why database 'master' is trying to
attach to bookorder.mdf. Get same error when I try to connect to northwind,
pubs or any other databases.
help

windows PRO
MSDE
Visual Studio .NET acad 2003
--
playabill

Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.