Trust, authentification or connection issue between server 2008 domain and 2003 none domain member server

-

hi folks

i have application connection problem, dont know if place post ill give try.

server a
windows 2008 std r2 sql 2008 std ed - 64 bit - domain member (stand alone physical db server)

server b
windows 2003 std application server (only 1 application) - no domain member

server b runs appliaction service, when user connects connects service , service connects database , faults.

ive run profiler , doesen't seem try connect db, after while got know
service needs have administrative rights on db server, meaning account running service needs same rights on db server able connect. there way configure work since appliction server yet can't join domain.

i tried create accounts in active directory on dbserver , domain controller having same name account running service no results. cant create account on dbserver name serverb\servicerunner since serverb isn't domain member.

if use start->run \\servername\c$ works in both directions. sqlserver configured tu allow remote connections, @ moment dont think sql problem since sql profiler doesent indicate connection tries.

thanks in advance hint/tip.

this appears more of sql question.

have tried setting sql server mixed mode , authenticate sql via local sql account?  should work , there no trust needed. 

changing mixed mode

http://www.sql-programmers.com/benefitsofsql/security/mixedmodeauthentication.aspx

choosing authentication

http://msdn.microsoft.com/en-us/library/ms144284.aspx

are using named pipes, tcp/ip or shared memory?  these can all have different connection issues.  again think should repost in sql forum.

 

--
paul bergson
mvp - directory services
mcitp: enterprise administrator
mcts, mct, mcse, mcsa, security+, bs csci
2008, vista, 2003, 2000 (early achiever), nt4
http://www.pbbergs.com    twitter @pbbergs

please no e-mails, questions should posted in newsgroup this
posting provided "as is" no warranties, , confers no rights.



Windows Server  >  Directory Services



Comments

Post a Comment

Popular posts from this blog

WIMMount (HSM) causing cluster storage to go redirected (2012r2 DC)

-
looking options resolve error , prevent in future. thanks help. hardware: 2 node dell hv cluster running2012r2 dc 8 nic/ea in multiplex mode 4x hyper-v 4x hosts storage: 2x synology nas, accessed through iscsi hosts , cluster relevant logs: log name:      microsoft-windows-failoverclustering/diagnostic source:        microsoft-windows-failoverclustering date:          event id:      2050 task category: none level:         warning keywords:       user:          system computer:      l description: [dcm] filter wimmount found @ unsafe altitude 180700 log name:      system source:        microsoft-windows-failoverclustering date:         event id:      5125 task category: cluster shared volume level:         warning keywords:       user:          system computer: description: cluster shared volume 'volume1' ('cluster disk 1') has identified 1 or more active filter drivers on device stack interfere csv operatio
Read more

Failed to delete the test record dcdiag-test-record in zone test.com

-
ps c:\users\administrator.test> dcdiag /test:dns directory server diagnosis performing initial setup:    trying find home server...    home server = dc02    * identified ad forest.    done gathering initial info. doing initial required tests    testing server: default-first-site-name\dc02       starting test: connectivity          ......................... dc02 passed test connectivity doing primary tests    testing server: default-first-site-name\dc02       starting test: dns          dns tests running , not hung. please wait few minutes...          ......................... dc02 passed test dns    running partition tests on : forestdnszones    running partition tests on : domaindnszones    running partition tests on : schema    running partition tests on : configuration    running partition tests on : test    running enterprise tests on : test.com       starting test: dns          test results domain
Read more

Azure MFA with Azure AD and RDS

-
i have setup following lab in azure , need help. a server (domain controller) , remote desktop services. and server multi factor authentication server. i have setup following one http://www.rdsgurus.com/uncategorized/step-by-step-using-windows-server-2012-r2-rd-gateway-with-azure-multifactor-authentication/ and when im connecting got following error. the user "domain\username", on client computer "xxx.xxx.xxx.xxx", did not meet connection authorization policy requirements , therefore not authorized access rd gateway server. authentication method used was: "ntlm" , connection protocol used: "rpc-http". following error occurred: "23003". also on security log i've got following authentication details: connection request policy name: ts gateway authorization policy network policy name: - authentication provider: radius proxy authentication server: test.test.local authentication type: - eap t
Read more