Connection Error with SQL Azure and Entity Framework on Azure Website -

-

not sure start, whenever publish asp.net website azure, pages have database access give me message saying "error. error occurred while processing request." open remote debugger (which fickle because refuses attach half of time) , see error occurs when establishing when trying access entity framework. error varies between "network-related or instance-specific" error, or "login failed" error (which result of previous error, don't know).

the ado.net connection string sql azure gives is

server=tcp:[servername].database.windows.net,1433;database=ensemblemusicwebdatabase;user id=user@[servername];password=(password);trusted_connection=false;connection timeout=30;

but every implementation (inserting ef metadata string, changing server data source...etc) still gives me same login error

i'm pretty sure it's problem connection string, infuriating part i've tried every possible combination can think of (entity framework metadata, using sql azure database ado.net connection strings in possible way, changing azure website connection strings under config tab, using plain connection string...etc).

i've deleted , rebuilt entity framework models @ least 5 times, , every time can establish connection server , reads database , creates correct models. deploy application localhost , works. problem when publish, cannot access database , keeps giving me these login failed errors (the login details exact same when set ef model).

i think might firewall, since can access db locally approved firewall ip on server config, website can't access database (i have enable azure services box ticked well). i'm @ loss now, because want site (not user, application) fetch data database , display on page, don't understand how complicated.

can point me in right direction? tried every tutorial , example on msdn , can't find solutions on work.

thanks, shaun

i realised somehow got complete mess connection strings on place , best way fix start again. deleted azure website , database instances, built database first (created correct login well) , when creating new website azure gave me option include database had created. have correct connection string azure generated, safe (because metadata made connection strings confusing , didn't want risk having same issue again) i'm not using entity framework , using normal sqlclient queries, since website requests 2 objects database.

i think i've got correct , working string can @ , understand went wrong , how avoid if end using entity framework.


Comments

Post a Comment

Popular posts from this blog

node.js - Mongoose: Cast to ObjectId failed for value on newly created object after setting the value -

-
this question has answer here: what's mongoose error cast objectid failed value xxx @ path “_id”? 7 answers even though has been asked many times because entity has no valid objectid field. i came across situation objectid set value can casted objectid still error. the schema: var serviceschema = parammongoose.schema({ servicename:{ type: parammongoose.schema.types.objectid , ref: 'servicenames',required:true } }); pseudo code: servicefromdb=new service({servicename:'some name'}); servicefromdb.servicename='000000000000000000000001'; servicefromdb.save(function(paramerror,paramdata){ if(paramerror){ console.log('but but...',servicefromdb,paramerror) } }); the output of code is: but but... { servicename: 000000000000000000000001, _id: 55079a90286f49280364f78b } { [casterror: cast objectid faile...
Read more

gradle error "Cannot convert the provided notation to a File or URI" -

-
i have defined 2 system properties in gradle.properties: systemprop.builddir=build systemprop.cfgdir=build\\cfg and have following task defined in build.gradle: task clean(group:'clean',description:'clean project') << { ant.sequential { delete(dir: system.properties.builddir) mkdir(dir: system.properties.builddir) delete(dir: system.properties.cfgdir) mkdir(dir: system.properties.cfgdir) } } this generates following error: execution failed task ':clean'. > cannot convert provided notation file or uri: {dir=build}. following types/formats supported: - string or charsequence path, e.g 'src/main/java' or '/usr/include' - string or charsequence uri, e.g 'file:/usr/include' - file instance. - uri or url instance. but equivalent block of code not generate error , works expected: task clean(group:'clean',description:'clean project') << { ...
Read more

python - NameError: name 'subprocess' is not defined -

-
i'm trying make rng website: http://jamesdotcom.com/?p=417 . when run following code: captureimage = subprocess.popen( [ "fswebcam", "-r", "356x292", "-d", "/dev/video0", "static.jpg", "--skip", "10" ], stdout=devnull, stderr=devnull) captureimage.communicate() i following error message: nameerror: name 'subprocess' not defined what should do? thanks have imported first? import subprocess captureimage = subprocess.popen(["fswebcam", ...) subprocess included in python standard library since python 2.4. should not necessary install it.
Read more