windows server 2012 r2 - Error Installing ADFS 3.0 -


i'm trying install adfs on new installation of win server 2012r2 , error in post-deployment configuration. domain controller win server 2008r2. please me, i've been trying solve 3 days.

the error says:

schema verification failed database 'adfsconfiguration'. alter database statement failed. failed restart current database. current database switched master.

this error log after installation:

2015-04-29 12:46:55.93 server microsoft sql server 2012 - 11.0.2100.60 (x64) feb 10 2012 19:39:15 copyright (c) microsoft corporation windows internal database (64-bit) on windows nt 6.2 (build 9200: ) (hypervisor)

2015-04-29 12:46:55.97 server (c) microsoft corporation.

2015-04-29 12:46:55.97 server rights reserved.

2015-04-29 12:46:55.97 server server process id 1532.

2015-04-29 12:46:55.97 server system manufacturer: 'vmware, inc.', system model: 'vmware virtual platform'.

2015-04-29 12:46:55.98 server authentication mode windows-only.

2015-04-29 12:46:55.98 server logging sql server messages in file 'c:\windows\wid\log\error.log'.

2015-04-29 12:46:55.98 server service account 'nt service\mssql$microsoft##wid'. informational message; no user action required.

2015-04-29 12:46:56.00 server registry startup parameters: -w 65535 -t 1617 -k -e c:\windows\wid\log\error.log -l c:\windows\wid\data\mastlog.ldf -d c:\windows\wid\data\master.mdf

2015-04-29 12:46:56.00 server command line startup parameters: -s "mswin8.sqlwid" -s "microsoft##wid"

2015-04-29 12:46:56.54 server sql server detected 1 sockets 1 cores per socket , 1 logical processors per socket, 1 total logical processors; using 1 logical processors based on sql server licensing. informational message; no user action required.

2015-04-29 12:46:56.54 server sql server starting @ normal priority base (=7). informational message only. no user action required.

2015-04-29 12:46:56.54 server detected 4095 mb of ram. informational message; no user action required.

2015-04-29 12:46:56.54 server using conventional memory in memory manager.

2015-04-29 12:46:59.38 server node configuration: node 0: cpu mask: 0x0000000000000001:0 active cpu mask: 0x0000000000000001:0. message provides description of numa configuration computer. informational message only. no user action required.

2015-04-29 12:46:59.41 server using dynamic lock allocation. initial allocation of 2500 lock blocks , 5000 lock owner blocks per node. informational message only. no user action required.

2015-04-29 12:46:59.42 server software usage metrics disabled.

2015-04-29 12:46:59.57 spid7s starting database 'master'.

2015-04-29 12:47:00.20 spid7s password regeneration attempt sa successful.

2015-04-29 12:47:00.25 spid7s resource governor reconfiguration succeeded.

2015-04-29 12:47:00.25 spid7s sql server audit starting audits. informational message. no user action required.

2015-04-29 12:47:00.26 spid7s sql server audit has started audits. informational message. no user action required.

2015-04-29 12:47:00.48 spid7s sql trace id 1 started login "sa".

2015-04-29 12:47:00.50 spid7s server name 'garweb01\microsoft##wid'. informational message only. no user action required.

2015-04-29 12:47:01.00 server clr version v4.0.30319 loaded.

2015-04-29 12:47:01.16 spid9s starting database 'mssqlsystemresource'.

2015-04-29 12:47:01.21 spid7s starting database 'msdb'.

2015-04-29 12:47:01.24 spid13s service master key regeneration successful.

2015-04-29 12:47:01.24 spid13s server local connection provider ready accept connection on [ \.\pipe\microsoft##wid\tsql\query ].

2015-04-29 12:47:01.25 spid9s resource database build version 11.00.2100. informational message only. no user action required.

2015-04-29 12:47:01.26 spid13s dedicated administrator connection support not started because disabled on edition of sql server. if want use dedicated administrator connection, restart sql server using trace flag 7806. informational message only. no user action required.

2015-04-29 12:47:01.43 spid9s starting database 'model'.

2015-04-29 12:47:01.87 spid9s clearing tempdb database.

2015-04-29 12:47:03.65 spid9s starting database 'tempdb'.

2015-04-29 12:47:07.48 spid16s service broker endpoint in disabled or stopped state.

2015-04-29 12:47:07.52 spid16s database mirroring endpoint in disabled or stopped state.

2015-04-29 12:47:07.72 spid16s service broker manager has started.

2015-04-29 12:47:08.13 server common language runtime (clr) functionality initialized using clr version v4.0.30319 c:\windows\microsoft.net\framework64\v4.0.30319.

2015-04-29 12:47:09.13 spid7s sql server ready client connections. informational message; no user action required.

2015-04-29 12:47:09.28 spid7s recovery complete. informational message only. no user action required.

2015-04-29 12:47:09.59 spid3s significant part of sql server process memory has been paged out. may result in performance degradation. duration: 0 seconds. working set (kb): 5648, committed (kb): 119708, memory utilization: 4%.

2015-04-29 12:49:03.32 spid3s significant part of sql server process memory has been paged out. may result in performance degradation. duration: 331 seconds. working set (kb): 24060, committed (kb): 98188, memory utilization: 24%.

2015-04-29 12:52:52.70 spid51 attempting load library 'xpsqlbot.dll' memory. informational message only. no user action required.

2015-04-29 12:52:52.74 spid51 using 'xpsqlbot.dll' version '2011.110.2100' execute extended stored procedure 'xp_qv'. informational message only; no user action required.

2015-04-29 12:53:05.74 spid3s significant part of sql server process memory has been paged out. may result in performance degradation. duration: 601 seconds. working set (kb): 38888, committed (kb): 98548, memory utilization: 39%.

2015-04-29 12:58:19.65 spid3s significant part of sql server process memory has been paged out. may result in performance degradation. duration: 928 seconds. working set (kb): 39020, committed (kb): 98548, memory utilization: 39%.

2015-04-29 13:03:46.67 spid3s significant part of sql server process memory has been paged out. may result in performance degradation. duration: 1258 seconds. working set (kb): 39580, committed (kb): 98892, memory utilization: 40%.

2015-04-29 13:09:17.59 spid3s significant part of sql server process memory has been paged out. may result in performance degradation. duration: 1523 seconds. working set (kb): 39568, committed (kb): 98940, memory utilization: 39%.

2015-04-29 13:15:34.11 spid3s significant part of sql server process memory has been paged out. may result in performance degradation. duration: 1853 seconds. working set (kb): 39776, committed (kb): 99044, memory utilization: 40%.

2015-04-29 13:16:33.02 logon error: 18456, severity: 14, state: 38.

2015-04-29 13:16:33.02 logon login failed user 'garantizar\backupusr'. reason: failed open explicitly specified database 'adfsconfiguration'. [client: ]

2015-04-29 13:16:48.56 logon error: 18456, severity: 14, state: 38.

2015-04-29 13:16:48.56 logon login failed user 'garantizar\backupusr'. reason: failed open explicitly specified database 'adfsconfiguration'. [client: ]

2015-04-29 13:16:50.57 spid51 starting database 'adfsconfiguration'.

2015-04-29 13:16:51.38 spid51 setting database option single_user on database 'adfsconfiguration'.

2015-04-29 13:16:51.88 spid34s not start service broker database id: 5. problem preventing sql server starting service broker. check sql server error log additional messages.

2015-04-29 13:16:51.97 spid34s error: 9645, severity: 16, state: 3.

2015-04-29 13:16:51.97 spid34s error occurred in service broker manager, error: 3602, state: 124.

2015-04-29 13:16:59.89 spid51 setting database option multi_user on database 'adfsconfiguration'.

2015-04-29 13:17:00.23 spid51 starting database 'adfsconfiguration'.

2015-04-29 13:17:00.34 spid51 failed verify authenticode signature on dll 'c:\windows\wid\binn\dbverify\adfsconfigdbverify.dll'.

2015-04-29 13:17:58.86 spid51 starting database 'adfsconfiguration'.

2015-04-29 13:18:20.94 spid54 attempting load library 'xpstar.dll' memory. informational message only. no user action required.

2015-04-29 13:18:21.11 spid54 using 'xpstar.dll' version '2011.110.2100' execute extended stored procedure 'xp_instance_regread'. informational message only; no user action required.

2015-04-29 13:18:23.04 spid54 starting database 'adfsconfiguration'.

2015-04-29 13:18:42.36 spid54 setting database option multi_user on database 'adfsconfiguration'.

2015-04-29 13:18:42.41 spid54 starting database 'adfsconfiguration'.

2015-04-29 13:18:42.44 spid54 failed verify authenticode signature on dll 'c:\windows\wid\binn\dbverify\adfsconfigdbverify.dll'.

i found myself error, problem windows internal database service running account nt service\mssql$microsoft##wid configured windows. configured service start local system account , worked ok.


Comments

Post a Comment

Popular posts from this blog

php - failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request -

this code i'm using find latitude , longitude of place: function coords($address){ echo $url="http://maps.googleapis.com/maps/api/geocode/json?address=".$address; $json = file_get_contents(urlencode($url)); $data = json_decode($json, true); print_r($data['results'][0]['geometry']['location']['lat']); print_r($data['results'][0]['geometry']['location']['lng']); } however returns warning: failed open stream: http request failed! http/1.0 400 bad request if use above code in simple procedure works fine not in function. note: have tried curl_init()... method produced same result? instead of encoding whole url encode address part. following code work fine $add='jamshoro phase 2'; $url="http://maps.googleapis.com/maps/api/geocode/json?address=".urlencode($add); $json = file_get_contents($url); $data = json_decode($json, true); print_r($data['r
Read more

java - How to filter a backspace keyboard input -

i have code gives message when key number pressed: txtvalueofclause.addeventfilter(keyevent.key_typed, new eventhandler<keyevent>() { @override public void handle(keyevent t) { char ar[] = t.getcharacter().tochararray(); char ch = ar[t.getcharacter().tochararray().length - 1]; if (!(ch >= '0' && ch <= '9')) { system.out.println("the char entered not number"); t.consume(); } } }); now if press on wrong button , press backspace remove it, error message. how can add backspace input if statement? i have found answer: txtvalueofclause.addeventfilter(keyevent.key_typed, new eventhandler<keyevent>() { @override public void handle(keyevent t) { char ar[] = t.getcharacter().tochararray(); char ch = ar[t.getcharacter().tochar
Read more

java - Show Soft Keyboard when EditText Appears -

i have code in android app, alert dialog , keyboard, , when dialog shown want keyboard appear. not , not sure why? here code: final alertdialog.builder alert = new alertdialog.builder(this); alert.settitle("title"); alert.setmessage("message"); final edittext input = new edittext(this); input.setinputtype(inputtype.type_class_number); alert.setview(input); input.setonfocuschangelistener(new view.onfocuschangelistener() { @override public void onfocuschange(view v, boolean hasfocus) { if (hasfocus) { log.i(tag, "in focus"); inputmethodmanager inputmethodmanager = (inputmethodmanager) getsystemservice(context.input_method_service); inputmethodmanager.showsoftinput(input, inputmethodmanager.show_implicit); } } }); but keyboard not appear though edit text in focus, , tell appear why, doesn't come up? thanks in advance.
Read more