My fan

i'm running visual studio 2005 (vb) sql 2005 installed.  tried add sql database , says sql express not installed.  , here thinking sqlexpress vs express. i not want use old crippled handicap sql express database... how use regular sql database? thanks.   for starters, sql express hardly old, came out @ same time sql server 2005 , based on sql server 2005 engine. secondly sql express installed default version of visual studio. doesn't mean can't have other versions of sql server installed on machine. now answer question, think problem selecting when attempt add database. if select "microsoft sqlserver database file", vs attempt use sql express user instance require sql express installed, sql express feature. need select "microsoft sql server" entry, , connect appropriate instance of sql server.     drae wrote: i not want use old crippled handicap sql express database... how use regular sql database? thanks.   ...

hello all, how sql server determines when grow file? if give autogrow by 10%, server increases size when full or sometime before? also, if autogrow option on, there pressure on engine regular checking of available space? thanks. how sql server determines when grow file ? : believe when becoms 90-95 % autogrow triggered. autogrow option killer, better pre-grow data files, other wise transactions wait until autogrow gets completed. one more thing, give autogrow in mb not in %. becasue if file 10 gb, 10% of 10 gb 1 gb. takes hell lot of time expand , can lead blockings.     veeresh v nashi. autogrow not triggered when file 90-95% full. you can set instant file initialization way when data files autogrow not zeroed out ,instant file initialization doesn't apply log files. the best practice have turned on emergency not rely on it. http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/13/629866.aspx http://sqlskills.com/blogs/paul/post...

hello, have weird problem azure's sql data sync. i have on-premise sql server, contains article table. table gets replicated azure sql database, using sql data sync. it works great if modify rows. want add new column article table. what add column on on-premise database, go azure management portal, check new column in sync rules, , save. and gives me "sync group failed provisioned". i tried add column manually in azure sql database, , provisioning works. mean that, every time have add column, have add both on-premise database , azure database? greetings. un saludo. hi   yes, if add new column need modify sync group update column , need have same column in azure database. avoid situation, try fix schema in initial stage , start use data sync.   check idea link,  https://feedback.azure.com/forums/217535-sql-data-sync/suggestions/2307852-automatic-propagation-of-schema-changes-to-one-dat thanks hari ...

i having issues when installing sql server 2012 developer edition keeps failing install database engine service. not sure why it's not installing had installed before while before had reset computer. i'm using windows 8 professional in case helps any. here message pops when fails: title: microsoft sql server 2012 service pack 1 setup ------------------------------ the following error has occurred: wait on database engine recovery handle failed. check sql server error log potential causes. for help, click: http://go.microsoft.com/fwlink?linkid=20476&prodname=microsoft%20sql%20server&evtsrc=setup.rll&evtid=50000&prodver=11.0.3128.0&evttype=0xd15b4eb2%25400x4bdaf9ba%25401306%254026 here log file: overall summary:   final result:                  failed: see details below   exit code (decimal):           ...

i trying move dns lucent qip 7.2 microsoft dns.  currently, of active directory information (including exchange 2003) in dns zones hosted on lucent box.  need seamlessly move zone ad integrated dns zone on domain controllers. is best way following instructions in article ( http://support.microsoft.com/kb/323419 ) , doing zone transfer?  work since zone must ad integrated?  or should make secondary zone , change ad inegrated zone? (if can that)   please advise.   thanks,   -brent so, in summary (note: memory on wizard, may have missed step): 1) install dns on domain controller (pdc preferebly) add/remove programs 2) create new dns zone (secondary) 3) name zone "contoso.com" 4) select "store zone in active directory" 5) select "only allow secure dynamic updates" (if source dns server supports) 6) select dns master server (third party device) 7) finish the wizard 8) select "update...

hi folks. a question has been nagging me while..   school district on 50 physical sites (with matching ad sites , subnets).   each site has domain controller. (the primary data center has 3 dc's, including fmso role holder). we have found if 1 of remote site loses it's network connectivity rest of wan, , domain controller reboots, fail restart ad (and therefore dns) because can't connect it's replication partners.   in sandbox, found can ad , dns on isolated dc disconnecting dc's network card during boot up. is expected behavior? or sign of misconfiguration somewhere?  are there work arounds can done pre-emptively? thanks thoughts hi paul j. landry: thanks posting. >>each site has 1 domain controller. have found if 1 of remote site loses network connectivity rest of wan, , domain controller reboots, fail restart ad (and therefore dns) because can't connect replication partners.   yes, fail because cannot replicate partners. in scenario,...

i using windows 2003 print server, 200 printers. of these printers hps, , result use universal print driver. on old version of upd, , causes issues in terminal sessions, wanted update driver latest version. problem however, can't update latest version 1 one -- take forever. i'd replace existing driver printers using latest version. there easy way other 1 one?   thanks help! hi, thanks post. i think easy way update upd mutiple printers make vbscript. in case, suggest re-post new thread our scripting forum ( http://social.technet.microsoft.com/forums/en/itcg/threads/ ) meanwhile, find tool named hp managed printing administration may on issue. contact hp support further assistance if needed. for more information, please refer link: ( http://h20338.www2.hp.com/hpsub/cache/392596-0-0-225-121.html ) hope helps. miles       please remember click “mark answer” on post helps you, , click “unmark answer” if marked post not answer question. can b...

i had 1 user come me saying couldn't save series of shared folders on particular server. other uses not experiencing problem when accessing same folders. after troubleshooting able determine use has these folders set mapped drives, however, each folder shows having 74.6mb of free space when reality should have on 2gb, quota enabled. mapped various folders multiple servers users profile , found issue occurring on d: drive of particular 2008 r2 file server. unfortunately, have no idea how proceed, ideas?   those appear shares on crosby-fs1, have folder or growth restrictions of kind placed on shares?  i revisit folder properties , @ quota settings, happens if drop mapped folder, , re-map it?  type of storage these shares on? :p advice offered, if need more advised seek council , advice of paid professionals. answer 42, or reboot. Windows Server ...

hi, time zone in 1 of windows 2008 server chaging frequenlty.is there way track how time zone getting changed? or changing time zone?.i dont find event log in system,security or application event logs system time zone change.. thanks... hi, as using windows server 2008 can find event id 4616 under security logs event indicate system time changed. thanks & regards, abhijit deshpande posting provided "as is" no warranties or guarantees , , confers no rights Windows Server  >  Windows Server General Forum

hi guys, idea how fix error? 0x8009030c (the logon attempt failed): unable initializesecuritycontext im trying connect using kerberos auth ®©™½¼ hi,   do encountered error message when using sql server?   here similar issue may refer to:   unable "initializesecuritycontext"? http://blogs.msdn.com/b/carloc/archive/2007/07/18/unable-to-initializesecuritycontext.aspx   if issue persists , related sql server, you’d better submit new question sql server forum further assistance.   sql server http://social.technet.microsoft.com/forums/en/category/sqlserver   regards, please remember click “mark answer” on post helps you, , click “unmark answer” if marked post not answer question. can beneficial other community members reading thread. Windows Server  ...

:\users\administrator.server>ntdsutil ntdsutil: activate instance ntds active instance set "ntds". ntdsutil: files not initialize jet engine:  jet error -583. failed open dit ad ds/lds instance ntds. error -2147418113 ntdsutil: semantic database analysis not initialize jet engine:  jet error -583. failed open dit ad ds/lds instance ntds. error -2147418113 ntdsutil: quit c:\users\administrator.server>esentutl /g c:\windows\ntds\ntds.dit extensible storage engine utilities microsoft(r) windows(r) version 6.1 copyright (c) microsoft corporation. rights reserved. initiating integrity mode...         database: c:\windows\ntds\ntds.dit   temp. database: tempinteg4340.edb operation terminated error -583 (jet_errsectorsizenotsupported, physica l sector size reported disk subsystem, unsupported ese specif ic file type.) after 0.32 seconds. c:\users\administrator.server>esentutl /p c:\windo...

my setup.... 4 node windows 2008 r2 failover cluster hyper v. each server dell r610 2-x520-d2 10gig nic's.  nic port each used iscsi, no teaming, mpio.  a nic port each teamed in lacp (satic) team team looks 20gig pipe 1 mac address.  using latest intel nic teaming software (ans name think).  have created 4 vlan's vlan3 host management (172.24.3.x) routable etc. vlan15 csv/heartbeat (172.24.15.x) private no gateway. vlan16 live migration (172.24.16.x) private no gateway. vlan4 bound hyper v vm's (172.24.4.x) routable etc. the nic's plugged nexus 5548's using vpc etc create lacp team. this works, vm's working, live migration, csv redirection when happens.  if run cluster validation warning...   found duplicate physical address 00-1b-21-c1-4a-7c on node dhqhyperv30.dierbergs.net adapter mgt , node dhqhyperv30.dierbergs.net adapter csv. found duplicate physical address 00-1b-21-c1-4a-7c on node dhqhyperv30.dierbergs.net adapter mgt , node d...

we have ad trust established between 2 forests. working fine except on 1 dc there event logs (event id 83 in operations manager log) generated. contains: ad monitor trusts : trusts between domain (<domain_name1>) , following domain(s) in error state: <domain_name2> (inbound). error is: specified domain either not exist or not contacted. (0x54b) there firewall between 1 dc , trusted domain dcs. wondering whether domain controllers in both forests must have connection each other or ok dcs (all except one) 1 forest have connection dcs in trusted domain? the answer no. if ports being firewalled necessary resource endpoints (your dcs in case), ad functionality fail, includes trusts. so if you've established fact ports blocked, have contingency plan allow traffic? is there vpn tunnel between locations? why ports blocked 1 set of dcs , not others? designed way networking group? ace fekay mvp, mct, mcse 2012, mcitp ea & mcts windows 2008/r2, exchange 20...

buenas estamos intentando auditar los movimientos de usuarios administradores y ordinarios. queremos que de los usuarios administradores se auditen sus movimienos (que cambian en ad, que borran, que modifican en carpetas...) y de los usuarios que recursos borran o modifican (si borran archivos etc...) en el dominio he seguido este tuto de ms: http://support.microsoft.com/default.aspx/kb/814595/es?p=1 pero no me queda muy claro si se hace así o si es lo que quiero, parte que no se donde consultar los resultados porque en el event view en seguridad no me aparece nada... saludos goldfran, algo más lo que comenta josé. la primera consideración tener en cuenta es ser cuidadoso sobre qué vas auditar, ya que una auditoría excesiva bajará notablemente el rendimiento del servidor, y además los logs serán difíciles de interpretar por la cantidad de eventos (aunque puedas poner filtros) otra consideració...

system admin small company. of users undeliverable emails "system administrator", didn't send. here actula message: from: system administrator sent: wednesday, july 30, 2008 6:59 am to: barbara bogle subject: undeliverable: anjelina jolie xxx video free.     your message did not reach or of intended recipients.         subject:    anjelina jolie xxx video free.       sent: 7/30/2008 6:59 am   the following recipient(s) cannot reached:         aparker@inlandrc.org on 7/30/2008 6:59 am             e-mail account not exist @ organization message sent to.  check e-mail address, or contact recipient directly find out correct address.             <ircmail2.irc.sb #5.1.1> barbara bogle not "system administrator".please help fzia   hi,   please understand discuss windows server issues in forum. issue relate exchange server, not best resource troubleshoot it. suggest discussing in our exchange server forum.   exchange serv...

i have 4 high end servers, 2 equallogic clustered storage sans, misc required switches, ups's, etc set maximum availability. using hardware sharepoint 2010. create dual independant 2 node failover clusters using server 2008 ent r2. run sharepoint off of 1 of 2 node clusters , sql off of other , use san iscsi attached storage. i'm thinking sharepoint , sql db hosted on cluster associated vm's? correct? understanding in configuration, need have server os on physical servers , applications on vm's. please confirm/deny , let me know if thinks there issues configuration. james hi it's possible install sql server on failover clustering , implement moss on windows network load balancing. please have @ below mentioned link need consider when virtualizing sql clusters. support policy microsoft sql server products running in hardware virtualization environment http://support.microsoft.com/?id=956893 microsoft server software , supported virtualization environm...

hi , is there way find windows firewall status on server on network . generate kinds of report. any idea please here go. https://gallery.technet.microsoft.com/scriptcenter/gather-remote-firewall-1d8721e4       regards, dave patrick .... microsoft certified professional microsoft mvp [windows] disclaimer: posting provided "as is" no warranties or guarantees , , confers no rights. Windows Server  >  Windows Server 2012 General

hi, we have installed new sql server 2005 (with sp3) on windows server 2008 r2. unable connect sql 2005 server through sql server 2014 management studio. supported? sql server 2005 services except ad domain helper running on server.  mps thanks andy. have gone through suggestions. found though tcp-ip enabled in sql, not enabled in ip tab. enabled , problem resolved. thank suggestion. mps Windows Server  >  Network Infrastructure Servers

i have 2 node windows server 2012 r2 failover cluster 2 sql server 2012 enterprise alwayson availability groups configured. within cluster have configured preference order on node alwayson availability group should run. get-clustergroup -name "alwayson1" | set-clusterownernode -owners "node1","node2"; get-clustergroup -name "alwayson2" | set-clusterownernode -owners "node2","node1"; after configuring preference , retrieving preference order configured should be. when failover preference order adjusted first node runs on , second other node instead of leaving preference order was. doesn't matter if use powershell "move-clustergroup" or "alter availability group [alwayson1] failover" t-sql command. cluster log shown preference modified after resource has been moved. info  [gum] node 2: executing request locally, gumid:15859, action: /rcm/gum/setgrouppreferredowners, # of updates: 1 ...

is there way merge cells of specific row in datagrid. here sample:       _____________________________________  r1 |_______|___________|____|____|_________|  r2 |_______|___________|____|____|_________|  r3 |_______|___________|mad2                         |  r4 |_______|___________|____|____|_________|  r5 |_______|___________|____|____|_________|  r6 |_______|___________|____|____|_________| thanks for any assistance   i don't know, first reaction not.  since user can potentially drag , drop columns reorder them.  maybe there trick can't think of though. when @ have, makes me think better of using grid instead of datagrid.  grid allows column spannning.  might have create grid cells dynamically in code. but see doing grid without trouble, datagrid, not...

i need create report looks in report builder (not excel, example).  https://www.dropbox.com/s/84cey7rkpknq3li/example.jpg i know need use dateadd function, maybe in combination iff, haven't slightest how it.  ipainter ******** update. again, got flagged abusive! not trying abusive. trying learn sql experts.  hello, your sql should declare @inputdate date ='2013-03-11' select customer_name, convert(date,cast(invoice_date varchar(20))) invoicedate, invoice, invoiced_amount, due_date, case when convert(date,cast(due_date, varchar(20))) < (@inputdate) (invoiced - paid) else 0 end past_due ,case when datediff(d,convert(date,cast(a.epdudt varchar(20))),@inputdate) between -999 , 0 (invoiced - paid) else 0 end current_ ,case when datediff(d,convert(date,cast(due_date varchar(20))),@inputdate) between -7 , 0 (invoiced - paid) else 0 end past_due1_7 ,case when datediff(d,convert(date,cast(a.epdudt varchar(20))),@inputdate) between -14 , ...

hi all, i have hybrid environment between ad (on-premises) , office 365, have completed sync user info ad office 365. want update user picture users on office 365 onetime, how can it? regards, hi, thanks post. i think use active directory sync tool (dirsync). tool runs on windows server machine on network , synchronizes users office 365. http://blogs.office.com/2014/04/15/synchronizing-your-directory-with-office-365-is-easy/ regards. vivian wang Windows Server  >  Directory Services

hello , i have remote desktop server smartcard authentication enabled on domain called domain.com. windows 7 machine on domain.com can authenticate smartcard. on windows 7 machine not on domain.com external network , certificate not recognized. (with same smartcard) can explain how solved problem? hi, here there checks on specific certificates issued active directory underlying kerberos authentication , account checks against upn of user data contained in certificate. refer this more information. apart case, providing link helpful resolve issue. 1.  smart card , remote desktop services 2.  automatic logon rds using smartcards 3.  remote desktop connection / error reading certificate smart card reader hope helps! thanks. we trying better understand customer views on social support experience, participation in interview project appreciated if have time. helping make community forums great place. ...

hi experts , need in resolving unexpected shutdown happing windows server 2003. below log details. server : hp dl 360 g5 note : had run hardware diagnostic , not found issue. event type:         error event source:      eventlog event category:  none event id:              6008 date:                      2/19/2015 time:                     8:48:40 pm user:                      n/a computer:           <server hostname> description: the previous system shutdown @ 8...

a 2000 server original dc. put in 2003. has been moved on including fsmo roles. created gc on 2003. if shutdown 2000 server cannot join computers domain. did dcdiag , there couple errors. 1 there no gc detected. have checked dns , srv records there. here dcdiag , ipconfigs of both servers. suggestions appreciated. thing have found haven't tried deleting replication entries. if not able put 2000server online (which has working gc). domain controller diagnosis performing initial setup:    * verifying local machine 2003server, dc.    * connecting directory service on server 2003server.    * collecting site info.    * identifying servers.    * identifying nc cross-refs.    * found 2 dc(s). testing 1 of them.    done gathering initial info. doing initial required tests       testing server: default-first-site-name\2003server       starting t...