Posts

Featured post

Top N or Bottom N filter based on a parameter

-
i have report parameter selection filtering data, either "highest" or "lowest".  if pick "highest" want top n, if "lowest" want bottom n.  how can set in filter ? j. way there many ways set report accomplish this. e.g asuming "n" fixed, you'll set report parameter has 2 hard-coded values "top" , "bottom" , based on user selects, can write report dataset query if (parameter value = "top") select top n ...... else if (parameter value = "bottom") select top n ......order <ordered column name> desc (again there other ways of doing too) else (whatever business logic needs go here, if @ all) if wanted keep n input parameter well, in addition above top/bottom filter, you'll add input filter (preferably free-text input) accept n , build dynamic sql string concatenating input parameter value in logic above. hope gets on right track. cheers! -muqadder.
Post a Comment
Read more

Powershell Script for checking sql services status and account name

-
$filename='sql-service-info' #$directorytosaveto='d:\powershell\fino_daily_check_list\' $directorytosaveto = 'c:\ps_test\' #split-path -parent $myinvocation.mycommand.path)+'\' $date = get-date -format "dd_mmm_yyy_hh_mm_tt"  $date2 = get-date -format "dd-mmm-yyy  hh:mm tt"  $serverlist = $directorytosaveto+'servers.txt'   $outputfile =  $directorytosaveto+$filename+$date+'.html'    $html = '<style type="text/css"> #header{font-family:"trebuchet ms", arial, helvetica, sans-serif;width:100%;border-collapse:collapse;} #header td, #header th {font-size:14px;border:1px solid #98bf21;padding:3px 7px 2px 7px;} #header th {font-size:14px;text-align:left;padding-padding-bottom:4px;background-color:#a7c942;color:#fff;} #header tr.alt td {color:#000;background-color:#eaf2d3;} </style>' $html += "<html><body> <b> sql services inf
Post a Comment
Read more

Physical disk can't be brought online

-
following steps create , turn on disk resource: 1). c:\>cluster res diske /create /group:"available storage" /type:"physical disk" 2). c:\>cluster res diske /priv disksignature=0xa79db16a    (note: a79db16a disk signature of local physical disk e:\) 3). c:\>cluster res diske /on however, step 3 failed following errors: bringing resource 'diske' online... system error 5018 has occurred (0x0000139a). the cluster resource not brought online resource monitor. and cluster logs following: 000007e0.00000804::2010/02/03-13:19:39.839 info  [rcm] rcm::rcmapi::onlineresource: (diske) 000007e0.00000804::2010/02/03-13:19:39.839 info  [rcm] transitiontostate(diske) failed-->onlinecallissued. 000007e0.00000804::2010/02/03-13:19:39.839 info  [rcm] rcm::rcmgroup::processstatechange: (available storage, failed --> pending) 00000844.00000934::2010/02/03-13:19:39.839 info  [res] physical disk <diske>: online request. 000007e0.000001e4::2010/02/03-13:19:39.8
Post a Comment
Read more

VPN Port Forwarding

-
i set vpn on dad's company's windows small business server 2003 , can access when connected network, when on network no response vpn server.  therefore, guessing need foward ports on router in order allow access outside. can tell me ports forward? tried portfoward.com or w/e website , couldn't find specific vpn windows sbs 2003.  thanks depends point point tunneling protocol or pptp on 1723 tcp hope helps jason Windows Server  >  Windows Server General Forum
Post a Comment
Read more

Windows Server 2008 RRAS - Server connects to Internet and disconnected after 2~3 minutes.

-
i installed rras in windows server 2008 standard (2nics) without installing ad dc, dns , dhcp. computer name called marvel. after installation of rras, connect 1 (wan) of nics isp modem , 1 (lan) switch connect local machine. marvel have internet connection few minutes after system boot , disconnected again soon. for example, restarted marvel because doesn't have internet connection. after restart, internet access , drop again soon. keep on repeating same steps , same thing happened. is there wrong configuration ? link below video tutorial followed install rras : http://www.youtube.com/watch?v=2ayqndvvoyk ip configuration: wan : ip address : 66.167.xxx.xxx subnet mask :  255.255.255.224 default gateway : 66.167.xxx.xxx preferred dns server : 64.105.xxx.xxx alternate dns server : 64.105.xxx.xxx lan : ip address : 192.168.1.1 subnet mask :  255.255.255.0 default gateway : leave blank or 0.0.0.0 preferred dns server : 192.168.1.2 alternate dns server
Post a Comment
Read more

Can't Reconnect to Server After Windows 7 Reinstall

-
hi, i reinstalled windows 7 on 1 of our computers , named same before, doesn't want rejoin domain through essentials connector because of that. reason keeping pc name same continuity , can use backups had if necessary. - scott from essentials server, go active directory users , computers right click computer object see there (this should old computer, same name) , choose 'reset account' now, try again connect computer. should work.  Windows Server  >  Windows Server 2012 Essentials
Post a Comment
Read more

Windows 2012 PKI Issuing Subordinate CA question

-
hello all, i have question implementing 802.11x wireless authentication using client computer certificates in 2 tier pki environment. have 1 root offline ca ,  multiple issuing subordinate ca's @ each site location.  is there way publish/deploy site specific computer templates ?  the way see now,  is if issuing ca's publish version of computer templates , each client computer in our domain end getting multiple computer certs issued each ca in personal certificates store.  how can have issuing ca of site issue certs computers physically located in site a.  auto-enroll publish computers domain wide.  is manual enroll way out ?  i don't see gpo setting can leverage deploy personal client computer certificates , bind specific ou. thanks neeraj   > way see now,  is if issuing ca's publish version of computer templates , each client computer in our domain end getting multiple computer certs issued each ca in personal certificates store. yep. , can&#
Post a Comment
Read more