entity framework - EF6 migrations (LocalDb) update-database login failed -

-

vs 2013 mvc5 code first project.

i’m working through asp.net getting started ef6 using mvc5 tutorial speed on latest changes , i’m having problem migrations. in first module database created using database initializer:

<contexts>       <context type="contosouniversity.dal.schoolcontext, contosouniversity">         <databaseinitializer type="contosouniversity.dal.schoolinitializer, contosouniversity" />       </context> </contexts>

and connection string:

<connectionstrings>     <add name="schoolcontext" connectionstring="data source=(localdb)\v11.0;initial catalog=contosouniversity1;integrated security=sspi;" providername="system.data.sqlclient"/> </connectionstrings>

this works fine. in code first migrations , deployment module migrations setup. initializer commented out , name of db changed contosouniversity2:

<connectionstrings>     <add name="schoolcontext" connectionstring="data source=(localdb)\v11.0;initial catalog=contosouniversity2;integrated security=sspi;" providername="system.data.sqlclient"/> </connectionstrings>

when update-database run packager manager console fails error message:

cannot open database "contosouniversity2" requested login. login failed. login failed user 'mymachine\myuser'.

i’ve re-run both scenarios several times same user , same results. if change initial catalog attachdbfilename=|datadirectory|\contosouniversity2; update-database succeeds (the db in app-data folder of project rather root of users profile):

<connectionstrings>     <add name="schoolcontext" connectionstring="data source=(localdb)\v11.0; attachdbfilename=|datadirectory|\contosouniversity2;integrated security=sspi;" providername="system.data.sqlclient"/> </connectionstrings>

you have use initial catalog when deploying though. production connectionstring set separately in web.release.config workable.

the question why need fix, why doesn’t initial catalog work update-database on development side?

update 1:

the problem not migrations localdb

myuser has full rights in sqlexpress (sysadmin). can log ssms under myuser , manage dbs. ran several tests. though created initial db tutorial myuser throws login failed error if rebuild app scratch , use databaseinitialzer. if run vs under admin both databaseinitialzer , update-database work without problem. if copy dbs admin's user profile root myuser's , run vs, not admin, while logged on myuser both databaseinitialzer , update-database work if db prior existing.

if change connectionstring attachdbfilename , run either databaseinitialzer , update-database myuser can create db in app_data folder proving myuser has db create rights. myuser has full rights root of own user profile. there amisss localdb implementation.

does 1 have insight on question?

if delete db file, still stays registered sqllocaldb. if localdb gets hung can’t attach (after manually deleting db file) or login failed see jsobell’s , codingwithspike’s answers here:

ef5-cannot-attach-the-file-0-as-database-1.

run ‘sqllocaldb.exe stop v11.0’ , ‘sqllocaldb.exe delete v11.0’ pm console

update:

easier yet use ssms. server name: (local)\v11.0, windows authentication. best way manage localdb databases.


Comments

Post a Comment

Popular posts from this blog

node.js - StackOverflow API not returning JSON -

-
i using node.js script gather data stackoverflow. know responses gzipped, put code in should take care of that. script follows: var request = require('request'); var zlib = require('zlib'); function getstackoverflowresponse(url, callback){ request(url, {encoding: null}, function(err, response, body){ if(response.headers['content-encoding'] == 'gzip'){ zlib.gunzip(body, function(err, dezipped) { callback(dezipped); }); } else { callback(body); } }); } var url = "https://api.stackexchange.com/docs/questions#pagesize=2&order=desc&min=2014-01-04&max=2014-02-02&sort=activity&tagged=apigee&filter=default&site=stackoverflow&run=true"; getstackoverflowresponse(url, function(questions) { console.log(questions); }); instead of getting json output, i'm getting following response: buffer 0d 0a 0d 0a 0d 0a 0d 0a 3c 21 44 4f 43 54 59 50 45 20 48...
Read more

python - Subclassed QStyledItemDelegate ignores Stylesheet -

-
i'm trying subclass qstyleditemdelegate remove focus rectangle in qcombobox . even though i'm calling base implementation of paint function , nothing else, result different. looks if parts of style-sheet influence bounding box of item taken consideration. class pstyleditemdelegate(qstyleditemdelegate): def __init__(self, *args, **kwds): super(pstyleditemdelegate, self).__init__(*args, **kwds) def paint(self, *args, **kwargs): qstyleditemdelegate.paint(*args, **kwargs) what have paint unmodified qstyleditemdelegate ? as suggested tried replacing pyside pyqt4 , works, appears bug. update pyside 1.1.2 1.2.1 result same. unfortunately switch breaks other parts of code, if there no other suggestions i'm going accept answer. edit bug tracked here
Read more

java - HttpClient 3.1 Connection pooling vs HttpClient 4.3.2 -

-
i have used httpclient3.1(java) connection pooling below : import org.apache.commons.httpclient.httpclient; import org.apache.commons.httpclient.multithreadedhttpconnectionmanager; import org.apache.commons.httpclient.params.httpclientparams; import org.apache.commons.httpclient.params.httpmethodparams; import org.apache.log4j.logger; public class httpclientmanager { private static logger logger = logger.getlogger(httpclientmanager.class); private static multithreadedhttpconnectionmanager connectionmanager = new multithreadedhttpconnectionmanager(); private static httpclientparams clientparams = new httpclientparams(); static { try { clientparams.makelenient(); clientparams.setauthenticationpreemptive(false); clientparams.setparameter(httpmethodparams.so_timeout, new integer(30000)); // set so_timeout clientparams.setparameter(httpmethodparams.head_body_check_timeout, new integer(3000)); // head responses ...
Read more