asp.net mvc - SQL Server Express database file auto-creation error in MVC 4 - But i DON'T want to use SQL Server Express -

-

i've deployed new application in asp.net mvc 4. use sql server 2008 r2 (not sql express).

it worked first 10 minutes, did little change in code , re-deployed it.

now, whenever try access page uses simplemembership, 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)

description: unhandled exception occurred during execution of current web request. please review stack trace more information error , originated in code.

sqlexpress database file auto-creation error:
connection string specifies local sql server express instance using database location within application's app_data directory. provider attempted automatically create application services database because provider determined database not exist. following configuration requirements necessary check existence of application services database , automatically create application services database:

but, not use sql server express. in web.config i've set connection strings follows:

<add name="applicationservices"       connectionstring="server=myserver;database=mydb;user id=myuserid;password=mypwd;"       providername="system.data.sqlclient" />  <add name="applicationservices"       connectionstring="server=myserver;database=mydb;user id=myuserid;password=mypwd;"       providername="system.data.sqlclient" />

why keep trying create sql server express database?

when encountered error, turned out simple. figured out in _layout.cshtml referencing user.isinrole("role") after request.isauthenticated. code looked @if (request.isauthenticated && user.isinrole("role")). if wasn't signed in home page render since not traverse isinrole() call (which requires simple membership initialized, otherwise error mention here. needed ensure each , every controller uses view extends _layout file , have unauthenticated users, needs have [initializesimplemembership]. or 1 of various ways initialize simple membership.

so 

namespace projectname.controllers {     [initializesimplemembership]     public class homecontroller : controller { ...

also, ctrl + f5 start application , use "rebuild solution" after. when refreshed page wasn't root home page, error until call root home page. @ point, start working again.

hopefully or someone. banged head @ least hour or two.


Comments

Post a Comment

Popular posts from this blog

android - getbluetoothservice() called with no bluetoothmanagercallback -

-
i getting getbluetoothservice() called no bluetoothmanagercallback error in android application. i have no idea causing or bluetooth manager callbacks. can give me idea of causing problem or start looking. by reading android source code, seems warning cannot about. source code shows if call bluetoothsocket#connect(); then call bluetoothadapter.getdefaultadapter().getbluetoothservice(null); the key here, null parameter passes in above line. due this, there no callback, , bluetoothsocket class throw out warning. since warning, not think need it. https://android.googlesource.com/platform/frameworks/base/+/master/core/java/android/bluetooth/bluetoothsocket.java line 306 https://android.googlesource.com/platform/frameworks/base/+/master/core/java/android/bluetooth/bluetoothadapter.java line 1610
Read more

sql - ASP.NET SqlDataSource, like on SelectCommand -

-
i'm working on asp.net. have sqldatasource query hardcoded on selectcommand: <asp:sqldatasource id="datasource1" runat="server" cancelselectonnullparameter="false" connectionstring="<%$ connectionstrings:s.properties.settings.connectionstring %>" selectcommand="select * [table] ([col1] case @col1_param when null col1 else @col1_param end) , ([col2] case @col2_param when null col2 else @col2_param end)" selectcommandtype="text"> <selectparameters> <asp:controlparameter controlid="textbox1" name="col1_param" propertyname="text" type="string" /> <asp:controlparameter controlid="textbox2" name="col2_param" propertyname="text" type="string" /> </selectparameters> what want if enter data on 1 textbox only, data display according textbox
Read more

ios - Undefined symbols for architecture armv7: "_OBJC_CLASS_$_SSZipArchive" -

-
i try using extractzipfile plugin @ this: https://github.com/phonegap/phonegap-plugins/tree/master/ios/extractzipfile but when compiler xcode 4.6.1 in sdk 6.1 throws error: undefined symbols architecture i386: "_objc_class_$_ssziparchive", referenced from: objc-class-ref in extractzipfileplugin.o ld: symbol(s) not found architecture i386 clang: error: linker command failed exit code 1 (use -v see invocation) i try issue @ here: undefined symbols architecture armv7 ssziparchive but shows error: /users/alienware/desktop/extractzipfile/ssziparchive/tests/ssziparchivetests.m:10:9: 'sentestingkit/sentestingkit.h' file not found i work phonegap , make app in ios, dump. update : try add ssziparchive.m compiler source , come new error: undefined symbols architecture i386: "_unzclose", referenced from: +[ssziparchive unzipfileatpath:todestination:overwrite:password:error:delegate:] in ssziparchive.o "_unzclosecurrentfil
Read more