Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Server 2005   (RSS)

Issues with SQL Server Login Failures and dependency on Windows Password Policy Check

Good afternoon techies! I recently worked with some customers on SQL Server 2005 login failure issues. Thought I’d make a blog post on what exactly we do @ PSS in such situations and specifically share my thoughts on login failure issues relating with Read More...
Posted Thursday, November 12, 2009 1:38 AM by AmruthaVarshiniJ | 0 Comments

On a Clustered SQL Server 2005 running on Windows 2003 machine the maintenance plan MIGHT fail with: “The LoadFromSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired)”

On a Clustered SQL Server 2005 running on Windows 2003 machine the maintenance plan fails with below error. This issue is also seen on a newly created a maintenance plan as well. Executed as user: <Domain>\User. Microsoft (R) SQL Server Execute Read More...
Posted Monday, November 09, 2009 3:12 PM by Nikesh Mhatre | 0 Comments
Filed under: ,

In SQL Server 2008, the product name and the data source information goes blank in "Linked server properties" window

In SQL Server 2008, sometimes the product name and the data source information goes blank in Linked server properties window for a Linked server of provider type Microsoft OLEDB provider for SQL Server or SQLOLEDB . When we create a Linked Server of type Read More...
Posted Sunday, August 23, 2009 6:28 PM by sanjayap | 0 Comments

Unable to failover a Named instance of SQL server 2005 in cluster or unable to bring a Named Instance of SQL server 2005 Online

The problem is that we have a Named instance of SQL Server 2005 in a 2 node cluster. While trying to bring the SQL Services online we get these error messages in the Application Event Log. Application Event Log: Event Type: Error Event Source: MSSQL$SQL2k5 Read More...
Posted Thursday, August 20, 2009 9:19 PM by sanjayap | 0 Comments
Filed under: ,

INFORMATIONAL: Understanding and Troubleshooting MSP Error: 29512 SQL Server Setup was unable add user <Domain\Username>, when you try to install SQL Server 2005

Good morning Folks! Today I will take you through a setup issue that many of you might have run into when trying to install SQL Server 2005 (especially on a cluster). I’ve tried to list down all possible solutions to the following errors one faces while Read More...
Posted Thursday, August 20, 2009 11:55 AM by sanjayap | 0 Comments

DTS PACKAGE FAILS TO OPEN WITH ERROR [Dbnetlib][ConnectionRead (WrapperRead()).] General network error

We have observed a number of cases where in the dts package fails to open from the enterprise manager in sql 2000 or management studio in sql 2005. We are able to create a new DTS package and save them but when we try to open them, it fails with below Read More...
Posted Thursday, August 20, 2009 11:48 AM by sanjayap | 0 Comments

Installing Hotfix on SQL Server may throw error 29538 and fail

In this case we were installing hotfix http://support.microsoft.com/?kbid=960089 Microsoft SQL Server 2005 Service Pack 2 Cumulative Hotfix 3077 The Hotfix Setup would rollback. You will see the below error in the Hotfix.log file 06/24/2009 16:15:38.994 Read More...
Posted Wednesday, July 08, 2009 11:26 PM by sanjayap | 0 Comments

Upgrade from SQL 2005 to SQL 2008 might fail with MsiGetProductInfo error

Consider a scenario where an upgrade from SQL 2005 to SQL 2008 fails with the following messages while installing Setup Support Files. ******************************************************** TITLE: SQL Server Setup failure. ------------------------------ Read More...
Posted Saturday, June 13, 2009 12:46 AM by sanjayap | 1 Comments

Unable to start SQL Server Agent

We are unable to start SQL Server Agent. It was giving the following error when we were trying to start it from the services console The SQL Server Agent (MSSQLSERVER) service on Local Computer started and then stopped. Some services stop automatically Read More...
Posted Friday, June 12, 2009 1:09 PM by sanjayap | 2 Comments

Not able to restore backup from tape for large databases on the SQL Server 2005

We get the below error message when we try to restore from tape for large databases. ERROR MESSAGE: ============== TITLE: Microsoft SQL Server Management Studio ------------------------------ An exception occurred while executing a Transact-SQL statement Read More...
Posted Wednesday, April 15, 2009 4:00 PM by sanjayap | 0 Comments

SQL Server 2005 SP2 installation hangs on a 2 Node cluster with the message: "Awaiting first complete passive cluster node"

Environment: SQL Server Enterprise Edition 2005 32 bit on Windows Server 2003 Enterprise SP1 Consider a scenario where you are installing SQL Server 2005 Servce Pack 2 on a clustered environment. Sometimes you will notice that the installation get hung Read More...
Posted Thursday, April 09, 2009 7:04 PM by sanjayap | 1 Comments

SQL Server 2005 SP2 setup might fail with the error Error 29528: The setup has encountered an unexpected error while Updating security settings on HTTP services

Few days back I worked on a case where the sql server SP2 setup was failing to install with an Error 29528 so I thought I should blog this article to address the cause of the failure and how can we resolve the issue. Problem Description: You may see the Read More...
Posted Thursday, April 02, 2009 5:12 PM by Pariks | 2 Comments

How to list all the installed SQL Server on the Server using TSQL

The SQL Server instances are independent and do not know each other. The method is to query the registry to find the instances. You can use the following Script to list all the installed sql server on the server using TSQL Solution ========= Set NoCount Read More...
Posted Friday, March 20, 2009 8:49 PM by Pariks | 1 Comments

SQL Server 2005 Setup Failing to Install on Cluster when we use an underscore in the virtual cluster name

Setup is always known to have a mind of its own; this blog is meant to demystify this process. We are specifically talking about SQL Server 2005 Setup on a cluster. It has been observed that the installation of the SQL server 2005 instance on the cluster Read More...
Posted Wednesday, March 18, 2009 5:53 PM by Pariks | 1 Comments
Filed under: ,

FAILED TO DROP Full TEXT Catalog ON A DATABASE after upgrading to sql server 2005

Consider the following scenario where you upgraded a database from sql server 2000 to sql server 2005 instance and changed the compatibility of the database to 90 and now you wish to drop the Full Text catalog which was originally created in the sql server Read More...
Posted Thursday, February 19, 2009 7:56 AM by Pariks | 7 Comments
More Posts Next page »
 
Page view tracker