SQL Server Connection String - Different Domain -


i have sql server connection string in config file:

<add name="dbmaster" connectionstring="data source=servername\namedinstance;initial catalog=somedb;integrated security=sspi;" providername="system.data.sqlclient"/>

this fine if running domain sql server located, receive following error on different domain:

system.data.sqlclient.sqlexception: error has occurred while establishing connection server. when connecting sql server 2005, failure may caused fact under default settings sql server not allow remote connections. (provider: sql network interfaces, error: 26 - error locating server/instance specified)

there trust between domains.

i tried following no success:

<add name="dbmaster" connectionstring="data source=servername.domain.com\namedinstance;initial catalog=somedb;integrated security=sspi;" providername="system.data.sqlclient"/>

i can ping servername.domain.com.

i have tried connecting sql server on different domain using sql server management studio same error above received.

is there obvious doing wrong?

if management studio giving same error, problem isn't application. problem sql server configuration.

either trust between domains isn't configured enable integrated security across domains or sql server isn't configured allow remote connections (like error message states).

integrated security across domains more hassle it's worth. using sql server authentication relieve of headaches.


Comments

Post a Comment

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

i'm using abcpdf , i'm curious if can recursively call addimageurl() function assemble pdf document compile multiple urls? something like: int pagecount = 0; int theid = thedoc.addimageurl("http://stackoverflow.com/search?q=abcpdf+footer+page+x+out+of+", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetochain(theid); } pagecount = thedoc.pagecount; console.writeline("1 document page count:" + pagecount); //flatten document (int = 1; <= pagecount; i++) { thedoc.pagenumber = i; thedoc.flatten(); } //now try again theid = thedoc.addimageurl("http://stackoverflow.com/questions/1980890/pdf-report-generation", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetoc
Read more

java - Android recognize cell phone with keyboard or not? -

in android app, want detect user's device if device has keyboard(like motorola milestone) , show corresponding user interface. guys know how that? ! regards justicepenny http://developer.android.com/reference/android/content/res/configuration.html public int keyboard the kind of keyboard attached device. 1 of: keyboard_nokeys, keyboard_qwerty, keyboard_12key. that's it!
Read more

iphone - How would you achieve a LED Scrolling effect? -

how achieve led scrolling effect example below? led sign - led ticker emulator iphone , ipad http://img.skitch.com/20101201-rsfh4p1bajb1wp94k466pdpiuj.preview.jpg sometimes remunerates comment in other posts :) have put code you, should implement font '8pin matrix' realistic feeling. uilabel *label; - (void)viewdidload { [super viewdidload]; label = [[uilabel alloc]initwithframe:cgrectmake(10, 50, 300, 20)]; label.font = [uifont fontwithname:@"courier-bold" size:16.0]; label.backgroundcolor = [uicolor blackcolor]; label.textcolor = [uicolor greencolor]; label.linebreakmode = uilinebreakmodecharacterwrap; // otherwise "…" label.text = @"this led text scrolled "; // blanks space between [self.view addsubview:label]; [nstimer scheduledtimerwithtimeinterval:0.12f target:self selector:@selector(scrolllabel) use
Read more