.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Cumulative update 1 for SQL 2005 SP3 issue

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :Sql Server


Lately i applied CUmulative update 1 for SQL 2005 SP3 in one of our production sharepoint database clusters.Today some users reported that they cannot open the macro's enabled excel spreadsheets in sharepoint. spreadsheets that do not have macros or other file formats do not have any problem.I wanted to check if this issue could be due to SQL CU1 patching.

Please help.



View Complete Post

More Related Resource Links

2005 SP3 Cumulative Update



I noticed that cu should apply to affected system that with specific issues with fixes.  cu4 contains fix that allow to use "Locked pages in memory".  Is that safe to apply cu just for that?



Cannot install Cumulative Update 11 for SQL Server 2005


Please note: running as a Domain Admin, FTData folders all exist, SIDs are correct for the relavnt user groups, Full Control permission given to Administartors group for WMI yet stull:

Cannot install Cumulative Update 11 for SQL Server 2005

Sumary.txt extract;

Product Installation Status
Product                   : SQL Server Database Services 2005 (MSSQLSERVER)
Product Version (Previous): 4211
Product Version (Final)   :
Status                    : Failure
Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB2258854_sqlrun_sql.msp.log
Error Number              : 11032
Error Description         : Unable to install Windows Installer MSP file

Hotfix.log extract:

09/22/2010 21:20:28.175 Installing product: SQL9
09/22/2010 21:20:28.635 Registry: Opened registry key "Software\Micr

SQL 2005 migration issue

Hey everyone, I do not know anything about SQL, so hopefully someone can help me out. Installed SQL 2005 on a new server.  Restored a database from SQL7. The database I restored is called "train" for example and in that database is a user called "train_user" I cannot connect to the obdc data source using this "train_user".  I do not know if the password didn't carry over during the migration and don't even know how to check or change this password.  I don't know if this user needs certain privileges to be able to access the SQL server?  They are the db owner of the database that I restored.  The application I am trying to launch gives me the odbc error.  This info is stored in an ini file.  If I change this info to sa, then I can access the application. If I need to provide more info, I can do that, but hopefully someone understands what is going on or what I need to do to fix it. Here is the error code:  Error: 18456, Severity: 14, State: 5.

SQL Server 2005 Express Edition Service Pack 3 (KB955706) update is successful but repeats installin

  Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) (update 1 of 1) This update seems to be stuck in a loop of installing, each time it successfull installs acccording to automatic updates. Then says it requires installing again straight away. This has been happening for 10 days now. I have tried a manual update from the website rather than automatic updates, no change. Any ideas why? Have posted in Windows update which is where I think the problem lies but they have suggested I post here also.

Kerberos issue with SQL Reporting Services 2005 on Server 2003 R2

Hi Guys,apologies if this is the incorrect forum, so moderators, feel free to move it to SQL/IIS/SharePoint as appropriate... [Windows Server Security moderator pushed me this direction]I have a test environment that I'm trying to get SQL Reporting Services 2005 SP3 working in integrated mode with SharePoint 2007 SP2.The environment is all in VMWare, running Server 2003 R2 x86 and is layed out like this:SERVER A:AD/DNS/DHCPSERVER B:SQL 2005 SP3 CU8SERVER C:SharePoint 2007 SP2 Dec 09 CU- Central admin on port 9000- SSP on port 9001- MySite on port 81- Main Content on port 80SQL Reporting Services 2005 SP3 CU8- Reporting Service website on port 82SERVER D:SharePoint 2007 SP2 Dec 09 CU- Central admin on port 9000- SSP on port 9001- MySite on port 81- Main Content on port 80SQL Reporting Services 2005 SP3 CU8- Reporting Service website on port 82Through the use of DNS and (SharePoint) Alternate Access Names, SERVER D is used to deliver the Main Content in SharePoint and the Reporting Service website.  SERVER C is used to deliver the Central Admin, SSP and MySite.I've set up SPN's for the SharePoint App Pools, using the following: [main content] setspn -S HTTP/SERVERA DOMAIN\AppPoolUserA setspn -S HTTP/SERVERA.FQDN DOMAIN\AppPoolUserA setspn -S HTTP/SERVERB DOMAIN\AppPoolUserA setspn -S HTTP/SERVERB.FQDN DOMAIN\AppPoolUserA [repor

MSAS 2005 vs 2008 - different results of an UPDATE CUBE instruction

Hi ALL!   When moving from SSAS2005 to SSAS2008 I have a problem with write enabled cubes. On SSAS2005 UPDATE CUBE instruction occures almost instantaneously but on SSAS 2008 this takes few seconds. I created a cube with one dimension and one measure for testing. No aggregations, fact table initially empty, measure has 3 elements. Profiler shows that SSAS2008 UPDATE CUBE instruction initiates cube processing, but SSAS2005 doesn’t do this. What's wrong? Please, help! SSAS2005 Profiler: http://savepic.ru/1593644.jpg SSAS2008 Profiler: http://savepic.ru/1584428.jpg   Thnx!

Cumulative Update CU4 For SSRS 2008

trying to download CU4 For SSRS 2008 SP1, I'm confused as to what the different suffixes mean at the end of the CU name, I seeRRB2ClickOnSNACRSSharepoinCan someone explain to me what these are or what the differences are?  SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_CU_Updated_Ref_KB_976761 2008 10.00.2740.00 237625057 11/4/2009 7:06:28 PM SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_Cumlative_Update_4_RRB2ClickOn 2008 10.00.2734.00 122189228 9/22/2009 4:18:56 PM SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_Cumlative_Update_4 2008 10.00.2734.00 237547729 9/22/2009 7:13:01 AM SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_Cumulative_Update_4_SNAC 2008 10.00.2734.00 7012764 9/22/2009 7:23:53 AM SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_Cumlative_Update_4_RSSharepoin

SharePoint 2010 Cumulative Update - Install sequence - Foundation required or not?

For a SharePoint 2010 Server (not Foundation) environment, is it necessary to install the Foundation Cumulative Update as well as the Server Cumulative Update?  (In the same way that with 2007, you install the WSS update and then the MOSS update) The nearest I have found to an answer is here: http://technet.microsoft.com/en-gb/sharepoint/ff800847.aspx where it says 'We recommend that you always install SharePoint Foundation 2010 patches before installing SharePoint Server 2010 patches. This best practice ensures that you will always be successful when installing updates.'   In this regard, should 2010 Foundation be thought of as a pre-req, or underlying component, for 2010 Server?   The same question applies to the use of the Updates folder in the install media - for a Server install, should we be extracting both the Foundation and Server Cumulative Updates there, for a correct slipstreamed install?   Thanks.   Rob

Issue with transactional replication on SQL 2005 SP3 using row filters with bit columns

We recently upgraded from SQL 2000 to SQL 2005 SP3 and I am noticing something that I think is a bug with replication from a publication that has an article in it with row filters.  It seems to be that if the row filter has columns that are bit datatype and that column is updated on the publisher to cause the row filter to exclude it, it is not removed from the subscriber.  If you update a column that is part of the row filter that is not a bit datatype it works as expected.  I can reproduce this in a test environment with a small base table.  In production this is resulting in an occasional 20598 error "The row was not found at the Subscriber when applying the replicated command". Is anyone aware of a hotfix that addresses this? I can think of a few work arounds but the table is rather large and I really would like to avoid having to pull replication, re-snap or changing datatypes on the base table etc. Any suggestions are greatly appreciated.  Thanks!

SQL Server Express 2005 connection timeout issue.

Client: Sql Sever Management Studio Express 2005 (SSMSE) on Vista Server: Sql Server 2005 Express on Windows Server 2008 Standard When I first try to log into SSMSE from the client machine, the login operation times out. When I retry, the login succeeds almost immediately. If I close the app and re-open it, the same thing happens. This appears to be infinitely repeatable. I am able to reproduce this behavior using SQLCMD.exe. Here's the error: "Timeout expired. The timeout elapsed prior to completion of the operation or the server is not responding. (Microsoft SQL Server)" The technical details reference Error Number -2 What may be unique or tricky about this client's network is that it's a mixture of IPv4 and IPv6. I believe the server is configured for both, but honestly the networking side of things is outside of my expertise. Has anyone else experienced a problem like this? I'm looking for some troubleshooting tips and of course a flat-out answer :-). Thank you in advance for your time and expertise - I hope I've broken the problem down to its simplest form. Will.

Issue in SMO DB transfer from SQL 2005 EE to SQL 2008 EE SP1

Hi All, I am transferring DB from SQL Server 2005 EE to SQL 2008 EE SP1 using SQL Server SMO. I am using the TransferData method of Transfer object. I am facing a problem where it creates the DB on 2008 instance but does not create any table, view and procedures. This is not getting reproduced every time. The error that caught in code reads below:   ERROR : errorCode=-1073548784 description=Executing the query "CREATE TABLE [dbo].[table1]( [ParamKe..." failed with the following error: "The log for database 'sadb20052008' is not available. Check the event log for related error messages. Resolve any errors and restart the database.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. helpFile= helpContext=0 idofInterfaceWithError={C81DFC5A-3B22-4DA3-BD3B-10BF861A7F9C} For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.   I checked the SQL Server logs and it is reading as below. I enabled the deadlock logging by setting the SQL Server service startup parameters to -T1204, -T1205, -T3605 and found the log as given below. How can I debug it to find the root cause and resolve it?   2010-04-06 16:50:28.31 spid7s Deadlock encountered .... Printing deadlock information 201

Implementing Cumulative Beta Distribution function in Sql server 2005.

Hi,   I am trying to implement BETADIST function which is present in Excel through Sql Server Integration Services(SSIS). Can any body help me on this.   Thanks in advance, Prasad Palaparthy.

Issue with Enable and Disable Parameters in SSRS 2005

Hi Guys, I am currently facing an issue with Enabling and Disabling Parameters in SSRS 2005. Here is my scenario. I am having the following 4 parameters - ParamType (has values 1,2,3), ParamMonth, ParamStartDate, ParamEndDate Now What I want is When I select ParamType = 1 and 2 then ParamMonth should be enabled and ParamStartDate and ParamEndDate should be disabled. When I select ParamType = 3 then ParamStartDate and ParamEndDate should be enabled and ParamMonth should be disabled. I have done google search on this issue and found out that this is not possible at run time. Is there any alternative for this issue? If the above is not possible, I would like to get atleast in this way : When I select ParamType = 1 and 2 then ParamMonth should show the values (from dataset named MonthDataSet and default should be the latest Month) and ParamStartDate and ParamEndDate should show as NULL. When I select ParamType = 3, then I need to enter ParamStartDate and ParamEndDate values manually or pick via datepicker and ParamMOnth should show as NULL. I am not sure whether this is possible or not....but just trying to get in some way. Here is the query used in MonthDataSet : Select Month_Code, Month_Name from MonthTable. Thanks

Update SQL Server 2005 SP3 KB970892

Hi guys, When I try to install the SP at the server with SQL 2005 Express Edition I get the following error message: EventID: 1023 Source: MsiInstaller Product: Microsoft SQL Server 2005 Express Edition - Update 'GDR 4053 for SQL Server Database Services 2005 ENU (KB970892)' could not be installed. Error code 1603. Additional information is available in the log file C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB970892_sqlrun_sql.msp.log. EventID: 10005 Source: MsiInstaller Product: Microsoft SQL Server 2005 Express Edition -- Error 29528. The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation. I tried this article but it does not help: http://support.microsoft.com/kb/925976/de I read an article to install some iis components but is this realy necessary? Thank a lot and best regards Christian LOG: === Verbose logging started: 9/9/2010  13:53:24  Build type: SHIP UNICODE 5.00.7600.00  Calling process: d:\51983bd1d61113e85006\hotfix.exe === MSI (c) (D8:18) [13:53:24:868]: Resetting cached policy values MSI (c) (D8:18) [13:53:24:868]: Machine policy value 'Debug' is 0 MSI (c) (D8:18) [13:53:24:868]: ******* RunEngine:            ******* Product: {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}   

Character spacing issue SSRS 2005 custom font

Hello together, we are facing a strange character spacing issue in SSRS 2005 SP3 (Version 9.00.4035.00). As we export the report to a pdf file, we get unwanted spaces between each character. The report uses custom fonts. Is there any known issue related to this? I appreciate your help. Thanks!  Kind regards Moritz Mars

Problem installing Cumulative Update 6 for SQL 2008 SP1 on Windows XP

I am attempting to apply SQL Server 20008 SP1 Cumulative Update 6 on my Windows XP desktop. The update executable is unpacked and I get a brief flash of a Command Screen and then nothing. I have searched for any update files but have not found any. My Desktop Configuration: Windows XP SP3, Windows Installer 4. SQL Server 2008 SP1 Developer Edition. I am also attempting to install the Client Tools for SQL 2008R2 on this same desktop and am getting the same results. I click on SETUP and get a brief flash of the Command Screen and the installation does not continue. Internet searches speak of a problem with a registry entry in the Boostrap Key for a valid Setup directory, but this key exists in my desktop registry. Thanks,

Cumulative Update Webcasts

Is Microsoft planning to have CU webcasts (like Project/Project Server) to describe the CUs in more detail and allow Q & A?  It is VERY useful and informative.BT
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend