dotnet academic: Visual studio .net error -- dotnet academic

Visual studio .net error

playabill
3/27/2005 10:15:03 AM

dotnet academic:

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
--

RE: Visual studio .net error

Abdul
3/30/2005 11:23:02 AM

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.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the dotnet academic group.