http://www.sqlservercentral.com/Content tagged Installation posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)When trying to add a node to an existing SQL Server 2008 cluster you get an Invalid SKU Errorhttp://www.sqlservercentral.com/scripts/Installation/64290/2008/09/07http://www.sqlservercentral.com/scripts/Installation/64290/In this next article of the SQL Server in the Enterprise Series, we'll explore how to cluster Windows 2000 and SQL Server 2000 in a step-by-step manner. After this article, you should be able to cluster a SQL Server 2000 machine for failover availability in an Active/Active cluster. http://www.sqlservercentral.com/articles/Installation/stepbystepclustering/356/2008/01/18http://www.sqlservercentral.com/articles/Installation/stepbystepclustering/356/http://www.sqlservercentral.com/questions/SQL+Server+2005/61623/2007/12/28http://www.sqlservercentral.com/questions/SQL+Server+2005/61623/This article highlights the steps involved to install SQL Server 2008.http://www.sqlservercentral.com/redirect/articles/61726/2007/12/27http://www.sqlservercentral.com/redirect/articles/61726/http://www.sqlservercentral.com/questions/SQL+Server+2005/61624/2007/12/04http://www.sqlservercentral.com/questions/SQL+Server+2005/61624/Longtime SQL Server author Raj Vasant brings us a technique for delivering databases along with an application. As more and more systems take advantage of SQL Server or Express, this is a technique that can come in very handy.http://www.sqlservercentral.com/articles/Administration/61331/2007/10/22http://www.sqlservercentral.com/articles/Administration/61331/In this article, Brian Kelley focuses on learning the various services in SQL Server. He also covers the security needed to make them work. http://www.sqlservercentral.com/articles/Installation/services/567/2006/05/12http://www.sqlservercentral.com/articles/Installation/services/567/Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes. http://www.sqlservercentral.com/articles/Service+Packs/sp3coresecurity/907/2005/12/09http://www.sqlservercentral.com/articles/Service+Packs/sp3coresecurity/907/As a DBA you do not need to know how to setup an Active Directory domain or a DNS server, but you still need to know how Kerberos, Service Principle Names, and hostnames are used to perform integrated authentication to a SQL Server. This article by new columnist Chad Miller shows you some of the more integral parts of troubleshooting running Windows Authentication security in a SQL Server environmnet. http://www.sqlservercentral.com/articles/Installation/cannotgeneratesspicontext/929/2005/08/19http://www.sqlservercentral.com/articles/Installation/cannotgeneratesspicontext/929/When installing SQL Server, regardless of versions and editions, SQL Server database administrators tend to choose the default collation and sort-order, which is SQL_Latin1_General_CP1_CI_AS. Though case insensitiveness makes the life of the database developers and database administrator's easy, there are situations where case sensitivity should be enforced just as password checking is enforced. In this article, I would like to discuss different methods for achieving case sensitivity in a case insensitive database/server.http://www.sqlservercentral.com/redirect/articles/1797/2005/03/25http://www.sqlservercentral.com/redirect/articles/1797/Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary! http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/2005/02/04http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/In this next article of the SQL Server in the Enterprise Series, we'll explore how to cluster Windows 2000 and SQL Server 2000 in a step-by-step manner. After this article, you should be able to cluster a SQL Server 2000 machine for failover availability in an Active/Active cluster. http://www.sqlservercentral.com/articles/Installation/stepbystepclustering/356/2008/01/18http://www.sqlservercentral.com/articles/Installation/stepbystepclustering/356/Clustering a SQL Server machine was one of the most frustrating tasks a DBA and Windows administrator had to accomplish in SQL Server 7.0 and Windows NT 4.0. With the maturity of both the OS and the DBMS in Windows 2000 and SQL Server 2000, this operation has been simplified tremendously. This first article in the series of article on clustering SQL Server will explain the general architecture of clustering. http://www.sqlservercentral.com/articles/Installation/clustering_a_sql_server_machine_/344/2004/11/25http://www.sqlservercentral.com/articles/Installation/clustering_a_sql_server_machine_/344/Everyone does demos. Selling software relies upon people viewing your software in action and being confident it will work. Managing a demo server can be a challenge and this series will look at different problems and options you have. http://www.sqlservercentral.com/articles/Installation/buildingademoserver/864/2004/01/14http://www.sqlservercentral.com/articles/Installation/buildingademoserver/864/This article by Andy Warren offers a free utility that will generate DSN's for all or just a subset of the databases on a server in seconds. http://www.sqlservercentral.com/articles/Installation/dsngen/119/2003/09/19http://www.sqlservercentral.com/articles/Installation/dsngen/119/Is Windows 2003 really faster for a SQL Server/IIS environment? Let us do all the leg work for you! We are about to upgrade the SQLServerCentral.com web and SQL Server from Windows 2000 to Windows 2003. As part of the case study, we are going to capture a baseline of the server's overall performance before the upgrade and then again after the upgrade. We will then document the experience and benchmark numbers. http://www.sqlservercentral.com/articles/Installation/windows2003faster/1020/2003/06/10http://www.sqlservercentral.com/articles/Installation/windows2003faster/1020/Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes. http://www.sqlservercentral.com/articles/Service+Packs/sp3coresecurity/907/2005/12/09http://www.sqlservercentral.com/articles/Service+Packs/sp3coresecurity/907/A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks! http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/2003/04/18http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/This article is the first of a multi-part series detailing the SQL Server Upgrade process from the technical, logistical and business perspective. http://www.sqlservercentral.com/articles/Installation/sqlserverupgrade/930/2003/03/03http://www.sqlservercentral.com/articles/Installation/sqlserverupgrade/930/There may be more ways than you realize to determine the version and service pack of SQL Server. This quick article by Dinesh Priyankara will show you 3 of those methods. http://www.sqlservercentral.com/articles/Service+Packs/versionservicepack/928/2003/02/28http://www.sqlservercentral.com/articles/Service+Packs/versionservicepack/928/As a DBA you do not need to know how to setup an Active Directory domain or a DNS server, but you still need to know how Kerberos, Service Principle Names, and hostnames are used to perform integrated authentication to a SQL Server. This article by new columnist Chad Miller shows you some of the more integral parts of troubleshooting running Windows Authentication security in a SQL Server environmnet. http://www.sqlservercentral.com/articles/Installation/cannotgeneratesspicontext/929/2005/08/19http://www.sqlservercentral.com/articles/Installation/cannotgeneratesspicontext/929/Your software has passed all testing phase(s) and it is time to install your database into production. Andy Jones will outline below how he accomplished this task. This article is concerned with an evolving system and how to migrate it to production. http://www.sqlservercentral.com/articles/Installation/initialinstall/905/2003/02/04http://www.sqlservercentral.com/articles/Installation/initialinstall/905/In this next article of the SQL Server in the Enterprise Series, we'll explore how to cluster Windows 2000 and SQL Server 2000 in a step-by-step manner. After this article, you should be able to cluster a SQL Server 2000 machine for failover availability in an Active/Active cluster. http://www.sqlservercentral.com/articles/Installation/stepbystepclustering/356/2008/01/18http://www.sqlservercentral.com/articles/Installation/stepbystepclustering/356/Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now! http://www.sqlservercentral.com/articles/Installation/reviewofsqlserver2000programmingmspress/694/2002/06/04http://www.sqlservercentral.com/articles/Installation/reviewofsqlserver2000programmingmspress/694/Whether you are a developer, IT professional, or a database administrator, whether you are just developing and testing or are ready to deploy in production, there is a SQL Server 2000 edition for you and your organization. This paper will inform you about the differences among the various editions of SQL Server 2000, and how you can save time and money by choosing the right one for the job. http://www.sqlservercentral.com/redirect/articles/670/2002/04/24http://www.sqlservercentral.com/redirect/articles/670/As I work with a particular topic or problem, I often research on the Internet different opinions, white papers, etc. Here is a list of resources that deal with the licensing aspects of using SQL Server. http://www.sqlservercentral.com/articles/Installation/sqlserverlicensingresources/636/2002/03/21http://www.sqlservercentral.com/articles/Installation/sqlserverlicensingresources/636/Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary! http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/2005/02/04http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/In this article, Brian Kelley focuses on learning the various services in SQL Server. He also covers the security needed to make them work. http://www.sqlservercentral.com/articles/Installation/services/567/2006/05/12http://www.sqlservercentral.com/articles/Installation/services/567/This article examines the basics of installing SQL Server 7.0 http://www.sqlservercentral.com/articles/Installation/sqlserver7.0installation/399/2001/09/03http://www.sqlservercentral.com/articles/Installation/sqlserver7.0installation/399/This article examines some of the common issues that may occur when installing SQL Server 7.0 http://www.sqlservercentral.com/articles/Installation/installationproblemsinsqlserver7.0/397/2001/08/23http://www.sqlservercentral.com/articles/Installation/installationproblemsinsqlserver7.0/397/