asp.net mvc 5 - MVC 5 SQL Network Interfaces, error: 26 - Error, with [Authorize] -


i'm having trouble setting authorization in mvc 5. have brand new mvc 5 website individual user accounts , sql server database 5 aspnet... tables.

i can login locally, works fine on local server , can login production database local website when point local connection string @ production server can't login website on production server,

i following error:

a network-related or instance-specific error occurred while establishing connection sql server. server not found or not accessible. verify instance name correct , sql server configured allow remote connections. (provider: sql network interfaces, error: 26 - error locating server/instance specified)

the error happens when use [authorize] on action have login, if remove [authorize] action , database work fine.

any ideas

edit

just clarity, sql server on 1 of arvixe servers, , website @ godaddy here connection string

<add name="mysiteentities" connectionstring="metadata = res://*/models.mysite.csdl|res://*/models.mysite.ssdl|res://*/models.mysite.msl; provider = system.data.sqlclient; provider connection string =' data source = xxxxx.arvixe.com; initial catalog = mysite; user id = xxxxxx; password = xxxxxxx'" providername="system.data.entityclient" />

i unable login godaddy string if use string on local computer can login.

i have number of websites set same configuration in mvc 4 work fine.

i had similar issue; however, wrongly assumed not using ef , sql server, telerik data access around oracle 11g. fixed me remove rolemanager module in config file, per article (http://blog.luppes.com/2013/12/08/mvc5-authentication-roles-failure/)

so, paraphrase link posterity, was:

<system.webserver>   <modules>     <remove name="rolemanager" />   </modules> </system.webserver>

Comments

Post a Comment

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

i working latest mpandroidchart library , looking way add annotations or images clickable. example: once data reaches value event occurs want able display user - there multiple events can occur annotations (not sure if right word) or image added @ point in chart. any pointers welcome. check documentation of yaxis . focus on setspacetop(...) , setaxismaxvalue(...) methods. for background: bar-shadow , disable calling: barchart.setdrawbarshadow(false) or change color: bardataset.setbarshadowcolor(int color)
Read more

javascript - Add class to another page attribute using URL id - Jquery -

i have attached id url. ex: when click link 1 , has #tab-2 id , takes me landing page. in landing page have find element has #tab-2 id have add class .active . i tried no luck. please 1 correct code. thanks js fiddle link html <div class="menu"> <ul> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-2">link 1</a></li> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-44">link 2</a></li> <li><a href="http://jsfiddle.net/gscyoa0j/1/#tab-74">link 3</a></li> </ul> </div> landing page <div class="tab"> <ul> <li><a id="tab-2" class="active" >link 1 content</a></li> <li><a id="tab-44" >link 2 content</a></li> <li><a id="tab-74" >link 3 content</a></l...
Read more

firefox - Where is 'webgl.osmesalib' parameter? -

i'm trying webgl running on firefox (v37.0.2) via software acceleration mesa. tried following steps have been stated in article: http://www.binarytides.com/enable-webgl-firefox-ubuntu/ however, unable find parameter named ' webgl.osmesalib ' in about:config section? has been removed (or renamed)? if yes, how should instruct firefox use mesa's software acceleration webgl? looks support osmesa removed in favour llvmpipe.
Read more