Connecting website to MS SQL Express db

[rich_ex]

Hi everyone,

I have been creating a website hosting over the last few weeks, and have just bought my hosting package etc from here.

Basically, I've used Visual Studio Express with the built in SQL Server Express db hooked on with stored procs and tables.

Locally, this is all running fine - but I'm have a few issues on the remote website hosting. I have put all the website hosting files in the 'httpdocs' folder, and the SQL Server db is under this structure within an 'App_Data' folder

On loading the website hosting I was getting :
Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.
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: Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed.


After looking through a few forums I changed my connection string in the web config, so that User Instance = False, but now get an even odder error:

CREATE DATABASE permission denied in database 'master'.
An attempt to attach an auto-named database for file D:\Inetpub\vhost\#####.co.uk\httpdocs\App_Data\Web DB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
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'.
An attempt to attach an auto-named database for file D:\Inetpub\vhost\#####.co.uk\httpdocs\App_Data\Web DB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Can anyone help?
Many thanks,
Rich

P.S. if useful, my web config connection string is:
connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=False;AttachDBFilename=|DataDirectory|Web DB.mdf"
providerName="System.Data.SqlClient"

[Rock]

Hi Rich,

Could you please place a ticket or email us at windows@eukhost.com with the complete details (URL, DB name, DB username, DB password, etc) to produce the above mentioned error. The errors appears to be related to user rights & permissions either on the DB or the machine username. This will be fixed & your ticket will be replied on priority. Thank you,

[Rock]

Rich,

It appears like your scripts are trying to write to the 'master' database, which is a system database & is only written by the 'sa' user. If you have designed the code on your end (Visual Studio Express), it may work on your local machine, but not on the server. Please re-design it & make sure you supply the correct DB name for the Asp.Net scripts to access/fetch data.
We're still working on your issue & you'll be updated in the ticket itself, as I think you don't want the name of your website hosting disclosed