Posts

Showing posts from July, 2014

SQL 2005 and LDF files. Are the following command acceptable and sufficient?

i inherited sql 2005 server has database sbo-common in full recovery model. sbo-common, d:\sql data\sbo-common.mdf, initial size 596 mb sbo-common_log, d:\sql data\sbo-common_log.ldf, initial size 30000 mb as of now, sbo-common.mdf 609kb sbo-common_log.ldf 29322533kb if schedule following commands every night before tape backup runs: --------------------------------------------------- use [sbo-common] go backup database [sbo-common] disk = 'f:\sql backup\sbo-common.bak' go backup log [sbo-common] disk = 'f:\sql backup\sbo-common_log.bak' go dbcc shrinkfile ('sbo-common_log',emptyfile) go ------------------------------------------------------------------------ would above acceptable , sufficient?  want sbo-common_log.bak file shrink. what if did following? ---------------------------------------------------- use [sbo-common] go dbcc shrinkfile ('sbo-common_log',emptyfile) go backup database [sbo-common] disk = 'f:\sql backup\sbo-common.bak' go bac

Need Help!!! SSAS Cube Structure

i designing cube , came across few challenges, can help? challenge # 1: under cube structure windows have sort measure items way when process cube , browse in browsers folders , measure items under folders sorted alphabatically. need them show have sorted them under cube structure tab. how can that? challenge # 2: have created time calculations ytd, mtd, qtd... etc. when try browse them in browser, works fine when try import data in power pivot takes extremely long time. challenge # 3: initializing time calculation members null when browse them empty not appear. works when put time calculation member on row when try put on column, throws error until enable empty rows. challenge # 4: have description field in fact table, creating dimension fact table , using description in dimension, when process cube, complains found duplicate attribute , doesn't work until change key want group data on description , not on key. how fix that? thank you   aneel ismaily challenge

Handle Violation of Primary Key Constraint in SSIS

     i getting following error when running integration services project to insert , update data 1 sql server database sql server database: "violation of primary key constraint". cannot insert duplicate key in object.      there way check if key unique prior trying to transfer data? once 1 error stops , none of data transfered. project designed ran every few weeks to update destination data match source reporting purposes. appreciated. thanks... hi bhushan juare, besides others professional suggestion, please refer thef following links: http://social.msdn.microsoft.com/forums/en/sqlintegrationservices/thread/5c70c5d5-b914-4052-a9a2-009d9d460a27 http://support.microsoft.com/kb/972498 thanks, eileen SQL Server  >  SQL Server Integration Services

<class> does not contain a definition for <property>

hi, i tried question earlier , did not response, trying again still stuck! i have collection of string values binding textblocks in silverlight project.  string values showing fine when run project.  however, added string:  link ="some more stuff"  and blend 3 throws error, says: 'olympicmediacomponentone.storyinfo' not contain definition 'link' here code snippet: in mainpage.xaml.cs: namespace olympicmediacomponentone { public partial class mainpage : usercontrol { private list<storyinfo> stories; private storyinfo selectedstory;   public mainpage() { // required initialize variables initializecomponent(); stories = new list<storyinfo>(); stories.add( new storyinfo() { headline = "us gold haul" , body = "speed skating becomes sensation @ winter olympics pick 7 gold medals in 4 days." , link = "play video" , image = new bitmapimage( new uri( "im

Office 2013 Trusted Locations increase

Image
hi, creating office 2013 policy , 1 of requirements use trusted locations require more 20 available in template.  can advise how address this?  requirement have 40 (ish) trusted locations. thanks time hi, thanks posting in forum. regarding request, maybe try refer following similar thread details. others mentioned, modify office administrative template files achieve target maybe limitation 35 trusted locations. regarding how modify admx file, please first navigate following location on dc %systemroot% \sysvol\domain\policies\policydefinitions then open admx file notepad , add following content in turn. <policy name="l_trustedloc20" displayname="$(string.l_trustedloc20)" explaintext="$(string.l_trustedlocationsexplain)" presentation="$(presentation.l_trustedloc20)" key="software\policies\microsoft\office\15.0\excel\security\trusted locations\location20">       <parentcategory ref="l_trustedlocatio

How to get custom Attributes to show up in Users&Computers Attribute Editor

we running active directory on server 2008r2 forest function level server 2008r2. some time ago, prior administrator added custom class , custom attributes custom class.  we edit these attributes using aduc's attribute editor tab. now have add custom attribute existing custom class.  is easy going mmc (with schema mgmt loaded) , creating custom attribute, associating custom class?  is need new custom attribute shows under "attribute editor" in aduc each user?  (we have our own oid tree well) in order find out myself , before breaking in production, created test environment and attempted add new class , new attributes new class.  i used following threads this: http://technet.microsoft.com/en-us/library/bb727064.aspx http://blogs.technet.com/b/isingh/archive/2007/02/18/adding-custom-attributes-in-active-directory.aspx i able create custom auxiliary class , 1 custom attribute class.  the custom attribute associated new class , new class auxiliary class of "

Monitoring vm bandwidth

i want monitor bandwidth vm.  i've tried using performance counters under "hyper-v virtual network adapter" suggested http://blogs.msdn.com/tvoellm/archive/2009/04/23/monitoring-hyper-v-performance.aspx instances available don't have vm instance ids. suggested using switch port instead have no idea on how map them vm. http://social.technet.microsoft.com/forums/en-us/winserverhyperv/thread/4d307dfc-aed9-4fd0-8aff-8cfcf0b29839 Windows Server  >  Hyper-V

NO Activation Processed On New KMS Server

hello, i installed volume activation role on dc in windows environment yesterday. registered in dns , installed windows server 2012 r2 kms key microsoft volume licensing site. left old kms server , registered in dns. checked morning , there no clients checking in on new kms server still checking in on old kms server. how force them start checking in on new kms server need shut down old kms server , delete out of dns? can delete out of dns , forced go new kms server? cshsysadmin you need ensure new kms server has srv record in active directory. how clients find it.  https://technet.microsoft.com/en-us/library/ff793405.aspx gerry hampson | blog: www.gerryhampsoncm.blogspot.ie | linkedin: gerry hampson | twitter: @gerryhampson Windows Server  >  Windows Server 2012

Securing Domain Controllers

i'd give give particular ad security group rights on ad domain controllers. i not want use domain admins this. i notice there doesn't appear way of adding groups local administrator groups on dc's. is there way give ad security group rights administer dc without using domain admins? pajoryan123 hi there, unfortunately there isn't. ofcourse can delegate management tasks, "full" server management on dc requires domain admins. regards, stefan hazenbroek Windows Server  >  Security

Forest Domain

hello guys! hope u can this? im starting know adds (ws 2008r2). build forest ad lab consist of ff: root: fqdn:sage.com 1 dc (root) child1:  fqdn:kabuto.sage.com 1dc (child1)  1user (usera) 1member comp (win7) child2: fqdn: jiraiya.sage.com  1dc (child2)  question: what configuration must allow usera of childa access/log on childb using win7 joined childa?  is possible? please help! as far know, usera need login own domain authenticated. domains within forest will, default, have trusts in place can access resources in other domains. articles below should help: domain trees: http://msdn.microsoft.com/en-us/library/windows/desktop/ms675914(v=vs.85).aspx trust types: http://technet.microsoft.com/en-us/library/cc775736(v=ws.10).aspx accessing resources across domains: http://technet.microsoft.com/en-us/library/cc787646(v=ws.10).aspx what trying achieve , getting trouble? i hope helps, mark

Users outside the domain must delete and re-add printer.

as title states, user outside of domain must re-add shared printer when permissions allow print.  upon reboot, printer appears offline.  shortcuts network resources vanish upon reboot.  has else experienced this?  might have overlooked in permissions? server: 2012r2 client: w7 edit:  accomplished through login script? hi, try to configure everyone permissions apply anonymous users. here path in gpo: computer configuration\windows settings\security settings\local polices\security options find network access: let permissions apply anonymous users , enable it. update policy on server , relogin take effect. >> could accomplished through login script? as far know, run powershell commands add printers. you post in powershell forum detailed information: https://social.technet.microsoft.com/forums/windowsserver/en-us/home?forum=winserverpowershell&filter=alltypes&sort=lastpostdesc best regards, leo please remember mark replies answers if , unmark t

How to connect to servers on domain and run batch file

hi, totally new here , new vb, hope i'm in right place ask help. i'm working on little script automate tasks across 12 servers, on same domain , have similar setup. tasks create new folder, copy contents off network it, , create virtual directory in iis 6 pointing it. ideally i'd log errors that's later concern. approach write vb script connect wmi on each server in array, use run off batch file. while vbs works if tell create folder directly, not run (any part of) batch file, nor give me errors. doing wrong? the script: on error resume next 'define servers connect to arrcomputers = array("svrname1","svrname2","svrname3") 'call wmi on each server & use cmd make directory for each strcomputer in arrcomputers     set objwmiservice = getobject _     ("winmgmts:\\" & strcomputer & "\root\cimv2:win32_process")     errreturn = objwmiservice.create _         ("cmd.exe /c j:\te

One box Hyper-V server for training - Comms question

hi, i have powerful hp ml350 server i'm setting 1 box training solution. host os on physical box 2008r2 hyper-v (workgroup, not domain). else on vm's (and on domain). i have question networking i'm not clued on networking unfortunately. because hp server moved customer sites training, i'm unsure how configure solution vm's have internet connectivity, wherever server travels, without major reconfiguration @ each customer site. i thinking of setting vm's static ip's , using routing services in separate windows vm route traffic through customers network (probably wireless). i'm unsure if work, or how configure it. has done similar i'm trying achieve, or have ideas on best way it? thanks, paul i've tested static route now, using home network. basic ip comms looks work through external network. the next problem configuring internet settings in vm's use customers proxy. guess should simple using group policy. paul

windows 2012 server automatic counter - didn't restart when updates were applied

i have enabled automatic patching , set following group policies under computer configuration>adm temp>windows comp>windows update> always automatically restart @ scheduled time enabled  configure automatic updates (4 > everyday 03:00)   allow automatic updates immediate installation disabled no auto-restart logged on users scheduled automate updates disabled reschedule automatic updates scheduled installation disabled the problem updates installed @ 3 last night , when logged on server - said - i'll reboot in 15 minutes.  alwaysautorebootatscheduledtime reg key set 1.  how can server boot when has installed updates @ 3 am?? have done wrong here?  ps : net stop "windows update" stopped countdown needed. hi, based on description, it's suggested disable following setting: no auto-restart scheduled automatic update installation options if status of setting is set disabled or not configured , automatic updates notify user comput

RDSH 2012 Farm

after researching bit seems having multiple session hosts considered farm in 2012?  how configure load balancing? the present configuration 1 server doing web access , connection broker, , 2 more session hosts.  each session host running different collection entirely different apps.  the first 1 running ms office , need expand how many clients can connect adding host collection.  i understand how make host , add existing  collection.  however, needs done load balance them?   right deployed in library @ school.  at times 20+ students walk in , login , start running apps once.  this puts quite beating on server initially.  the goal split sudden load between both servers, servicing users better. hi, in basic sense can think of 2012 collection being same thing 2008 r2 farm.  precise logic connection broker uses balance load has not been published, however, in general based on number of sessions, relative weight, and session limit setting. -tp

PowerShell, count messages sent from mailboxes in a distribution group.

Image
hi all, i wondering if me on one. i trying find powershell script count , report either csv or html number of sent emails between period of time each mailbox in specific distribution group. i no powershell user , far have managed - get-messagetrackinglog -server "<hub server>" -resultsize "unlimited" -sender "<email address>" -start "02/01/2012 00:00:00" -end "03/01/2012 00:00:00" | measure-object | convertto-html count, sender | set-content \\server\usermailout.html but reports on single user, need pick mailboxes out of distribution group , report sent count. any advise appreciated. si hi, regarding first error, below links should helpful: exchange management shell error: pipelines cannot executed concurrently http://www.mikepfeiffer.net/2010/02/exchange-management-shell-error-pipelines-cannot-be-executed-concurrently/ exchange 2010 - getting errors trying run scripts http://social.technet.micros

Installation Failed - Previous Version of Windows Restored

Image
i downloaded setup. installed after restarting 2nd time, displayed "restoring previous version of windows. i used doemon extract it.   any help? hi anthar, first, confirm option choose install windows 10, upgrade or clean install. have tried burn image onto dvd or created usb drive install windows 10? let’s remove external devices or hard drives , try install again. once failed install windows, find $windows.~bt under c drive (the system drive), please make sure show hidden file. then, locate $windows.~bt folder , find \sources\panther\setuperr.log , setupact.log, please upload them file sharing service onedrive or "rapidshare" , put link them in reply. kate li technet community support Windows 10 Insider Preview  >  Windows 10 Insider Preview Setup and

How to solve shutdown delay of VM (running Windows Server 2008) with SEPM 12.1

hello, i ask solve "shutdown delay of vm (running windows server 2008) sepm 12.1". weekly, restart antivirus server, windows server 2008 on sepm 12.1 running. while shutting down, took on 1 hour , did force power off since march 2014. but, sometimes, vm shut down normally. how think may cause error? i report surveyed information. 1)    windows' status:     i)     event logs              : no severe error occurred     ii)    cpu                         : below 20%     iii)    physical memory    : below 30%     iv)    network                  : normal 2)    running processes:     i)    highest memory using processes:             dbsrv11.exe    = 554,928 k             semsvc.exe    = 235,132 k             sqlservr.exe    = 224,076 k             (last scanned on 07-aug-2014) 3)    virtual machine's usage status on esx06:         general             guest os             : windows server 2008 (32-bit)             vm version     

Windows Server 2012 System Reserved partition

hello! can tell me based on windows setup chooses hard disk system reserved partition? example: windows setup displays "where install" window in there 2 hard disks: disk0 , disk1. choose disk0 , press enter. the result: disk c ( system partition ) created on disk0, system reserved partition (350mb) crteated on disk1. why system reserved partition has not been created on disk0? is there msdn article regarding question? thank in advance, michael kailashc, thank help! my server not dual-booted, think choosing appropriate hdd in bios enough place system partition on correct hdd. best regards, michael Windows Server  >  Windows Server 2012 General

Policy applied is ghost. Where's it cached?

i know lengthy posts don’t response, because of intense focus required on reader’s part, understand situation presented. i’ll try best to point here. domain names , ip schema not actual ones in use presented here, obvious reasons. lab setup: server 2008r2 domain controller set test.local domain. pdc has wsus installed. workstations not joined test domain, , use wsus.reg file merge in workstation registry point @ test.com wsus. when setting new workstations, saves ton of time getting them date before deploying them production domain. production setup: server 2012r2 standard pdc.   this server has ad, dns, dhcp , group policy management roles. domain has mix of win 7 pro , win 8.1 pro. also have server 2008r2 standard member server joined domain. 2008r2 server not have ad installed. it’s joined domain no differently workstations are. 2008r2 server has wsus installed, along rd gateway configured certificate remote access, , last computer joined domain. problem: hav

WS2K8R2 Dropped in My Lap - Not A lot of Help

hi everyone! i acquired administration duties of ws2k8r2 server , i'm not sure begin because partially configured when fell lap. after doing poking around, found "best practices analysis" scanner , scanned adds, dhcp server, , dns server. of course came recommendations, begin? (ad ds, dhcp, or dns) should begin changing first?? order matter? i've put spreadsheet of these recommendations , have researched site solutions....awesome site way, don't know i'm supposed begin. it's small network maybe 25 users, 1 doman, , handful of users have admin privileges. appears easy enough however, dhcp isn't config'd, nor dns work properly....just not sure dependencies.  guess i'm looking sort of checklist, "do before that". i have (edited) excel spreadsheet if needs @ it. didn't want post unnecessarily. thanks in advance! i straighten out dns first (all else depends on it), dhcp, ad ds. if have 1 dc, things simple have no redund

Total AD Concurrent Logins

hi.  our administration asking total number of concurrent users logged ad @ peak time.  know if possible?  possible sccm or scom? thanks. don't think ad tracks @ all. you'd have find way count current logon/logoff session. could, example, create 2 scripts - logon , logoff , let users text file on share , on logoff, delete text file. go monitor text file number in share. 1 method.. you'll surely find others - doubt there's built-in functionality .. sccm or scom. why want number? cheers, florian microsoft mvp - group policy -- blog: http://www.frickelsoft.net/blog Windows Server  >  Directory Services

This computer can't connect to the remote computer

hi all, i have probelm  "this computer can't connect remote computer.try connecting again.  if problem continues, contact owner of remote computer or network administrator."   [img]http://up.khellan.com/file/uploads/aef90edc6a.jpg[/img] i connecting vpn remotely i have 2 laptop , have probelm in 1 laptop only, other laptop working without problem vpn connected cant connect server , got msg hi, it strange works 1 laptop not other. what differences between laptops? to kind of server connect? (terminal server, isa, desktop/laptop, ..) are sure vpn setup correctly? can ping server on it's ip address? can connect server it's ip address? let me know , try respond soon. cheers, yuri Windows Server  >  Remote Desktop Services (Terminal Services)

foreign Domain users not able to RDP local Domain after trust

hello experts,  i having issues users foreign domain forest to to take remote of computers in local domain forest, althought can valiadate trust , able ping computers. when take remote of computer, getting error " the connection denied because user acccount not authorized remote login " . please me authentication through users login. trying foreign domain admin`s account login getting denied.     please help.   -mohit goyal cheers, mohit goyal is users other domain member of rdp group in local system allowed take rdp remotely. required make them member of rdp group on system using security groups or member of local administrators group. you need use global, domain local or universal group make them member of rdp group in  remote domain group scopes http://technet.microsoft.com/en-us/library/cc755692%28ws.10%29.aspx domain local, global & universal group http://social.technet.microsoft.com/forums/en/winserverds/thread/fa66b5c5-3ed3-4700-b479-e0365

dcdiag DNS test - Missing AAAA records

Image
we're seeing warnings in dcdiag's dns test aaaa records.  when running test on of our 2008 r2 sp1 domain controllers warnings like: < pre > test: records registration (rreg) network adapter [00000019] basp virtual adapter: warning: missing aaaa record @ dns server x.y.99.160: dc1.company.com warning: missing aaaa record @ dns server x.y.97.54: dc1.company.com warning: missing aaaa record @ dns server x.y.97.55: dc1.company.com </ pre > network traces show dns queries being asked , answered, including aaaa answers. running dcdiag /test:dns /v shows dcdiag has picked local-link ipv6 address.  < pre > adapter [00000025] basp virtual adapter: mac add

DNS fowarder

Image
hi all, already 3 month ++ done migration 2003 2008. below post before. http://goo.gl/shqerg http://goo.gl/7idp6x now, 3 month past, realize there problem sent email domain. i suspect fowarder issue, i'm not sure setting. attached forwarded image. before capture screen, in forwarder list ip of server (192.168.x.x). should right ip put??? hi, the right ip address should corresponding ip address of dns server forwarder referring to. you mentioned there problem sending emails domain, can ping domain local domain? more information you: ping http://technet.microsoft.com/en-us/library/ff961503.aspx configure dns server use forwarders http://technet.microsoft.com/en-us/library/cc754941.aspx configure dns server forwarders http://technet.microsoft.com/en-us/library/cc787071(v=ws.10).aspx best regards, amy wang Windows Server

The Professional to Enterprise edition build 10130 to the Enterprise build 10162

hi i installed the professional edition of windows 10 build 10130 and upgraded to the  enterprise edition . now , how i update it to build 10162 ? thanks bye balubeto hi, no, if current edition enterprise, next build release, reserve corresponding edition. 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  >  Windows 10 Insider Preview Setup and Installation

Server 2008 R2 - how to choose performance monitoring objects and then how to extract results for trending

Image
i have been tasked setting performance monitors on new server 2008 r2 hosting virtualized operating systems.   management wants me provide them performance results , provide data track trends. this first time admin on server 2008 r2 , know there differences in setup of monitoring between server 2008 , server 2008 r2. (i haven't had admin on server box since had box running  server 2000). i had few questions: 1. windows monitors important have running on server 2008 r2 ? server hosts virtualized non-windows os @ time. i thinking of scheduling basic monitors run, such as: cpu usage,ram memory usage , pagefile usage.     i not sure which, if any, sub-monitors of cpu, ram , pagefiles choose run. 2. best way gather , save performance monitoring results, use in ongoing long term trending?  i thinking maybe freeware or inexpensive 3rd party collect , gather of logged monitor data , organize/compile 1 or more formats easy create trending charts with.  or find

How to configure DNS manager for a Remote Computer

i trying set dns remote computer called win7. i not think has {same parent folder} or ws2012r2 win-123456. what missing? dns manager forward lookup zone mysite.com {same parent folder} host(a) 192.168.1.1 win-123456 host(a) 192.168.1.1 win7 host(a) 192.168.1.2 reverse lookup zone 1.168.192.in-addr.arpa 1-253 192.168.1.1 pointer(ptr) win-123456.mysite.com 192.168.1.2 pointer(ptr) win7.mysite.com i not think has {same parent folder} or ws2012r2 win-123456. i'm not sure if real question. {same parent folder} host records, registered domain controller automatically.   see active directory integrated dns. means ip reachable domain name specified in parent folder above (domain name). each dc should have 2 host records: 1 dc's unique hostname , 1 domain (the {same parent folder} one).   assume win-123456.mysite.com domain controller, correct?   regards, e

Animating ScatterViewItem.Orientation and retaining the value

i having trouble animating scatterviewitem's orientation property using doubleanimation. have flip button on scatterviewitem supposed flip item 180 degrees , -180 degrees on second click. works. problem seeing must use fillbehavior.holdend in order flipped angle persist after flipping doubleanimation seems never finish (even though completed fired) , orientation property's local value ignored after initial animation. basically, after item first flipped 1 cannot rotate scatterviewitem neither finger nor programmatically. have tried calling beginanimation(null) in completed event handler in order stop pending animations no avail. ideas helpful. i have created surface project scratch , added this: private void flipcompleted( object sender, eventargs e) { _item.beginanimation(scatterviewitem.orientationproperty, null ); } as modified xaml this: < s : surfacewindow x:class = " surfaceapplication1.surfacewindow1 " x