Posts

CountRows in a table

dear all,  i newbie on power bi , facing trivial problem. have created following table enlisted type of fault , related number of calls. insert in table simple incremental index instance first row 1 second 2 , on (look snap data model , table). incremental index can allow me filter top 5 values in table. used rankx problem same value give me tie same number. i.e 2nd , 3rd rows have both rank 2.  i have 2 tables  query1 fields: callref, calltype, cause1, completiondate measures: faultcount , ranx1 lu_cause_code_description fields: cause_code (key), description relationship lu_cause_code->query1 1ton cross filter direction: "both" table:  description|faultcount|rankx rail 8 1 assy 1 2 other 1 2 it seems easy issue reasons not it.  the formula used : faultcount = countrows( distinct(query1[call_ref] ) ) ranx1 = rankx(filter(all(lu_cause_codes[description]),[faultcount]),[faultcount],,desc,dense) please ...

Migrating DTS 2000 to SSIS ; modifying OLE DB connection properties

hi - im migrating packages in dts 2000 ssis 2005 using package migrator wizard. loads csv table in db. need change server , file location paths after migration. while changing this, im encountering error - "the acquireconnection method call connectionmanager failed hi, do use dts designer? http://download.microsoft.com/download/2/7/c/27c60d49-6dbe-423e-9a9e-1c873f269484/sqlserver2005_dts.msi   anyways, minimum replace dts2000 datapump ssis 2005 dataflow, way use expressions , never again have hard code server , path. you use unc's path, i.e. \\localhost\csv$\importcust.csv this way not care machine name and drive letter. philippe SQL Server  >  SQL Server Integration Services

Trying to access Shared Folder on VM running WIndows Server 2003

i have windows server 2003 virtual environment(vmware) acting file server( or @ least trying be) , trying access shared folder that i created on telling me "the account not authorized log in station?".  have tried countless forums on issue , have ran wall, can please help. thanks hi please write vmware version. try bridge connection in vmware. did have active directory? mohammad javad bagdeli Windows Server  >  Directory Services

Сannot run Windows Server Migration Tools because a required version of .NET Framework is not installed

Image
hi! i'm trying complete migration windows server 2012 r2 windows server 2016. task migrate local groups , users in them (local , domain). there a  guide on technet.microsoft.com . on target server (windows server 2016)  i've created windows server migration tools deployment folder (smigdeploy.exe /package). copied folder source server (windows server 2012 r2) , need to  register windows server migration tools on source computers . that's i've got error: c:\smt_ws12_amd64>.\smigdeploy.exe smigdeploy.exe checking prerequisites. -------------------------------------------------------------------------------- error: cannot run windows server migration tools because required version of .net framework not installed on server. install .net framework 2.0 or newer release of .net framework on migration source server, , install .n et framework 4.0 or newer release of .net framework on windows server 2012 , newer releases of windows server operating system, , run com...

Cannot Get RDP For Administrative Access To Work

we have 2 2012r2 standard servers rdp admin access not work.  other 2012r2 servers work fine.  2 not work both domain controllers.  both vm's, of others.  have verified rdp service running.  verified registry settings, port 3389.  remote access turned on in system settings.  windows firewall turned off, service disabled , not running.  there no anti-virus.  these both new ground domain controllers built separately.  have checked find after reading hours of posts on internet.  have had no luck. the weird thing when doing netstat there nothing listening on port 3389.  service running , there no errors in event logs yet port not open.  have verified settings against servers work , same. can identify missing here?  thanks!!! is network location set public network? Windows Server ...

Windows Explorer Search

i running classroom private network windows server 2008 r2 enterprise server , 35 windows 7 machines.  have setup login policy "student" group limits user accessability making changes computer.  however, haven't been able find way disable or remove search functionality windows explorer.  have disabled ability use start button search through gpo, windows explorer search still functions 100%.  have made not able see harddrives on computers, through search function can search of "*" , shows them of files on harddrive shouldn't see. i know remove search function , solve problem, however, having ability administrators able run things start button search makes things alot easier. any suggestions? i try changing ntfs permissions on c:\ partition on desktops via gp then. http://technet.microsoft.com/en-us/library/cc756952(v=ws.10).aspx http://msdirectoryservices.wordpress.com/2012/01/13/set-ntfs-folder-permissions-using-gpo/ ...

Event 1079 The processing of Group Policy Failed. Windows could not obtain the list of Group Policy Objects... Windows 2008 Member in 2003 Domain

ok have 2 windows 2008 member servers in our 2003 domain. getting error event id's 1079 processing of group policy failed. windows not obtain list of group policy objects applciable computer or user. in group policy operation logs see error event id's 7001, user logon policy processing failed domain\user in 255 seconds. dns appears working fine can resolve computer on domain. any appreciated. mike the gpresult showed computer polices processed fine, user's didn't. , yes 2 of 4 2008 servers show symptom. did comparison , both started same date of 1 june 2009. looked , close day updated servers service pack. there several other updates ready download, last night before went home installed updates. around 8 pm vpn'd in , rebooted both servers, , viola both work now. below updates installed last night. kb961501 kb968537 kb969897 kb969898 kb970238 again on this. mike Windows Server ...