Setup Issue: Unable To Install SQL Server 2005 Express On Windows 2003 Server SP2
Aug 17, 2006
Hello Experts,
I have been unable to install SQL Express 2005 Server on my Windows 2003 Server (with SP2 installed). I keep getting an error message saying that Microsoft Windows Installer 3.1 is not installed.
Click here for image
So, I downloaded Microsoft Windows Installer 3.1 v2 (WindowsInstaller-KB893803-v2-x86.exe) but whenever I try to install it I get an error message saying that "the Service Pack version of this system is newer than the update you are applying" and that there is no need to install the update and it stops there.
Click here for image
Is there a workaround to this? How can I get Microsoft Windows Installer 3.1 installed? I tried going to the Windows Update site, I already have everything installed and I even started the Windows Installer service manually. Has anyone else experienced this?
How can I get SQL Server 2005 Express installed if not how can I install SQL Server 2000 on tihs machine? The only reason I am trying to install SQL Server 2005 is because wanted to try it so I uninstalled SQL Server 2000 now I can no longer install SQL Server 2000 again because it won't let me because of the SP2 patch.
hi everyone, can anyone help me how to install sql 2005 server express edition on windows server 2003 x64 edition. because its my first time installing on a 64 bit OS i dont know how. When i tried installing it gives a warning on ASP.Net , when i ignore that & continue the installation. when installing now the SQLServer Management Studio Express now it says "installation of this product failed because it is not supported on this qperating system....." any idea?
I Try to install SQL Server Express in Windows 2003 Standard edition x64 and have some problems.
It say that can not instal client and say to use sqlncli_x64.msi, but I can not find this packege to install this client and I receive one alert with ASP.NET register 64.
I Check all request systems requirements many times and looks ok.
How can I solve this to install properly the SQL 2005 Express? When the setup finish say that was not possiblem to install SQL Server 2005 Express.
I cant figure out why this is happening.. its a fresh 2003 x64 R2 sp2 server, during the installation of the SQL Server Database Services the server hangs and displays Setting File Security. I let the install run for over 45 mins and it still hangs... the log file is useless.. i cant find any clues as to why ...
VERY frustrating. I have tried uninstalling. removing regietry keys. removing with the windows unistaller etc... to NO avial. See my Core.Log:
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run: "c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 3221225477 Aborting queue processing as nested installer has completed Message pump returning: 3221225477
And my Core(local).log:
Error: Action "ReportChainingResults" threw an exception during execution. DwLaunchMsiExec() returned : -1073741819 Error Code: -1073741819 Windows Error Text: Source File Name: sqlchainingsqlchainingactions.cpp Compiler Timestamp: Mon Jan 16 02:06:13 2006 Function Name: sqls::ReportChainingResults::perform Source Line Number: 3140
I'm unable to successfully install SQL 2005 on Windows Server 2003. Everything installs correctly except 'SQLXML4', and after installation, there's no Management Studio, unless I then install SQL Express Management Studio.
Installation details: Successfully installs 'Native Client' and the 'Support Files'. The 'System Configuration Check' passes everything. Installed 'Database Services', 'Integration Services', 'Client Components' (except for the 2 development tools), and 'Books Online'. Created the default instance (there were no other instances). Set it to run as 'Local System'. Set only the 'SQL Server' service to start after setup. Specified 'Mixed Mode'.
Then the installation proceeds, and everything looks good until SQLXML4 fails. Soon after, a window pops up saying "Setup is preparing to continue with the installation". Nothing happens till I click 'OK', and then 'Workstation Components' shows as having failed. Then the installation finishes normally. However there's no Management Studio, except that I then installed the SQL Express Management Studio, which appears to work fine.
I tried uninstalling, and installing again, but got the same results.
I tried to install SQL Server 2005 (x64) Standard Edition on Windows Server 2003 R2 (x64) Standard Edition. My box meet the requirement. But I got the following error when the installing progress was just about to begin:
Error 1016:Could not access network location k.3643236F_FC70_11D3_A536_0090278A1BB8]URTVersio.
(this is exactly what i saw in the system log)
what does it mean?? i am totally confused...what the hell is the k.3643236F_FC70_11D3_A536_0090278A1BB8]URTVersio????
I am trying to install SQL 2005 in a 2-node virtual Windows 2003 cluster. I set the cluster up through Virtual Server 2005 with 2 virtual nodes and one virtual domain. The nodes can connect to each other as well as the physical machine. When I try to install a fresh copy of SQL 2005 on my cluster, I get an error every time. The error stops the installation while checking system configuration after installing prerequisites. The log file entry is as follows:
******************************************* Setup Consistency Check Report for Machine: --SERVERNAME-- ******************************************* Article: WMI Service Requirement, Result: CheckPassed Article: MSXML Requirement, Result: CheckPassed Article: Operating System Minimum Level Requirement, Result: CheckPassed Article: Operating System Service Pack Level Requirement, Result: CheckPassed Article: SQL Compatibility With Operating System, Result: CheckPassed Article: Minimum Hardware Requirement, Result: CheckPassed Article: IIS Feature Requirement, Result: Warning Description: IIS is not installed, therefore Report Server feature will be disabled Action: Install IIS in order for Report Server feature to be enabled Article: Pending Reboot Requirement, Result: CheckPassed Article: Performance Monitor Counter Requirement, Result: CheckPassed Article: Default Installation Path Permission Requirement, Result: CheckPassed Article: Internet Explorer Requirement, Result: CheckPassed Article: Check COM+ Catalogue, Result: CheckPassed Article: ASP.Net Registration Requirement, Result: CheckPassed Article: Minimum MDAC Version Requirement, Result: CheckPassed <Func Name='PerformDetections'> 1 Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0 Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Error information reported during run: Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "ComputerList" {"SqlComputers", "", ""} in cache Source File Name: datastoreclusterinfocollector.cpp Compiler Timestamp: Fri Sep 16 13:20:12 2005 Function Name: ClusterInfoCollector::collectClusterVSInfo Source Line Number: 883 ---------------------------------------------------------- Failed to detect VS info due to datastore exception. Source File Name: datastoreclustergroupsproperties.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: ClusterGroupScope.SharedDisks Source Line Number: 56 ---------------------------------------------------------- Failed to find a cluster group that owned shared disk: J: WinException : 2 Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified. Source File Name: datastoreclustergroupsproperties.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: ClusterGroupScope.SharedDisks Source Line Number: 56
I have tried to install SQL Server 2005 Standard edition with CLUSTERING. I faced a problem and everything rolls back.
TITLE: Microsoft SQL Server 2005 Setup ------------------------------
SQL Server Setup was unable add user domain1xyz to local group domain1IT Security Admin-Group.
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29512&EvtType=sqlca%5csqlsecurityca.cpp%40Do_sqlGroupMember%40Do_sqlGroupMember%40x6ba
I have refered to PostI=1659185 posted by Fly and it still won't be able to fix my problem.
I have added LOCAL SERVICE into the local group (SQLServer2005MSFTEUser$AAA$MSSQLSERVER), but it still can't work.
Please can someone help me on this. Thank a lot....
Hello - We have been unable to successfully install Integration Services with an instance of SQL 2005 running on a Windows Small Business Server 2003. Installation proceeds with no errors, but when you attempt to connect to the Integrations Services and browse to where it apparently exists, the SQL Server Managment Studio returns the following error:
TITLE: Connect to Server ------------------------------
I'have this error during install of Microsoft SQL Server 2005 Express Edition (x86). I'm Using Windows XP Professional with SP2 Build 2600. Does anyone knows how to solve this?
****
Microsoft SQL Server 2005 Setup was unable to install on your computer.
Can anyone confirm whether SQL Server 2005 Express edition SP2 is compatible with Windows Server 2003 SP 2? The SQL Server 2005 Express readme only mentions 2003 SP1.
Can anyone confirm whether SQL Server 2005 Express edition SP2 is compatible with Windows Server 2003 SP 2? The SQL Server 2005 Express readme only mentions 2003 SP1.
I note that after installing sql server 2005 express onto a Windows 2003 server from a Windows XP pro computer I lose the ability to backup, specifically, the microsoft sql studio express lost or is missing the function (management -> Management plans) which allows for backups to be run at specified times.
How can I proceed to backup my SQL server 2005 express database ?
I run setup using GUI. It upgrades all components of the existing installation w/out any problems except the last component. That is, it proceeds with the installation of SQL Server Database Serices and at the end fails to shut down the SQL Server and aborts the installation reporting the following:
"Service 'Computer_NameSQLEXPRESS' could not be stopped. Verify that you have sufficient privileges to stop system services. The error code is (16386)".
I am running Windows XP SP2 with both .NET 2.0 and .NET 3.0 installed on it. I am logged in as a system administrator.
The most puzzling to me things are:
- the setup starts AND STOPS w/out any problems SQL Server Reporting Services and SQL Server VSS Writer (thus finding enough privileges for both).
- the setup starts the SQL Server w/out any problems (thus it finds enough privileges to START A SYSTEM SERVICE) and then fails as described above 'lucking privileges".
During installation before failing the setup displays following:
"Run as Normal User. RANU instance Shutdwon in progress: MSSQL$SQLEXPRESS". The "normal user" puzzles me too, unless the SQL Server itself is meant here.
Any suggestions would be appreciated. I can provide the installation log file as well.
I had some issues on my server and had to uninstall .Net Framework 2.0, SQL Server 2005 Express, and SQL Express Toolkit. I installed SQL Server 2005 Express and it seemed to be ok.
Then my problems all started when I tried to install SQL Express Toolkit because I needed to install DTS Wizard again, and it errors out and wouldn't let me install it. So I uninstalled everything that's listed above again.
I then tried to install SQL Server 2005 Express again, and on the second from last screen, while its listing all the components and configuring them, I get the following error as it's configuring the last component... which was the SQL Server Database Services.
TITLE: Microsoft SQL Server 2005 Setup ----------------------------------------------------------- The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
I tried to re-install the SQL Server Express another 7 times wth no luck.
If anyone can point me in the right direction I'd really appreciate it.
I am trying to install sql server 2005 express on 64 bit windows but i get a error message saying SQLncli_x64.msi file is missing and asks me to download it.
How can i fix this problem to install the SQL server on my Windows XP x64 Edition?
My uncle runs a small networking company and has extra licenses for Windows 2003 Server as well as SQL Server 2000. Since I just graduated from college and have started working as a database programmer (for a different company) I'd like to setup a small server at home to learn more about SQL (as well as networking, but SQL is my primary concern). I know I can setup SQL Server 2000 on my main PC, but I'd still like to set everything up in a server environment.
So, what I'm wondering is if any books (or web sites?) exist that walk you through setting up Windows 2003 Server and SQL Server 2000. I've actually set these up before (it's not very complicated) but I'm not sure if I did it the "correct" way.
Ideally if any books exist on O'Reilly's Safari Bookshelf that would be even better.
Wondering if there is a different way to setup mail because of Windows Server 2003 instead of Windows Server 2000? The server I'm being asked to get mail working on will have an exchange email account and I'm not familiar with setting this up. On my 2000 machine I had to use Outlook 2000 with option for Corporate or Workgroup an a POP email account. Any help is appreciated.
I have been trying to install BCM 07 and Accounting Pro 07 for a couple days now with the same SQL Server Express eroor. I've also attempted to install SQL Express sp2 alone to no avail either. Here is the log file from my last BCM install attempt. Any advise would be GREAT! I have already tried changing my PC name to CHARLIE which did not resolve it either. Thanks for the help! Charlie
Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Professional (Build 6000) Time : Thu Jul 26 21:21:43 2007
Machine : CHARLIE Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : CHARLIE Product : Microsoft SQL Server Native Client Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : CHARLIE Product : Microsoft SQL Server VSS Writer Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : CHARLIE Product : SQL Server Database Services Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: Timeout error [258]. 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. -------------------------------------------------------------------------------- Machine : CHARLIE Product : SQL Server Database Services Error : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Shared Memory Provider: Timeout error [258]. 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. -------------------------------------------------------------------------------- Machine : CHARLIE Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.1.2047.00 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0015_CHARLIE_SQL.log Last Action : InstallFinalize Error String : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}Shared Memory Provider: Timeout error {258}. 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. Error Number : 29515 -------------------------------------------------------------------------------- SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
I have tried this several times and each time get the same result. I even installed Visual Studio 2008 beta 2 - everything but SQL Server Express installed fine. The error I get when running the SQL Server 2005 Express download is (from the log file):
Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Mon Nov 12 22:31:11 2007 Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Mon Nov 12 22:31:11 2007 SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to accept client connections Service MSSQL$SQLEXPRESS started at Mon Nov 12 22:31:18 2007 SQL_ERROR (-1) in OdbcConnection::connect sqlstate=IM003, level=-1, state=-1, native_error=160, msg=Specified driver could not be loaded due to system error 193 (SQL Native Client).
Error Code: 0x800700a0 (160) Windows Error Text: One or more arguments are not correct. Source File Name: libodbc_connection.cpp Compiler Timestamp: Wed Jun 14 16:28:15 2006 Function Name: OdbcConnection::connect@connect Source Line Number: 148
Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: Specified driver could not be loaded due to system error 193 (SQL Native Client). 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.
I have no idea what the error is or how to fix it; I've enountered a number of postings related to install errors but none match exactly.
I do have the full log. Thanks in advance for any/all help!
Past one week I have been struggling to install SQL server express edition on my laptop which is preinstalled with Vista Basic. After it commences installation, it says the .net 2.0 on the system in corrupted.
Please let me know how to proceed ASAP... i have a project due for submission this week!
I have tried to install Outlook 2007 with BCM and recieve the error listed above. I have also included a copy of my log file. Any suggestions?
Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Thu Aug 23 14:22:59 2007
Machine : MACBOOK Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0010_MACBOOK_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : MACBOOK Product : Microsoft SQL Server Native Client Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0010_MACBOOK_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : MACBOOK Product : Microsoft SQL Server VSS Writer Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0010_MACBOOK_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : MACBOOK Product : MSXML 6.0 Parser Product Version : 6.00.3883.8 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0010_MACBOOK_MSXML6_1.log Error Number : 1603 -------------------------------------------------------------------------------- SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
I have tried to install SQL Server 2005 Express several times with no success. I have followed the instructions to remove all SQL files on the Programs menu. Then, when I attempt to install it again, it only goes as far as the database where it stops and gives the error message: SQL Server cannot write system databases to C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData because it contains files from a previous installation. To continue, move the databases from the specified folder, or specify a different installation folder. Then run SQL Server Setup again.
It doesn't give options and I can only abort the installation.
Does anyone have a remedy for a technologically challenged person?
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'.
I have Vista Home premium installed on my system. I installed SQL server 2005 express SP2. When I am trying to attach Advetureworks database by using following script, i get the following error.I am logged in as administrator.What kind of permission i have to set so that i can install the database.Any help will be appreciated.Script is :
Unable to open the physical file "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAdventureWorksDW_Data.mdf". Operating system error 5: "5(Access is denied.)".
I'm facing a problem while installing the SQL Server 2005 Express on Windows 2000 Pro with SP4.
After finishing the downloading from Microsoft I start the installation and things seems to go ok but during Extracting Files step a message appears "SQL Server Setup unexpectedly failed. For more information, review the setup summary log file in %Program Files%Microsoft SQL Server90Setup BootstrapLOGSummary.txt" and it terminates the installation.
I located the log file and open it but can't understand the problem..I copy the text and paste it here for anyone who can understand it.Please, it is very importand for me to work with SQL Server for my project. Any advice or information or anything else???
Thank you all,
HERE IS THE LOG FILE:
"Microsoft SQL Server 2005 Setup beginning at Wed Mar 14 07:45:33 2007 Process ID : 2684 c:c7720b32114815db82783dd06c2d54b9setup.exe Version: 2005.90.3042.0 Running: LoadResourcesAction at: 2007/2/14 7:45:33 Complete: LoadResourcesAction at: 2007/2/14 7:45:33, returned true Running: ParseBootstrapOptionsAction at: 2007/2/14 7:45:33 Loaded DLL:c:c7720b32114815db82783dd06c2d54b9xmlrw.dll Version:2.0.3609.0 Complete: ParseBootstrapOptionsAction at: 2007/2/14 7:45:33, returned false Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run: Could not parse command line due to datastore exception. Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Wed Jun 14 16:30:14 2006 Function Name: writeEncryptedString Source Line Number: 124 ---------------------------------------------------------- writeEncryptedString() failed Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Wed Jun 14 16:30:14 2006 Function Name: writeEncryptedString Source Line Number: 123 ---------------------------------------------------------- Error Code: 0x80070002 (2) Windows Error Text: Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run: Datastore exception while trying to write logging properties. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:27:59 2006 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:28:01 2006 Function Name: SetupStateScope.primaryLogFiles Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupStateScope" 02B1CFC0Unable to proceed with setup, there was a command line parsing error. : 2 Error Code: 0x80070002 (2) Windows Error Text: Class not registered. Failed to create CAB file due to datastore exception Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:27:59 2006 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "2684"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:28:01 2006 Function Name: SetupBootstrapOptionsScope.HostSetup Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Message pump returning: 2"
I am trying to install MSDE 2.8 on this OS. When I try to install, I receive the following error: Fatal error setup This setup does not support installing on this operating system
I'm running SQL Express on Server 2003 SP1 (workstation - although, I did dcpromo promote and demote prior to installing SQL Express).
I'm trying to connect from SQL Studio Express on Vista.
TCP and Named Pipes are selected in Surface Area Config; sp_config remote, access..., 1 was run (per KB); ports 1433 & 1434 are open (I think 435 also was opened when I ran the KB instructions); Mixed mode is selected, user is set for SQL Auth, password is correct; all permissions are granted.
I found an article online which stated that mixed versions of MDAC can lead to the problem. The server has 2.82.1830 and the client has 6.0.5600.16834. Could this be the problem? If so, how to solve?
I have a Sql Server Express Edition instaled in a Windows 2003 Server. I will use SQL Authentication. Need I Cal's for Windows 2003 server to each user that will access the SQL Express ? If yes, why ?
