SQL Reporting Services: How to configure the service account

To configure the Report Server service account Start the Reporting Services Configuration manager and connect to the report server. On the Service Account page, select the option that describes the type of account you want to use. For recommendations about which account type to specify, see Configuring the Report Server Service Account. If you selected a Windows user account, specify the new account and password. The account cannot be more than 20 characters. If the report server is deployed in a network that supports Kerberos authentication, you must register the report server Service Principal Name (SPN) with the domain user … Continue reading SQL Reporting Services: How to configure the service account

Dynamic Memory for Hyper-V How To – Sp1 for Windows 7 and 2008 R2

Service Pack 1 for Windows 7 and Windows 2008 R2 released to the public and they are in the wild. Perhaps the most interesting and sought after aspect is Dynamic Memory for Hyper-V. This post sheds some limelight on a whitepaper and extracts some key aspects. The document can be found here: http://download.microsoft.com/download/E/0/5/E05DF049-8220-4AEE-818B-786ADD9B434E/Implementing_and_Configuring_Dynamic_Memory.docx Download Windows 7 and Windows Server 2008 R2 Service Pack 1 (SP1) Beta http://technet.microsoft.com/en-gb/evalcenter/ff183870.aspx Executive Summary Dynamic Memory is a new feature of Hyper-V™ introduced in Service Pack 1 for Windows Server® 2008 R2 that enables Hyper-V hosts to dynamically adjust the amount of memory available to … Continue reading Dynamic Memory for Hyper-V How To – Sp1 for Windows 7 and 2008 R2

How to Gems from the EBS team!

Windows Essential Business Server Team Blog : Our Technical Findings While Developing EBS v2: http://blogs.technet.com/essentialbusinessserver/archive/2010/04/07/our-technical-findings-while-developing-ebs-v2.aspx During the development of EBS v2, we tackled quite a few challenges in integrating Microsoft server technologies. We developed solutions and workarounds, proved them through exhaustive testing, and implemented them in EBSv2. Due to external factors, EBS v2 did not release to public. Therefore, we decided to gather some of our solutions and findings, and share it with our community. 1. Performing an ‘isolated’ installation of Exchange 2010 There is no supported way to rollback a failed Exchange installation from the forest. However, there is … Continue reading How to Gems from the EBS team!

SQL Server – How to Determine Which Version

To determine which version of Microsoft SQL Server is running, connect to SQL Server by using SQL Server Management Studio, and then run the following Transact-SQL statement. For SQL 2008, 2005, 2000: SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’) The following results are returned: The product version (for example, 10.0.1600.22) The product level (for example, RTM) The edition (for example, Enterprise) For example, the results resemble the following. 10.0.1600.22 RTM Enterprise Edition The following table lists the Sqlservr.exe version number. Release Sqlservr.exe SQL Server 2008 RTM 2007.100.1600.0 SQL Server 2008 Service Pack 1 2007.100.2531.0 SQL Server 2005 RTM 2005.90.1399 SQL Server … Continue reading SQL Server – How to Determine Which Version

Branch Office: Creating Visio Diagrams

Spider webs. That is what I call most network diagrams I see. A diagram is worth a thousand words when it comes to understanding the layout of your network. There are a few skills which help you get full value out of diagramming and it is the intent of this post to highlight a few. Most involve clearing the cobwebs and bringing clarity through visual cues. I am using a diagram that comes from an administrator for whom I have a lot of respect. He has taken on challenges and kept to a tight budget while advancing the use of … Continue reading Branch Office: Creating Visio Diagrams

How to Determine If You have a 64bit version of Windows 7

So your new Windows 7 box just arrived and they said it is 64bit. Cool. Now how do you check. Here are some tips which IT Pros have used for years but first the fastest way to find out: #1 Way to determine if you have 64 Bit Windows. Using DxDiag. Click the Start Button Type dxdiag in the search and press Enter The DirectX Diagnostic Tool will open. On the System Tab  locate the Operating System Row and Check for 64 bit Also note at the bottom you have the ability to run the 64-bit version of the DxDiag tool. … Continue reading How to Determine If You have a 64bit version of Windows 7

Upgrade to SharePoint 2010 System Requirements – 64 Bit Only

First thing to know about SharePoint 2010 is it is 64 bit only. Huh, let’s talk about 64bit a little. Exchange came out in 64 bit in the current version 2008 and I think Microsoft is going mainstream in support for 64 bit applications and operating systems. As a side note, a number of my family members are upgrading around Windows 7 and 64 bit is the choice for me in advising them. We are seeing more and more mainstream support for 64 bit and Acer to name one manufacturer is putting out mass market Home Premium boxes preloaded with 64 bit in … Continue reading Upgrade to SharePoint 2010 System Requirements – 64 Bit Only

Hyper-V 2008 R2 – Gotcha #1 – How to install Windows Server 2003 SP2 without a network card

Well I am deep into using Hyper-V R2 and I have probably forgotten a dozen things that caught me off guard at the beginning. I have resolved to just blog about them as they come up rather that put them in order of importance. In order for Hyper-V 2008 R2 Integration services to be installed on Windows Server 2003, SP2 needs to be installed. Now in most circustances this would not be a problem because you could use slipstreamimng to make another ISO image with the SP2 or SP3 install files. For more information on slip streamimng look here: How … Continue reading Hyper-V 2008 R2 – Gotcha #1 – How to install Windows Server 2003 SP2 without a network card