I have Vista Ultimate (IIS Enabled), SQL Server 2005 Developer Edition
(downloaded and ran the SP2 Update), Visual Studio 2008. VS2008
installs no problem. When I install SQL Server 2005, I get an error
when it trys to install the last part( Workstation Components,
Management Studio, etc).
I have tried FULLY, MANUALLY removing all SQL products and registry
entries. I have used Windows Installer Cleanup Utility. I have tried
Microsoft's recommended way of manually removing SQL Server 2005.
If I manually run SqlRun_Tools.msi the error comes up right away.
The error is:
"A component that you have specified in the ADD_LOCAL property is
already
installed. To upgrade the existing component, refer to the
template.ini and
set the UPGRADE property to the name of the component."
Here's the Setup Error log: http://toby.pastebin.com/f63405e24
I have Vista Ultimate (IIS Enabled), SQL Server 2005 Developer Edition (downloaded and ran the SP2 Update), Visual Studio 2008. VS2008 installs no problem. When I install SQL Server 2005, I get an error when it trys to install the last part( Workstation Components, Management Studio, etc). I have tried FULLY, MANUALLY removing all SQL products and registry entries. I have used Windows Installer Cleanup Utility. I have tried Microsoft's recommended way of manually removing SQL Server 2005. If I manually run SqlRun_Tools.msi the error comes up right away.
The error is: "A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the name of the component."
Here's the Setup Error log: http://toby.pastebin.com/f63405e24 Any help?! Thanks! -Toby
I've got VS 2008 Pro installed, as well as SQL Sever 200 (which I must keep installed). When I run the install for SQL Server 2005 developer edition, it continually fails to install
I had a perfectly good working copy of SQL Server 2005 installed. However, at some point I needed the Report Services Designer so I could edit my reports in Visual Studio. I inserted the CD and selected the feature from the list and it installed. Only problem being that it has completely removed my Management Studio and practically every other tool I didnt explicitly checked when installing the RS Designer.
When I tried to run the same Setup again and check everything, it tells me that there is no change between what I have selected and what is installed, which sounds like total bs to me, since my pc doesnt have a management studio etc anymore.
Out of pure misery I decided to remove my entire SQL Server installation, inc Instance, hoping to start anew and achieve the result I wanted with the least amount of frustration. I ended up here and followed it all the way: http://support.microsoft.com/kb/909967
When I started reinstalling, I ran into something new. The installer refuses to let me install anything but the Workstation components, books online and development tools. All the other options are greyed out and not even available.
Someone please help me get my SQL Server back up and running because I'm getting hopeless.
When I install SQL Server 2005, it all goes well except that it fails to install these two:
- SQLXML 4
- workstation components and tools
When I try to install these two from the CD in the Setup folder of the CD 2 with the files sqlxml4.msi and sqlRun_Tools.msi (if I remember these names correctly), it gives me an error:
'Ce package d'installation n'est pas pris en charge par ce type de processeur'
Sorry. My SQL CDs are in french, but it roughly translates to the message:
This installation package is not taken by this processor.
I thought that my hardware configuration does not meet the requirements. But I have a Pentium 4, 2Gig RAM, over 100Gig free HD space. Also I tried to install on other computers to no avail. This is a fresh install, that is, there is no previous SQL Server 2000 in it, no VS.NET 2005 or before. Nothing. I have just a fresh, new computer.
Hello. I am trying to install only the Workstation Components portion of SQL Server 2005 and I get about halfway through and the installation errors out. The error is:
This happens after the second disk of the installation is about halfway through installing and then it throws an error stating that "The wrong volume is in the drive. Please insert volume SQLSRVRS into drive D. Cancel, Try Again, Continue" I replace the disc with the first disc and if I pick "Continue" it will display the error above. If I pick "Try again" the installation finishes, but there are components missing from Visual Studio.
I've tried looking for a solution in other threads but I couldn't find anything that was completely the same as my situation. I got a new pc at work and I've tried installing SQL Server 2005 on it but everytime I try to install it, regardless of services included or excluded with the install, I cannot get through the install without this error. Below is the excerpt from the Summary.txt log file.
Error Code: -2147024894 MSI (s) (74!98) [17:10:55:858]: Product: Microsoft SQL Server 2005 Tools -- Error 29549. Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894 Error message: The system cannot find the file specified. Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
Error 29549. Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894 Error message: The system cannot find the file specified. Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlAssemblyRegSvcs PerfTime Start: Do_sqlAssemblyRegSvcs : Mon Nov 12 17:10:55 2007 <Func Name='Do_sqlAssemblyRegSvcs'> Failed to install and configure assemblies C:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: 2147942402 Error message: The system cannot find the file specified. Error descrition: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. Error Code: -2147024894 Windows Error Text: The system cannot find the file specified. Source File Name: sqlcasqlassembly.cpp Compiler Timestamp: Thu Aug 11 01:12:01 2005 Function Name: Do_sqlAssemblyRegSvcs Source Line Number: 155
I've searched for and found similar problems that deal with the microsoft.sqlserver.notificationservices.dll not being found but I haven't found a fix that worked for me. These are the fixes I've refered to thus far.
The answer that seems to fix this problem for everyone is to set the MSDTC service login as the NT AUTHORITYNetworkService account. The problem for me is that this is already set to this profile and I've tried resetting the services and rebooting the machine. I did not have a problem with my old machine, which as far as I can tell, is the same configuration, so I know this install should work.
I'm running Windows XP SP2. This is not the upgrade to SQL Server 2005 SP2, this is the original disk that came with Visual Studio 2005.
Has anyone else faced this issue where changing the MSDTC login wasn't the solution? Also, this is my first post, so I apologize if I've left anything out. Just let me know if you want any other information.
I'm currently receiving the following error message whilst attempting to install SQL Server 2005 Standard Edition on Windows Server 2003 (32 Bit): Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.
This server already has an install of SQL Server 2000 as the default instance. I'm attempting to install a new named instance of SQL Server 2005.
Extract from log:
<Func Name='LaunchFunction'> Function=Do_sqlPerfmon2 <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='0'> Doing Action: Do_sqlPerfmon2 PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007 <Func Name='Do_sqlPerfmon2'> <EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'> PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007 MSI (s) (4C:FC) [10:20:02:833]: Executing op: ActionStart(Name=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing performance counters,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_Do_sqlPerfmon2,CustomActionData=100Removing performance counters200000DTSPipelineC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INI) MSI (s) (4C:FC) [10:20:02:849]: Executing op: ActionStart(Name=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing performance counters,) MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlPerfmon2,CustomActionData=100Installing performance counters200000C:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INIC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.HC:Program FilesMicrosoft SQL Server90DTSBinnDTSPipelinePerf.dllDTSPipeline0DTSPipelinePrfData_OpenPrfData_CollectPrfData_Close) MSI (s) (4C:94) [10:20:02:864]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI1683.tmp, Entrypoint: Do_sqlPerfmon2 <Func Name='LaunchFunction'> Function=Do_sqlPerfmon2 <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='0'> Doing Action: Do_sqlPerfmon2 PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007 <Func Name='Do_sqlPerfmon2'> <EndFunc Name='Do_sqlPerfmon2' Return='2' GetLastError='2'> PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007 Gathering darwin properties for failure handling. Error Code: 2 MSI (s) (4C!F0) [10:23:46:381]: Product: Microsoft SQL Server 2005 Integration Services -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.
You can ignore this and it will complete the installation, but subsequently trying to patch with SP2 will fail on the same sections - Hotfix.exe crashes whilst attempting to patch Database Services, Integration Services and Client Components (3 separate crashes).
I've removed SQL Server 2005 elements and tried to re-install, but it's not improved the situation.
I recently installed VB6.0 Enterprise on my system. As a part of the installation is the option to install SQL Server 6.5 Development. I elected to install SQL. The install went without any glitches. Upon going into SQL Enterprise Manager, I was asked to register the server where SQL was running. My understanding was that SQL would allow me to register the name of my host system. (This is a stand alone system with VB6.0 and Sql development 6.5 installed - no network attached). SQL will not allow me to register my server's name as the host server. It says that if cannot connect to the named server. SQLSERVER and SQL EXEC services appear to be running without any problems. Anyone have any idea where I should start or what could be disallowing my connection/registeration of my server. Any help would be greatly appreciated..... Thanks... Tom
Developers wanting to access sql server developer edition on XP workstation in small office network (workgroup) will have problems using windows authentication (trusted connection) if the XP "server" machine has "simple file sharing" enabled.
Simple file sharing in XP can be disabled in control panel - folder options.
For this sneak mode to work accounts with the same user and password should exist on both "client" and "server".
Hi all!Is there any function in SQL that I can use to get current date fromworkstation? All functions which I tried (now(), getdate() etc.)returns current date from server but I need date from workstation.Regards,Mirnes Lemes
I would like to know if one can adminiter SQL server remotely using MMC on NT workstation? If so, how do you install the MMC and SQL Enterprise Manager Add-in on NT workstation?
How can I configure my workstation running WIN95 to used the SQL Enterprise Manager from the server end and other utilities. I have installed the client network utility.
Reason to use enterprise manager because I wanted to perform administrative tasks on my workstation and I've installed SQL SERVER 7.0(Standard version with 5 clients)on the WINNT 4.0 server.
Hi all;I am trying to replicate our database by using the merge replication.[color=blue]>From server side I tried to connect to the workstation. I have[/color]installed MSDE to the client machine. I can see the machine name on theSQL Server Group however I wasnt able to create the conncetion betweenthe machines. I have checked my network connection, there is no problemI can see the machine and I can connect it through the network. I triedto use Client Network Utility with Named Pipes and TCP/IP but not agood news. I couldnt achieve to connect to the machine. So couldsomeone please help me out with this problem. I am really in trouble Ihave to find out this end of this week.RegardsAs
It appears that there is no way to install SQL Server 2005 Workstation Components on an x86 operating system (XP in this case) if you have the x64 install disks (Standard Edition). Can someone verify this?
I am finding it hard to believe that workstation components for a standard Windows client environment are not distributed with the version of SQL Server that matches Windows 2003 x64.
I have the following connection string in my Windows app that works fine on the Server: workstation id=SCSXP;packet size=4096;integrated security=SSPI;data source=scsxp;persist security info=False;initial catalog=nala But when I use that string on a workstation, it times out. I do have a Network connection to the Server. How should I modify the connection string to work on the workstation? Thanks, Bill
I am running SQL 7 (SP3) on a 2000 Server. When I configure the server as part of the Workgroup I have no problems connecting from the workstation. However, if I join the server to our 2000 domain, I cannot connect and/or register the server from the workstation through EM.
Is this a security issue? If so, what are the minimum requirements or what else am I missing. Any suggestions would be appreciated.
Hi again, could anyone tell me what to do about this...I'm not a dba but I do need direct access to the sql server such as scheduling new jobs (I can execute them immediately as pkgs or even run them as jobs on my machine, but to schedule I need to go to the server. The NT administrator does not like the idea of anyone else touching his server, so is there any way to circumvent the situation and do the scheduling from my workstation? Someone had mentioned creating an icon on my desktop but I'm not clear on the idea. Thanks a million. I get great help on this website.
I have installed SQL 6.5 client tool on to my workstation. Since then, we have upgraded to SQL 7.0 on our server. I installed SQL 7.0 client tool to my workstation and have been using it. I want to remove SQL 6.5 client tool from my workstation and do not know how. There is no uninstall button in the SQL 6.5 folder nor this program exists in Add/Remove Program in COntrol Panel. Can you help? Thank you.
Could someone please tell me what I have to set at the Server side so that I will be able to STOP and START the SQL Server using Enterprise Manager and `sa` login remotely, say from the workstation.
I have 3 NT Workstations that will not connect to my SMS database using NT Integrated Security. The SQL 6.5 server is set up to use mixed security. The only way to connect to the server is to use a standard sql account. Any ideas? THis happens to all users even administrators.
This might not be a SQL Server question, might be something else. Ihave a workstation on a LAN that can't connect to the SQL Server. WhenI try to configure a User DSN to connect to it, the server name I wantappears TWICE in the list of possible servers. No matter which one Iselect, it can't get the connection.The workstation also can't connect through EM or QA.We've checked the user's permissions, we've re-installed some serverpacks, re-installed the Client Tools, we've even hunted through theregistry, everything looks OK, but we still can't connect. This is theonly machine on the LAN that can't connect. Everybody else connectsfine.I'm stumped. Any ideas? Anybody ever seen the server name appeartwice like that?-Emily
Hey yall. I'm a DBA in a company where I do NOT have the ability tocontrol who logs into my SQL servers as administrator, so I'm lookingfor a way to uninstall the workstation components WITHOUT completelyuninstalling all of my instances. Does anyone know how to do this?All I can find is the complete removal option in add/remove, and theinstall cd setup doesn't have a remove function that I can find. Anyidea's?The reason for wanting to do this is so that every tom dick and harrythat logs in as administrator doesn't have the ability to just open EMand do what they please. I want to force people to log in fromanother box so I can get tighter control over who can access mydatabases. Any help is awesome, thanks!Joshua Austill
I'm having no success install SSMS on a 32 bit workstation from 64 bit media.
I'm aware from researching that the SSMS is 32 bit, in fact I see it run as a 32 bit app on the server.
However, when i try and install from the 64 bit CD or DVD I get errors such as not a valid Win32 application, or when i tre random msi's guessing as to which is ssms I get "This installation package is not supported by this processor type. Contact yoru product vendor."
I run a Pent D 2.8 on 32 bit XP
Any assisstance on how to install SSMS on a 32 bit workstation from the 64 bit media would be greatly appreciated.
Just getting started using SSRS (SQL Server Reporting Services) 2005 in production and I've got what should be a simple question.
How do I configure a development workstation to be able to develop SSRS reports which will run on a networked server running SQL Server 2005?
Here is my problem... I installed VS2005 (Visual Studio Pro 2005) and SQL Server 2005 workstation components (with SQL Server SP2) on the workstation but the "Business Intelligence Projects", "Business Intelligence Wizards", and "Report Projects" are missing from the New > Project types. How do I get them added?
I can access the network SQL Server and the http://<Server>/Reports from the workstation. On the SQL Server I can develop & deploy reports using BIDS (Business Intelligence Development Studio), on the server. But on the workstation I cannot create a new Report Project nor can I open an existing reporting project (rptproj) or solution. (I get the error that rptproj is not intalled and that I should install the associated program...which is what?)
WORKSTATION:
Windows Vista Business with all the latest updates.
Visual Studio Pro 2005 with SP1 & Vista SP1 Update installed.
SQL Server 2005 Standard with SP2 & Reporting Services installed.
This should be a simple question, but I'm suprised that it is not working after installing what seemed like the appropriate components from the SQL Server 2005 disk.
Any suggestions on how to get the SSRS projects to show up and work in the Visual Studio 2005 on the development workstation?
I€™ve moved my server folder which contains about 10 dtsx and its ADO .net connection as well as OLEDB into my folder workstation. Then, when I€™m gonna to open them appears this error:
Error 1 Error loading M_HAC_Modelo198_CECA.dtsx: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Clave no vĂ¡lida para utilizar en el estado especificado.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. c:ssishacienda_anualM_HAC_Modelo198_CECA.dtsx 1 1
Translate into english: "Clave no vĂ¡lida para utilizar en el estado especificado" = Invalid key for to use in the specified state (more or less)
What really happen? Well, I wrote these packages using a domain user (belong to Administrators group in Active Directory) via Terminal Server and now I want to modify them by mean my domain user (I already have got installed sql25k client tools and the stuff required)
I thouht that these connections were saved in the same folder where dtsx, dtsproj, etc..
Solution? Create them again? I hope that it will be a piece of cake otherwise...
I cannot install management studio on workstation (development machine).
I have removed both instances of SQL Express (one installed with VS2005, the other with Office Business Tools). Have ensured all SQL components are removed.
Is it true that SMSS won't install over IE7, that must have IE6 installed to get SMSS.
=== Verbose logging started: 09-03-2007 11:22:01 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: c:2615800be9b170361adff8bc7a52ebhotfix.exe === MSI (c) (68:50) [11:22:01:246]: Resetting cached policy values MSI (c) (68:50) [11:22:01:246]: Machine policy value 'Debug' is 0 MSI (c) (68:50) [11:22:01:246]: ******* RunEngine: ******* Product: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi ******* Action: ******* CommandLine: ********** MSI (c) (68:50) [11:22:01:246]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (68:50) [11:22:01:246]: Grabbed execution mutex. MSI (c) (68:50) [11:22:01:246]: Cloaking enabled. MSI (c) (68:50) [11:22:01:246]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (68:50) [11:22:01:246]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (A8:D0) [11:22:01:277]: Grabbed execution mutex. MSI (s) (A8:3C) [11:22:01:277]: Resetting cached policy values MSI (s) (A8:3C) [11:22:01:277]: Machine policy value 'Debug' is 0 MSI (s) (A8:3C) [11:22:01:277]: ******* RunEngine: ******* Product: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi ******* Action: ******* CommandLine: ********** MSI (s) (A8:3C) [11:22:01:402]: Machine policy value 'DisableUserInstalls' is 0 MSI (s) (A8:3C) [11:22:01:402]: File will have security applied from OpCode. MSI (s) (A8:3C) [11:22:01:996]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi' against software restriction policy MSI (s) (A8:3C) [11:22:01:996]: SOFTWARE RESTRICTION POLICY: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi has a digital signature MSI (s) (A8:3C) [11:22:02:121]: SOFTWARE RESTRICTION POLICY: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi is permitted to run at the 'unrestricted' authorization level. MSI (s) (A8:3C) [11:22:02:121]: End dialog not enabled MSI (s) (A8:3C) [11:22:02:121]: Original package ==> C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi MSI (s) (A8:3C) [11:22:02:121]: Package we're running from ==> C:WINDOWSInstaller1e413d.msi MSI (s) (A8:3C) [11:22:02:136]: APPCOMPAT: looking for appcompat database entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'. MSI (s) (A8:3C) [11:22:02:136]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (A8:3C) [11:22:02:136]: MSCOREE not loaded loading copy from system32 MSI (s) (A8:3C) [11:22:02:136]: Opening existing patch 'C:WINDOWSInstaller3d37f8c.msp'. MSI (s) (A8:3C) [11:22:02:136]: SequencePatches starts. Product code: {53F5C3EE-05ED-4830-994B-50B2F0D50FCE}, Product version: 9.00.3042.00, Upgrade code: {3A91FA19-A197-467C-850F-0AFE90899371}, Product language 1033 MSI (s) (A8:3C) [11:22:02:136]: PATCH SEQUENCER: Setting patch {EE92F683-5F5C-4970-BB0B-9AC591B60268} to be unregistered, because the patch doesn't have any transform that targets this product. MSI (s) (A8:3C) [11:22:02:136]: SequencePatches returns success. MSI (s) (A8:3C) [11:22:02:136]: Final Patch Application Order: MSI (s) (A8:3C) [11:22:02:136]: Other Patches: MSI (s) (A8:3C) [11:22:02:136]: UnknownAbsent: {EE92F683-5F5C-4970-BB0B-9AC591B60268} - MSI (s) (A8:3C) [11:22:02:136]: Machine policy value 'DisablePatch' is 0 MSI (s) (A8:3C) [11:22:02:136]: Machine policy value 'AllowLockdownPatch' is 1 MSI (s) (A8:3C) [11:22:02:136]: Machine policy value 'DisableLUAPatching' is 0 MSI (s) (A8:3C) [11:22:02:152]: Machine policy value 'DisableFlyWeightPatching' is 0 MSI (s) (A8:3C) [11:22:02:152]: APPCOMPAT: looking for appcompat database entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'. MSI (s) (A8:3C) [11:22:02:152]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (A8:3C) [11:22:02:152]: Transforms are not secure. MSI (s) (A8:3C) [11:22:02:152]: Note: 1: 2205 2: 3: Control MSI (s) (A8:3C) [11:22:02:152]: Command Line: REBOOT=ReallySuppress REINSTALLMODE=vomus REINSTALL=ALL CURRENTDIRECTORY=c:2615800be9b170361adff8bc7a52eb CLIENTUILEVEL=3 CLIENTPROCESSID=5736 MSI (s) (A8:3C) [11:22:02:152]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{BEFE6789-8AE1-4E45-B1F7-E3D6B30A51C8}'. MSI (s) (A8:3C) [11:22:02:152]: Product Code passed to Engine.Initialize: '' MSI (s) (A8:3C) [11:22:02:152]: Product Code from property table before transforms: '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}' MSI (s) (A8:3C) [11:22:02:152]: Product Code from property table after transforms: '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}' MSI (s) (A8:3C) [11:22:02:152]: Product registered: entering maintenance mode MSI (s) (A8:3C) [11:22:02:152]: PROPERTY CHANGE: Adding ProductState property. Its value is '5'. MSI (s) (A8:3C) [11:22:02:152]: PROPERTY CHANGE: Adding ProductToBeRegistered property. Its value is '1'. MSI (s) (A8:3C) [11:22:02:152]: Entering CMsiConfigurationManager::SetLastUsedSource. MSI (s) (A8:3C) [11:22:02:152]: Note: 1: 1402 2: UNKNOWNNet 3: 2 MSI (s) (A8:3C) [11:22:02:152]: Specifed source is not already in a list. MSI (s) (A8:3C) [11:22:02:152]: Policy value 'SearchOrder' is 'nmu' MSI (s) (A8:3C) [11:22:02:152]: Machine policy value 'DisableBrowse' is 1 MSI (s) (A8:3C) [11:22:02:152]: Adding new sources is not allowed. MSI (s) (A8:3C) [11:22:02:152]: Note: 1: 1729 MSI (s) (A8:3C) [11:22:02:152]: Note: 1: 2729 MSI (s) (A8:3C) [11:22:02:199]: Note: 1: 2729 MSI (s) (A8:3C) [11:22:02:199]: Product: Microsoft SQL Server Setup Support Files (English) -- Configuration failed.
MSI (s) (A8:3C) [11:22:02:199]: MainEngineThread is returning 1625 This installation is forbidden by system policy. Contact your system administrator. C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi MSI (c) (68:50) [11:22:02:308]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (68:50) [11:22:02:308]: MainEngineThread is returning 1625 === Verbose logging stopped: 09-03-2007 11:22:02 ===
Time: 03/09/2007 11:22:35.028 KB Number: KB921896 Machine: CEPHEUS OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790) Package Language: 1033 (ENU) Package Platform: x86 Package SP Level: 2 Package Version: 3042 Command-line parameters specified: Cluster Installation: No
********************************************************************************** Prerequisites Check & Status SQLSupport: Failed
********************************************************************************** Products Detected Language Level Patch Level Platform Edition Setup Support Files ENU 9.1.2047 x86 Database Services (MSSQLSERVER) ENU SP1 2005.090.2153.00 x86 ENTERPRISE Analysis Services (MSSQLSERVER) ENU SP1 2005.090.2153.00 x86 ENTERPRISE Reporting Services (MSSQLSERVER) ENU SP1 9.00.2153.00 x86 ENTERPRISE Notification Services ENU SP1 9.00.2153.00 x86 ENTERPRISE Integration Services ENU SP1 9.00.2153.00 x86 ENTERPRISE SQL Server Native Client ENU 9.00.2047.00 x86 Client Components ENU SP1 9.1.2153 x86 ENTERPRISE MSXML 6.0 Parser ENU 6.00.3890.0 x86 SQLXML4 ENU 9.00.2047.00 x86 Backward Compatibility ENU 8.05.1704 x86 Microsoft SQL Server VSS Writer ENU 9.00.2047.00 x86
********************************************************************************** Processes Locking Files Process Name Feature Type User Name PID MSSQLSERVER SQL Server Native Client Service 1168 SQLSERVERAGENT SQL Server Native Client Service 2776 DISTRIB.exe SQL Server Native Client Application VASPservicelogon 4276 DISTRIB.exe SQL Server Native Client Application VASPservicelogon 4280 DISTRIB.exe SQL Server Native Client Application VASPservicelogon 4288 DISTRIB.exe SQL Server Native Client Application VASPservicelogon 4300 DISTRIB.exe SQL Server Native Client Application VASPservicelogon 4308 DISTRIB.exe SQL Server Native Client Application VASPservicelogon 4324 DISTRIB.exe SQL Server Native Client Application VASPservicelogon 4364 msftesql Database Services Service 296 ReportServer Database Services Service 1660 MSSQLServerOLAPService Analysis Services Service 1148 MsDtsServer Integration Services Service 352
********************************************************************************** Product Installation Status Product : Setup Support Files Product Version (Previous): 2047 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRedist9_Hotfix_KB921896_SqlSupport.msi.log Error Number : 1625 Error Description : Unable to install Windows Installer MSI file ---------------------------------------------------------------------------------- Product : Database Services (MSSQLSERVER) Product Version (Previous): 2153 Product Version (Final) : Status : Not Applied Log File : Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : Analysis Services (MSSQLSERVER) Product Version (Previous): 2153 Product Version (Final) : Status : Not Applied Log File : Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : Reporting Services (MSSQLSERVER) Product Version (Previous): 2153 Product Version (Final) : Status : Not Applied Log File : Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : Notification Services Product Version (Previous): 2153 Product Version (Final) : Status : Not Applied Log File : Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : Integration Services Product Version (Previous): 2153 Product Version (Final) : Status : Not Applied Log File : Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : SQL Server Native Client Product Version (Previous): 2047 Product Version (Final) : Status : Not Applied Log File : Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : Client Components Product Version (Previous): 2153 Product Version (Final) : Status : Not Applied Log File : Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : MSXML 6.0 Parser Product Version (Previous): 3890 Product Version (Final) : Status : Not Applied Log File : Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : SQLXML4 Product Version (Previous): 2047 Product Version (Final) : Status : Not Applied Log File : Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : Backward Compatibility Product Version (Previous): 1704 Product Version (Final) : Status : Not Applied Log File : Error Number : 0 Error Description : ---------------------------------------------------------------------------------- Product : Microsoft SQL Server VSS Writer Product Version (Previous): 2047 Product Version (Final) : Status : Not Applied Log File : Error Number : 0 Error Description : ----------------------------------------------------------------------------------
********************************************************************************** Summary One or more products failed to install, see above for details Exit Code Returned: 1603
We have a couple XP machines with only 256Mb of RAM and have Windows 2000 client tools installed. What are the minimum hardware requirements for SQL 2005 (Workstation) on an XP desktop?
My boss thinks since we have been blissfully ignorant and running fine with 256Mb then their is no need to upgrade memory in these machines.
I'm setting up a new 2005 server and bulk insert from a client workstation (using windows authentication) is failing with:
Msg 4861, Level 16, State 1, Line 1 Cannot bulk load because the file "\FILESERVERNAMEsharedfolderfilename.txt" could not be opened. Operating system error code 5(Access is denied.).
Here's my BULK INSERT statement (though I'm pretty sure there's nothing wrong with it):
BULK INSERT #FIRSTROW FROM '\FILESERVERNAMEsharedfolderfilename.txt' WITH ( DATAFILETYPE = 'char', ROWTERMINATOR = '', LASTROW = 1 )
If I run the same transact SQL when remote desktopped into the new server (under the same login as that used in the client workstation), it imports the file without errors.
If I use the sa client login from the client workstation (sql server authentication) the bulk insert succeeds.
My old SQL 2000 server lets me bulk insert the file without errors even from my client workstations using windows authentication.
I have followed the instructions on this site: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=928173&SiteID=1 , but still no luck and same error.
I'm pretty sure it is being caused by the increased constraints on bulk insert in 2005. Hoping someone can help. The more specific the better. If you need more info, let me know.
Oh and I've also made sure that the SQL service uses a domain logon account rather than the local system account.
Note that the file server (source file resides there) is a DIFFERENT machine than the 2005 SQL server. If I move the source file to the sql server machine the error goes away (not a preferred solution though).
