SQL Server 2005 Express Edition W/Reporting Services Problem...
Feb 16, 2007
For some reason, the Reporting Services Configuration Tool does not install with the Express Edition of Sql Server 2005 (although I can generate reports in preview mode of the SQL Server Business Intelligence Studio, which does install).
Anyone know how I can get this Reporting Services Configuration Tool to install, or is there a workaround to get the RS Server setup on our network computer?
I have downloaded the freeware SQL Server 2005 Express Edition for learning SQL Server. Now I want to get familiar with the BIDS and the reporting services. I want to know whether Express Edition supports these tools. If not then what do i need to have to get the same started?? I have a pc running on Vista.
Help from anyone will be greatly appreciated as I have been looking at the forums for quite a while and i am totally confused in this respect. What is the most uncomplicated way to solve this problem??
Has i install SQL Server 2005 Express Edition with Advanced Services but why that Report Manager it was not installed. To me will not address under the reference http: // localhost/reports$SQLExpress since such catalogue is not present in IIS. In what there can be a problem?
I have SQL Server 2005 Express edition installed on my pc,running on Vista. I want to know how can I create reports on this arrangement?? Do i need to upgrade to advanced express edition or what?? Will I also need Visual Studio??
Please help as I am a beginer in this.....Can anybody tell me how to proceed towards getting familiar with Reporting in SQL Server
If i have been using sql server 2005 express for developing my application and i decide to upgrade to sql server 2005 express with advanced services while still working on the same application, what will happen to my application's database. Can i be able to continue with my work with out any major regrets.
Folks, Today I saw that an upgraded(?) version of SQL Server express was available. Since it is supposed to have the ability to generate a script to put a database on a hosted server I decided to get it. Bad decision. I uninstalled my previous version of SSE. and attempted to install the SP2 version with Advanced Services. After three installs I finally got the server to start. Now I can not log onto it using Management Studio Express. I know the server is running because I can see it in the task manager and I can open one database used with an ASP.NET web site through Visual Studio. Can you provide any suggestions on how to find my server or server instances through Management Studio? Do I need to remove all sql server related items and do a complete reinstall? I can see the server in the Configuration Manager and in the Surface configuration manager. Any assistance would be greatly appreciated. I have spent way too much time on this.Thanks
Does SQL Server 2005 Express Edition with Advance Services comes with Reporting service. I mean to say If I have installed Express Edition in my computer, does seperate installation of Reporting service required.
i have an installation of SQL Server 2005 Express Edition and now i want to upgrade to SQL Server 2005 Express Edition with Advanced Services SP1 but without uninstall the old version...could someone help me...
I've been using SQL Server 2005 Std. for my development work on a laptop w/ 2 GHz Celeron and 768 Mb RAM. Now that Express Edition has Reporting Services and Full-Text Search, would I be wise to just use it instead? I actually have both on my machine since Express Edition installed with VS 2005 Standard. Also, if I uninstall SQL Server 2005 Std. what will I lose? Thanks in advance.
Windows 2000 Professional (Build 2195: Service Pack 4)
Previous version of SQL Server 2005 Express Edition with Advanced Services CTP was removed using Add/Remove Programs
Visual Studio 2005 Professional is installed
WARNING MESSAGE (should it be an error message since what was requested did not take place?)
--------------------------- Microsoft SQL Server 2005 Setup --------------------------- Warning 28123.Warning: SQL Server Setup cannot install this feature because a different edition of this feature is already installed. For more information, see 'Version and Edition Upgrades' in SQL Server Books Online. --------------------------- OK ---------------------------
FAILED WORKAROUND STEPS
1. Used Add/Remove Programs to remove Microsoft SQL Server 2005 (there was only a single instance).
2. Since Microsoft SQL Server 2005 still appeared in the list of programs to remove, decided to reboot.
3. After reboot, Microsoft SQL Server 2005 still appeared in Add/Remove Programs. Clicked the Remove button a second time and clicked the Yes button to remove it from the list.
4. Used Add/Remove Programs to remove Microsoft SQL Server Management Studio Express.
5. Used Add/Remove Programs to remove Microsoft SQL Server Native Client.
22. Selected Latin1_General under Collation designator and sort order.
23. Unchecked Enable User Instances.
24. Setup fails on product Workstation Components, Books Online and Development Tools with the dialog box shown near the top of this post.
Summary Log
-------------------------------------------------------------------------------- Machine : SomeComputerName Product : Workstation Components, Books Online and Development Tools Warning : Warning 28123.Warning: SQL Server Setup cannot install this feature because a different edition of this feature is already installed. For more information, see 'Version and Edition Upgrades' in SQL Server Books Online. --------------------------------------------------------------------------------
Detailed Tools Log
=== Verbose logging started: 4/20/2006 10:55:39 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe === MSI (c) (04:B8) [10:55:39:234]: Resetting cached policy values MSI (c) (04:B8) [10:55:39:234]: Machine policy value 'Debug' is 0 MSI (c) (04:B8) [10:55:39:234]: ******* RunEngine: ******* Product: e:6771b864b449c707fd961a7fd719a8c1SetupSqlRun_Tools.msi ******* Action: ******* CommandLine: ********** MSI (c) (04:B8) [10:55:39:250]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (04:B8) [10:55:39:250]: Grabbed execution mutex. MSI (c) (04:B8) [10:55:39:250]: Cloaking enabled. MSI (c) (04:B8) [10:55:39:250]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (04:B8) [10:55:39:250]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (3C:88) [10:55:39:265]: Grabbed execution mutex. MSI (s) (3C:20) [10:55:39:265]: Resetting cached policy values MSI (s) (3C:20) [10:55:39:265]: Machine policy value 'Debug' is 0 MSI (s) (3C:20) [10:55:39:265]: ******* RunEngine: ******* Product: e:6771b864b449c707fd961a7fd719a8c1SetupSqlRun_Tools.msi ******* Action: ******* CommandLine: ********** MSI (s) (3C:20) [10:55:39:265]: Machine policy value 'DisableUserInstalls' is 0 MSI (s) (3C:20) [10:55:39:281]: File will have security applied from OpCode. MSI (s) (3C:20) [10:55:45:015]: End dialog not enabled MSI (s) (3C:20) [10:55:45:015]: Original package ==> e:6771b864b449c707fd961a7fd719a8c1SetupSqlRun_Tools.msi MSI (s) (3C:20) [10:55:45:015]: Package we're running from ==> C:WINNTInstaller19c5ce.msi MSI (s) (3C:20) [10:55:45:046]: APPCOMPAT: looking for appcompat database entry with ProductCode '{58D379F7-62BC-4748-8237-FE071ECE797C}'. MSI (s) (3C:20) [10:55:45:046]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (3C:20) [10:55:45:046]: MSCOREE already loaded, using loaded copy MSI (s) (3C:20) [10:55:45:046]: Machine policy value 'TransformsSecure' is 0 MSI (s) (3C:20) [10:55:45:046]: User policy value 'TransformsAtSource' is 0 MSI (s) (3C:20) [10:55:45:046]: Machine policy value 'DisablePatch' is 0 MSI (s) (3C:20) [10:55:45:046]: Machine policy value 'AllowLockdownPatch' is 0 MSI (s) (3C:20) [10:55:45:046]: Machine policy value 'DisableLUAPatching' is 0 MSI (s) (3C:20) [10:55:45:046]: Machine policy value 'DisableFlyWeightPatching' is 0 MSI (s) (3C:20) [10:55:45:046]: APPCOMPAT: looking for appcompat database entry with ProductCode '{58D379F7-62BC-4748-8237-FE071ECE797C}'. MSI (s) (3C:20) [10:55:45:046]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (3C:20) [10:55:45:046]: Transforms are not secure. MSI (s) (3C:20) [10:55:45:046]: Command Line: USERNAME=SomeCompanyName COMPANYNAME=SomeCompanyName INSTALLSQLSHAREDDIR=C:Program FilesMicrosoft SQL Server SAMPLEDATABASESERVER=SomeMachineName STPSETUPTHREADID=1740 STPSETUPPROCESSID=260 EXTERNALCONTROL=1 ADDLOCAL=Client_Components,Connectivity,SDK,SQL_SSMSEE REBOOT=ReallySuppress CURRENTDIRECTORY=C:Program FilesMicrosoft SQL Server90Setup Bootstrap CLIENTUILEVEL=3 CLIENTPROCESSID=260 %HOMEPATH=Documents and SettingsSomeUserName %HOMEDRIVE=D: %HOMESHARE= MSI (s) (3C:20) [10:55:45:046]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{89DAFCFE-ED1B-4EC7-82EE-1D153F4C0980}'. MSI (s) (3C:20) [10:55:45:046]: Product Code passed to Engine.Initialize: '' MSI (s) (3C:20) [10:55:45:046]: Product Code from property table before transforms: '{58D379F7-62BC-4748-8237-FE071ECE797C}' MSI (s) (3C:20) [10:55:45:046]: Product Code from property table after transforms: '{58D379F7-62BC-4748-8237-FE071ECE797C}' MSI (s) (3C:20) [10:55:45:046]: Product not registered: beginning first-time install MSI (s) (3C:20) [10:55:45:046]: PROPERTY CHANGE: Adding ProductState property. Its value is '-1'. MSI (s) (3C:20) [10:55:45:046]: Entering CMsiConfigurationManager::SetLastUsedSource. MSI (s) (3C:20) [10:55:45:046]: User policy value 'SearchOrder' is 'nmu' MSI (s) (3C:20) [10:55:45:046]: Adding new sources is allowed. MSI (s) (3C:20) [10:55:45:046]: PROPERTY CHANGE: Adding PackagecodeChanging property. Its value is '1'. MSI (s) (3C:20) [10:55:45:046]: Package name extracted from package path: 'SqlRun_Tools.msi' MSI (s) (3C:20) [10:55:45:062]: Package to be registered: 'sqlrun_tools.msi' MSI (s) (3C:20) [10:55:45:062]: Note: 1: 2262 2: AdminProperties 3: -2147287038 MSI (s) (3C:20) [10:55:45:062]: Machine policy value 'DisableMsi' is 0 MSI (s) (3C:20) [10:55:45:062]: Machine policy value 'AlwaysInstallElevated' is 0 MSI (s) (3C:20) [10:55:45:062]: User policy value 'AlwaysInstallElevated' is 0 MSI (s) (3C:20) [10:55:45:062]: Product installation will be elevated because user is admin and product is being installed per-machine. MSI (s) (3C:20) [10:55:45:062]: Running product '{58D379F7-62BC-4748-8237-FE071ECE797C}' with elevated privileges: Product is assigned. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding USERNAME property. Its value is 'SomeCompanyName'. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding COMPANYNAME property. Its value is 'SomeCompanyName'. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding SAMPLEDATABASESERVER property. Its value is 'SomeMachineName'. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding STPSETUPTHREADID property. Its value is '1740'. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding STPSETUPPROCESSID property. Its value is '260'. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding EXTERNALCONTROL property. Its value is '1'. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'Client_Components,Connectivity,SDK,SQL_SSMSEE'. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding REBOOT property. Its value is 'ReallySuppress'. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding CURRENTDIRECTORY property. Its value is 'C:Program FilesMicrosoft SQL Server90Setup Bootstrap'. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding CLIENTUILEVEL property. Its value is '3'. MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding CLIENTPROCESSID property. Its value is '260'. MSI (s) (3C:20) [10:55:45:062]: TRANSFORMS property is now: MSI (s) (3C:20) [10:55:45:062]: PROPERTY CHANGE: Adding VersionDatabase property. Its value is '150'. MSI (s) (3C:20) [10:55:45:062]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameApplication Data MSI (s) (3C:20) [10:55:45:062]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameFavorites MSI (s) (3C:20) [10:55:45:062]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameNetHood MSI (s) (3C:20) [10:55:45:062]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameMy Documents MSI (s) (3C:20) [10:55:45:062]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNamePrintHood MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameRecent MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameSendTo MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameTemplates MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsAll UsersApplication Data MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameLocal SettingsApplication Data MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameMy DocumentsMy Pictures MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsAll UsersStart MenuProgramsAdministrative Tools MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsAll UsersStart MenuProgramsStartup MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsAll UsersStart MenuPrograms MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsAll UsersStart Menu MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsAll UsersDesktop MSI (s) (3C:20) [10:55:45:078]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameStart MenuProgramsAdministrative Tools MSI (s) (3C:20) [10:55:45:093]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameStart MenuProgramsStartup MSI (s) (3C:20) [10:55:45:093]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameStart MenuPrograms MSI (s) (3C:20) [10:55:45:093]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameStart Menu MSI (s) (3C:20) [10:55:45:093]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsSomeUserNameDesktop MSI (s) (3C:20) [10:55:45:093]: SHELL32::SHGetFolderPath returned: D:Documents and SettingsAll UsersTemplates MSI (s) (3C:20) [10:55:45:093]: SHELL32::SHGetFolderPath returned: C:WINNTFonts MSI (s) (3C:20) [10:55:45:093]: Note: 1: 2898 2: MS Sans Serif 3: MS Sans Serif 4: 0 5: 16 MSI (s) (3C:20) [10:55:45:093]: PROPERTY CHANGE: Adding Privileged property. Its value is '1'. MSI (s) (3C:20) [10:55:45:093]: PROPERTY CHANGE: Adding DATABASE property. Its value is 'C:WINNTInstaller19c5ce.msi'. MSI (s) (3C:20) [10:55:45:093]: PROPERTY CHANGE: Adding OriginalDatabase property. Its value is 'e:6771b864b449c707fd961a7fd719a8c1SetupSqlRun_Tools.msi'. MSI (s) (3C:20) [10:55:45:093]: Note: 1: 2205 2: 3: PatchPackage MSI (s) (3C:20) [10:55:45:093]: Machine policy value 'DisableRollback' is 0 MSI (s) (3C:20) [10:55:45:093]: User policy value 'DisableRollback' is 0 MSI (s) (3C:20) [10:55:45:093]: PROPERTY CHANGE: Adding UILevel property. Its value is '2'. === Logging started: 4/20/2006 10:55:45 === MSI (s) (3C:20) [10:55:45:093]: PROPERTY CHANGE: Adding Preselected property. Its value is '1'. MSI (s) (3C:20) [10:55:45:093]: PROPERTY CHANGE: Adding ACTION property. Its value is 'INSTALL'. MSI (s) (3C:20) [10:55:45:093]: Doing action: INSTALL MSI (s) (3C:20) [10:55:45:109]: Running ExecuteSequence MSI (s) (3C:20) [10:55:45:109]: Doing action: SystemFolder.60A85CA1_D9D8_43FA_9DD5_574BEF970F9F Action start 10:55:45: INSTALL. MSI (s) (3C:20) [10:55:45:109]: PROPERTY CHANGE: Adding SystemFolder.60A85CA1_D9D8_43FA_9DD5_574BEF970F9F property. Its value is 'C:WINNTsystem32'. Action start 10:55:45: SystemFolder.60A85CA1_D9D8_43FA_9DD5_574BEF970F9F. MSI (s) (3C:20) [10:55:45:109]: Doing action: WindowsFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E Action ended 10:55:45: SystemFolder.60A85CA1_D9D8_43FA_9DD5_574BEF970F9F. Return value 1. MSI (s) (3C:20) [10:55:45:109]: PROPERTY CHANGE: Adding WindowsFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNT'. Action start 10:55:45: WindowsFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:109]: Doing action: SystemFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E Action ended 10:55:45: WindowsFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:109]: PROPERTY CHANGE: Adding SystemFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNTsystem32'. Action start 10:55:45: SystemFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:109]: Doing action: WindowsFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E Action ended 10:55:45: SystemFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:109]: PROPERTY CHANGE: Adding WindowsFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNT'. Action start 10:55:45: WindowsFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:109]: Doing action: SystemFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E Action ended 10:55:45: WindowsFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:109]: PROPERTY CHANGE: Adding SystemFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNTsystem32'. Action start 10:55:45: SystemFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:125]: Doing action: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E Action ended 10:55:45: SystemFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:125]: PROPERTY CHANGE: Adding WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNT'. Action start 10:55:45: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:125]: Doing action: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E Action ended 10:55:45: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:125]: PROPERTY CHANGE: Adding SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNTsystem32'. Action start 10:55:45: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:125]: Doing action: WindowsFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E Action ended 10:55:45: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:125]: PROPERTY CHANGE: Adding WindowsFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNT'. Action start 10:55:45: WindowsFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:125]: Doing action: SystemFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E Action ended 10:55:45: WindowsFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:125]: PROPERTY CHANGE: Adding SystemFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNTsystem32'. Action start 10:55:45: SystemFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:125]: Doing action: WindowsFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E Action ended 10:55:45: SystemFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:125]: PROPERTY CHANGE: Adding WindowsFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNT'. Action start 10:55:45: WindowsFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:140]: Doing action: SystemFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E Action ended 10:55:45: WindowsFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:140]: PROPERTY CHANGE: Adding SystemFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNTsystem32'. Action start 10:55:45: SystemFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:140]: Doing action: WindowsFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E Action ended 10:55:45: SystemFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:140]: PROPERTY CHANGE: Adding WindowsFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNT'. Action start 10:55:45: WindowsFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:140]: Doing action: SystemFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E Action ended 10:55:45: WindowsFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:140]: PROPERTY CHANGE: Adding SystemFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNTsystem32'. Action start 10:55:45: SystemFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:140]: Doing action: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E Action ended 10:55:45: SystemFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:140]: PROPERTY CHANGE: Adding WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNT'. Action start 10:55:45: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:140]: Doing action: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E Action ended 10:55:45: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:140]: PROPERTY CHANGE: Adding SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNTsystem32'. Action start 10:55:45: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:156]: Doing action: WindowsFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E Action ended 10:55:45: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:156]: PROPERTY CHANGE: Adding WindowsFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNT'. Action start 10:55:45: WindowsFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:156]: Doing action: SystemFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E Action ended 10:55:45: WindowsFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:156]: PROPERTY CHANGE: Adding SystemFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E property. Its value is 'C:WINNTsystem32'. Action start 10:55:45: SystemFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E. MSI (s) (3C:20) [10:55:45:156]: Doing action: ProgramMenuFolder.ConfigurationTools1033 Action ended 10:55:45: SystemFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (3C:20) [10:55:45:156]: PROPERTY CHANGE: Adding ProgramMenuFolder.ConfigurationTools1033 property. Its value is 'D:Documents and SettingsAll UsersStart MenuPrograms'. Action start 10:55:45: ProgramMenuFolder.ConfigurationTools1033. MSI (s) (3C:20) [10:55:45:156]: Doing action: ProgramFilesFolder.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 10:55:45: ProgramMenuFolder.ConfigurationTools1033. Return value 1. MSI (s) (3C:20) [10:55:45:156]: PROPERTY CHANGE: Adding ProgramFilesFolder.D20239D7_E87C_40C9_9837_E70B8D4882C2 property. Its value is 'C:Program Files'. Action start 10:55:45: ProgramFilesFolder.D20239D7_E87C_40C9_9837_E70B8D4882C2. MSI (s) (3C:20) [10:55:45:156]: Skipping action: SetMDACSxS (condition is false) MSI (s) (3C:20) [10:55:45:156]: Doing action: LaunchConditions Action ended 10:55:45: ProgramFilesFolder.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (3C:20) [10:55:45:156]: Note: 1: 2205 2: 3: LaunchCondition MSI (s) (3C:20) [10:55:45:156]: Note: 1: 2228 2: 3: LaunchCondition 4: SELECT `Condition`, `Description` FROM `LaunchCondition` Action start 10:55:45: LaunchConditions. MSI (s) (3C:20) [10:55:45:156]: Doing action: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 10:55:45: LaunchConditions. Return value 0. MSI (s) (3C:BC) [10:55:45:171]: Invoking remote custom action. DLL: C:WINNTInstallerMSI299.tmp, Entrypoint: StreamSupportFiles MSI (s) (3C:D0) [10:55:45:171]: Generating random cookie. MSI (s) (3C:D0) [10:55:45:171]: Created Custom Action Server with PID 616 (0x268). MSI (s) (3C:70) [10:55:45:187]: Running as a service. MSI (s) (3C:70) [10:55:45:187]: Hello, I'm your 32bit Impersonated custom action server. Action start 10:55:45: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2. Property(SQL): Setup Bootstrap Directory = C:Program FilesMicrosoft SQL Server90Setup Bootstrap 1: 0 2: Iterating through _sqlSupportFiles entries Streamed sqlca.D20239D7_E87C_40C9_9837_E70B8D4882C2 to C:Program FilesMicrosoft SQL Server90Setup Bootstrapin{58D379F7-62BC-4748-8237-FE071ECE797C}sqlca.dll MSI (s) (3C:20) [10:55:45:312]: Doing action: Do_LogInstallStart.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 10:55:45: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (3C:BC) [10:55:45:328]: Invoking remote custom action. DLL: C:WINNTInstallerMSI29A.tmp, Entrypoint: Do_LogInstallStart Action start 10:55:45: Do_LogInstallStart.D20239D7_E87C_40C9_9837_E70B8D4882C2. Property(SQL): Setup Bootstrap Directory = C:Program FilesMicrosoft SQL Server90Setup Bootstrap Property(SQL): CA DLL Path = C:Program FilesMicrosoft SQL Server90Setup BootstrapBin{58D379F7-62BC-4748-8237-FE071ECE797C}sqlca.dll <Func Name='LaunchFunction'> Function=Do_LogInstallStart <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'> Doing Action: Do_LogInstallStart PerfTime Start: Do_LogInstallStart : Thu Apr 20 10:55:46 2006 <Func Name='Do_LogInstallStart'> <EndFunc Name='Do_LogInstallStart' Return='0' GetLastError='203'> PerfTime Stop: Do_LogInstallStart : Thu Apr 20 10:55:46 2006 <EndFunc Name='LaunchFunction' Return='0' GetLastError='203'> MSI (s) (3C:20) [10:55:46:625]: Doing action: GetDefaultDomain.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 10:55:46: Do_LogInstallStart.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (3C:BC) [10:55:46:625]: Invoking remote custom action. DLL: C:WINNTInstallerMSI29B.tmp, Entrypoint: GetDefaultDomain Action start 10:55:46: GetDefaultDomain.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=GetDefaultDomain <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'> Doing Action: GetDefaultDomain PerfTime Start: GetDefaultDomain : Thu Apr 20 10:55:46 2006 <Func Name='GetDefaultDomain'> MSI (s) (3C!38) [10:55:46:687]: PROPERTY CHANGE: Adding DefaultDomain property. Its value is 'SomeDomainName'. MSI (s) (3C!38) [10:55:46:687]: PROPERTY CHANGE: Adding QuotedDefaultDomain property. Its value is 'SomeDomainName'. MSI (s) (3C!38) [10:55:46:687]: PROPERTY CHANGE: Adding QuotedComputerName property. Its value is 'SomeMachineName'. PerfTime Stop: GetDefaultDomain : Thu Apr 20 10:55:46 2006 <EndFunc Name='LaunchFunction' Return='0' GetLastError='997'> MSI (s) (3C:20) [10:55:46:687]: Doing action: RestoreSetupParams.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 10:55:46: GetDefaultDomain.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (3C:BC) [10:55:46:687]: Invoking remote custom action. DLL: C:WINNTInstallerMSI29C.tmp, Entrypoint: RestoreSetupParams Action start 10:55:46: RestoreSetupParams.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=RestoreSetupParams Skipping Action: RestoreSetupParams (Condition is false) <EndFunc Name='LaunchFunction' Return='0' GetLastError='203'> MSI (s) (3C:20) [10:55:46:718]: Doing action: ShutdownServiceManager.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 10:55:46: RestoreSetupParams.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (3C:BC) [10:55:46:718]: Invoking remote custom action. DLL: C:WINNTInstallerMSI29D.tmp, Entrypoint: ShutdownServiceManager Action start 10:55:46: ShutdownServiceManager.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=ShutdownServiceManager <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'> Doing Action: ShutdownServiceManager PerfTime Start: ShutdownServiceManager : Thu Apr 20 10:55:46 2006 <Func Name='ShutdownServiceManager'> <EndFunc Name='ShutdownServiceManager' Return='0' GetLastError='2'> PerfTime Stop: ShutdownServiceManager : Thu Apr 20 10:55:46 2006 <EndFunc Name='LaunchFunction' Return='0' GetLastError='2'> MSI (s) (3C:20) [10:55:46:750]: Doing action: Write_sqlWellKnownAccountNames.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 10:55:46: ShutdownServiceManager.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (3C:BC) [10:55:46:765]: Invoking remote custom action. DLL: C:WINNTInstallerMSI29E.tmp, Entrypoint: Write_sqlWellKnownAccountNames Action start 10:55:46: Write_sqlWellKnownAccountNames.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=Write_sqlWellKnownAccountNames <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'> Doing Action: Write_sqlWellKnownAccountNames PerfTime Start: Write_sqlWellKnownAccountNames : Thu Apr 20 10:55:46 2006 <Func Name='Write_sqlWellKnownAccountNames'> MSI (s) (3C!38) [10:55:46:781]: PROPERTY CHANGE: Adding AdministratorsGroup property. Its value is 'BUILTINAdministrators'. MSI (s) (3C!38) [10:55:46:796]: PROPERTY CHANGE: Adding UsersGroup property. Its value is 'BUILTINUsers'. MSI (s) (3C!38) [10:55:46:812]: PROPERTY CHANGE: Adding LocalSystemAccount property. Its value is 'NT AUTHORITYSYSTEM'. <EndFunc Name='Write_sqlWellKnownAccountNames' Return='0' GetLastError='1332'> PerfTime Stop: Write_sqlWellKnownAccountNames : Thu Apr 20 10:55:46 2006 <EndFunc Name='LaunchFunction' Return='0' GetLastError='1332'> MSI (s) (3C:20) [10:55:46:843]: Skipping action: PropSetSQLAutoStart.D20239D7_E87C_40C9_9837_E70B8D4882C2 (condition is false) MSI (s) (3C:20) [10:55:46:843]: Doing action: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 10:55:46: Write_sqlWellKnownAccountNames.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (3C:BC) [10:55:46:843]: Invoking remote custom action. DLL: C:WINNTInstallerMSI29F.tmp, Entrypoint: CheckIIS Action start 10:55:46: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=CheckIIS <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'> Doing Action: CheckIIS PerfTime Start: CheckIIS : Thu Apr 20 10:55:46 2006 <Func Name='CheckIIS'> MSI (s) (3C!38) [10:55:46:906]: PROPERTY CHANGE: Adding IISCHECKED property. Its value is '0'. MSI (s) (3C!38) [10:55:46:921]: PROPERTY CHANGE: Adding SqlASPNETInstalled property. Its value is '1'. Skipping RS Feature Dependency Check <Func Name='GetXMLAttributeValue'> Error to find XML node /configuration/system.web/compilation <EndFunc Name='GetXMLAttributeValue' Return='2' GetLastError='0'> Failed to get ModuleID_RS_Server when getting the ASP Temp directory. MSI (s) (3C!38) [10:55:47:031]: PROPERTY CHANGE: Adding SqlCOMPlusInstalled property. Its value is '1'. Could not get the ASP temp directory. MSI (s) (3C!38) [10:55:47:031]: PROPERTY CHANGE: Adding RSPREREQUISITECHECKED property. Its value is '1'. MSI (s) (3C!38) [10:55:47:031]: PROPERTY CHANGE: Modifying IISCHECKED property. Its current value is '0'. Its new value: '1'. SqlCOMPlusInstalled value set to 1 <EndFunc Name='CheckIIS' Return='0' GetLastError='0'> PerfTime Stop: CheckIIS : Thu Apr 20 10:55:47 2006 <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (3C:20) [10:55:47:031]: Doing action: Create_RSGUID.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 10:55:47: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (3C:BC) [10:55:47:046]: Invoking remote custom action. DLL: C:WINNTInstallerMSI2A0.tmp, Entrypoint: Create_RSGUID Action start 10:55:47: Create_RSGUID.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=Create_RSGUID <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'> Doing Action: Create_RSGUID PerfTime Start: Create_RSGUID : Thu Apr 20 10:55:47 2006 <Func Name='Create_RSGUID'> MSI (s) (3C!38) [10:55:47:156]: PROPERTY CHANGE: Adding RSGUIDVALUE property. Its value is '{91051fc0-581b-4a79-8672-9ae717477574}'. Starting Create_RSGUID Created new GUID: {91051fc0-581b-4a79-8672-9ae717477574} <EndFunc Name='Create_RSGUID' Return='0' GetLastError='0'> PerfTime Stop: Create_RSGUID : Thu Apr 20 10:55:47 2006 <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (3C:20) [10:55:47:171]: Doing action: CheckPassedPropertiesLength.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action ended 10:55:47: Create_RSGUID.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. MSI (s) (3C:BC) [10:55:47:171]: Invoking remote custom action. DLL: C:WINNTInstallerMSI2A1.tmp, Entrypoint: CheckPassedPropertiesLength Action start 10:55:47: CheckPassedPropertiesLength.D20239D7_E87C_40C9_9837_E70B8D4882C2. <Func Name='LaunchFunction'> Function=CheckPassedPropertiesLength <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'> Doing Action: CheckPassedPropertiesLength PerfTime Start: CheckPassedPropertiesLength : Thu Apr 20 10:55:47 2006 <Func Name='CheckPassedPropertiesLength'> CheckPassedPropertiesLength: Property USERNAME is of legal length. MSI (s) (3C!38) [10:55:47:203]: PROPERTY CHANGE: Adding RSSqlPoolLimit property. Its value is '100'. CheckPassedPropertiesLength: Property COMPANYNAME is of legal length. <EndFunc Name='CheckPassedPropertiesLength' Return='0' GetLastError='0'> PerfTime Stop: CheckPassedPropertiesLength : Thu Apr 20 10:55:47 2006 <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (3C:20) [10:55:47:203]: Skipping action: CheckForGDRPatch.D20239D7_E87C_40C9_9837_E70B8D4882C2 (condition is false) MSI (s) (3C:20) [10:55:47:203]: Doing action: FindRelatedProducts Action ended 10:55:47: CheckPassedPropertiesLength.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1. Action start 10:55:47: FindRelatedProducts. MSI (s) (3C:20) [10:55:47:218]: PROPERTY CHANGE: Adding UPGRADETOOLS90 property. Its value is '{A30965BD-2D4D-45CE-8F04-6A6889818CF1}'. MSI (s) (3C:20) [10:55:47:218]: PROPERTY CHANGE: Adding PRODUCT_TOOLS property. Its value is '{A30965BD-2D4D-45CE-8F04-6A6889818CF1}'. MSI (s) (3C:20) [10:55:47:218]: Doing action: FindUpgradeableProduct Action ended 10:55:47: FindRelatedProducts. Return value 1. MSI (s) (3C:BC) [10:55:47:218]: Invoking remote custom action. DLL: C:WINNTInstallerMSI2A2.tmp, Entrypoint: FindUpgradeableProduct Action start 10:55:47: FindUpgradeableProduct. <Func Name='LaunchFunction'> Function=FindUpgradeableProduct <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'> Doing Action: FindUpgradeableProduct PerfTime Start: FindUpgradeableProduct : Thu Apr 20 10:55:47 2006 <Func Name='FindUpgradeableProduct'> Warning 28123.Warning: SQL Server Setup cannot install this feature because a different edition of this feature is already installed. For more information, see 'Version and Edition Upgrades' in SQL Server Books Online. <EndFunc Name='FindUpgradeableProduct' Return='259' GetLastError='0'> PerfTime Stop: FindUpgradeableProduct : Thu Apr 20 11:08:55 2006 Gathering darwin properties for failure handling. Loaded DLL: C:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version: 2.0.3609.0
<EndFunc Name='LaunchFunction' Return='259' GetLastError='0'> Action ended 11:08:55: FindUpgradeableProduct. Return value 5. Action ended 11:08:55: INSTALL. Return value 1. Property(S): ProductCode = {58D379F7-62BC-4748-8237-FE071ECE797C} Property(S): ProductLanguage = 1033 Property(S): Manufacturer = Microsoft Corporation Property(S): ProductVersion = 9.1.2047.00 Property(S): MEDIAPACKAGEPATH = Setup Property(S): ALLUSERS = 1 Property(S): NULLGUID = {00000000-0000-0000-0000-000000000000} Property(S): ASPNetVersion = 2.0.50727 Property(S): ARPHELPLINK = http://go.microsoft.com/fwlink/?LinkId=52152 Property(S): ARPPRODUCTICON = ARPIcon.ico Property(S): ARPNOREPAIR = 1 Property(S): ARPSYSTEMCOMPONENT = 1 Property(S): MsiHiddenProperties = SQLPASSWORD;AGTPASSWORD;ASPASSWORD;RSPASSWORD;SQLBROWSERPASSWORD;RSSQLPASSWORD;RSSQLPassword;RSSQLPasswordQuoted;RSSETUPPASSWORD;RSSetupPassword;SAPWD;saPWD;UPGRADEPWD;SqlUpgradePwd;SQLPassword;ServicePassword;ADMINPASSWORD;PIDKEY;FTEPassword.68C6D15C_77E0_11D5_8528_00C04F68155C;checksum.7354AFCB_913B_4E9F_B76C_2376101FDE0C;checksum.;DigitalProductID;DPID;Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2;Rollback_SqlConnection.D20239D7_E87C_40C9_9837_E70B8D4882C2;Do_XmlSingleNode.D20239D7_E87C_40C9_9837_E70B8D4882C2;Do_RSSetting.D20239D7_E87C_40C9_9837_E70B8D4882C2;PID;ProductID;RSUPGRADEPASSWORD;Do_RSSetSharePointExclusionPath.D20239D7_E87C_40C9_9837_E70B8D4882C2 Property(S): SecureCustomProperties = SQL_SHOWLIC;PRODUCT_TOOLS;UPGRADETOOLS90;PRODUCT_TOOLS_LCID Property(S): SqlServerBuild = 1 Property(S): SqlCluster = 0 Property(S): INSTALLLEVEL = 90 Property(S): FXAssemblyVersion = 2.0.0.0 Property(S): VSAssemblyVersion = 8.0.0.0 Property(S): SqlErrorReporting = #0 Property(S): SqlSqmReporting = #0 Property(S): SqlEnableRanu = 0 Property(S): SqlPatchLevel = 9.1.2047 Property(S): ReleaseProductVersion = 9.00.2047.00 Property(S): SpLevel = 1 Property(S): PIDTemplate = <````=````=````=````=`````>@@@@@ Property(S): UPGRADETOOLS90 = {A30965BD-2D4D-45CE-8F04-6A6889818CF1} Property(S): UpgradeCode = {FED8B2D9-159B-41B0-826C-E3E0F8ADE264} Property(S): PRODUCT_TOOLS = {A30965BD-2D4D-45CE-8F04-6A6889818CF1} Property(S): BOL_INSTALL = SQLServer90 Property(S): ProgramFilesFolder = C:Program Files Property(S): DefaultUIFont = Tahoma8 Property(S): VersionNT = 500 Property(S): INSTALLSQLSHAREDDIR = C:Program FilesMicrosoft SQL Server Property(S): LocalSystemAccount = NT AUTHORITYSYSTEM Property(S): DefaultBuiltInAccount = NetworkServiceAccount Property(S): SqlDisableNetworkProtocols = 1 Property(S): SimpleFeatureTitle_Feat6 = Client Components Property(S): SimpleFeature_Feat6_Expr = &Workstation components and development tools Property(S): Service_AGT = SQL Server Agent Property(S): Service_OLAP = SQL Server Analysis Services Property(S): Service_SQL = SQL Server Property(S): Service_RS = SQL Server Reporting Services Property(S): Service_Browse = SQL Server Browser Property(S): Service_DTS = SQL Server Integration Services Property(S): Service_ADHelper = SQL Server Active Directory Helper Property(S): Service_SQLWriter = SQL Server VSS Writer Property(S): Service_FTS = SQL Server FullText Search Property(S): ServiceDesc_RS = Manages, executes, renders, schedules and delivers reports. Property(S): ServiceDesc_AGT = Executes jobs, monitors SQL Server, and fires alerts, and allows automation of some administrative tasks. Property(S): ServiceDesc_SQL = Provides storage, processing and controlled access of data and rapid transaction processing. Property(S): ServiceDesc_Browse = Provides SQL Server connection information to client computers. Property(S): ServiceDesc_OLAP = Supplies online analytical processing (OLAP) and data mining functionality for business intelligence applications. Property(S): ServiceDesc_DTS = Provides management support for SSIS package storage and execution. Property(S): ServiceDesc_ADHelper = Enables integration with Active Directories. Property(S): ServiceDesc_SQLWriter = Provides the interface to backup/restore Microsoft SQL server through the Windows VSS infrastructure. Property(S): ServiceDesc_FTS = Quickly creates full-text indexes on content and properties of structured and semi-structured data to allow fast linguistic searches on this data. Property(S): ServiceGroupDesc_ADHelper = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Active Directory Helper in SQL Server 2005. Property(S): ServiceGroupDesc_AGT = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Agent in SQL Server 2005. Property(S): ServiceGroupDesc_OLAP = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Analysis Services in SQL Server 2005. Property(S): ServiceGroupDesc_Browse = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Browser in SQL Server 2005. Property(S): ServiceGroupDesc_DTS = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Integration Services in SQL Server 2005. Property(S): ServiceGroupDesc_FTS = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server and SQL Server FullText Search in SQL Server 2005. Property(S): ServiceGroupDesc_NS = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Notification Services in SQL Server 2005. Property(S): ServiceGroupDesc_RS = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Reporting Services in SQL Server 2005. Property(S): ServiceGroupDesc_RSWeb = Members in the group have the required access to be assigned as the log on account for the associated instance of SQL Server Reporting Services in SQL Server 2005 Property(S): ServiceGroupDesc_SQL = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server and SQL Server FullText Search in SQL Server 2005. Property(S): ServiceGroupDesc_SQL_NEW = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server in SQL Server 2005. Property(S): ServiceGroupDesc_FTS_NEW = Members in the group have the required access and privileges to be assigned as the log on account for the associated instance of SQL Server Full Text Search in SQL Server 2005. Property(S): DlgService_AGT = SQL Server Agent Property(S): DlgService_OLAP = Analysis Services Property(S): DlgService_SQL = SQL Server Property(S): DlgService_RS = Reporting Services Property(S): DlgService_Browse = SQL Browser Property(S): AutoStart_AGT = SQL Server A&gent Property(S): AutoStart_OLAP = &Analysis Services Property(S): AutoStart_SQL = &SQL Server Property(S): AutoStart_RS = Rep&orting Services Property(S): AutoStart_Browse = SQL Bro&wser Property(S): AutoStart_FTS = SQL Server &FullText Search Property(S): _AuthenticationType = Windows Property(S): SQL_rgCollation = 1 Property(S): OLAP_rgCollation = 0 Property(S): _InstanceType = Default Property(S): _LicensingMode = PerSeat Property(S): AGTLogin = DomainAccount Property(S): ASLogin = DomainAccount Property(S): SingleLogin = DomainAccount Property(S): SQLLogin = DomainAccount Property(S): RSLogin = DomainAccount Property(S): SQLBROWSERLogin = DomainAccount Property(S): _UpgradeLogon = Windows Property(S): _SampleDBMode = InstallSD Property(S): ButtonTextStyle = {ButtonTextStyle} Property(S): DlgTextStyle = {DlgTextStyle} Property(S): DlgTextStyleB = {DlgTextStyleB} Property(S): DlgTitleStyle = {DlgTitleStyle} Property(S): DlgTitleStyleB = {DlgTitleStyleB} Property(S): FixedStyle = {FixedStyle} Property(S): T_DataFree = T_DataFree Property(S): T_DataReq = T_DataReq Property(S): T_ProgramFree = T_ProgramFree Property(S): T_ProgramReq = T_ProgramReq Property(S): T_IPVal = T_IPVal Property(S): T_Subnet = T_Subnet Property(S): ErrorDialog = ErrorDlg Property(S): ENABLERANU = 1 Property(S): AccountForAllNodesDlg_Desc = Account for remote setup. Property(S): AccountForAllNodesDlg_Text = Enter a user name and password that is a valid administrator account for all nodes in the cluster system. This will be used during setup only. Property(S): AccountForAllNodesDlg_Title = Remote Account Information Property(S): Authentication_ConfirmPWText = Confirm &password: Property(S): Authentication_DlgDesc = The authentication mode specifies the security used when connecting to SQL Server. Property(S): Authentication_DlgText = Select the authentication mode to use for this installation. Property(S): Authentication_DlgTitle = Authentication Mode Property(S): Authentication_EnterPWText = &Enter password: Property(S): Authentication_saPasswordText = Specify the sa logon password below: Property(S): Authentication_SQL = &Mixed Mode (Windows Authentication and SQL Server Authentication) Property(S): Authentication_Windows = &Windows Authentication Mode Property(S): BrowseFolder_ComboText = &Install in: Property(S): BrowseFolder_DlgDesc = You can select a different folder for installation. Property(S): BrowseFolder_DlgTitle = Change Folders Property(S): BrowseFolder_TailText = Installation &path: Property(S): BrowseFolder_TailTextShared = The SQL Server shared path has already been configured. Property(S): ButtonText_Abort = &Abort Property(S): ButtonText_Add = &Add Property(S): ButtonText_Back = < &Back Property(S): ButtonText_Browse = B&rowse... Property(S): ButtonText_Cancel = Cancel Property(S): ButtonText_Close = &Close Property(S): ButtonText_Complete = &Complete Property(S): ButtonText_ContinueLater = &Continue Later Property(S): ButtonText_DiskCost = &Disk Cost... Property(S): ButtonText_Exit = &Exit Property(S): ButtonText_Finish = &Finish Property(S): ButtonText_Help = &Help Property(S): ButtonText_Ignore = &Ignore Property(S): ButtonText_Install = &Install Property(S): ButtonText_Minimal = &Minimal Property(S): ButtonText_New = &New Property(S): ButtonText_Next = &Next > Property(S): ButtonText_No = &No Property(S): ButtonText_Normal = &Normal Property(S): ButtonText_OK = OK Property(S): ButtonText_Open = &Open Property(S): ButtonText_Reinstall = &Reinstall Property(S): ButtonText_ReinstallMode = &Select the reinstall mode Property(S): ButtonText_Remove = &Remove Property(S): ButtonText_Remove2 = &Remove Property(S): ButtonText_Report = &Report Property(S): ButtonText_Reset = &Reset Property(S): ButtonText_Restore = &Restore Property(S): ButtonText_Resume = &Resume Property(S): ButtonText_Retry = &Retry Property(S): ButtonText_Up = &Up Property(S): ButtonText_Yes = &Yes Property(S): Cancel_DlgDesc = Are you sure you want to cancel the installation? Property(S): Cancel_DlgText = The installation is not complete. If you exit the wizard now, Microsoft SQL Server will not be installed. Property(S): ClusterGroup_DlgDesc = Select the cluster group where the virtual server resources will be installed. Property(S): ClusterGroup_DlgStaticTextAvailable = Available cluster groups: Property(S): ClusterGroup_DlgStaticTextUnavailable = Unavailable cluster groups: Property(S): ClusterGroup_DlgTitle = Cluster Group Selection Property(S): ClusterNodeDlg_ButtonTextAdd = &Add -> Property(S): ClusterNodeDlg_ButtonTextRemove = <- &Remove Property(S): ClusterNodeDlg_StaticTextAvailableNode = Available nodes: Property(S): ClusterNodeDlg_StaticTextRequiredNode = Required node: Property(S): ClusterNodeDlg_StaticTextSelectedNode = Selected nodes: Property(S): ClusterNodeDlg_StaticTextUnavailableNode = Unavailable nodes: Property(S): ClusterNodeDlg_Text = Select the nodes to include in the virtual server. Property(S): ClusterNodeDlg_Title = Cluster Node Configuration Property(S): Collation_Service = S&ervice: Property(S): Collation_Service1 = Collation settings for service: Property(S): Collation_AS_Collation = Analysis Services Collation: Property(S): Collation_ChkBinary = Binary Property(S): Collation_ChkBinary2 = Binary - code point Property(S): Collation_ChkCase = Case - sensitive Property(S): Collation_ChkAccent = Accent - sensitive Property(S): Collation_ChkKana = Kana - sensitive Property(S): Collation_ChkWidth = Width - sensitive Property(S): Collation_Designator = Collation &designator and sort order: Property(S): Collation_DlgDesc = Collation settings define the sorting behavior for your server. Property(S): Collation_DlgCusomizeText = &Customize for each service account Property(S): Collation_DlgTitle = Collation Settings Property(S): Collation_SQL = &SQL collations (used for compatibility with previous versions of SQL Server) Property(S): DiskPrompt = Please insert next disk Property(S): DiskSpace_DlgDesc = Disk space required for the installation exceeds available disk space. Property(S): DiskSpace_DlgDesc1 = The available disk space and the space required for installation are shown below. Property(S): DiskSpace_DlgText = The highlighted volumes, if any, do not have enough disk space available for the currently selected features. Click Disk Cleanup to free disk space and then click Resume to continue the installation, or click Exit to exit the wizard. Property(S): DiskSpace_DlgTitle = Out of Disk Space Property(S): DiskSpace_DlgTitle1 = Disk Cost Property(S): DiskSpace_LBDiskCleanup = Use disk cleanup to free more disk space by removing unneeded files. Property(S): REASON_ADMIN_DISABLED = Administrative shares must be enabled in order to let Setup access remote nodes Property(S): REASON_DARWIN_VER = Windows installer is not present or has not the required version Property(S): REASON_DUP_INSTANCE_NAME_CLST = An instance with the same name is already installed in one or more nodes of the cluster. Property(S): REASON_GROUP_HOSTS_VS = Already contains a SQL Virtual Server Property(S): REASON_GROUP_NO_DISK = Does not contain any valid cluster disk Property(S): ERROR_INVALID_PID = This is an invalid Product Key value. Please check the number located on your Product Key sticker. Property(S): ERROR_INVALID_USERNAME = The Name is required for the installation. Property(S): REASON_NODE_DOWN = The node is down or unavailable Property(S): REASON_NOT_KNOWN = Unknown Property(S): REASON_PENDING_REBOOT = The node must be rebooted before running setup Property(S): REASON_SCC_CHECK_FAILED = A SCC check failed on the node Property(S): ERROR_UNKNOWN = Installation error. Install it by running setup.exe. Property(S): REASON_VERSION_ADDNODE = Adding nodes to the Virtual Server definition using a newer version of Setup is not allowed. Property(S): REASON_OS_VER = SQL Server requires Windows 2000 Service Pack 4, or Windows XP Service Pack 1 or later for installation. Property(S): REASON_OS_TYPE = This version of SQL Server is not supported on this version of Windows. Property(S): Exit_DlgDesc1 = Setup has installed Microsoft SQL Server successfully. Click Finish to exit. Property(S): Exit_DlgDesc2 = Setup has removed Microsoft SQL Server successfully. Click Finish to exit. Property(S): Exit_DlgDesc3 = Setup has updated Microsoft SQL Server successfully. Click Finish to exit. Property(S): Exit_DlgDesc4 = Setup has reinstalled Microsoft SQL Server successfully. Click Finish to exit. Property(S): Exit_DlgDesc5 = Setup has upgraded Microsoft SQL Server successfully. Click Finish to exit. Property(S): Exit_DlgTitle = Completing Microsoft SQL Server Setup Property(S): SimpleFeature_DlgDesc = Select the components to install or upgrade. Property(S): SimpleFeature_DlgTitle = Components to Install Property(S): SimpleFeature_Feat1 = &SQL Server Database Services Property(S): SimpleFeature_SQLEngineVS = Create a SQL Server failover cluster Property(S): SimpleFeature_Feat2 = &Analysis Services Property(S): SimpleFeature_AnalysisServerVS = Create an Analysis Server failover cluster Property(S): SimpleFeature_Feat3 = &Reporting Services Property(S): SimpleFeature_Feat4 = N&otification Services Property(S): SimpleFeature_Feat5 = &Integration Services Property(S): SimpleFeature_Feat6 = &Workstation components, Books Online and development tools Property(S): SimpleFeatureTitle_Feat1 = SQL Server Database Services Property(S): SimpleFeatureTitle_Feat2 = Analysis Services Property(S): SimpleFeatureTitle_Feat3 = Reporting Services Property(S): SimpleFeatureTitle_Feat4 = Notification Services Property(S): SimpleFeatureTitle_Feat5 = Integration Services Property(S): SimpleFeature_Advanced = A&dvanced Property(S): SimpleFeature_AdvancedText = For more options, click Advanced. Property(S): SimpleFeature_Components = Components to be installed Property(S): SimpleFeature_OutOfSpace = There is not enough disk space to install the selected components. Click Advanced for more options. Property(S): Feature_DlgDesc = Select the program features you want installed. Property(S): Feature_DlgText = Click an icon in the following list to change how a feature is installed. Property(S): Feature_DlgTitle = Feature Selection Property(S): Feature_FeatureFrame = Feature description Property(S): Feature_GroupBox1 = Installation path Property(S): FileInUse_DlgDesc = Some files that need to be updated are currently in use. Property(S): FileInUse_DlgText = The following applications are using files that need to be updated by this setup. Close these applications and click Retry to continue. Property(S): FileInUse_DlgTitle = Files in Use Property(S): InitDlg_Title = Microsoft SQL Server Installation Property(S): InitDlg_Desc = Setup is preparing to continue with the installation. Property(S): InitDlg_Text = Please wait while setup prepares to continue with the installation. Property(S): Instance_Default = &Default instance Property(S): Instance_DlgDesc = You can install a default instance or you can specify a named instance. Property(S): Instance_DlgText = Provide a name for the instance. For a default installation, click Default instance and click Next. To upgrade an existing default instance, click Default instance. To upgrade an existing named instance select Named instance and specify the instance name. Property(S): Instance_DlgText1 = To view a list of existing instances and components click on Installed instances. Property(S): Instance_DlgTitle = Instance Name Property(S): Instance_Named = N&amed instance Property(S): IPAddress_DlgDesc = Enter virtual server information. Property(S): IPAddress_DlgStaticTextClusterIP = Network address: Property(S): IPAddress_DlgStaticTextIPAddress = &IP address: Property(S): IPAddress_DlgStaticTextIPSel = &Selected networks and IP addresses: Property(S): IPAddress_DlgStaticTextNetToUse = N&etwork to use: Property(S): IPAddress_DlgStaticTextSubnet = Network subnet: Property(S): IPAddress_DlgStaticTextVSName = Virtual server name: Property(S): IPAddress_DlgText = Enter an IP address for the virtual server. To add IP addreses for additional networks, click Add. Property(S): IPAddress_DlgTitle = Virtual Server Configuration Property(S): License_Devices = devices Property(S): License_Processors = processors Property(S): LicenseModeDlg_DlgDesc = SQL server supports two client licensing modes: per seat licensing and processor licensing. Property(S): LicenseModeDlg_DlgText = Choose the appropriate licensing modes. Property(S): LicenseModeDlg_DlgText1 = Per seat license: each device that accesses Microsoft SQL Server requires a separate license. Property(S): LicenseModeDlg_DlgText2 = Processor license: each processor on this server requires a separate license. Property(S): LicenseModeDlg_DlgTitle = Licensing Mode Property(S): LicenseModeDlg_Processor = &Processor license for Property(S): LicenseModeDlg_RadioButtonGroup = Licensing mode Property(S): LicenseModeDlg_Seat = Per &seat license for Property(S): Maintenance_ChgLabel = Ch&ange Installed Components Property(S): Maintenance_ChgLabelCl = &Maintain the Virtual Server Property(S): Maintenance_ChgText = Maintain features of this instance. Property(S): Maintenance_ChgTextCl = Add or remove nodes to the virtual server. Property(S): Maintenance_DlgDesc = You can change or remove this instance of SQL Server. Property(S): Maintenance_DlgTitle = Change or Remove Instance Property(S): Maintenance_RmvLabel = R&emove Microsoft SQL Server Property(S): Maintenance_RmvText = Remove all features of this existing installation from your computer. Property(S): Maintenance_RmvTextCl = Remove the virtual server from your cluster. Property(S): Maintenance_ChgLabelResume = Complete the &suspended installation Property(S): Maintenance_ChgTextResume = Complete the suspended installation of Microsoft SQL Server on your computer. Property(S): Progress_DlgDesc1 = The program features you selected are being installed. Property(S): Progress_DlgDesc2 = The Microsoft SQL Server is being removed. Property(S): Progress_DlgDesc3 = Setup is installing the components you selected. Property(S): Progress_DlgDesc4 = The Microsoft SQL Server is being reinstalled. Property(S): Progress_DlgText1 = Please wait while Setup installs Microsoft SQL Server. Installation may take several minutes. Property(S): Progress_DlgText2 = Please wait while Setup removes Microsoft SQL Server. This may take several minutes. Property(S): Progress_DlgText3 = Please wait while Setup updates Microsoft SQL Server. This may take several minutes. Property(S): Progress_DlgText4 = Please wait while Setup reinstalls Microsoft SQL Server. Installation may take several minutes. Property(S): Progress_DlgTitle1 = Installing Microsoft SQL Server Property(S): Progress_DlgTitle2 = Removing Microsoft SQL Server Property(S): Progress_DlgTitle3 = Configuring Microsoft SQL Server Property(S): Progress_DlgTitle4 = Reinstalling Microsoft SQL Server Property(S): Progress_lbStatus = Status: Property(S): Register_CompLabel = C&ompany: Property(S): Register_DlgSpec = The following information will personalize your installation. Property(S): Register_DlgText = The Name field must be filled in prior to proceeding. The Company field is optional. Property(S): Register_DlgText1 = Please enter your 25 character Product Key. You can find this number on the yellow sticker in the CD liner notes or the CD sleeve. Property(S): Register_DlgTitle = Registration Information Property(S): Register_NameLabel = N&ame: Property(S): Resume_ResumeText = Setup will complete the suspended installation of Microsoft SQL Server on your computer. To continue, click Next. Property(S): Resume_TextLine1 = Microsoft SQL Server Installation Wizard Property(S): ServiceAccountDlg_Advanced = &Customize for each service account Property(S): ServiceAccountDlg_Autostart = Start services at the end of setup Property(S): ServiceAccountDlg_AutostartServices = Start services at the end of setup Property(S): ServiceAccountDlg_DlgDesc = Service accounts define which accounts to log in. Property(S): ServiceAccountDlg_DlgTitle = Service Account Property(S): ServiceAccountDlg_Domain = Use a domain use&r account Property(S): ServiceAccountDlg_DomainLabel = &Domain: Property(S): ServiceAccountDlg_BuiltIn = Use the built-in S&ystem account Property(S): ServiceAccountDlg_PasswordLabel = &Password: Property(S): ServiceAccountDlg_Service = S&ervice: Property(S): ServiceAccountDlg_Service1 = Service: Property(S): ServiceAccountDlg_UsernameLabel = &Username: Property(S): Setup = Setup Property(S): StartCopy_DlgDesc = Setup is ready to begin installation. Property(S): StartCopy_DlgDescReinst = Setup is ready to begin reinstallation. Property(S): StartCopy_DlgDescRemove = You have chosen to remove the program from your system. Property(S): StartCopy_DlgDescRemoveCl = You have chosen to remove the program from your cluster. Property(S): StartCopy_DlgDescVSConfig = Setup is ready to begin updating your virtual server. Property(S): StartCopy_DlgText = Setup has enough information to start copying the program files. To proceed, click Install. To change any of your installation settings, click Back. To exit setup, click Cancel. Property(S): StartCopy_DlgText2 = Click Cancel to exit setup. Property(S): StartCopy_DlgTextConfig = Setup has enough information to start installation. Click Install to proceed. Property(S): StartCopy_DlgTextReinstData = You have chosen to re-install all features of existing installation including data files, and therefore overwrite the system database. Click Reinstall to proceed. Property(S): StartCopy_DlgTextReinst = You have chosen to re-install all features of existing installation. Click Reinstall to proceed. Property(S): StartCopy_DlgTextRemove = Click Remove to remove Microsoft SQL Server from your computer. After removal, this program will no longer be available for use. Property(S): StartCopy_DlgTextRemoveCl = Click Remove to remove Microsoft SQL Server from your cluster. After removal, this program will no longer be available for use. Property(S): StartCopy_DlgTextUnchanged = You did not change your virtual server configuration. Property(S): StartCopy_DlgTitle = Ready to Install Property(S): StartCopy_DlgTitleConfig = Ready to Update Property(S): StartCopy_DlgTitleReinst = Ready to Reinstall Property(S): StartCopy_DlgTitleRemove = Remove Microsoft SQL Server Property(S): StaticUserName = Account: Property(S): StaticUserPassword = &Password: Property(S): TextDataDir = &Data files: Property(S): TextProgramFileDir = Program files
I tried to install 'SQL Server 2005 Express Edition with Advanced Services'. First, I uninstalled the old version thru Add/Delete Programs in the Control Panel.
My first problem was I didn't have IIS installed on my computer, but, I could not find it in the downloads section.
Then the installation aborted because old version databases were in C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData. But, it would not let me delete them, saying that they were being used, even though nothing was running at the time that I tried to delete them.
I get the following error message each time I try to install SQL Server 2005 Express Edition with Advanced Services SP2:
Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
This problem is described in: http://support.microsoft.com/kb/920201 and each of the IIS 7 components specified in this article have been installed.
When I continue with: http://support.microsoft.com/kb/934162, the script 'adsutil.vbs' cannot be executed because it does not exist anywhere on my drive.
My question is, what is the 'adsutil.vbs' script and how do I get a hold of it? Are these contortions really necessary to get SQL server working or has MS provided a patch for this nasty problem?
My system:
VISTA Home Premium, x64 Intel Quad CPU, 2.4GHz 4Gig RAM 500Gig hard disk
I have encountered a showstopper problem during installation. I have installed SSEE on a fresh XP, all the checks but memory requirements passed. In the final stage of the install, during the "real work", the Client Component installation failed due to missing ASP.NET state service (? spelling). After the failure the installation continued, but marked both the db engine and the management studio failed. Despite this, management studio was installed and later I have removed it with the control panel applet.
I have found a service (executable: aspnet_state.exe), started it and retried the installation. It failed again so I have removed everything installed except the VSS writer and started it again. This time the installation completed (and finally got BIDS).
Is it enough to start this ASP service manually for a painless install? I don't want to play this "on the field" ever...
i've tried to install sql server 2005 express edition several times but when it get to the 'database services' it gives the following error:
SQL Server Setup could not connect to the database service configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.
when insatalling "SQL Server 2005 Express Edition with Advanced Services SP2",the error message"cab file cannot open or corrupted",cannot read fron DVD/CD.when ignore that message installation exit.but,i try to install again.setup installed successfully .but sqlserevr cannot be connected.
From reading the licensing considerations page [1], my understanding is that if my environment is 2 servers - an IIS Server and a separate SQL Server Std - I will need a 2nd license of SQL Server to run Reporting Services on my IIS Server? Is this correct? If so, would a license of SQL Server Express Edition w/Advanced Services satisfy the second license requirement, or would I need a license to match the database server?
Essentially, what is the recommended guidance for Reporting Services and Web Applications? It's a known best practice that, for performance, run SQL Server on a dedicated machine separate from IIS. Is it recommended that the database server also serve the reports?
I am installing SQL Server 2005 Express Edition with Advanced Services on Windows XP Home Edition SP2 and received error 29521. I am installing with an account that has administrator rights. The summary.txt file contains: Error String : SQL Server Setup failed to execute a command for server configuration. The error was {Microsoft}{SQL Native Client}{SQL Server}CREATE DATABASE failed. Some file names listed could not be created. Check related errors.. Refer to the server error logs and Setup logs for detailed error information. Error Number : 29521
From the Windows update site and also via automatic download of updates, the following update fails every time...The SQL it is trying to update works fine. The following updates were not installed: Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 2 (KB 921896)
Can I use C# express edition 2008 with Reporting Services.
and i add 2008 report viewer component in my tool box list
while viewing the report in my solution ...i was getting the error as given below..
The report definition is not valid. Details: The report definition has an invalid target namespace "http://schemas.microsoft.com/sqlserver/reporting/2007/01/reportdefinition' which cannot be upgraded.
Hi, I had previously installed SQL Server 2005 Express edition (and later, SQl Server Management studio express). Recently, I wanted to try out 'Reporting services' and downloaded 'SQL server 2005 express Toolkit'. After installation, I have a new program group 'Visual studio 2005' . I started that with 'New Report Project'. I tried to attach an existing database (to be precise, in 'connection string' part) , but it is giving error saying
'An error has occured while establishing connection to Server. When connecting to SQL Server 2005 (???) ,..... may be caused the fact that under default setting SQL Server does not allow remote connections '
I tried my existing SQL Server 2005 express edition Surface Area Configuration and it is configured for accepting remote connection using both TCP/IP & named pipes.
Now, I have following doubts: 1. Do I have to download & install SQL Server 2005 Express edition wiht Advanced options, if I wish to use Reporting services or I can use the existing SS2005EE along with Toolkit services? 2. If answer is yes to above question, how do I attach a database?
If you can throw some light on above, I shall be very grateful to you.
I've installed Visual Basic 2005 express edition & tried to connect to SQL Server 2005 express edition. I noticed that VB2005 Express Edition doesn't have any OLEDB provider for SQL Server. The only OLEDB Provider is for M.Access. Is this correct? if so, what should i do if i want to connect SQL Server 2005 express edition with VB2005 express edition by using OLEDB connection type?
I really appreciate any respond from you guys.. Thank's and waiting for the good news..
Hi, I'm wondering if I can use SQL 2005 Reporting Services with SQL Server 2000, SQL Express or MSDE, or I need to install SQL Server 2005 in order to use Reporting Services 2005? Thank you in advance.
I have problem during first configuration of Reporting Services from MS SQL 2005 Server Express with Advanced Services SP2. The error occurs when configuring virtual directory (Reporting Services Configuration Manager -> Report Server Virtual Directory). When I try to create new virtual directory I can see following messages:
Number of errors: 0 Create Virtual Directory
The virtual directory was created and assigned. Changing Secure Connection Level
After last message Windows reports that SQL Server 2005 Reporting Configuration Tool has encountered a problem and needs to close (and I can send report to Microsoft).
IIS shows that virtual directory under default web site was created.
My environment: MS SQL Reporting Services Version 9.00.3042.00 Windows XP Proffessional SP2 IIS 5.1 all components are fresh new installations. The only additional configuration I've made was adding IWAM_<hostname> as WebServiceAccount, all other configuration is default.
Hello all, I have installed an SQL 2005 Standard Edition and I deploy 1 RS in the web server successfully. I wanted to know if there is a possibility to install another RS on my 2nd web server (I have 2 web servers because I have WSD active/passive) although I know you can use scale out only in SQL 2005 Enterprise Edition!
Can reporting services be upgraded to include data driven subscriptions or must SQL server be upgraded to enterprise edition. Currently I am using SQL 2000 standard edition 32bit with reporting services and data driven subscription. Has the features been changed from 2000 to 2005?
I have been unable to create a replication from an SQL Server 2005 standard edition database to remote SQL Server 2005 Express Edition. The remote express edition is on a Virtual Private Server we are leasing from a hosting company. The name of the remote DB is similar to vs572.si-vs572.com. I can connect to this with SQL server authentication through Management Studio and also with SSIS. But, I have been unable to create a push subscription (I have tried a test push subscription with the same publication to a local SQL Express server here in our office and this works fine).
Here is the error message: SQL Server Replication requires the actual server name to make a connection to the server. Connections through server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'VS572SQLEXPRESS'.
The hosting company had originally installed a shared SQL server which would not support replication. They then installed SQL Express edition and I was hoping this would allow us to run a replication.
I tried to connect to VS572SQLEXPRESS with out any luck. I check the remote connections, made sure replication was installed, etc., but no luck.
Hello!M a newbie.. I just want to know, that wots the difference b/w SQL Server Standard Edition and Express Edition.?And can I use Visual Studio 2005 (Professional Edition) with SQL Server Express Edition.?
