Can't connect NPS server a MSSQL DB.

-

i'm trying connect server 2008 r2 nps mssql server logging accounting data , i'm running issues.

i configured nps accounting through "configure accounting" wizard and, using windows integrated security, able connect mssql server (2012 express) , create db accounting. 

when test out though nps generates 6274 event: "... not written configured accounting datastore". 

looking on db server see 18456 event: "login failed user 'mydom\npsserver$'. reason: failed open explicitly specified database 'mynpsdb'. [client: nps.servers.ip.addr]"

so though setup db connection domain account db access server connecting local machine account.

i don't want give nps server's computer account explicit access db , want use domain account instead.

when in data link properties dialogue box tried enter domain account "use specific user name , password", "login failed user" error- know credentials typed in correct.

i tried running network policy server service domain account, after doing not start.

how can nps connect db domain account?

hi,

>>i don't want give nps server's computer account explicit access db , want use domain account instead.

actually, "'mydom\npsserver$" domain account. it's machine account.

please add nps's machine account sql server.

if want use user account access sql server, please change authenticate method use specific user name , password, input user account has proper permission.

here screenshot of lab:

best regards.

steven lee please remember mark replies answers if , unmark them if provide no help. if have feedback technet support, contact tnmff@microsoft.com.




Windows Server  >  Network Infrastructure Servers



Comments

Post a Comment

Popular posts from this blog

Edit Group Policy

-
i have pc has power settings pushed out default domain policy in ad environment. of course on local machine "some settings managed system adminstrator". the machine temporarily no longer in contact domain controller (it's been physically moved , not on same network now) can't updated gpo settings. i believe if edit local group policy won't make difference because of group policy processing , precedence. since it's temporary away ad network, still want use settings of ad user. is there somewhere in registry stored can edit power plan manually until can sync domain? (i need prevent sleeping while plugged in - it's set 1 hour) thanks! allen crist i found site: http://gpsearch.azurewebsites.net/#7916 i able add policy to hkey_local_machine\software\policies\microsoft\power using specs found on site. looks solved issue. i'll report if didn't. thanks! allen crist ...
Read more

Hyper-V VM not reaching OS 'Logon' screen

-
i trying migrate vm vmware hyper-v. so far have done following (seemingly successfully): prepare vmware vm conversion hyper-v format (vhd) within vmware workstation 8.0 environment following steps guide: http://social.technet.microsoft.com/forums/en/winserverhyperv/thread/ef8c12f7-c45d-442e-9a30-c43cd87df3b3   (i.e. remove vm tools, add new ide hard disk…) use vmdk2vhd application convert individual vmdk files vhd ones create new vm in hyper-v exporting in 3 newly converted vhd files at point have checked settings , powered on vm in hyper-v find although windows begins load expected manages reach screen prior login screen saying either of following messages: “windows starting up…” “the active directory rebuilding indices… please wait” to knowledge, albeit limited in area, vm should present me login screen since appears in vmware. if start vm in safe mode can login not desired affect. below details of vm: operating system: windows server 2003 (enterprise edit...
Read more

DNS question...

-
i new setting dns server....my domain name expl. "domain.com"....i set "a" record in forward lookup for  www.domain.com itself...."server's local ip"....i've added no other zones , i seem able resolve names except own....www.domain.com.....also, do i put my isp's dns ip's....for external dns's server can't resolve?....forwarding or in nic setup?......i want setup in my dns server don't have include them on client side..... thanks mark     not put isp dsn server address in settings on nic dc or clients. should point local dns server on dc. set dns forward public dns, such isp. bill Windows Server  >  Network Infrastructure Servers
Read more