The SQL Network Interface library was unable to register SPN

The SQL Network Interface library was unable to register SPN. Problem In the SQL Server error log you got the following message: The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x2098, state: 15. Failure to register an SPN may cause integrated authentication to fall…

28

How to install SQL Server 2008 32Bit on Windows 2008 X64

How install SQL Server 2008 32Bit on Windows 2008 X64 In a specific case, you have to install SQL Server 2008 32Bit (X86) on Windows 2008 X64. It can be due to the provider of your end application who supports only on a SQL 32Bit his application. If you want to install SQL server 2008…

9

Apply a service pack or hotfix SQL Server 2008 to a failover cluster instance

Apply a service pack or patch SQL Server 2008 in a clustered environment     Step 1 : Validation wizard     Step 2 : Pre-check    Step 3 : Installation of the first node    Step 4 : Add a new node     Step 5: Apply a service pack or hotfix on a SQL cluster Installing Service Pack…

9

Migration SQL Server 2000 to SQL Server 2008

The purpose of this post is to explain the minimum required for the migration of Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You can use the same principles to migrate a Microsoft SQL Server 2005 to Microsoft SQL Server 2008. 1. SQL server 2008 upgrade advisor1.1. Before migratingMicrosoft provides a tool called “Microsoft…

6

The database principal owns a schema in the database, and cannot be dropped

   Description of the problem: When you tried to drop a user, you got this message: Error: 15138 The database principal owns a schema in the database, and cannot be dropped. Cause: That means, you are trying to drop a user owning a schema. In order to drop the user, you have to find the schema…

5

Last stored procedures updated with SQL Server Management Studio 2008

Last stored procedures updated with SQL Server Management Studio 2008 I would like to share with you a new feature that I found out by using SQL Server Management Studio 2008. With SQL Server 2005, I used to run the query below to get the list of the stored procedure whom modified by the developper…

4

SQL Server 2008 script to rebuild all indexes for all tables on all databases

I got several times the same questions around index and fragmentation on SQL2008. So I decided to add one more item on Internet to discuss about the reconstruction and reorganization of the index and how detect index fragmentation. StarterAs fragmentation can have a negative impact on the efficiency of data access; one of the main…

4

Microsoft SQL server and Antivirus

Many of you wondered if it is necessary to use an antivirus on the server hosting your SQL Server Database. Some DBAs will say to not run anti-virus software on a server hosting SQL Server and the other say that you have to do.In general, Antivirus are to protect file systems, SQL database services are…

2