Installing The Asp.net Application Services In A Custom SQL Express Database.
Nov 16, 2005
I know that by default asp.net 2.0
creates the aspnetdb sql express database for storing membership, role
management, profiling etc. And I saw we have the aspnet_regsql tool to
have this installed in a standard sql server. But what should I do to
have these stored procedures, tables etc installed in an existing sql
express database? Aspnet_regsql doesn't seem suited for that.
I've noticed some sql scripts in the framework folder like
InstallCommon.sql, InstallMembership.sql, etc. They seem to be used to
create the regular aspnetdb.mdf database, should I just modify those
and run them against my own sql express database or is there a tool or
an easier way?
Hi, I am trying to install multiple application services on 1 sql server database. Is this possible? I do not know how to install anything but the default application services settings for the membership, roles, etc.
I have found a lot of info on MS site regarding installing SQL Server 2005 Express as part of an application. I have found these articles to be extremely inaccurate or at best incomplete.
1. The documentation says all I need is the setup.exe from SQLEXP but this is not true.
2. When I do launch setup.exe during my app's install, it fails because setup.exe trys to run the support.msi. Of course this causes failure because my install is also an msi.
So, does anyone know how to install SQLEXPRESS as part of my app's install?
Hi all, How to package sql server database as part of our custom application (VB application) using install shield or any software. That setup should detect the presence of sql server. If sql server is not present in the client machine, then our set up should install the sql server and deploy our database. If sql server is present in the client machine, then our set up should install our database alone. How to do that. Please help me. Regards, S.Sevugan.
Hi, if I install SQL Server Express with Advance Services on top of my existing SQL Server Express installation, will it wipe out my existing database in my current SQL Server Express installation ?
Hi All! I'm a newbie to SQL & have a question about Reporting Services. I have already installed SQL Express & now want to install Reporting Services. Is there a way to install just this feature or do I need to do a complete re-install? Thanks!
I was unable to install the CTP version of SS Express Edition SP1 with Advance Services. The installation failed with the following error message:
TITLE: Microsoft SQL Server 2005 Setup ------------------------------
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
------------------------------ However, I was able to install and run the standard CTP version of SS Express Edition SP1 without any problems, even though the above error message indicated I may have login problem. First let me confess that my computer does not have IIS installed, which as I understand is only needed for running the Report Services. Is it necessary for IIS to be up and running while installing SSEE with Advance Services?
The main reason I want to install SSEE with Advance Services is to use the full text search capability. I do not need the Report Services, and was hoping there is an option to turn it off and not require IIS. Is this possible?
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 installed Sql Server Express 2005 with Advanced Services on a PC.
Several critical items failed to install including: Sql Native Client Sql Server Database Services
The installer Summary Log says: 1) the system does not meet the hardware requirements. (I do not know why... see below) 2) SQL Native Client Error: An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'.
This is a WinXP SP2 PC with 1.67 ghz processor & 512Meg ram with 12 Gig of Hard disk space remaining unused.
The web site said to install .Net Framework 2.0. I did not see that listed on the links provided so I installed .Net Framework 3.5 instead. That installed fine, althought I get a message that .Net Framework 3.0 failed to install.
When I downloaded Sql Server Express 2005 with Advanced Services, from this web site http://msdn2.microsoft.com/en-us/express/bb410792.aspx, I thought it was unusual... but the download screen said "Publisher Unknown" instead of the usual "Microsoft".
This installation went normally but failed to install those critical items. Can someone tell me what I did wrong, and how to get it installed from here?
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.
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 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'm trying to connect to a sql express database on my local machine, using the following connection string:
SqlConnection thisConnection = new SqlConnection(@"Data Source=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataTest.mdf");
However, I keep getting an error message saying "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections."
Why would my application be trying to connect remotely when the database is on my local machine? And how can I fix this problem?
I have created an .iss file which when compiled creates a setup.exe file on a cd rom. Within the .iss I have extracted the sqlexpress files out so that it will install straight from disk to the users machine rather than from the .msi file. All this has been successful so far....
My problem is:- I want to attach a database to the an instance of sqlexpress on the users machine. I have detached it from SQL Server 2000 and copied it over to the cd. The setup file copies these over the users hard drive. I have looked through many forums etc and the words that keep popping up are:-
sqlcmd.exe
template.ini
type into the command prompt.
Sorry if I'm a little ignorant but I am not sure how to go about these. How do I open the command prompt on the users machine from CD? Do I have to create something to do this?
Any information would be appreciated, any guidance or scripts would be great.
I have been programming an application with VC++ 2005 and SQL Server 2005. I have converted an old 16-bit database to 32-bit managed code and SQL server and the application seems to be good. Now I want to deploy the application to another server for testing.
I have installed XP SP2, Windows Installer 3.1, Net framework 2.0 and SQL Server 2005 express to the test server. I have transferred the application with WI 3.1 and the program works well in the test server till the first SQL command. I have made a back up of the database and restored it in the test server. In the test server I can log in the database with Server Management studio and I can read the data there correctly. I have enabled both named pipes and TCP/IP for the database in the test server. With Surface Area Configuration I have enabled Local and Remote Connections Using both TCP/IP and named pipes. I only need Windows authentication at this time.
After all this when I come to the first SQL command in the application on the test server I receive the error message: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 €“ Could not open a connection to SQL Server).
My connection string to the database is: 'connection->ConnectionString = "Persist Security Info=False; Integrated Security =SSPI;" "Data Source=TESTSERVER; Initial Catalog=TESTDATABASE;";'
When I use "Data Source=DevelopmentServer", the application works well on the development server.
Can't understand what is still wrong. Can you possibly have an answer for me?
Trying to install SQL Server Express Edition from downloaded file SQLEXPR_DUT.EXE. MSXML6, SQL Setup support files, SQL Native Client and SQL VSS Writer are all installed ok, but SQL Server Database Services fails with a message that the SQL Server-service cannot be started and to look at Book Online for error files and starting manually. The end of the relevant error file would seem to be:
2006-07-26 18:45:47.33 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required. 2006-07-26 18:45:47.33 Server Detected 1 CPUs. This is an informational message; no user action is required. 2006-07-26 18:45:47.48 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required. 2006-07-26 18:45:47.49 Server Database Mirroring Transport is disabled in the endpoint configuration. 2006-07-26 18:45:47.49 spid5s Warning ****************** 2006-07-26 18:45:47.50 spid5s SQL Server started in single-user mode. This an informational message only. No user action is required. 2006-07-26 18:45:47.50 spid5s Starting up database 'master'. 2006-07-26 18:45:47.60 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required. 2006-07-26 18:45:47.71 spid5s SQL Trace ID 1 was started by login "sa". 2006-07-26 18:45:47.75 spid5s Starting up database 'mssqlsystemresource'. 2006-07-26 18:45:47.78 spid5s The resource database build version is 9.00.2047. This is an informational message only. No user action is required. 2006-07-26 18:45:48.20 spid5s Error: 15209, Severity: 16, State: 1. 2006-07-26 18:45:48.20 spid5s An error occurred during encryption. 2006-07-26 18:45:48.20 spid5s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
I have a windows app I am deploying by CD along with SQL Server - when I manually installed sql server my app can access the db (named instance, local system, mixed mode). I used the exact same settings to do an unattended install for sql express and it does not work. All the settings in the db look the same. Does anyone know what it could be?
I am having problems connecting to the database. I am trying to use Membership API and for some reason it will no longer connect to the database. I previously had Visual Studio 2005 Standard Edition and it worked just fine, until I tried to install MS SQL Express. I have tried the aspnet_regsql and sqlcmd InstallCommon.sql and both times I received a named pipe error. I look at the configuration and it said named pipes enabled.
I eventually gave up after trying for two days and removed MS SQL Express, but now I am still getting the same error. I tried to uninstall all of the SQL editions and reinstall the MSDE that comes with VS 2005, but I am getting the same error.
When checking the ASP.NET Web Application and testing the provider I receive the following error: Could not establish a connection to the database. If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider.
The security tab gives you the following error: There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.
The following message may help in diagnosing the problem: Unable to connect to SQL Server database.
Running the sqlcmd in the command prompt I receive the following error: Sqlcmd: Error: Connection failure. SQL Native Client is not installed correctly. To correct this, run SQL Server Setup.
I can't seem to get all of the SQL9_Hotfix_KB913090_sqlrun_sql.msp.log to post (too big), but I can post the SQL9_Hotfix_KB913090.log file...hope that helps and which seems to me might contain the clue as to what's going. Any ideas would be appreciated. This is happening on a fresh install of Win Server 2003 and SQL Server standard 2005.
Thanks,
Steve
04/09/2007 16:14:30.562 ================================================================================ 04/09/2007 16:14:30.578 Hotfix package launched 04/09/2007 16:14:33.312 Product discovery successfully completed during the install process for MSSQLSERVER 04/09/2007 16:14:33.328 SP Level check successfully completed during the install process for MSSQLSERVER 04/09/2007 16:14:33.359 Product language check successfully completed during the install process for MSSQLSERVER 04/09/2007 16:14:33.390 Product version check successfully completed during the install process for MSSQLSERVER 04/09/2007 16:14:33.421 Command-line instance name check completed during the install process 04/09/2007 16:14:33.437 Baseline build check completed during the install process 04/09/2007 16:16:52.828 Attempting to install instance: MSSQLSERVER 04/09/2007 16:16:52.875 Attempting to install target: TURBULENT2 04/09/2007 16:16:53.015 Attempting to stop service: SQLSERVERAGENT 04/09/2007 16:16:58.171 Successfully stopped service: SQLSERVERAGENT 04/09/2007 16:16:58.203 Attempting to stop service: MSSQLServer 04/09/2007 16:17:00.250 Successfully stopped service: MSSQLServer 04/09/2007 16:17:00.281 Attempting to check for locked files: sqlrun_sql.msp 04/09/2007 16:17:00.468 Attempting to check for locked files: \TURBULENT2f$9104ddf6956f8b22663aHotFixSQLFilessqlrun_sql.msp 04/09/2007 16:17:00.500 Creating MSP locked file check log at: C:WINDOWSHotfixSQL9LogsSQL9_Hotfix_KB913090_sqlrun_sql.msp.out 04/09/2007 16:17:38.125 MSP returned 1602: The user cancels installation. 04/09/2007 16:17:38.328 Successfully checked file: \TURBULENT2f$9104ddf6956f8b22663aHotFixSQLFilessqlrun_sql.msp 04/09/2007 16:17:38.359 Successfully opened registry key: SystemCurrentControlSetControlSession Manager 04/09/2007 16:17:38.421 Failed to read registry key: PendingFileRenameOperations 04/09/2007 16:17:38.468 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnxmlfilt.dll 04/09/2007 16:17:38.515 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnThaWBrkr.dll 04/09/2007 16:17:38.562 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnquery.dll 04/09/2007 16:17:38.609 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnls400.dll 04/09/2007 16:17:38.687 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnlhtml.dll 04/09/2007 16:17:38.734 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsir5jp.dll 04/09/2007 16:17:38.765 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsftesql.exe 04/09/2007 16:17:38.812 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsftepxy.dll 04/09/2007 16:17:38.843 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsftefd.exe 04/09/2007 16:17:38.875 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsfte.dll 04/09/2007 16:17:38.890 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnLangWrbk.dll 04/09/2007 16:17:38.921 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnkorwbrkr.dll 04/09/2007 16:17:38.937 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinninfosoft.dll 04/09/2007 16:17:38.968 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERefFTERef.dll 04/09/2007 16:17:39.000 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnCHTBRKR.DLL 04/09/2007 16:17:39.015 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnChsBrkr.dll 04/09/2007 16:17:39.046 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0 C:Program FilesMicrosoft SQL Server90COMResources1033REPLRES.rll 04/09/2007 16:17:39.062 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0 C:Program FilesMicrosoft SQL Server90COM eplrec.dll 04/09/2007 16:17:39.093 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0 C:Program FilesMicrosoft SQL Server90COM plisapi.dll 04/09/2007 16:17:39.156 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0 C:WINDOWSassemblyGAC_32Microsoft.SqlServer.Replication9.0.242.0__89845dcd8080cc91Repl.dll 04/09/2007 16:17:39.171 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.DataStorage9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DataStorage.dll 04/09/2007 16:17:39.203 Failed to read version information for the following file: C:Program FilesCommon FilesMicrosoft SharedDatabase ReplicationResources10332005.90.2047.0 C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstall plhtfin.sql 04/09/2007 16:17:39.218 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstall C:Program FilesMicrosoft SQL Server90COMqrdrsvc.exe 04/09/2007 16:17:39.250 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0 C:Program FilesMicrosoft SQL Server90COMsnapshot.exe 04/09/2007 16:17:39.281 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0 C:Program FilesMicrosoft SQL Server90COM eplmerg.exe 04/09/2007 16:17:39.296 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90COM ablediff.exe 04/09/2007 16:17:39.328 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0 C:Program FilesMicrosoft SQL Server90COMDISTRIB.exe 04/09/2007 16:17:39.359 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnDatabaseMail90.exe 04/09/2007 16:17:39.390 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources30822005.90.2047.0 C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources2052sqlevn70.rll 04/09/2007 16:17:39.406 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10422005.90.2047.0 C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1041sqlevn70.rll 04/09/2007 16:17:39.437 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10402005.90.2047.0 C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1036sqlevn70.rll 04/09/2007 16:17:39.453 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10332005.90.2047.0 C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1031sqlevn70.rll 04/09/2007 16:17:39.484 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10282005.90.2047.0 C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033XPStar90.RLL 04/09/2007 16:17:39.515 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlaccess.dll 04/09/2007 16:17:39.531 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlaccess.dll 04/09/2007 16:17:39.562 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlaccess.dll 04/09/2007 16:17:39.578 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn6.6.3.5 C:Program FilesMicrosoft SQL Server90Sharedmsxmlsql.dll 04/09/2007 16:17:39.609 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2.0.3609.0 C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnxmlrw.dll 04/09/2007 16:17:39.640 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlsvc90.dll 04/09/2007 16:17:39.656 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlsvc90.dll 04/09/2007 16:17:39.687 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlsvc90.dll 04/09/2007 16:17:39.703 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2005.90.2047.0 C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLBOOT.dll 04/09/2007 16:17:39.734 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2005.90.2047.0 C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnxplog70.dll 04/09/2007 16:17:39.765 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2005.90.2047.0 C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnatchp~1.dll 04/09/2007 16:17:39.796 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAgentMail90.rll 04/09/2007 16:17:39.812 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAgentMail90.rll 04/09/2007 16:17:39.843 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAgentMail90.rll 04/09/2007 16:17:39.875 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAGENT90.RLL 04/09/2007 16:17:39.906 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAGENT90.RLL 04/09/2007 16:17:39.921 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAGENT90.RLL 04/09/2007 16:17:39.953 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAgentMail90.dll 04/09/2007 16:17:39.984 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAgentMail90.dll 04/09/2007 16:17:40.000 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAgentMail90.dll 04/09/2007 16:17:40.031 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAGENT90.EXE 04/09/2007 16:17:40.062 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAGENT90.EXE 04/09/2007 16:17:40.078 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAGENT90.EXE 04/09/2007 16:17:40.140 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90SharedResources10339.0.2047.0 C:Program FilesMicrosoft SQL Server90Sharedmsmdrdir.dll 04/09/2007 16:17:40.156 Failed to read version information for the following file: C:Program FilesCommon FilesSystemole db2.0.3609.0 C:Program FilesCommon FilesSystemole dbxmlrw.dll 04/09/2007 16:17:40.171 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsmdlocal.dll 04/09/2007 16:17:40.203 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsmdlocal.dll 04/09/2007 16:17:40.218 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsmdlocal.dll 04/09/2007 16:17:40.265 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlbrowser.exe 04/09/2007 16:17:40.281 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlbrowser.exe 04/09/2007 16:17:40.296 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlbrowser.exe 04/09/2007 16:17:40.312 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll 04/09/2007 16:17:40.328 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll 04/09/2007 16:17:40.359 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll 04/09/2007 16:17:40.375 Failed to read version information for the following file: C:Program FilesMicrosoft.NETADOMD.NET90enMicrosoft.AnalysisServices.AdomdClient.xml 04/09/2007 16:17:40.390 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft.NETADOMD.NET90Microsoft.AnalysisServices.AdomdClient.dll 04/09/2007 16:17:40.421 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices.AdomdClient9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.AdomdClient.dll 04/09/2007 16:17:40.437 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033 C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033sqlcm.xml 04/09/2007 16:17:40.453 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll 04/09/2007 16:17:40.484 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll 04/09/2007 16:17:40.500 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll 04/09/2007 16:17:40.515 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll 04/09/2007 16:17:40.531 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll 04/09/2007 16:17:40.546 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll 04/09/2007 16:17:40.578 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnatchparser90.dll 04/09/2007 16:17:40.593 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnatchparser90.dll 04/09/2007 16:17:40.609 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnatchparser90.dll 04/09/2007 16:17:40.625 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources10332005.90.2047.0 C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstallsysdbupg.sql 04/09/2007 16:17:40.656 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSQLSVC90.DLL 04/09/2007 16:17:40.671 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSQLSVC90.DLL 04/09/2007 16:17:40.687 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSQLSVC90.DLL 04/09/2007 16:17:40.703 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinn2.0.3609.0 C:Program FilesMicrosoft SQL Server90ToolsBinnSQLdiag.exe 04/09/2007 16:17:40.718 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinn2005.90.2047.0 C:Program FilesMicrosoft SQL Server90Sharedsqlsvc~1.dll 04/09/2007 16:17:40.765 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll 04/09/2007 16:17:40.781 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll 04/09/2007 16:17:40.796 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll 04/09/2007 16:17:40.812 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll 04/09/2007 16:17:40.843 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll 04/09/2007 16:17:40.875 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll 04/09/2007 16:17:40.890 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll 04/09/2007 16:17:40.906 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll 04/09/2007 16:17:40.937 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll 04/09/2007 16:17:40.968 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll 04/09/2007 16:17:40.984 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll 04/09/2007 16:17:41.000 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll 04/09/2007 16:17:41.015 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90Shared2005.90.2047.0 C:Program FilesMicrosoft SQL Server90Sharedsqlsqm.exe 04/09/2007 16:17:41.046 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90Shared9.0.2047.0 C:Program FilesMicrosoft SQL Server90Shareddbghelp.dll 04/09/2007 16:17:41.062 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe 04/09/2007 16:17:41.125 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe 04/09/2007 16:17:41.171 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe 04/09/2007 16:17:41.203 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Rmo9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.Rmo.dll 04/09/2007 16:17:41.234 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.DLL 04/09/2007 16:17:41.250 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.DataWarehouse.Interfaces9.0.242.0__89845dcd8080cc91Microsoft.DataWarehouse.Interfaces.DLL 04/09/2007 16:17:41.265 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.RegSvrEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.RegSvrEnum.dll 04/09/2007 16:17:41.281 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll 04/09/2007 16:17:41.312 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll 04/09/2007 16:17:41.328 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll 04/09/2007 16:17:41.359 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ServiceBrokerEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ServiceBrokerEnum.dll 04/09/2007 16:17:41.375 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.WmiEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.WmiEnum.dll 04/09/2007 16:17:41.406 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.SqlEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SqlEnum.dll 04/09/2007 16:17:41.421 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.SmoEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SmoEnum.dll 04/09/2007 16:17:41.453 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Smo9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.Smo.dll 04/09/2007 16:17:41.484 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlSAC.exe 04/09/2007 16:17:41.515 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedMicrosoft.SqlSac.Public.dll 04/09/2007 16:17:41.687 Attempting to install file: sqlrun_sql.msp 04/09/2007 16:17:41.750 Attempting to install file: \TURBULENT2f$9104ddf6956f8b22663aHotFixSQLFilessqlrun_sql.msp 04/09/2007 16:17:41.765 Creating MSP install log file at: C:WINDOWSHotfixSQL9LogsSQL9_Hotfix_KB913090_sqlrun_sql.msp.log 04/09/2007 16:17:41.796 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller 04/09/2007 16:17:41.812 Failed to read registry key: Debug 04/09/2007 16:19:50.187 MSP returned 1603: A fatal error occurred during installation. 04/09/2007 16:19:50.250 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller 04/09/2007 16:19:50.265 Failed to read registry key: Debug 04/09/2007 16:19:50.296 Unable to install MSP file: \TURBULENT2f$9104ddf6956f8b22663aHotFixSQLFilessqlrun_sql.msp 04/09/2007 16:19:50.312 The following exception occurred: Unable to install Windows Installer MSP file Date: 04/09/2007 16:19:50.312 File: depotsqlvaultsetupmainsetupsqlsesqlsedllcopyengine.cpp Line: 856 04/09/2007 16:19:50.437 04/09/2007 16:19:50.468 Product Status Summary: 04/09/2007 16:19:50.500 Product: SQL Server Native Client 04/09/2007 16:19:50.546 SQL Server Native Client (RTM ) - Success 04/09/2007 16:19:50.578 04/09/2007 16:19:50.609 Product: Setup Support Files 04/09/2007 16:19:50.640 Setup Support Files (RTM ) - Success 04/09/2007 16:19:50.656 04/09/2007 16:19:50.687 Product: Database Services 04/09/2007 16:19:50.734 Database Services (SP1 2047 ENU) - Failure 04/09/2007 16:19:50.750 Details: Unable to install Windows Installer MSP file 04/09/2007 16:19:50.781 Reporting Services (SP1 2047 ENU) - Not Applied 04/09/2007 16:19:50.812 04/09/2007 16:19:50.843 Product: Client Components 04/09/2007 16:19:50.890 Client Components (SP1 2047 ENU) - Not Selected 04/09/2007 16:19:50.921 04/09/2007 16:19:50.953 Product: MSXML 6.0 Parser 04/09/2007 16:19:50.968 MSXML 6.0 Parser (RTM ) - Not Selected 04/09/2007 16:19:51.015 04/09/2007 16:19:51.046 Product: SQLXML4 04/09/2007 16:19:51.078 SQLXML4 (RTM ) - Not Selected 04/09/2007 16:19:51.109 04/09/2007 16:19:51.125 Product: Backward Compatibility 04/09/2007 16:19:51.140 Backward Compatibility (RTM ) - Not Selected 04/09/2007 16:19:51.171 04/09/2007 16:19:51.203 Product: Microsoft SQL Server VSS Writer 04/09/2007 16:19:51.265 Microsoft SQL Server VSS Writer (RTM ) - Not Selected 04/09/2007 16:19:51.296 04/09/2007 16:29:32.812 Hotfix package closed
I have SQL server express 2005 installed on my pc as instance SQLEXPRESS.
I have created a Visual Basic applicaion with the following as connection to the SQL server express 2005 running on the same PC: **************************************************************************************************** Dim lconnectionString As String Dim builder As New SqlConnectionStringBuilder Dim cmd As New SqlCommand Dim reader As SqlDataReader Dim parameter As SqlParameter builder("Data Source") = ".SQLEXPRESS" builder("Initial Catalog") = "" builder("AttachDbFilename") = "C:My DocumentsVisual Studio 2005Projectsabcabcabc.mdf" builder("Integrated Security") = True builder("User Instance") = True lconnectionString = builder.ConnectionString Dim sqlConnection1 As New SqlConnection(lconnectionString) cmd.CommandText = "SP_add_collection" cmd.CommandType = CommandType.StoredProcedure cmd.Connection = sqlConnection1 sqlConnection1.Open() *******************************************************************************************************************
It seems that i can not connect to the abc.mdf in SSMSE while the VB program is running. (ERROR: Database 'C:My DocumentsVisual Studio 2005Projectsabcabcabc.mdf' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details. (.Net SqlClient Data Provider) )
If i connect to the abc.mdf first in SSMSE, then run the VB program afterwards, it gives me the error on this line -- sqlConnection1.Open()
I want to be able to access the abc.mdf database with both SSMSE and VB at the same time. Could anyone help me on this ?
I am new to SQL Server, but the current project that I am working on has the following requirement:-
1) Migrate the application (a servlet based web application on Apache Tomcat) from Solaris to Wintel 2) Migrate the supporting database from SQL Server 2000 to Sql Server 2005 3) Get IIS to communicate with Tomcat for serving servlet/jsp etc to the client
Though I successfully completed item 1 above, am stuck at item 2. Details are below
Actions taken for item 2
A. Installed MS 2005 B. Created new database in MS 2005 (logged in as user 'sa') C. Generated SQL scripts (such as create table table_A etc) from existing MS 2000 D. Genearted SQL scripts (such as insert into table_A etc) from existing MS 2000 E. Created new schema in MS 2005 F. Ran scripts C & D in the new schema. All tables are records populated. G. Obtained new JDBC driver and test run to see if connection is working fine, and it worked. Even ran an sql statment
Code Block[select count(*) from sa.table_A]
and got appropriate response.
H. When I made the application to talk to this new database (which is a copy of Production from step C, D above), it's behaving as though it cannot find the record. I. When I further debugged, I realised that the web application is excuting queries without mentioning the schema. For eg.
Code Block[Select firstName, lastName from table_A]
Or rather it assumes that the user connecting to database is same as the schema name.
J. To further ascertain my point, I ran the query
Code Block[Select firstName, lastName from sa.table_A]
and it worked!
Now the real problem is that I cannot modify the existing code to append a schema name and this approach is rather not recommended best practise.
I tried to match the user name with the schema name, even made this schema as default to the user. But still not finding any luck.
I request all you experts out there to help me out with this problem.
Is there a way to use a custom component programmatically (I'm using C# to create and run my packages) without installing a compiled .dll of the class into the SQL folders and the GAC? For instance, can I instantiate my custom component and somehow pass it to be used in a task in my code.
I made my own DTS custom task with Visual Basic 6.0. The DTS custom task work but when i delete it from the DTS package a mmc.exe application error occur about written memory.
I trie an other DTS custom task that i dowloaded from this site, the same error occur.
My SQL Server version is the 7.0 with Service Pack 1.
Does anyone have any experience or knowledge what would be best way of installing msde with vb application I created vb app with msde database , right now app uses sql server, iam planning to move sql database to msde and distribute that with vb app. What would be best approach for distributing and installing those files? Does vb package deployment will do the trick or I should acuire some professional setup program ?? Thanks Robert
I have an application that is being developed on Visual Studio 2005 (VB) and SQL Express. The application is set up to use the SQL Express on the development computer, and if an Internet or CD install is built, it installs SQL Express as expected. The question is, when it is time to deploy and put the SQL Express database on the 2003 server, how should the install on the server be done and how should we set the database path to the server?
I am invoking RS web services to render reports, using Apache Axis to generate stub classes from Reporting Service WSDL.
Please let me know if I can integrate Report Viewer control in the jsp where I am writing the report output. Else do I have to create my own custom tags simulating ReportViewer functionality.
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'.
My query should be pretty simple to answer by the gurus. I have SQL Server Express Advance series installed at my system along with VS 2005. I tried the reporting services (remote mode) to display a report in the report viewer on my aspx page. The report simply uses an SQL query to get the result. Everything works fine and dandy!
However if i want to get data from my own data set, i used a webservice and ussed the XML data source option in the report to traverse through the XML. In the preview mode of the RDL everything works fine however when i deploy or rather run it using report viewer on my webpage, it gives an error that 'XML' has not been registered as an extension etc.
I looked in the rsserver config file, it IS configured. The only answer i have is that the EXPRESS version of SQL only supports the regular SQL data sources. I do not understand if that was the case, why does the preview mode work fine??
If i am correct then for the next release the ms developers should disable that or rather give a more meaning full error. I spent an entire day fideling around just to find out that it isnt supported with debates all over the place as to why in the world does it work in the preview mode?
Anyhoo, to get around that issue, i am wondering if the Custom Data Extension would work on the SQL Express or not? I am assuming it wouldnt. Please clearify this. Ideally all i want is to access my own data set in the report, no SQL queries or whatever, CDE seems the way forward but does SQL Express allow it?
Many thanks guyz.
Regards
Zeeshan (btw, its only been two days since i started working with reporting services, so be gentle :-D )
When I run the install script, I always get a warning that the hard drive (space?) won't support the install, but I have installed successfully with the new tools etc. and I still have 20 gigs left on my laptop. Why is this warning given?