Posts

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 i...
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::...
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 altern...
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 c...
Post a Comment
Read more

Autostartup when start server 2012 under specified user(admin).

-
Image
hi want autorun 2 programs under specified user(admin) in server 2012 r2. don't want logon user want program run under user when server start up. there how now's how this? tray fix in task scheduler , says running program not want start. have rights admin not help. grateful help? hello, with sc.exe create service using specific service account. https://technet.microsoft.com/en-us/library/cc754599.aspx check gpo settings account set "logon service" permission https://technet.microsoft.com/en-us/library/cc794944(v=ws.10).aspx best regards meinolf weber mvp, mcp, mcts microsoft mvp - directory services my blog: http://blogs.msmvps.com/mweber disclaimer: posting provided no warranties or guarantees , confers no rights. twitter:   Windows Server  >  ...
Post a Comment
Read more

autologon on unattended answer file

-
hello, i in progress of making unattended answer file let imaged server log on administrator account automatically once after syspreping process completed. however, it keeps failing to log on automatically error on screen "the user name or password incorrect". have tried add autologon account audit systems, specialized system, still has same error. please me have resolve issue? here answer file have. added both administrator account , autologon account in oobe system.     <settings pass="oobesystem">         <component name="microsoft-windows-shell-setup" processorarchitecture="amd64" publickeytoken="31bf3856ad364e35" language="neutral" versionscope="nonsxs" xmlns:wcm=" http://schemas.microsoft.com/wmiconfig/2002/state " xmlns:xsi=" http://www.w3.org/2001/xmlschema-instance ">      ...
Post a Comment
Read more

GPP Drive Mappings time out settings at logon

-
Image
hi all, we have odd issue our temrinal servers and  gpp drive mappings. have old windows server sometimnes falls over. hangs ina way can still ping device can not connect device.  we have shared drive on machine mapped number of users via gpp. issue when server hangs users can not start new terminal server session login process stalls when trying map drive.  users on thick client able log in process seems time out, isn't case on the terminal servers. there group policy setting need adjust make sure policy drive mapping process timesout if can not map aa drive after a minute or so? thanks dej  hi,   according search, timeout value controlled keepconn value of registry key, hkey_local_machine\system\currentcontrolset\service\lanmanworkstation\parameters.   the client-side session automatically disconnected when idling time lasts more duration set in keepconn. therefore, session disconnected according shorter set...
Post a Comment
Read more

Server 2008 R2 disables Shadow copy on volume C upon reboot

-
i can enable shadow copy feature on drive c , take snapshot when reboot has reset disabled.  data drive d stays enabled.  cause this?  it's causing symantec backups fail because not stay active. btw has 2.8gb of available free space on drive , retention set 1gb. hi, this should not default behaviour. you test set shadow copy storage volume test. here article provided common solution such kind of issue. please have try: restore points lost after system rebooting http://blogs.technet.com/b/win7/archive/2011/02/16/restore-points-lost-after-system-rebooting.aspx technet subscriber support in forum |if have feedback on our support, please contact tnmff@microsoft.com. Windows Server  >  Windows Server General Forum ...
Post a Comment
Read more

Filter Distribution Group based on Names - Exchange

-
hello, we have around 1.5lakhs distribution lists in our organization. i need extract list of dls filtering out has "-restrict", "-delegate", "-access" @ end (for alias). want dls without these words. tried command still extracting whole list without filtering requirement. please help? my command: [ps] c:\>get-distributiongroup -resultsize unlimited | {($_.alias -ne "*-delegate") -and ($_.alias -ne "*-restrict")} |select distinguishedname |export-csv d:\dlinfo.csv please help never giveup till want. use -notlike instead 0f -ne ex get-adgroup -filter *| {($_.name -notlike "*users") -and ($_.name -notlike "*admins")} Windows Server  >  Windows PowerShell ...
Post a Comment
Read more

IPSec Implementation

-
i have scanario want pose make sure i'm on right track far ipsec , protecting data. let's want implement wireless network business.  ideally, wireless network should on seperate network , have sort of wireless encryption.  in addition, since know sniffers can crack wireless encryption, computers on wireless network should implement ipsec further protect data.  does seem solid approach? hi,   thanks posting here.   it’s depend on security standard going deploy in scenario. far have encryption methods   encrypt traffic when wirelessly transfer it. introductions , comparison acquired form link below:   http://technet.microsoft.com/en-us/library/dd348514(ws.10).aspx   for more information please refer articles in link below:   http://technet.microsoft.com/en-us/network/bb530679   thanks.   tiger li please remember click “mark answer” on post helps you, , click “u...
Post a Comment
Read more

Event ID 41 Kernel Power

-
have having issues sbs 2011 server. keep on getting below error. there no errors before , error after stating restart not planned. thing new in machine 4 more gb of memory. causing issue? log name:      system source:        microsoft-windows-kernel-power date:          4/3/2013 12:50:39 pm event id:      41 task category: (63) level:         critical keywords:      (2) user:          system computer:      ambsbs.ambientenv.local description: the system has rebooted without cleanly shutting down first. error caused if system stopped responding, crashed, or lost power unexpectedly. event xml: <event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">   <system>     <provider name="microsoft-windows-kernel-power" guid="{331c3b3a-2005-44c...
Post a Comment
Read more

The task "View the account properties" did not complete successfully on Essentials Dashboard User Accounts

-
when trying view account properties standard users error saying "the task 'view account properties" did not complete successfully". @ time service "windows server remote web access administration provider" crashes , must restarted manually. there 2 errors occur in event logs list below. lastly, there no traces of error before morning , made no significant changes system. i'm little stumped , appreciate community's help. if need more info please let me know. event 1025, .net runtime application: sharedservicehost.exe framework version: v4.0.30319 description: application requested process termination through system.environment.failfast(string message). message: unhandled exception operation: service type: microsoft.windowsserversolutions.remotedesktop.rdaccessmanagerprovider operation: [http://tempuri.org/] irdaccessmanager.getcomputersforuser async: false parameters:     string username system.runtime.interopservi...
Post a Comment
Read more

login password

-
i restored windows 8 previous restore point, , maybe settings well, set new local account , set new password put old password.  have changed password many times have no idea.  login account on computer , cant safemode f8 more.  need files , stuff on there work urgently.  please asap. hi, generally can logon default administrator account reset password if disabled or password set, not able logon. in current situation standard solution reinstall system new account created in new system. not clean install, data still there , can remove old windows later. also can connect disk computer bruno mentioned. if in domain can use group policy enable , set password build-in administrator account logon it. meanwhile windows 8 related question should post forum instead: http://social.technet.microsoft.com/forums/windows/en-us/home?category=w8itpro if have feedback on our support, please send tnfsl@microsoft.com. ...
Post a Comment
Read more

Shadow Copy

-
i have server has been locked down, normal system admin staff, contains highly sensitive data.  1 of admins not have direct access server audits, , such need have him security log suspic activity. what looking @ copying log file out area has access to, file in use, , thinking of using shadow copy serivice.  there way script this?     derek look @ http://www.microsoft.com/technet/scriptcenter/scripts/default.mspx?mfr=true  where you'll find codesnippets managing logs scripts. in case example copy log database , such operations. Windows Server  >  Management
Post a Comment
Read more

Windows 10 TP build 10041 seen as Windows 8.1 OS when imported to a Deployment Share

-
hi all, i tried import windows 10 tp build 10041 operating system new deployment share created mdt 2013 u1. i referenced dvd iso image of windows 10 technical preview 10041 , os type recognized windows 8.1. there plan fix issue? thanks hi michele.t, apologize long delay. regarding windows 10 build 10041 deploy, have forum faq, please check there , see if content help: [forum faq] using mdt2013update1 deploy windows 10 technical preview (build 10041 as content told, windows 10 still under building, please d on’t mind windows 8.1 mistake, build number shows windows 10 technical preview 10041 build. regards please remember mark replies answers if help, , unmark answers if provide no help. if have feedback technet support, contact tnmff@microsoft.com . Windows 10 Insider Preview  >  ...
Post a Comment
Read more

EXEC sp_configure 'optimize for ad hoc workloads', 1 is hanged

-
  sp_configure 'optimize ad hoc workloads' , 1 .........  taking hours complete   (spid 64)  cmd in sysprocesses raiseerror , , once spid 64 killed spid 85 , spid 85 having wait type preemptive_os_reportevent. (not info available os waits ..) 1>how can check os level .. whether both doing .. 2> how rid of both spid in scenario .. spid program_name cmd status waittype lastwaittype cpu 64 microsoft sql server management studio - query killed/rollback runnable 0x01ee preemptive_os_reportevent 16 85 microsoft sql server management studio - query kill process runnable 0x01ee preemptive_os_reportevent 47 both spid having status runnable .. cancel request not take effect ... i need close\clear both spid's without sql restart ... related preemptive_os_reportevent waits great .. ...
Post a Comment
Read more

Database mirroring question

-
hi, use database mirroring in sql server 2008 r2. have 1 primary server , 1 mirror server. our application connect primary instance ip address. if our primary server down , failover mirror server, our application not able connect. our plan put ip address of old primary server mirror (new primary). but, changing ip address confuse database mirroring setting ? can if think endpoint config ? regards, you need use failover partner=partnerservername parameter in connection string. http://msdn.microsoft.com/en-us/library/5h52hef8(v=vs.80).aspx the client application connects principal database, , server sends name of partner server, cached on client. if server containing principal database fails or connectivity interrupted, connection , transaction state lost. client application attempts re-establish connection principal database , fails. the client application transparently attempts establish connection mirror database on partner server. if succeeds, ...
Post a Comment
Read more