My fan

i have formula field.  within formula, check duplicate casenumber. if {srs} = 'srs-adep' then     if {srspetitiontype} in ['cvdep01'] then         here need check duplicate casenumber before set 1         1     else         0 else     0 help please! thanks! ssrs not crystal reports. need direct query elsewhere   craig bryden - please mark correct answers SQL Server  >  SQL Server Reporting Services, Power View

can throttle/restrict resources @ database level similar resource governor? melissa explore information services, llc you use resource governor - simple ensure connection string includes correct database , include database name of connection string within classifier function. if mean "can define database x have y cpu % , z memory etc" no - doesn't work that.   restrict resources based on session being classified workload group , resource pool martin cairney sql server mvp SQL Server  >  SQL Server Database Engine

hi all, in 1 of our sql server box (i took on box), being used monitor other sql , webservers runningstored procedures in each , every minute. everything going smoothly until last couple of weeks seems. suddenly, sql agent stops automatically in sql monitory box. when checked memory availability in task manager, shows less 10% available free memory. lot of powershel.exe running on processes column. i guess stored procedures invoking powershell.exe , not closing after done operation. can me identify consumes more memory , going behind scene. checked blocks or locks , failed see using ssms please me resolve this. cheers,sengwa     hi sengwa,   lot of powershel.exe running on processes column. please check detail of job. if there invocation powershell, seems powershell threads worked incorrectly. if there no invocation powershell, please check other programs see program running it.   in order check content of job, please follow steps be...

everything looks fine, driver says working correctly , connection exists. problem there no internet connection. not recognize dchp router or cable modem directly. there no ipv4 , won't let me delete set again. have read in other posts in different forums happening lot of people on win 10. known problem , there fix? more not when device isn't working because driver has become corrupted. re-installing fresh copy should help http://windows.microsoft.com/en-us/windows7/update-a-driver-for-hardware-that-isnt-working-properly?signedin=1 http://captaindbg.com/how-to-update-drivers-on-windows-7/    (works on win 8 & win 10) wanikiya , dyami--team zigzag Windows 10 Insider Preview  >  Windows 10 Insider Preview General ...

i have windows server 2008 file server. file server hosts personal directories of end users. 1 particular user receiving folling error message when synching files, " no more connections can made remote computer @ time because there many connections computer can accept." the client using windows xp sp2. maximum amount of users can connect share set 10 , end-user person has access share. any tips or suggestions on or at? thanks, mj when see issue, suggest verify number of connections under 10 share.  there else connecting share didn't realize.  check number of connections share run start -> administrative tools -> computer management -> system tools -> shared folders -> shares , check # client connections share in question.   if find number 10 can check out list of connections in sessions section see if can track down connections coming from. Windows Server ...

i have searched on , on solution, standard boilerplate answers don't work.  we have small, flat domain single dc.  it's 2012 server , have windows 7 clients.  when particular user on particular workstation tries log in, login screen gives error "there time and/or date difference between client , server".  however, user.  can log in workstation using different user names.  user (a domain admin) can log in locally server , can log in other workstations.  things have done: 1.)  set user's account not require kerberos in account tab in aduc. 2.)  command line, run "net time /domain:<my domain> /set 3.)  command line, run following commands: w32tm /config /manualpeerlist:"0.north-america.pool.ntp.org, 1.north-america.pool.ntp.org, 2.north-america.pool.ntp.org, 3.north-america.pool.ntp.org" /syncfromflags:manual /reliable:yes /update w32tm /query /peers net stop w32time net start w3...

hello, we updated our ssl certificate our rds system (consisting of single rds server including gateway web access , host roles), configured in iis , rdgateway configuration.  iis works fine, certificate picked browsers accessing ssl version of web access site, checking certificate information in address bar checks out ok.  can demonstrated going https://mercury.counterpointeurozone.com/rdweb/pages/en-us/login.aspx . the problem access published applications web access (i might add using clients updated rdc7, , in instances of xp sp3 have credssp patch installed) certificate warning, pointing random auto-generated internal certificate have not explicitly created. the frustrating thing have wiped certificates out using cert mmc, , installed our certificate, upon accessing application self certified certificate auto-created (if doesnt exist) , uses it.  have tried disabling uses of certificate once it's been created still ends using it. this worked fine befor...

hello we're getting issues creating files , setting security on 1 of our servers, getting error "the requested operation not completed due file system limitation" in event viewer>applications , services logs>microsoft>windows>ntfs>operational, have error: log name:      microsoft-windows-ntfs/operational source:        microsoft-windows-ntfs date:          01/04/2015 23:01:48 event id:      139 task category: none level:         warning keywords:      (4) user:          system computer:      jps-sr-fs-02.jps.internal description: file system structure maintains security information on volume d: (\device\harddiskvolume4) has grown excessively large , fragmented.  the structure has reached 100%% of maximum fragmentation limit.  if structure continues grow , reaches limit, m...

i trying convert vmware based vm (server 2008 r2) hyper v vm.  hyper v server 2012.  problem when create smb share, error when trying add full access permissions.  hyper v server definition in workgroup instructions seem based on hyper v being role in windows server , assume domain configuration.   when use vmware plugin, same error indicating there no write permissions on smb folder.  message suggests problem 2 machines in different domains , should addressed. is there way address workgoup issue in hyper v server 2012 can add required write permissions?  can use location on same machine source vm , and manually copy there?   not have scvmm , aware rebuild machines , port data on onerous. you can use free vm converter 5nine you..it works well http://www.5nine.com/vmware-hyper-v-v2v-conversion-free.aspx i think easier use 1 microsoft , have had better success it james_stephan@yahoo.com visit blog stephanco.blogspot.com ...

our environment quite simple, have 3 dcs , 1 site. dc1 (fsmo holder) dc2 dc3 they 2008 r2 servers dfl , ffl both on 2008 r2. have been upgrading 1 @ time server 2012. when upgrade, building brand new server 2012 cutting old server on , renaming/re-iping new server match old server. following similar steps provided here: http://msmvps.com/blogs/acefekay/archive/2010/10/09/remove-an-old-dc-and-introduce-a-new-dc-with-the-same-name-and-ip-address.aspx immediately after moving dc3 2012, started receiving 3 errors per day under directory service event log. event id 1864 (replication) , "this directory server has not received replication information number of directory servers within configured latency interval. " there 1 event for each of following: directory partition: cn=schema,cn=configuration,dc=intra,dc=cas,dc=org cn=configuration,dc=intra,dc=cas,dc=org dc=intra,dc=cas,dc=org interesting enough, after 60 days event went away (i believe ou...

i running windows xp  home edition on dell inspiron 1501 laptop.  need reinstall programs.  have certified windows xp cd, product key label located on bottom of laptop rubbed clear , not have key written down.  how can product key can reinstall programs.  cd not work without key. hi,   if laptop came windows xp home edition , got windows xp home edition cd laptop, should able perform fresh installation cd.   if issue continues, recommended contact dell support further support. understanding.     best regards, vincent hu     Windows Server  >  Windows Server General Forum

i receiving access denied when trying edit gpo have created using gpmc createenvironmentfromxml.wsf script. i've created gpo in dev environment ok, backed create xml file/folder. can import in new environment using createenvironmentfromxml.wsf when edit gpo gives access denied. i've checked permissions in sysvol , have write access gpos. im creating 22 gpos using method , affects ones.. there no replication issues on domain. the environment windows 2003 r2 single forrest/single domain. any advice or pointers welcomed. thanks mattc thanks replies....delegation had been correctly set administrator full permissions. however think i've solved it....i using xml file import , create gpos using createenvironmentfromxml.wsf script bundled gpmc. on close inspection had incorrectly set enabled=" xxxx" parameter. had marked machine rather true....this meant unable save changes in user section of gpo. by recreating gpo correct enabled="true" ...

the hpc management service service terminated unexpectedly.  has done 1 time(s).  following corrective action taken in 60000 milliseconds: restart service. hi minjun xu, have checked kb related error 1603: https://support.microsoft.com/en-sg/kb/834484 this forum failover cluster, issues of hpc, post in dedicated forum better help: https://social.microsoft.com/forums/en-us/home?category=windowshpc best regards, leo please remember mark replies answers if , unmark them if provide no help. if have feedback technet support, contact tnmff@microsoft.com. Windows Server  >  High Availability (Clustering)

i have wsus 3.2 on disconnected network. can export server 2012 wsus 6 imported wsus 3.2 server 2008r2? hi, i can't find official document limitation. from point of view, it's not idea import data newer server. i'll test in lab later. 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  >  WSUS

hi guys, i have 2003 terminal server misbehaving it's printing. working has since started cause problems know can work properly. here symptoms: i have several pcs connecting server same type of printer - canon lbp3100. rdp redirecting print jobs these printers. in print queue of each of these printers job called: "system job" status "sent printer" pages n/a , size of 44 bytes. job seems blocking other print jobs being deleted queue. jobs print, remain "sent printer"  and queue fills up. printing slow. i have changed permissions on spool drive allow users full rights , allowed anonymous have same permissions "everyone" in local security policies. i've updated drivers latest ones available canon's website. if disable bi-directional support, "system job" queues, prints , re-queues endlessly user changing after each "printing" whoever logged in. is, print user 1, print user 2, user 3 , user 1 again. i...

hi using remote desktop app version 8.0.32 on os x 10.11. there has been issue client tries connect screen closes @ stage of 'connecting rdp' i know remote desktop licensing data stored can rule out if causing issue hi, i doubt licensing information stored within remote desktop mac. you may test windows clients see happens. in addition, please try our remote desktop mac beta application below: http://aka.ms/rdmac-preview if issue persists, suggest check terminal services logs on rds server see whether more clues can found, under: event viewer -> applications , services logs\ microsoft\ windows. best regards, amy please remember mark replies answers if , un-mark them if provide no help. if have feedback technet subscriber support, contact tnmff@microsoft.com. Windows Server  >  ...

adprep /forestprep issue: adding additional server (note: 3 server 2008 , using 2008 functionality) server #4. discription/error: install domain controller active directory forest, must first prepare forest using "adprep /forestprep". adprep utility available on windows server 2008 r2.... etc... have tried: transferring fsmo schema master other server. after running adprep warning: (note: usual warning) typing "c" enter. result = forest-wide information has been updated. [status/consequence] adprep did not attempt rerun operation. --- yet when run "adprep /forestprep" - same issue in discription/error. any assistance great if know answer , fix. please not limit 1 response. 1 response not right answer. thank , have great new year. gerald, i'm not sure opinion looking other provided. pretty contributed thread stated need upgrade schema running adprep windows server 2008 r2 installation media hth marcin ...

i have hp pavilion desktop pc a1322in windows xp(home)  media center edition. i coming across sudden shutdown , automatic reboot error message appearing windows has recovered serious error. event log shows following record during shutdown: event type: information event source: save dump event category: none event id: 1001 date: 9/1/2006 time: 12:08:57 am user: n/a computer: udayan description: the computer has rebooted bugcheck. bugcheck was: 0x000000fe (0x00000002, 0x83aa4718, 0x83311e70, 0x834c4c58). dump saved in: c:\windows\minidump\mini090106-02.dmp. for more information, see , support center @ http://go.microsoft.com/fwlink/events.asp .   detailed log shows:   event type: error event source: system error event category: (102) event id: 1003 date: 9/1/2006 time: 12:10:13 am user: n/a computer: udayan description: error code 000000fe, parameter1 00000002, parameter2 83aa4718, parameter3 83311e70, parameter4 834c4c58. for...

we choose buy ebs 2008 st. can use secondary dc if server not included in ebs 2008 licensing (we'll buy separately)? hi,   thanks post.   for licensing issue, please call 1-800-426-9400 (select option 4), monday through friday, 6:00 a.m. 5:30 p.m. (pst) speak directly microsoft licensing specialist. believe best resource , address concern on this licensing issue.   for common ebs 2008 licensing issues , may check following faq list   http://www.microsoft.com/ebs/en/us/faq.aspx#lic   hope helps. Windows Server  >  Windows Server General Forum

hi, i can't head around problem. think i'm still thinking sql devlopper. here problem. i have connection fact table contains attribute member id , date attribute. need know how many user have lost on period of time (churn rate). rate should between first 30 day period (p1) , next 30 days until (p2). theoretically : ((count distinct member in p1 - count distinct member both in p1 , p2) * 100) / (count distinct member in p1) but can't find measures and/or calculated members job. part can compute (count distinct member in p2), <hich monthly active use member, using aggregate lastperiods aggregate (lastperiods(30,[calendar].[pk date].currentmember), [measures].[daily active user]) [measures].[daily active user] count distinct on member id. not me @ all. tried find way (count distinct member in p1) part, ssas doesn't seem accept lastperiods parallelperiod second argument. as might see i'm lost. i'm learning alone. i'll buy book tomorr...

hi, all i installing powerpivot sharepoint 2010. farm has 2 server, 1 sharepoint , other a database server sql server 2008 r2. tried to add powerpivot on database server, cannot done. @ end of installation, always showed analysis service sharepoint integrated feature failed and powerpivot engine service instance not found on local machine. on sharepoint central admin, sql analysis service showed "error starting". i follow guide on msdn website. there missed. can me? thank you!  hi wendy, this same error message, please refer thread http://social.msdn.microsoft.com/forums/en-hk/sqlkjpowerpointforsharepoint/thread/cd2ab662-b592-4d3d-8dc8-20998d55e31e   you can refer to the same issue @ connect site http://connect.microsoft.com/sqlserver/feedback/details/511074/error-could-not-load-file-or-assembly-microsoft-analysisservices-sharepoint-integration hope you. thanks, challen fu please remember mark replies answers if , unmark...

hi! i need replace null values in 2 columns. in first colum (level1) replace null previous non null value looks table 2 in example below. i,ve tried code on example it,s not working. use 1 variable , loop function on column sql updates variable if theres name not equal null , takes value in variable ant put in te row if row value null. column 2 more tricky. here use same metod column 1 column 2 should updated previous value column if variable column 1 equal row in column 1. column 2 should in example below. managed in access before i,m trying use sql more need function in sql. sent code access think clarifies better words. br structure of file have convert row level1 level2 1 test1 2 testing1 3 4 5 6 7 test2 testing2 8 9 10 test3 11 12 13 14 test4 testing3 15 16 how file should row level1 level2 1 test1 2 test1 testing1 3 test1 testing1 4 test1 testing1 5 test1 testing1 6 test1 testing1 7 test2 testing2 8 test2 testing2...

in sequence container, have populate county2 dataflow task, and a delete staging execute sql task. in dataflow task, single table called 'county2' populated 'county2_staging'. these tables in sql server 2005 database runs on 64 bit edition.   after populate county2 dataflow task completes successfully, records in staging table deleted county2_staging in delete staging sql task.   before populate county2 dataflow task, have execute sql task starts transaction: begin transaction   after populate county2 dataflow task , delete staging execute sql task, have execute sql task commits transaction:   commit transaction   if error occurs within sequence container, sequence container failed. have execute sql task in ontaskfailed event of sequence container.   the problem having when sequence container fails, delete staging execute sql task rolled back, insert occurs between county2_staging , county2 in populate county2 dataflow task not.   why won...

small basic needs new file object. not replacement. file great job with… well… files. no, small basic needs special purpose file object. won't commented out of operation "publish" process. file object lets save , load files user of newly imported program, on computer, without security fears. small basic needs sandbox. jibba jabba commented on topic of "seamless sharing" in recent blog post: turtle-maze versus hangman - case seamless sharing he outlines process small basic comments out "file" operations in published code, , gives examples of issues causes. basic logic sound. if remove possibility of reading , writing files on computer, eliminate mischief programs can cause. issue kind of brute force modification code render programs unusable, or cause bugs , compile errors. i encountered last issue myself game wrote: meteor shower (import code: rjp883-15 ).   after first published code, realized silly amount of code being commented out...

hello asim, how i convert  pk_date date different format.  example: pk_date = 2011-12-23 new date = 23/12/2011 i appreciate help. jigsy50 brian roberts hi brian, try with =format( cdate (fields!pk_date.value), "dd/mm/yyyy" ) regards, asim bagwan kindly mark replies answers if help! SQL Server  >  SQL Server Reporting Services, Power View

i using following mdx query build dynamic performancepoint dashboard filter. each user(identified ntid) assigned view type.  a view type of 1 sees leave view type of 2 sees first sibling view type of 3 has no restriction , see dependants my questions how filter following mdx filter? [ccr security].[home cc].currentmember.properties( "login" )="xxxx\t827638" with  member [measures].[ccr amt] [measures].[cca amt] member [measures].[login]   [ccr security].[home cc].currentmember.properties( "login" ) member [measures].[view type] ([ccr security].[home cc].currentmember.properties( "view type" )) select {[measures].[ccr amt], [measures].[login], [measures].[view type]} on columns, {case when [measures].[view type]=1 descendants([cca hierarchy].[cca parent node key].&[171779],,leaves) when [measures].[view type]=2 descendants([cca hierarchy].[cca parent node key].&[171779].firstsibling) el...

 hi, i added service reference to  https://database.windows.net/soap/v1/ . have ensured username , password correct. authority id unique extension of username. i an endpointnotfoundexception when try create authority. full error message - "could not connect https://data.database.windows.net/soap/v1 . tcp error code 10061: no connection made because target machine actively refused 65.55.23.119:443. " here's code using: var client = new sitkasoapserviceclient ( "basicauthendpoint" ); string errmessage = null try {     client.clientcredentials.username.username = "myusername" ;     client.clientcredentials.username.password = "mypassword" ;      scope scope = new scope ();     authority authority = new authority ();     authority.id = "uniqueauthid" ;     client.create(scope, authority); } catch ( faultexception < error > ex) {     errmessage = ex.detail.message; } finally {     client.abort(); } please help. than...

hi, i have 2 data sources 2 different servers.. using have created 2 cubes namely hostcube , applications cube..now need link 2 cubes based on host name.. host name present in host cube , site name present in application cube.. need link these both , keywords, referal page, number of applications running , number of visits. am not able link 2 cubes , result.. tried using virtual cubes, takes dimensions both cubes , gives result.. can me out in please. thanks in advance.. i guess trying use 2000 solve problem. you should way better off using 2005 allows use data 2 different datasources in single cube. edward. -- this posting provided "as is" no warranties, , confers no rights. SQL Server  >  SQL Server Analysis Services ...

i want remove following charaters of cells in column "a": - "*" - "@" - "#" after removed, want trim of cells in column "a". thank you. i found following works: dim cel range     application.screenupdating = false     range("a:a")         .replace what:="~*", replacement:="", lookat:=xlpart         .replace what:="@", replacement:="", lookat:=xlpart         .replace what:="#", replacement:="", lookat:=xlpart         each cel in .specialcells(xlcelltypeconstants)             cel.value = trim(cel.value)         next cel     end with     application.screenupdating = true thank time. Learning ...

hi, can tell me how register dependency property of type enum? property accessable in xaml, not how expect enum (drop down, etc). , runtime throws weird exception doesn't make sense... thanks in advance... below generic enumtypeconverter class wrote.  here's property using it:     <typeconverter( gettype (enumtypeconverter(of vehicle.vehicletype)))> _     public property type() as vehicletype         get             return directcast (getvalue(vehicle.typeproperty), vehicletype)         end get         set ( byval value as vehicletype)             setvalue(vehicle.typeproperty, value)         end set     end property here generic enumtypeconve...

 i have set dfs servers. how backup dfs data. hi, you mean want backup dfs namespace , relate dfs configuration? if so, may follow blog below. https://blogs.technet.microsoft.com/craigf/2010/09/20/backing-up-and-restoring-domain-based-dfs-namespaces/ best regards, mary please remember mark replies answers if help. if have feedback technet subscriber support, contact tnmff@microsoft.com . Windows Server  >  File Services and Storage

i've seen conflicting forum answers , in offical docs. does know is the default setting windows 2008 server regarding, "maximize data throughput network applications"? thanks, dc thanks you both, yagmoth555 , santosh, repling.  link below santosh provided, http://technet.microsoft.com/en-us/library/cc784562.aspx i had come across before, deals 2003 servers' setting - need exact info 2008 server ms has changed defaults in 2008 server.  why doesn't ms have 2008 documentation the 2003 link above?, odd.... i've looked , looked...  i see if can network admin in registry see setting for: hklm\system\currentcontrolset\control\session manager\memory management hoping query remote command line shell or ms documentation setting 2008, no love ms.  reference anynone reading this, when windows os set ,"maximize data throughput file sharing", horrible databases running on windows os - want set to, "maximize data...

hello, i new hyper-v replica , have few questions listed below: 1. there 3 volumes created on hyper-v primary server c:\, d:\, , e:\. have configured vm , configured 3 hard disks below: -vhdx1 attached scsi controller 0 , kept in c:\ drive -vhdx2 attached scsi controller 1 , kept in d:\ drive -vhdx3 attached scsi controller 2 , kept in e:\ drive on replica server, have c:\ drive created hold data c:\, d:\ , e:\ drive.  question: do need configure d:\ , e:\ drive on replica server also?  2. in case of failover replica server, how vm going retain same ip address configured on primary vm? thank in advance. nratawa when configure replica specify files stored not need have the same drive mapping. default replica vm holds same ip addressing. Windows Server  >  ...

hello, first of all, sorry mistakes write, spanish. i know if there anyway know relationship between virtual cpu of each vm , real cpu in host machine. mean, when vm working, if has 1 virtual cpu attached, mean has 1 physical cpu or vm takes piece of each physical cpu? there tool watch these relations between physical ressources , ressources used vms? i quite new in world of virtualization , need know how hyper-v works. need job. thank , hope have understood me... teresa you said:  "but there not way know physical cpu using vm, isn't it?" correct.  there no cpu affinity (not necessary anyway)   in regards tutorials...there aren't ones.  of products in class of virtualization work in similar ways similar limitations.  (hyper-v, xenserver, xen, esx, etc.) many of have past experience other products (vmware, xen, virtualiron, etc.) , implementing products.  in virtual environments today there tasks documented , understood, there tuning , manipulation of environ...

hi - general, feedback on scenario: server 1 - w2003 r2 standard x64 edition service pack 2 server 1 - configured application (web front-end) server sharepoint server 2007 (iis, asp.net 2.0, .net framework 3.5, smtp) server 2 - w2003 r2 standard x64 edition service pack 2 server 2 - configured database server sharepoint server 2007 (sql2008 standard edition 10.0.1600.22) scenario: want upgrade server 2 w2008 r2 in preparation upgrade of sharepoint 2010. @ same time create couple of low workload virtual machines on server 2. question: scenario ok inplace upgrade of server 2? question: there defined problems running sql on host os of w2008 server running couple of virtual machines... or there guidelines virtual configuration. hello, start " plan , prepare " , " perform in-place upgrade " in: http://technet.microsoft.com/en-us/sharepoint/ee517214.aspx additional suggest use sharepoint forum upgrades: http://social.technet.microsoft.com/...

hi we getting bellow error the dns name unavailable , cannot added subject alternate name. 0x8009480f (-2146875377 certsrv_e_subject_dns_required). regards jaspreet singh jhans this typically happens when duplicate user-based certificate , enable dns name check box in subject alternative name section of certificate template configuration dialog box. for example, duplicating "user" certificate template, , enabling dns name check box, result in error. certificate being enrolled using credentials of user's account, not have dns name attached object. brian Windows Server  >  Security

my question simple. powershell direct? differences between "the old powershell" , direct version? it suitable pssessions? thx read this https://blogs.technet.microsoft.com/virtualization/2015/05/14/powershell-direct-running-powershell-inside-a-virtual-machine-from-the-hyper-v-host/ Windows Server  >  Windows PowerShell