Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Setup   (RSS)

How to fix your SQL Server 2008 Setup before you run setup...

Huh? This is not meant to be a brain teaser. The purpose of this post is to help you avoid problems with SQL Server 2008 setup before you run..well setup. Why not take advantage of known fixes we have for setup to avoid the problem in the first place?
Posted by psssql | 4 Comments

Welcome to SQL Server 2008 Patching

We have posted the first cumulative update for SQL Server 2008 aptly named Cumulative Update 1 (CU1). I thought before you considered installing a patch for SQL Server 2008, you would like to see a tour of what it looks like compared to SQL Server 2005
Posted by psssql | 9 Comments

Upgrade for SQL Server 2008 can fail if you have renamed the 'sa' account

Gail Shaw, a SQL MVP, presented me with a new issue for SQL Server 2008 I had not heard of before. It was posted at the following web site: http://www.sqlservercentral.com/Forums/Topic560965-391-1.aspx This customer had renamed the 'sa' account as many
Posted by psssql | 3 Comments

SQL Server 2005 Setup Fails in WOW (x86) On Computer With More Than 32 CPUs

  SCENARIO SQL Server fails to install a WOW64 instance (x86) an on a computer with more than 32 CPUs.    During setup you will encounter a SQL Server failed to start message.      SQL Server is attempting to determine the
Posted by psssql | 1 Comments
Filed under: ,

SQL Server 2008 Management Tools Basic vs Complete Explained....

A few questions have come up about the differences between the features you can install on SQL Server 2008 called Management Tools - Basic   and Management Tools - Complete. So I thought I'd blog about these to resolve any questions you might have.
Posted by psssql | 3 Comments

How to Rebuild System Databases in SQL Server 2008

In SQL Server 2005, we introduced a different method than in previous versions to rebuild system databases (affectionately known as "rebuild master"). You were required to use the setup.exe program with command line switches. This is no different
Posted by psssql | 5 Comments

SQL Server 2008 Express, .Net Framework 2.0 SP2, and 3.5 SP1 explained...

Many of you may have read my post about dependencies with Visual Studio 2008 SP1 and the .Net Framework 3.5 SP1 and SQL Server 2008. I have some related information to provide to you about SQL Server 2008 Express. If you are a user of SQL Server 2008
Posted by psssql | 5 Comments

SQL Server 2008, Visual Studio 2008 SP1, and .Net Framework 3.5 SP1 explained....

PLEASE NOTE: This blog post has been updated from its original posting to clarify other details about installation of SQL Server 2008 and Visual Studio 2008 SP1. I must say that I'm personally proud to see our release of SQL Server 2008. I've been involved
Posted by psssql | 19 Comments
Filed under: ,

SQL Server 2005 Encounters Exception During Install When System has Odd Number of Processors or Logical Processors Per Core

While attempting to install SQL Server 2005 you may encounter an error familiar to the following and a retry option presented by setup. Faulting application sqlservr.exe, version 2005.90.1399.0, time stamp 0x434f82e9, faulting module sqlservr.exe, version

Database compatibility and new features

Have you attempted to execute queries using some of the new keywords and constructs only to see error messages like the following? Msg 321, Level 15, State 1, Line 5 "sql_handle" is not a recognized table hints option. If it is intended as a parameter

SQL 2005 Setup Failures

This week I was reviewing Watson setup failure rates and comparing them to cases opened in the same areas with SQL Server support. Dec 2006 was the highest volume level for SQL Server 2005 RTM and SP1 cases to date. The values were not out of line, in
Posted by psssql | 1 Comments
Filed under:
 
Page view tracker