Posted on: 6/1/2009 8:24:25 AM | Views : 255

I am having a strange problem. I have a web application and it is fetching data from Northwind database which is downloaded and attached to sql express 2008. When I execute the web application from VS2008 it is working fine. But when I publish the website and browse from there I am getting a permission error, as follows.CREATE DATABASE permission denied in database 'master'.Cannot attach the file 'D:\SQL Server 2000 Sample Databases\NORTHWIND.MDF' as database 'Northwindd'. 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'.Cannot attach the file 'D:\SQL Server 2000 Sample Databases\NORTHWIND.MDF' as database 'Northwindd'.
I dont understand why is this happening. I gave permission to Northwi ...

Go to the complete details ...