SQL 2008 on Windows 2008 R2

יום ראשון, אוגוסט 8, 2010

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 ...
אין תגובות

Hyper-V & SQL consolidation at Microsoft IT

יום חמישי, מרץ 19, 2009

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 ...
אין תגובות

Creating Custom Reports By Using Configuration Manager 2007 SQL Views

יום חמישי, ינואר 15, 2009

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 objects that represent Configuration Manager 2007 items such as advertisements, software update deployments, configuration baselines, reports, and status messages. Configuration Manager administrators need to understand the different...
אין תגובות

ConfigMgr 2007: Status Message 2407 in SMS_SQL_MONITOR after upgrade from SMS 2003

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", restore it to its original, unmodified state.    Possible cause: SQL Server problem.  Solution... Continue reading at our new blog - http://www.dario.co.il/blog/?p=367
אין תגובות

Presentations from the System Center Round Table for Enterprise Clients

יום שישי, דצמבר 19, 2008

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

Microsoft Assessment and Planning Toolkit 3.2 RTM Version Now Available!

יום רביעי, נובמבר 5, 2008

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!) Microsoft Online Services Migration Surveys, Proposals, and Reports...

Running SQL Server in Hyper-V Environment: Best Practices and Recommendations

יום ראשון, אוקטובר 12, 2008

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 (QoS). Hyper-V opens more potential development and test environment types that otherwise might be constrained by hardware availability. It is challenging enough in...
אין תגובות

Important updates regarding SCCM 2007 R2

יום חמישי, ספטמבר 25, 2008

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 of ConfigMgr 2007 RTM on a SQL Server 2008 database is...
תגובה אחת

Connect to an SQL Server Instance from a remote server

יום רביעי, יולי 30, 2008

כאשר מגדירים של-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 זהו. אממ.... לא בדיוק, תעשו את זה ועדיין שום דבר לא יעזור השרת לא מתחבר משום מקום אחר בעולם. הסיבה היא שבשביל לתת...
תגיות: ,
אין תגובות