c# - Error. An error occurred while processing your request -
fairly simple question connection strings using asp.net mvc web application sql server database.
i created web application uses database, using default templates mvc 5 application using visual studio 2014.
i moving application on iis , sql server express database (2014) , see database application uses localdb (has .mdf extension) need know how attach sql server express database. (the development machine , server separate machines)
i have attached server , have login "iis apppool\defaultapppool" iis able use server. here have granted login read , write permission database "aspnet-owintest-20140519094353" , connection string in iis
server=kevin-pc\sqlexpress;database=aspnet-owintest-20140519094353;integrated security=true
the default connection string when building application is:
<add name="defaultconnection" connectionstring="data source=(localdb)\v11.0;attachdbfilename=|datadirectory|\aspnet-owintest-20140519094353.mdf;initial catalog=aspnet-owintest-20140519094353;integrated security=true" providername="system.data.sqlclient" />
if can please give me hand this. application throws error
error. error occurred while processing request.
this default mvc error.
also there ways can see happened? in log of sorts, checked in iis log , there did not seem information me. better me have login used username/password rather using windows authentication?
i believe found looking for:
how deploy asp.net mvc 4 application using localdb local iis on windows 7?
this did trick, though not idea production server.
i guess 1 have type of restore on sql server .mdf.
all 1 has publish files, drop them in wwwroot folder (along app_data folder containing database , logs) , set pool local , should set.
Comments
Post a Comment