Posts

Showing posts from January, 2015

Re: How to deal with the problem? Errors in the OLAP storage engine

please go ahead , start thread. provide more details situation. trying process , machine doing during processing? try , use activityviewer sample application ( you'll have re-run setup , install samples it) see if interesting looking @ opened connections/sessions , doing. edward. -- this posting provided "as is" no warranties, , confers no rights. we unable start additional threads when service hangs; restart of service option has worked us. this happens after data has been loaded source tables , attempting process cubes new data.  process run late in night when "practically" nobody working (since around midnight cube processing task scheduled). do need me attach trace files?   thanks help.   SQL Server  >  SQL Server Analysis Services

Deadlock at trigger

a trigger need insert or update record @ other table in high traffic environments however, deadlock happens; ie, trigger running twice @ same time want need insert record @ table. i trid change isolation serializable or repeatable , cannot solve problem. guess "while loop" affects result because try cancel loop , execute smoothly. ? how solve deadlock??? thx alex ----------------------------- i used following commands change isolation level: set transaction isolation level serializable begin transaction commit transaction ----------------------------- the code follows:      declare setskucursor cursor      local      static      for select item, quantity invset sku = @sku      open setskucursor      fetch next setskucursor @invsetitem, @invsetqty      while @@fetch_status = 0       begin        select @balsku = sku, @opendate = opendate invbal sku = @invsetitem        if (@balsku not null)         begin                         if @txdate <= @opendate           

How to selectively show grand total for columns or rows on pivot table

Image
hi i using excel 2013 self bi feature following reports here pivot table settings as can see, grand total dates not making sense. how can disable grand total dates while keeping totals other value fields? thanks regards jl another approach use iscrossfiltered-function, if no slicers or filter fields used on pivot table: if(iscrossfiltered(facttable[anycolumn]);[firstvisit];blank())) whereas replace parameter of iscrossfiltered real column of fact table.   SQL Server  >  Power Pivot

Create Dimension member with MDX in non Parent/Child Dimensions

hi, i've dimension table in star-schema. dimension-table doesn't based on parent-child structure. hierarchy based on several columns. my problem - how can add dynamically (with mdx) new dimension member in such dimension? it seams ssas doesn't support this??? - instead (if)- ssas offer insert new dimension member in such tables mdx? i've included attributes in dimension writeenabled true. any idea?   florian SQL Server  >  SQL Server Analysis Services

DQS not removing special characters

i using dqs , have domain checked box 'normalize string' , give output in form of lower case characters. but when run file against domain output contains lower case characters special characters comma, forward slash still there. anything wrong doing? thanks in advance. hello, when select normalize string check box, dqs ignores special characters in source value. dqs internally replaces special characters either null or space ensure better string comparison data quality processing. these internal replacements of special characters not have impact on processed or output data. if want find out special characters in source data, use regular expresssions in domain rule flag values containing special characters, , clean them interactively using dqs. example, can use following domain rule flag values contain special character or spaces between 2 words in value: value matches regular expression = ^[a-za-z0-9]+([\s][a-za-z0-9]+)*$ th

Cannot return SUM as a calculated measure based on member from query

apologies perhaps obvious solution this, i'm new mdx , olaps , trying find way. have cube has measure dimension derives average measures. incrementally i'm trying solution, using sum, , query below: with member measures.currentregion as  sum( { [region].[county].currentmember } ,  [measures].[avgbodyworklabourrate])   select    { [measures].[avgbodyworklabourrate], [measures].[avgpaintworklabourrate], measures.currentregion } on 0,  { nonempty([region].[county].children * [suppliers].[company name].children) } on 1  from [car cube]  i'm trying include the [measures].[avgbodyworklabourrate] per supplier company in each row, , include currentregion measure being sum of [measures].[avgbodyworklabourrate] [suppliers].[company name] in [region]. derived member seems return sum of current row, output values equivalent. ultimately i'm trying implement percent_rank function on region , country dimensions against each measure. appreciate assistance of

Access to ImageBrush from Javascript

i hava problem , can not find how solve it.  i created grid of rectangles 'grass' image imagesource javascript dynamically (20 20). now, i want change source of picture when mouse enters region of rectangle. don't know how i can it. event handle for this mouseenter wich calls ' mouseentertilehandler(sender, args)'  the following code gets executed in loop: var tile = control.content.createfromxaml( '<rectangle stroke="black" strokethickness="0.5" \ mouseleave="mouseleavetilehandler" mouseenter="mouseentertilehandler" height="25" width="25" \ canvas.zindex="1" canvas.top="' + * 25 + '" canvas.left="' + j * 25 + '"> \ <rectangle.fill> \ <imagebrush imagesource="images/grass.jpg"></imagebrush> \ </rectangle.fill> \ </rectangle>' );  is possible query sender , change imagesource of

"windows cannot back one or more private keys because the CSP does not support key export" while backing up CA database and private key...

hi all;   when want backup ca database , private key, following error message appears:   windows cannot 1 or more private keys because csp not support key export. want continue , backup private keys can exported?   i using windows server 2008 r2 enterprise , following output of running "certutil.exe –getreg ca\csp\*" command:   hkey_local_machine\system\currentcontrolset\services\certsvc\configuration\skicertificate\csp: values:   providertype             reg_dword = 1   provider                 reg_sz = microsoft strong cryptographic provider   hashalgorithm            reg_dword = 8004 (32772)     calg_sha1     algorithm class: 0x8000(4) alg_class_hash     algorithm type: 0x0(0) alg_type_any     algorithm sub-id: 0x4(4) alg_sid_sha1   machinekeyset            reg_dword = 1 certutil: -getreg command completed successfully.   any ideas?   thanks   thanks reply, uploaded requested log file , waiting response...   yes,

WMI issue with VB script

can not find relevant forum name, hence creating thread in "setup deployment" forum my product installer uses vb custom actions create , manage  scm service.  within vb custom actions, use  wmi classes win32_service, win32_dependentservice manage service.  use class "win32_dependentservice" present under namspace "\root\cimv2" list of depenedent services. on of machines, installer able execute vb custom action uses class "win32_dependentservice". on few machines, custom action fails. installer log shows following runtime error error number    : 451 error description    : object not collection source        : microsoft vbscript runtime error method name    : function operation    : executing query dependent service list the code snippet custom action fails below:- <snip> set objwmiservice = getobject("winmgmts:" & _                                 "{impersonationlevel=impersonate}!\\" & strcomputer & "\

Need some help with move-adobject

i trying run: get-adcomputer testpc | move-adobject -targetpath (get-adorganizationalunit -filter "name -eq '_test'") i trying move hostname testpc ou _test. have both, getting error: move-adobject : cannot convert 'system.object[]' type 'system.string' i trying move user: get-aduser testuser | move-adobject -targetpath "cn=ie,ou=firefox,ou=chrome,dc=ad,dc=mlp,dc=com" but getting following error: move-adobject : object cannot added because parent not on list of possible superiors thanks help hi, i have tested command below , move computer target path successfully. get-adcomputer w122 | move-adobject -targetpath 'ou=forcomputerou,dc=uu,dc=com' for more information, refer article below. the easy way use powershell move computer accounts https://blogs.technet.microsoft.com/heyscriptingguy/2012/03/01/the-easy-way-to-use-powershell-to-move-computer-accounts/ best regards, jay please remember mark replie

TS RemoteApp Published IE No Plugins

  i have server running ts remoteapp, server has shockwave, flash, adobe reader and java installed , working if rdp connect desktop.  published iexplore.exe remote app, , when run ie remote app keeps telling me need install flash plugin.  any idea how make work?   thanks   jared problem turned out problem 64 bit version of ie when published 32 bit ie worked should jared Windows Server  >  Remote Desktop Services (Terminal Services)

Generally what are the DNS problems we get and how to troubleshoot those problems

plz rely me muppuri hi,   here common dns problems resolutions:   http://technet.microsoft.com/en-us/library/cc959340.aspx http://technet.microsoft.com/en-us/library/cc961417.aspx http://technet.microsoft.com/en-us/library/bb727055.aspx   if encounter specific dns problem, you’re welcomed post in forum.   regards, bruce Windows Server  >  Group Policy

DNS Server not flushing Stale Records

i have 3  dc's active directory intergrated dns on them. have issues both forward , reverse lookup zones on both dns's server's. i have security section complaining due poor name resolution because scavenging not happening. have set-up microsoft says open call them on year ago. ideas why have many records time stamp older month not scavenging. i had microsoft ticket open year , half ago had me make these changes did not fix anything.  this had me change scavenge setting made dns server   1.   scavenging should set 1 server (dc03 x.x.10.50). scavenging should turned off on second dns server (dc02 x.x.9.41). scavenging need turned on 31 days should 1 day longer dhcp lease.   2.   the following need done on dc03, x.x.10.50:     a.   right click on server , click set aging , savaging on zones. make sure scavenge stale resource records checked. make sure no-refresh interval 15 days , refresh interval 16 days. (see below pic)       b.   right click on server ,

Server 2008 Upgrade worked... then update killed it!!

hi guys, i did upgrade windows server 2003 r2 2008. after quite time (overnight) greeted windows server 2008 login box, logged in , services started did else, jumped straight on network , had internet! whilst checking stuff out got .net framework 4.0 setup dialog box appear no buttons, informing me updating installation of .net framework 4.0 , let me know when it's done. after 10 minutes or running smoothly, several computers on network had succesffully connected , being issued ip's , access network related features normal, .net framework 4.0 prompted me reboot.. did. after reboot nothing hardly works, i'd around 30% of services start , when try manually start remaining i'm greeted 1053 error on each one. no longer connects internet , windows dialog boxes crash, network center. the problem it's live server , needs running asap! i've tried sfc /scannow , error saying windows resource cannot run, both in safe mode , normal. safe mode allows conne

How to block access to shares on domain computers from a work group computers?

in our company workstations , servers domain members. employees allowed use personal laptops not domain members in company network. problem hey can access shares in domain laptops entering domain credentials when prompted have domain user accounts. so, please me block them accessing domain shares workgroup latptops.. hello, without nap or manageble switches can't it. either not allow or configure network block it. http://technet.microsoft.com/en-us/network/bb545879 best regards meinolf weber mvp, mcp, mcts microsoft mvp - directory services my blog : http://msmvps.com/blogs/mweber/ disclaimer: posting provided "as is" no warranties or guarantees , , confers no rights. Windows Server  >  Group Policy

Server 2008 R2 cannot load Roles in server manager

system readiness tool reports following error...   checking system update readiness. version 6.0.6001.22275 2010-07-07 10:34 checking deployment packages checking package manifests , catalogs. checking package watchlist. checking component watchlist. checking packages. (f)    cbs mum missing    0x00000002    servicing\packages\package_for_kb980182~31bf3856ad364e35~amd64~~6.0.1.2.mum        checking component store checking smi store summary: milliseconds: 2304265  found 1 errors   cbs mum missing total count: 1 have attempted load mum file servicing/packages directory when unpacked update kb980182 did not have the correct mum file... closes thing found one: package_11_for_kb980182~31bf3856ad364e35~amd64~~6.0.1.2.mum   please provide me correct package, need urgently.   thanks, kevin hi kevin,   are running ie7 or ie8?   please confirm again whether system windows server 2008 or windows server 2008 r2.  

Can we upgrade Windows Vista Ultimate to Windows Server 2008?

i inherited client has winows vista "server" installed rather inept previous consultant.  babysat every day "server" serving file shares , printers , couple of apps across net windows xp machines.  no domains, peer peer file sharing. they need move forward upgrade , i'd them on windows server 2008 various reasons (like ad , centralized management among other things).  have ton of data on "server" today. i wondering - can sort of vista -> server migration or have reinstall bare hard drive? there no supported path upgrade vista 2008.  case versions.  not have ability upgrade workstation class oss server editions. visit: anitkb.com , knowledge base. Windows Server  >  Windows Server General Forum

Dell Inspiron M5030 - AMD Athlon II P360 AMD-V

Image
hi all, i have multiple laptops purchased late last year labs etc... server 8 beta. the intel chips have work , support both server 2008 r2 sp1 along windows 8 consumer , server 8 beta. i have 1 laptop dell inspiron m5030 - amd athlon ii p360 amd-v this laptop has run both server 2008 r2 sp1 , windows 8 consumer, both vm's. i unable install of server 8 dev or beta complete reason. the installs take me right point think finish , reboot second time , stops. lights on nobody home.  no bsod, no error message, lights continue blink bit screen dark going down second boot , stays way.  i have power off. tips, tricks, hints, hacks appreciated... i have contacted dell , should work fine.  i have spoken amd , used there virtual test , looks there.   have checked driver , firmware updates etc... , offered nothing dell or amd regarding this. so guess i'm wondering if software , if adjustments made accommodate... i have read thru of information laptops on ms site , g

FSMO fail, how long or max time/days must take action to seize roles

any figure on 10000 workstations, 130 dc, each role of fsmo fail, how long or max time/days must take action seize roles no production impact. thx alkq hello, if realize dc failed , can not restore backup direct. may not realize impact, schema if upgrade, domain naming if try create new domains. pdcemulator more important 1 used password conflict check between dcs , handles account lockout, if time goes wrong important 1 time source domain. rid relazie if dcs not able update rid pool , no new objects can created. best regards meinolf weber disclaimer: posting provided "as is" no warranties or guarantees , , confers no rights. Windows Server  >  Directory Services

Start Menu and Taskbar Icons, not responding on Windows 10 Insider Preview build 10074

Image
hello there, ask issue i'm having, regarding start button not respond when clicking it, search bar wouldn't work when typing or clicking it. whole taskbar not working. should do? since said whole taskbar not working, try method go settings..... right click @ open spot of desktop > click personalize > @ top, click arrow .... does bring settings ? if yes, click update & security > left side, click recovery > select refresh...... Windows 10 Insider Preview  >  Windows 10 Insider Preview Feedback

Auditing File Access on File Servers with GPO - Not logging any event

hi guys, im kind of new in please ask regarding audit configuration found in link: http://blogs.technet.com/b/mspfe/archive/2013/08/27/auditing-file-access-on-file-servers.aspx#comments so have done audit configuration cant see 4663 or other event related audit configuration on event viewer. give  abetter overview setup , i've done: - have lab domain 1 dc, 1 file server (that holds shared folders , files want audit) both of them w2008r2 , 1 windows7 client computer. - created 1 gpo name 'file server audit policy' configurations mentioned here applied ou contains fileserver - 'gpresult' command tells me gpos applied fileserver 'default domain policy' , 'file server audit policy' - in fs have 1 folder have shared name 'shares' , under have 3 folders, marketing, finance , it. - want audit happens on 3 folders create sacl on 'shares' 'everyone' group. - windows7 client computer, regular user accou

Problem synchronizing w2012 server with wsus server

hi, i have server 2012 cannot synchronize wsus server (version 6.2). i have reviewed page (https://technet.microsoft.com/en-us/library/dd939857(v=ws.10).aspx) , have checked fine client (server 2012) but, don't know why servers don't contact wsus. the rest of pc synchronizing without problem. in gpmc have policy apply these servers but looking in "local compute policy > computer configuration > administrative templates > windows" settings not filled, in regedit settings correct. can me? thanks in advanve. hi, please find fatal entry in windowsupdate.log. not warnings are  critical errors. start fatal errors , work top of the windowsupdate.log log file make sure that have identified correct error message. here article how troubleshooting wsus issue using windowsupdate.log file. https://support.microsoft.com/en-us/kb/902093 best regards. steven lee please remember mark replies answers if , unmark them if provide no help. if have feed

Remote Desktop Web Access and Gateway - the way they work together

as far remote web access component of remote desktop services in r2, need gateway service enable it? or can without running gateway component? in other words can have users go specific url points specific terminal server/remote desktop server , web interface show let's 3 icons - full remote desktop la old ts, virtualized app e.g. word or full virtualized workstation image - vdi - e.g. windows 7? hi, yes, can use remote desktop web access access rdsh, remoteapp, or vdi pool without using rd gateway.  name/ip address of each server associated with an icon must resolvable reachable client pc.   rdwa mechanism tell client pc server/remoteapp/pool/etc. should try connect to.  example, let you have three icons in rdwa like mentioned: 1. desktop -- rdsh server named rds01 ip address 10.2.2.30 (this server rdwa server) 2. microsoft word -- remoteapp runs microsoft word 2007 located on rdsh server named rds02 10.2.2.31 3. vdi pool -- connects virtual desktop pool consisting of 2 vms: vdi0

NTP Server -Windows 2012 R2

i secure server external time sync, , non dc server be hosting ntp. i have encountered issueas below: 1) domain enviroment big , complex, users' ntp associated available dc domain.     set non-dc specific ntp server. feasible? 2) gpo ntp client , ntp server settings, user still w32tm still sync dc time source.     is there way can workaround this? 3)  do windows 10 or end user can sync. ntp 4 intead of w32tm service? thank in advance help.  domain members must sync dc holds pdc fsmo role.  default configuration.  requirement ensure no time drift within domain of domain security dependent upon time synchronization. tim Windows Server  >  Windows Server 2012 General

ADFS in Azure fails when Site-to-Site VPN fails

we have adfs 3.0 setup on several vms in azure site-to-site vpn between them , local network. all works fine until vpn goes down , although external users can access adfs logon screen (via adfs proxy in azure) unable authenticate, though there's domain controller in azure. we can't understand why dc in azure won't authenticate users while vpn down? as vpn comes again starts working. we've checked azure vms using correct dns settings i.e. looking @ local dc rather on-premise , seems ok anyone else had similar problems? cheers now russell any error in event viewer on clients , security events on azure dc? post provided no warranties or guarantees, , confers no rights. ~~~ questo post non fornisce garanzie e non conferisce diritti Windows Server  >  Directory Serv

W2K8R2 RDS Server - Licensing

hello all, hopefully can convey question accurately enough. i have remote customer test server grace period has ended.  we can no longer rdp station - error message: the remote session disconnected because there no remote desktop license servers available provide license. please contact server administrator.  my question is, shouldn't still able rdp station @ least 1 session administration or because rds role installed eliminates option , depends on licensing server?  the tcals have been installed per user. i replaced person deployed station imagine license server never specified during configuration.  i know automatic detection removed in r2.  what options accessing station remotely?   able connect various consoles via w2k8 standard server running terminal services, when tried specify license server route, failed.  -brian hi brian, you can connect using /admin command line switch, this: mstsc /admin once connected please open rd session host config

Security ID 6281 l3codeca.asm

on new windows 2008 r2 terminal server, seeing event id 6281 source microsoft windows security. "code integrity determined page hashes of image file not valid. file improperly signed without page hashes or corrupt due unauthorized modification. invalid hashes indicate potential disk device error. file name: \device\harddiskvolume3\windows\system32\l3codeca.acm" http://social.technet.microsoft.com/forums/en-ca/winservergen/thread/009c3e66-f99e-40b6-97ca-05f33ad26239  pointed to  http://msdn.microsoft.com/en-us/windows/hardware/gg487338.aspx which describes vista file dated 2006/08/25. 1 on server dated 2009-07-13. kb891122 lists l3codeeca.acm older version. won't install on w2k8-r2 anyway. i don't want see security errors in event log. ignoring event not solution. there current fix this? thanks, bob. on tue, 21 feb 2012 00:29:04 +0000, bobh2 wrote: gopi, said, ignoring problem not solution. not want see errors in event logs , ha

How best to replace critical 2003 domain controllers with 2008 R2?

hi, we looking 'transition' 2003 sp2 x86 domain controllers 2008 r2 x64.  have hundreds of branch sites routers use ip addresses of 2 windows 2003 dcs dns.  primary pointing dc1 , secondary dc2.  in addition, have split scope dhcp running subnets on these 2 windows 2003 domain controllers. for obvious reasons, want retain ip addresses of 2 2003 domain controllers replacement windows 2008 r2 domain controllers.  strategy can think of @ present is: - prepare ad 2008 r2  - uninstall ad / dns from dc2, reboot.  change ip address of server, running dhcp, different.  ensure dns updated reflect before proceeding. - configure new 2008 r2 domain controller (dc4) ip address of decommissioned 2003 dc above.  install ad 2008 r2 onto dc4, including dns.  install , configure dhcp in readiness host other half of dhcp split scope, still sitting on 2003 dc above.  migrate dhcp member server above 2008 r2 domain controller.  test , ensure well. - now, same 2 steps above first dc

SP2 vs. the Windows Server 2003 Security Guide

in process of developing configuration standards address pci dss requirements , i'd like to use recommendations defined in ms "windows server 2003 security guide" , related template files.  but guide states relevant sp1, not sp2.  know if there changes in sp2 render guide no longer applicable servers running service pack?  or use guide on sp2 based servers without reservation? thanks. can use the windows server 2003 sp2 security configuration guide 3.0 situation you can download it  here in pdf , xps format. Windows Server  >  Windows Server General Forum

Managing Workstations

please kind; i'm newbie.  running windows server 2003 on our network, mix of thin clients , thick clients.  want able manage thick clients' network profiles remotely install software , make other changes.  i've tried using rdp, able log on local desktop , not network profile.  i'm confident user rights, etc., set our system support people have been able log on profiles right prior.  workstations i'm trying administer computers , not user accounts.  thick clients running windows xp professional.  please advise.  doing wrong? chris hi, i sorry little unclear exact requirement. before go further, collect information: 1.you mentioned “manage thick clients' network profiles”. please describe in detail kind of network profile manage? 2.how did system support people logon network profile? please describe in detail. david shen Windows Server

Problems with Windows 2008 terminal server roaming profiles

we have win 2008 server terminal serve, , 2003 server dc, , file server profiles. settings set gpo linked ou containing terminal server. problem when user logs off, local copy of profile not deleted. there few files ntuser.dat, or might empty, root folder still exist. next time log on, new folder called %username%.000, 001, etc.. know why happen? makes problems program each time new folder as robert mentioned, may bad print driver (wouldn't surprise me in least).  can use stressprinters  to diagnose printers , see if of them bad drivers.  have tried using easyprint don't have print drivers? Windows Server  >  Remote Desktop Services (Terminal Services)

Replication Scope for Reverse Zones ??

are there adverse effects on having reverse zones replicate forest-wide ? we have empty root domain 3 child domains 3 regions, na, eu , ap. decided create our reverse zones based on ad defined subnets. , keep them standard across board i.e forest wide. i understand how each replication scope works. wondering best practice on this. thanks knowledgeable input. regards,   hi,   i think ok move reverse zones forest-wide dns application directory partition. however, please note broader replication scope, greater network traffic caused replication. example, if choose have active directory-integrated dns zone data replicated dns servers in forest, produce greater network traffic replicating dns zone data dns servers in single active directory domain in forest.   hope information helpful. Windows Server  > 

Problems with interpreting "Historical Performance Trends"-report

hi all, we installed performance reports published grant holliday, i'm not sure if unterstand them right way. infact of using sql 2005 can't use reports, example "historical performance trends" report. tried show how time saved improving response time of version control request, calculation said, users spent 8 days while waiting response in last 2 weeks, sounds lot. here calculation: 50 intervals in 2 weeks multiplied 22.673 requests per interval (average of total number of source control download requests chart) multiplied 600ms per request (average time of version control) = 680.190 seconds = 11336,5 minutes = 188,94 hours = 7,8 days am missing or our users realy spent 8 days of waiting tfs? are there references given ms compare with the average values have? (~20 team projects, ~200users, ~50gb of data in sql) thanks far, michael hi michael, if you'd send me copy (granth @ microsoft.com) of rendered report you're concerned about, can have @ it. you might i

Exporting to Excel from TFS 2013 Web base

i trying export test cases visual studio team foundation server 2013 excel. i have right clicked , select export microsoft excel , once excel opens following message: this web query returned no data. change query, click ok, click arrow on name box in formula bar, click name of external data range web query, right0clicj selection , , click edit query. i have tried still not able export. hi kwhite88, i'd know more details scenarios. please confirm points list below: 1. saved query? if so, available query test cases in team explorer? 2. how did export test cases excel? in general, need create or new query test cases , save before can export. open file of excel, click "team" tab , "new list". connect team project , select query saved earlier export test cases excel. please have try see if works you, , elaborate more details scenario(or screenshots) if issue still exist. best regards, we trying better understand customer views on social suppor

GPMC Report Error

hello, i've problem agpmc. if want create html report, i've error message: "an unknown error occurred while data gathered extension. details: 64" i've noticed "administrative templates" missing under computer configuration , user configuration. if edit gpo, can change settings , there applied. error appears rsop report. anyone have idea problem? domain windows 2003 srv agpmc server installed on win2k8 srv r2 cse installed on xp clients hi,   would view html report software restriction policies settings?   if so, known problem on windows 7 , windows server 2008 r2.   to view software restriction policies settings, please use gpmc on computer running earlier version of windows operating system windows 7 , windows server 2008 r2.   for more information, please refer thread:   http://social.technet.microsoft.com/forums/en/winservergp/thread/eb3646ae-bfc5-43d3-a621-c83afc54d66a thanks understanding.   regards, bruce

Are there benefits to adding crossover cable between two servers for DFS replication and SQL Always On?

i have 2 identical servers 4 network interfaces each. primary usage 2 servers hosting sql server instance on high availability , dfs replication. 2 network interfaces each server used connect main network, while other 2 (on each) thinking using crossover cable possibly provide shorter path 2 servers communicate. will there benefits doing so, moreover, teaming 2 crossover cable more? edit: below link article got idea of moving dfs replication traffic crossover. wasn't able find info whether same thing applied sql on high availability. http://blogs.technet.com/b/filecab/archive/2006/08/24/449013.aspx hi, according description, understanding want connect 2 servers crossed cable(2 nics). just blog suggested, directly connect servers crossed cable , configure corresponding route entries improve efficiency. if both servers have 2 nics connect, recommend team 2 nics bandwidth aggregation. nic teaming supported windows server 2012/2012 r2, detailed information may referenc

Event ID 1864

i having issue every day getting event id errors 1864.  have 7 servers.  5 @ remote locations vpn tunnels hq.  other running exchange, , other file server.  haven't been able figure out.  have same error domaindnszones, forestdnszones, schema, configuration, , who-gb when run dcdiag get: directory server diagnosis performing initial setup:    trying find home server...    home server = dc1-wcasrv01    * identified ad forest.    ldap search capabality attribute search failed on server dc1-wcagb, return    value = 81    got error while checking if dc using frs or dfsr. error:    win32 error 81the verifyreferences, frsevent , dfsrevent tests might fail    because of error.    ldap search capabality attribute search failed on server dc1-wcamp, return    value = 81    got error while checking if dc using frs or dfsr. error:    win32 error 81the verifyreferences, frsevent , dfsrevent tests might fail    because of error.    ldap search capabality a