c# - Error Connecting to DB.mdf when published IIS -


i have been searching on different sources in search on solving issue.. i've published website on iis have been working on , first published website on iis.

i seem not able connect database.

i provide have done right down here..

appreciate please....

my web.config file in published website directory c:\financialhubtest. on side note tried adding user instance=true connection string in web.config file doesn't work..

<connectionstrings>     <!--<add name="connstr" connectionstring="data source=(localdb)\mssqllocaldb;attachdbfilename=|datadirectory|\financialhub.mdf;integrated security=true" />-->     <add name="connstr"           connectionstring="data source=(localdb)\.\iis_db;integrated security=true;" /> </connectionstrings>

details of mssqllocaldb cmd

mssqllocaldb

applicationhost file in c:\windows\system32\inetsrv\config edited notepad2. i'm using financialhub applicationpool published website in iis

<applicationpools>         <add name="defaultapppool" managedruntimeversion="v4.0" />         <add name="classic .net apppool" managedruntimeversion="v2.0" managedpipelinemode="classic" />         <add name=".net v2.0 classic" managedruntimeversion="v2.0" managedpipelinemode="classic" />         <add name=".net v2.0" managedruntimeversion="v2.0" />         <add name=".net v4.5 classic" managedruntimeversion="v4.0" managedpipelinemode="classic" />         <add name=".net v4.5" managedruntimeversion="v4.0" />         <add name="financialhub" autostart="true" managedruntimeversion="v4.0" managedpipelinemode="integrated">           <processmodel identitytype="applicationpoolidentity" loaduserprofile="true" setprofileenvironment="true" />         </add>         <applicationpooldefaults managedruntimeversion="v4.0">             <processmodel identitytype="applicationpoolidentity" loaduserprofile="true" setprofileenvironment="false" />         </applicationpooldefaults>     </applicationpools>

my published website directory app_data having financialhub.mdf file

mdf

my sql server object explorer, connection appears when run website via visual studio 2015 think running on iis express..

sql

i have been getting error every time change here , there i'm sure why.. or rather changes make either web.config, etc cause error. check windows event log too.

errorsql

i followed these 2 links on dealing issue,

using localdb full iis, part 1: user profile,

using localdb full iis, part 2: instance ownership

if there need more information can provide..

i feel have been beating around bush trying figure out can't seem solve it..

i appreciate please. thank much.

you still using localdb after publishing application iis. localdb (sql database inside app_data) intended developing , testing purpose only.

you need real sql server when host site on iis. need install sql server either in same server application hosted or dedicated sql server. attach or copy existing database sql server.


Comments

Post a Comment

Popular posts from this blog

javascript - Create a stacked percentage column -

i have collection of data : var data = [ {"p301a":"10","p301b":"7","p301c":"7","p301d":"3","p301e":"8","p301f":"8","p301g":"8","p301h":"8","p301i":"8","p301j":"8","p301k":"8","p301l":"8","p301m":"8","p301n":"8","p301o":"8","age":"31-40 years","profesion":"2","position":"2"}, {"p301a":"5","p301b":"4","p301c":"4","p301d":"4","p301e":"4","p301f":"4","p301g":"4","p301h":"4","p301i":"4","p301j":"4","p301k":"4...
Read more

Optimising Firebase database by automatically overwriting data -

in firebase app have following structure: posts latest all users can write posts > latest . want limit entries 20 posts save space in database. , posts beyond 20 unnecessary never shown on homepage. how can limit posts 20, when user writes posts > latest posts @ end drop off (be deleted) automatically? this sample should you. you need : const max_log_count = 20; exports.removeold = functions.database.ref('/posts/latest/{postid}').oncreate(event => { const parentref = event.data.ref.parent; return parentref.once('value').then(snapshot => { if (snapshot.numchildren() >= max_log_count) { let childcount = 0; const updates = {}; snapshot.foreach(function(child) { if (++childcount <= snapshot.numchildren() - max_log_count) { updates[child.key] = null; } }); // update parent. removes children. ...
Read more

javascript - Angular UI-Grid customTemplate directive causing rows to load slowly/? -

Image
each grid cell can have more 1 customtemplate loaded. have directive holds watcher on model_col_field listen cell updates on scroll when dom rows updated , recompile celltemplate . without watcher , $compile rows repeat on scroll, showing same set of rows. is there more angular way of approaching or way improve performance? relevant controller code: create gridoptions.data & gridoptions.columndefs : var customtemp = '<div ng-repeat="opt in grid.appscope.colvalueoptionsmodel" ng-init="tempstring=model_col_field.clazz+opt.key;"><comparison-directive dbo="model_col_field" attobj="opt" fff="grid.appscope.getattributetemplate(tempstring)" /></div>'; $scope.gridoptions.columndefs = [ { name:'yindex',pinnedleft:true,celltemplate: customtemp, displayname:'index'}, { name:'col1',celltemplate: customtemp}, { name:'col2',celltemplate: c...
Read more