SQL Server 2005 articles, fixes and updates - letter Y

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2005 starts with letter Y that have been released. The list is daily updated.

• 2729953 You may encounter a 'result == LCK_OK' assertion on a SQL Server mirror server Q2729953 KB2729953 January 25, 2021
• 2481773 You get "Error code 64" when accessing Replisapi.dll through ISA server Q2481773 KB2481773 January 25, 2021
• 917828 You may experience a decrease in query performance after you perform certain database maintenance operations or regular transaction operations in SQL Server 2005 Q917828 KB917828 January 7, 2021
• 913423 You cannot run a statement or a module that includes the EXECUTE AS clause after you restore a database in SQL Server 2005 Q913423 KB913423 January 7, 2021
• 264474 You cannot restore system database backups to a different build of SQL Server Q264474 KB264474 November 8, 2020
• 2539091 You should not disable the guest user in the msdb database in SQL Server Q2539091 KB2539091 October 20, 2020
• 2416767 You may get an error message when trying to load or save a SSIS package Q2416767 KB2416767 April 10, 2020
• 929152 You cannot connect to a local instance of SQL Server on a Windows XP-based computer or on a Windows 2000-based computer when you use "localhost" in the pipe name Q929152 KB929152 November 20, 2019
• 920201 You receive a warning message on the System Configuration Check page of the SQL Server 2005 Setup program on a computer that is running Windows Vista or a Server Core installation of Windows Server 2008 Q920201 KB920201 November 20, 2019
• 889615 You may receive a "Not associated with a trusted SQL Server connection" error message when you try to connect to SQL Server 2000 or SQL Server 2005 Q889615 KB889615 November 20, 2019
• 909678 You may receive the "System.OutOfMemoryException" error message when you use SQL Server Reporting Services Q909678 KB909678 March 29, 2019
• 910708 You must specify the domain groups for the clustered SQL Server services when you install a SQL Server failover cluster Q910708 KB910708 July 11, 2018
• 913817 You receive an error message when you use Business Intelligence Development Studio to build a SQL Server 2005 Integration Services package Q913817 KB913817 April 20, 2018
• 911003 You may receive an error message when you try to export a table by using the SQL Server Import and Export Wizard Q911003 KB911003 April 20, 2018
• 905618 You may receive a connection error message when you try to connect to an instance of SQL Server 2000 or of SQL Server 7.0 that was installed after you installed SQL Server 2005 Q905618 KB905618 April 20, 2018
• 904800 You receive an "Error loading" error message when you try to run an SQL Server 2005 Integration Services package in SQL Server 2005 Q904800 KB904800 April 20, 2018
• 839569 You may not be able to connect to an instance of SQL Server by using an anonymous login Q839569 KB839569 April 20, 2018
• 818182 You receive an "Unspecified error" error message when SQL Server accesses a linked server that uses Microsoft OLE DB provider for Jet 4.0 Q818182 KB818182 April 20, 2018
• 298147 You receive an "Invalid Class String" error when SQL Server connects to a Cluster Server through the Cluster Administrator Q298147 KB298147 April 20, 2018
• 264154 You must start an instance of SQL Server in single-user mode when you use DBCC CHECKDB/CHECKTABLE with REPAIR options Q264154 KB264154 April 20, 2018
• 235880 You receive an "Error 605" error message when you run a query with the optimizer hint NOLOCK or you set the transaction isolation level to READ UNCOMMITTED in SQL Server Q235880 KB235880 April 20, 2018
• 217395 You receive an "Error 18482" error message when you try to make a remote procedure call (RPC) from one server to another in SQL Server Q217395 KB217395 April 20, 2018
• 950891 You cannot restore a database from a backup file when you use a SQL Server login ID that has the dbcreator server role to connect to an instance of SQL Server 2005 Q950891 KB950891 April 17, 2018
• 918040 You may receive an error message when you try to run an existing CLR object or create an assembly that has the external_access or unsafe permission set on a database that is attached or restored from a different server Q918040 KB918040 April 17, 2018
• 918038 You receive an error message when you try to load an SSIS package that contains a DateTime type variable in SQL Server 2005 Q918038 KB918038 April 17, 2018
• 908711 You receive an “Explicit value must be specified for identity column” error message when you use the replication feature to run an INSERT statement on a table in SQL Server 2005 Q908711 KB908711 April 17, 2018
• 888228 You receive a "SQL Server does not exist or access denied" error message when you try to connect to a SQL Server named instance in a cluster by using TCP/IP sockets Q888228 KB888228 April 17, 2018
• 839269 You may not be able to connect to an instance of SQL Server that is configured to use the Named Pipes server network library on a computer that is running Windows XP Service Pack 2 Q839269 KB839269 April 17, 2018
• 207187 You cannot back up databases to a network drive if your account have not sufficient permissions to access the network drive Q207187 KB207187 April 17, 2018
• 943525 You cannot start the SQL Server Agent service of a failover cluster of SQL Server 2005 if the build of SQL Server is 3179 or a later build Q943525 KB943525 April 13, 2018
• 935563 You receive syntax error messages when you use transactional replication in SQL Server 2005 Q935563 KB935563 April 13, 2018
• 928317 You must perform a full database backup before you back up the transaction log for a database in SQL Server 2005 and in SQL Server 2000 Q928317 KB928317 April 13, 2018
• 914158 You receive an error message when you try to upgrade an expired installation of SQL Server 2005 Evaluation Edition to a retail version of SQL Server 2005 Q914158 KB914158 April 13, 2018
• 906892 You may experience slow performance when you run 32-bit SQL Server tools on 64-bit operating systems Q906892 KB906892 April 13, 2018
• 234748 You cannot correctly translate character data from a client to a server by using the SQL Server ODBC driver if the client code page differs from the server code page Q234748 KB234748 April 13, 2018
• 918695 You may experience a failure when you install SQL Server 2005 Service Pack 1 on an instance of SQL Server 2005 Q918695 KB918695 March 30, 2017
• 906954 You may receive an error message when you try to run distributed queries from a 64-bit SQL Server client to a linked 32-bit SQL Server Q906954 KB906954 March 30, 2017
• 906549 You may receive a "Permission denied" error message when an application role-based application tries to select records from any one of the system tables in a SQL Server 2005 master database Q906549 KB906549 March 30, 2017
• 915850 You may experience a 45-second delay when you run a full-text query in an instance of SQL Server 2005 that is running on a server without Internet access Q915850 KB915850 February 16, 2017
• 914779 You may receive error messages when you use the Configure Distribution Wizard in SQL Server 2005 Q914779 KB914779 February 16, 2017
• 907267 You may not be able to access Reporting Services after you create an application pool that runs under the LocalSystem account Q907267 KB907267 February 16, 2017
• 923317 You obtain incorrect results when you run a full-text search query that uses a thesaurus file in SQL Server 2005 Q923317 KB923317 December 9, 2015
• 917135 You receive an access violation error message when you use the Microsoft Application Verifier to monitor the Sqlservr.exe program for SQL Server 2005 Q917135 KB917135 December 9, 2015
• 900487 You cannot connect to a default instance of SQL Server 2005 through a firewall by using the SQL Server networking interface (SNI) Q900487 KB900487 December 9, 2015
• 975439 You receive an HTTP Error 403 page when you access the Reporting Services virtual directory for System Center Operations Manager 2007 after you upgrade to Windows Server 2008 Q975439 KB975439 January 16, 2015
• 912434 You cannot open the SQL Server Mobile Setup Help file in the SQL Server Mobile Server Tools installation wizard Q912434 KB912434 January 15, 2015
• 918325 You cannot install SQL Server 2005 Service Pack 1 if sufficient disk space is unavailable Q918325 KB918325 November 2, 2013
• 915848 You obtain inconsistent version information after you install SQL Server 2005 Service Pack 1 Q915848 KB915848 November 2, 2013
• 947989 You cannot install SQL Server 2005 Service Pack 2 when the database file of the Resource database is not in the same folder as the log file of the Resource database Q947989 KB947989 November 1, 2013
• 934652 You cannot install SQL Server 2005 Service Pack 2 on a computer that is running SQL Server 2005 Reporting Services after you install the .NET Framework 2.0 Q934652 KB934652 November 1, 2013
• 2009037 You are not able to install Full Text search resource on a SQL Server 2005 SP3 cluster Q2009037 KB2009037 October 24, 2013
• 303411 You receive a "Warning SuperSocket Info" warning information when a SQL Server service account is a domain user Q303411 KB303411 April 7, 2013
• 2745448 You cannot start SQL Server Reporting Services after you apply the update that is discussed in KB 2677070 Q2745448 KB2745448 January 22, 2013
• 910864 You cannot start the SQL Server service when you enable the Virtual Interface Adapter (VIA) network protocol in SQL Server 2005 Q910864 KB910864 October 22, 2012
• 2019779 You may receive incorrect values when using SCOPE_IDENTITY() and @@IDENTITY Q2019779 KB2019779 February 23, 2012
• 913854 You receive an error message when you try to switch to the Neural Network mining model in SQL Server 2005 Analysis Services Q913854 KB913854 October 9, 2011
• 930410 You may unexpectedly receive a NULL value when you run a Multidimensional Expressions (MDX) query in SQL Server 2005 Analysis Services Q930410 KB930410 October 8, 2011
• 2555855 You encounter error messages when you execute linked server queries without the required providers installed Q2555855 KB2555855 June 20, 2011
• 2983332 You cannot open a Business Intelligence project after you upgrade the project to the format that is used by Visual Studio 2010 Q2983332 KB2983332 March 24, 2011
• 983332 You cannot open a Business Intelligence project after you upgrade the project to the format that is used by Visual Studio 2010 Q983332 KB983332 March 24, 2011
• 2009672 You may get "Unable to prepare the SSIS bulk insert for data insertion" error on UAC enabled systems Q2009672 KB2009672 October 22, 2010
• 2020715 You are not able to migrate your Oracle or Sybase databases to a case-sensitive SQL Server database using SSMA Q2020715 KB2020715 October 4, 2010
• 2008303 You have to reinstall some drivers when you install SQL Server 2005 Q2008303 KB2008303 September 14, 2010
• 932897 You cannot find SQL Server cluster resources in Failover Cluster Manager after you install a SQL Server 2005 failover cluster on a computer that is running Windows Server 2008 Q932897 KB932897 September 11, 2010
• 2018991 You get #Error message when using large XML datasets in SQL Reporting Services Q2018991 KB2018991 April 29, 2010
• 947988 You cannot install SQL Server 2005 Service Pack 1 on a SQL Server 2005 failover cluster if the failover cluster is behind a firewall Q947988 KB947988 April 16, 2010
• 2009312 You get "DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER" error message when using Oracle connection manager in SSIS Q2009312 KB2009312 February 24, 2010
• 2009212 You are not able to browse SharePoint pages in non-default zone after uninstalling Reporting Services add-in Q2009212 KB2009212 January 19, 2010
• 2009225 You receive a “Connections to SQL server files (.mdf) require SQL Server Express 2005 to function properly.” exception when adding a new SQL Server database in App_Data folder. Q2009225 KB2009225 December 15, 2009
• 976419 You cannot connect to an instance of SQL Server Analysis Services from an application in Windows 7 or in Windows Server 2008 R2 after you install Office Live Add-in 1.4 or Windows Live ID Sign-in Assistant 6.5 Q976419 KB976419 October 22, 2009
• 2003580 You may get "The group or resource is not in the correct state to perform the requested operation" when rebuilding system databases on a SQL Server 2005 virtual server Q2003580 KB2003580 October 9, 2009
• 2003582 You cannot add a table article to an Oracle publication if its primary key is partitioned Q2003582 KB2003582 October 8, 2009
• 975651 You cannot connect to an instance of SQL Server Analysis Services from an application in Windows 7 or in Windows Server 2008 R2 after you install Office Live Add-in 1.4 or Windows Live ID Sign-in Assistant 6.5 Q975651 KB975651 September 29, 2009
• 2000395 You may notice performance issues when using date literal values in distributed queries with third party OLEDB providers from SQL server. Q2000395 KB2000395 September 14, 2009
• 2000373 You may not be able to make a remote connection to SQL Server from a CLR trigger Q2000373 KB2000373 August 6, 2009
• 927797 You cannot specify a USB-based tape drive as a backup device in SQL Server Q927797 KB927797 August 6, 2009
• 2000471 You may notice a continuous growth in tempdb data file size with a corresponding increase in mixed_extent_page_count after upgrading SQL server Q2000471 KB2000471 July 24, 2009
• 970878 You may receive a "FCB::RemoveAlternateStreams: Operating system error <error number>" when starting up databases on an instance of SQL Server 2005 or SQL Server 2008 Q970878 KB970878 May 1, 2009
• 954784 You obtain no result when you use an aggregate in a filter in Report Builder of SQL Server 2005 Reporting Services Q954784 KB954784 June 30, 2008
• 953201 You receive a "Creating the partitioned snapshot" message when you create a pull subscription that is configured to receive the precomputed partition of a merge publication in SQL Server 2005 Q953201 KB953201 June 26, 2008
• 954467 You do not receive an error message when you run the DBCC CHECKDB statement against a database in SQL Server, but an access violation occurs when you run a query on a table in the database Q954467 KB954467 June 25, 2008
• 938608 You receive an error message after you install SQL Server 2005 Service Pack 2 when you try to edit a Script component that is inside an SSIS package and the SSIS package was created in an earlier version of SQL Server 2005 Q938608 KB938608 June 16, 2008
• 929907 You may be unable to perform most database operations after you log on to an instance of SQL Server 2005 Express Edition Service Pack 1 on a Windows Vista-based computer Q929907 KB929907 June 16, 2008
• 919131 You may experience problems when you try to run a SQL Server 2000 DTS package after you upgrade all the instances of SQL Server 2000 to SQL Server 2005 Q919131 KB919131 June 16, 2008
• 910851 You receive error messages when you try to set up a clustered instance of SQL Server 2005 Q910851 KB910851 June 16, 2008
• 944527 You obtain no result set when you run an MDX query against an instance of SQL Server 2005 Analysis Services Q944527 KB944527 June 13, 2008
• 931846 You may be unable to execute SQL Server 2005 Integration Services packages that contain script tasks or script components Q931846 KB931846 June 13, 2008
• 912432 You receive a compiler error message when you call the Dispose(BooleanParameter) method of the SqlCeDataReader object in a SQL Server 2005 Compact Edition project or in a SQL Server 2005 Mobile Edition project Q912432 KB912432 March 27, 2008
• 948907 You receive error messages after you uninstall SQL Native Client from a server that is running SQL Server 2005 Q948907 KB948907 February 28, 2008
• 947509 You may obtain an incorrect result when you run an MDX query against an instance of SQL Server 2005 Analysis Services if the WHERE clause contains a set Q947509 KB947509 February 13, 2008
• 947512 You cannot connect to SQL Server 2000 Analysis Services on a server that is running a 64-bit instance of SQL Server 2005 and a 64-bit instance of SQL Server 2005 Analysis Services Q947512 KB947512 January 30, 2008
• 946089 You encounter a problem with a subscription that uses the file share delivery extension in SQL Server 2005 Reporting Services or in SQL Server 2008 Reporting Services after you upgrade Windows Server 2003 to Windows Server 2008 Q946089 KB946089 December 27, 2007
• 945374 You cannot compile a SQL Server Compact-based OLE DB application for Windows Mobile 5.0, and the Transact.h file cannot be found Q945374 KB945374 December 13, 2007
• 937684 You may be prompted to restart the computer after you install the 64-bit version of SQL Server 2005 Service Pack 2 even if the Setup program does not report that some components are locked Q937684 KB937684 November 20, 2007
• 931976 You may be prompted to enter the old password when you try to reset the password of a SQL Server login by using a SQL Server login that is a member of the securityadmin fixed server role in SQL Server 2005 Q931976 KB931976 November 20, 2007
• 928320 You cannot use existing tables on a heterogeneous subscriber database when you configure a push subscription to a heterogeneous subscriber in SQL Server 2005 Q928320 KB928320 November 20, 2007
• 922647 You cannot debug assemblies that are referenced in the Script task code by using Visual Studio for Applications in SSIS Q922647 KB922647 November 20, 2007
• 922546 You receive a "No description found" error message when you create an SSIS package or a SQL Server maintenance plan in SQL Server 2005 Q922546 KB922546 November 20, 2007
• 921902 You receive a "Sample database 'Adventureworks' already exists in SQL instance specified" error message when you use Add or Remove Programs to install the AdventureworksDW Sample Data Warehouse sample database in SQL Server 2005 Q921902 KB921902 November 20, 2007
• 916782 You may receive an error message when a SQL Server 2005 client requests encryption and connects to 127.0.0.1 on a Windows XP-based computer Q916782 KB916782 November 20, 2007
• 912430 You cannot replicate data from SQL Server 2005 to SQL Server Mobile Edition by using the 64-bit version of IIS Q912430 KB912430 November 20, 2007
• 943635 You cannot rebuild system databases if you run the Setup command from a location that is not the original installation location of SQL Server 2005 Q943635 KB943635 October 31, 2007
• 839405 You may receive an access violation exception when you try to use SQL Mail on a multiprocessor computer Q839405 KB839405 March 19, 2007
• 926629 You cannot connect to an instance of SQL Server 2005 Integration Services by using SQL Server Management Studio after you install an SSIS hotfix on a computer that has a 64-bit processor Q926629 KB926629 March 6, 2007
• 259561 You receive a "Cannot open user default database <ID>. Using master database instead." error message when you connect to a SQL Server database Q259561 KB259561 February 22, 2007
• 239530 You must precede all Unicode strings with a prefix N when you deal with Unicode string constants in SQL Server Q239530 KB239530 February 22, 2007
• 931292 You may experience decreased performance when you run queries against a cube that contains linked dimensions in SQL Server 2005 Analysis Services Q931292 KB931292 February 2, 2007
• 907739 You cannot modify a SQL Server Agent job for an instance of SQL Server 2000 in SQL Server Management Studio when you connect to the instance by using an account that is not a member of the SQL Server sysadmin fixed server role Q907739 KB907739 January 31, 2007
• 908038 You may receive an error message when you try to add a user control to a Windows Forms-based application if the user control contains a data-binding object that uses an attached local database file in Visual Studio 2005 Q908038 KB908038 June 12, 2006
• 915854 You receive an error message when you try to uninstall the second named instance of SQL Server 2005 Q915854 KB915854 April 18, 2006
• 914638 You receive a NULL value when you use XQuery to retrieve the value of an XML element in SQL Server 2005 Q914638 KB914638 April 6, 2006
• 912136 You may experience problems after you run the Business Intelligence Wizard to add time calculations in SQL Server 2005 Analysis Services Q912136 KB912136 April 5, 2006
• 915180 You can no longer enlist the target server into the master server after you change the service account for the SQL Server Agent service Q915180 KB915180 April 4, 2006
• 904796 You cannot run or schedule various packages that require SQL Server 2000 Meta Data Services files after you upgrade to SQL Server 2005 Q904796 KB904796 March 11, 2006
• 841394 You may not be able to connect to an instance of SQL Server that is configured to use the TCP/IP server network library on a computer that is running Windows XP Service Pack 2 Q841394 KB841394 December 1, 2005
• 302223 You receive an "Error 14114: (NULL) is not configured as a distributor" error message when you try to set up a SQL Server server as a distributor for replication Q302223 KB302223 November 30, 2005
• 908454 You cannot upgrade a named instance of SQL Server 2000 to SQL Server 2005 on a computer that is running the Itanium-based operating system Q908454 KB908454 November 1, 2005