Browse by Tags
All Tags »
SQL Server (
RSS)
Only SQL 2008 SP1 is supported on Windows 2008 R2. If you tried installing SQL 2008 from its DVD\ISO you surely got this error message: In order to install SQL 2008 together with SP1, follow these Steps: Install the prerequisites of SQL 2008: .NET Framework 3.5 SP1 (from Server Manager --> Features --> .Net Framework 3.5.1 Features) Windows Installer 4.5 Extract the service pack to a folder on the server using the following command: SQLServer2008SP1-KB968369-x64-ENU.exe /x:C:\SQL2008SP1 Run...
A new white paper has been published that compares the options to use multiple instances of SQL without Hyper-V with having multiple virtual machines with single instances of SQL Server. Not only it looks at the different pros and cons, but also provides interesting performance information. Here's are the topics covered in this 26-page white paper: Executive Overview Introduction Considerations for Consolidation and Virtualization Identification of Underutilized Servers Server temperature Consolidation...
Microsoft has released a new document to help you create custom reports. You can download it here . Overview Microsoft System Center Configuration Manager 2007 queries SQL Server views in the Configuration Manager site database when retrieving the information displayed in reports. The Configuration Manager site SQL database contains a large collection of information about the network, computers, users, user groups, and many other components of the computing environment. The database also contains...
Issue: After upgrading from SMS 2003 SP2 or SP3 to the Select version of Configuration Manager 2007 SP1, you may see the following status message: SMS_SQL_MONITOR_SiteServer - 2407 SMS SQL Monitor failed to install trigger "SQLTaskStatus_upd" in the SMS site database. Possible cause: Either table "SQLTaskStatus" or column "TaskName,TaskType" of table "SQLTaskStatus" does not exist in the SMS site database. Solution: If you modified table "SQLTaskStatus"...
As promised, I’ve uploaded the presentations from the sessions I gave on December 18th at Microsoft Israel. Enjoy. Physical And Virtual Server Management Deploying Windows With Configuration Manager 2007 R2 Data Protection Manager 2007 Dynamic Server Provisioning With Ops Manager And Hyper V – Notes From The Field
MAP is a scalable and agent-less assessment platform designed to make it easier for you to adopt the latest Microsoft technologies. In this version, MAP has expanded its assessment capabilities to include SQL Server 2008, Forefront/NAP, and Microsoft Online Services migration, as well as providing a Power Savings assessment to help you "go green." In summary, MAP 3.2 assessment areas now include: SQL Server 2008 Migration Proposals and Reports (NEW!) Forefront/NAP Readiness Proposals (NEW...
Based on hypervisor technology, the Hyper-V ™ virtualization feature in the Windows Server® 2008 operating system is a thin layer of software between the hardware and the operating system that allows multiple operating systems to run, unmodified, on a host computer at the same time. Hyper-V is a powerful virtualization technology that can be used by corporate IT to consolidate under-utilized servers, lowering total cost of ownership (TCO) and maintaining or improving quality of service...
SQL Server 2008 is now supported on Configuration Manager 2007 RTM and SP1 System Center Configuration Manager 2007 (RTM and SP1) now supports the use of SQL Server 2008 as a site database. In order to upgrade a site-server database to SQL 2008 there are 2 hot fixes required: ConfigMgr 2007 RTM customers must apply hot fix KB955229 ConfigMgr 2007 SP1 customers must apply hot fix KB955262 The following are requirements when performing a clean install on a SQL Server 2008 database: A clean install...
SQL Server 2008 has been RTM!! check out the features supported by the Standard edition - at last we can have a low cost SQL cluster... http://technet.microsoft.com/en-us/library/cc645993.aspx
כאשר מגדירים של-SQL יש גם instance אז בצורה default הוא לא מאפשר חיבור של מחשבים מרחוק, בשביל זה צריך לוודא שה-Instance מאפשר חיבור לא רק לוקאלי. 1.נכנסים ל-SQL Server Surface Area Configuration 2. נכנסים ל- Surface Area Configuration for services and connection 3. פותחים את העץ מצד שמאל ונכנסים לתוך ה-Instance שלכם. 4. תחת database engine נכנסים ל-remote connection 5. מגדירים Local and remote connection זהו. אממ.... לא בדיוק , תעשו את זה ועדיין שום דבר לא יעזור השרת לא מתחבר משום מקום אחר בעולם...
I check the licensing of SQL server 2005 for one of our clients which going to consolidate 5 SQL server to one virtual machine running 5 different instances as part of a big DRP project that we design for him. Licensing SQL server on a virtual machine According to Microsoft, there is three different approaches: For Standard, Workgroup, and Enterprise, if you decide to license on a per processor basis, you must buy a SQL Server license for each virtual processor. For Enterprise Edition, you can also...