Andy Green
asked on
App_Data SQLExpress databases
Hi Experts
I have a need to use the APP_Data folder to host my database to hold local test data. I have read several threads and got totally confused as thing wont work as I expect (or want)
What I want to do is use a current database without SQL Server installed. I read that you could detach the database mdf file and move it to the App_Data folder and away you go, but I get a connection error saying:
'Login failed for user 'WebService'. The user is not associated with a trusted SQL Server connection.'
This is my connection string:
<add name="AppDatabase" connectionString="Data Source=.\SQLEXPRESS;Attach DbFileName =|DataDire ctory|WS_T est.mdf;ui d=WebServi ce;pwd=ws; " />
Can I do what I want I'm trying to do.
If not what are my options.
And one more thing, if I create a database in the App_data folder I cannot set up user accounts for it, so what acount does it run under.
Andy
I have a need to use the APP_Data folder to host my database to hold local test data. I have read several threads and got totally confused as thing wont work as I expect (or want)
What I want to do is use a current database without SQL Server installed. I read that you could detach the database mdf file and move it to the App_Data folder and away you go, but I get a connection error saying:
'Login failed for user 'WebService'. The user is not associated with a trusted SQL Server connection.'
This is my connection string:
<add name="AppDatabase" connectionString="Data Source=.\SQLEXPRESS;Attach
Can I do what I want I'm trying to do.
If not what are my options.
And one more thing, if I create a database in the App_data folder I cannot set up user accounts for it, so what acount does it run under.
Andy
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER