Cannot find mdf files: installation

Showing posts with label installation. Show all posts

Sunday, March 11, 2012

Cannot make New role assignments

New role assignment does not work on my new installation of SQL Reporting Services Enterprise edition on a Windows 2003 server. From Report Manager I navigate to: Home->Properties and select 'New Role Assignment'. I fill in a local user and select the 'Browser' role and click 'OK'. Nothing happens - there is no post-back. I have the same problem for 'Site Settings'. It's as if the Report Manager is running in read-only mode. Do I need to change some configuration to facilitate changes?
Thanks,
--steveDo you see any script errors? They would show up in the lower left corner
of IE.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"stark" <stark@.discussions.microsoft.com> wrote in message
news:2AD202DE-EA7F-4AB2-B0D0-4B6B450C75DB@.microsoft.com...
> New role assignment does not work on my new installation of SQL Reporting
Services Enterprise edition on a Windows 2003 server. From Report Manager I
navigate to: Home->Properties and select 'New Role Assignment'. I fill in a
local user and select the 'Browser' role and click 'OK'. Nothing happens -
there is no post-back. I have the same problem for 'Site Settings'. It's as
if the Report Manager is running in read-only mode. Do I need to change some
configuration to facilitate changes?
> Thanks,
> --steve|||Dan,
I'm having the same problem on trying to create New Role on both spots as the previous poster. There is no script errors in lower left hand corner. The button "New Role" does not even post back to the browser as I always thought "submit" uses the method specified in form action? Any rate the button is not working and I'm using Windows 2003 as well with lastest Framework 1.1.
HTML Output from "EditGroup.aspx"
<input type="submit" name="ui_btnCreateNewRole" value="New Role" id="ui_btnCreateNewRole" class="msrs-button" />
"Daniel Reib [MSFT]" wrote:
> Do you see any script errors? They would show up in the lower left corner
> of IE.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "stark" <stark@.discussions.microsoft.com> wrote in message
> news:2AD202DE-EA7F-4AB2-B0D0-4B6B450C75DB@.microsoft.com...
> > New role assignment does not work on my new installation of SQL Reporting
> Services Enterprise edition on a Windows 2003 server. From Report Manager I
> navigate to: Home->Properties and select 'New Role Assignment'. I fill in a
> local user and select the 'Browser' role and click 'OK'. Nothing happens -
> there is no post-back. I have the same problem for 'Site Settings'. It's as
> if the Report Manager is running in read-only mode. Do I need to change some
> configuration to facilitate changes?
> > Thanks,
> > --steve
>
>|||I found the a partial work around to get access to exisitng parent roles.
When you create a report folder, and you click on the report folder, you will have a "security" link in left hand nav. This allowed me to assign to Browser role which I did not have access to under Parent site setting and properties. Also it will ask if youre sure you want to use specific security on that folder, you must say Yes. You can always revert back using the button provided.
"Daniel Reib [MSFT]" wrote:
> Do you see any script errors? They would show up in the lower left corner
> of IE.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "stark" <stark@.discussions.microsoft.com> wrote in message
> news:2AD202DE-EA7F-4AB2-B0D0-4B6B450C75DB@.microsoft.com...
> > New role assignment does not work on my new installation of SQL Reporting
> Services Enterprise edition on a Windows 2003 server. From Report Manager I
> navigate to: Home->Properties and select 'New Role Assignment'. I fill in a
> local user and select the 'Browser' role and click 'OK'. Nothing happens -
> there is no post-back. I have the same problem for 'Site Settings'. It's as
> if the Report Manager is running in read-only mode. Do I need to change some
> configuration to facilitate changes?
> > Thanks,
> > --steve
>
>|||We have the same problem on our reporting server as well (just after
we made the last SP installation), new rule and move report actions
are not working.
After clicking on the "OK" nothing happen, no script error or any
other error indication can be found.
Any ideas?|||Hi,
this should be it:
on the server run:
aspnet_regiis -c
from the .Net framwork dir.|||I have the same problem. This aspnet_regiis didn't solve it for me...
any other suggestions?
elad@.cydoor.com (Elad) wrote in message news:<2ba7f8ad.0408041410.38bd9598@.posting.google.com>...
> Hi,
> this should be it:
> on the server run:
> aspnet_regiis -c
> from the .Net framwork dir.|||I had the problem described above... and 'aspnet_regiis -c' worked out.
Win 2003 Server, SQL Srvr w/ sp3 and RS w/ sp1.
In case this helps anyone...
The installation had a problem (25619) with virtual directories and I had to
create them manually (setup parameter -rsdonotcreatevirtualdirectories=true)
which I found in a kb article. I followed the steps to create the vir dir's
after the install and everything functioned except for the problem described
in this thread.
Perhaps the following kb article should be updated with a step to execute
aspnet_regiis -c from the .net framework dir.
http://support.microsoft.com/?kbid=867872
"Scott Stonehouse" wrote:
> I have the same problem. This aspnet_regiis didn't solve it for me...
> any other suggestions?
> elad@.cydoor.com (Elad) wrote in message news:<2ba7f8ad.0408041410.38bd9598@.posting.google.com>...
> > Hi,
> >
> > this should be it:
> >
> > on the server run:
> > aspnet_regiis -c
> >
> > from the .Net framwork dir.
>

Wednesday, March 7, 2012

Cannot install SQL Server Express

I'm attempting an new installation on an Athlon 64 3300 system running XP Pro using the default install options. Get the message "SQL Server service failed to start..." and the installer starts Rolling Back the installation leaving me with a bunch of log files that mean nothing to me.

I'm not savvy enough to solve this one. Can anyone help?

Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Thu Oct 19 20:09:10 2006
Machine : SR1365CL
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.2047.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SR1365CL_SQLSupport_1.log
--
Machine : SR1365CL
Product : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SR1365CL_SQLNCLI_1.log
--
Machine : SR1365CL
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.2047.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SR1365CL_SqlWriter_1.log
--
Machine : SR1365CL
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SR1365CL_MSXML6_1.log
--
Machine : SR1365CL
Product : SQL Server Database Services
Error : 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."
--
Machine : SR1365CL
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.1.2047.00
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SR1365CL_SQL.log
Last Action : InstallFinalize
Error String : 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."
The error is (1067) The process terminated unexpectedly.
Error Number : 29503
--

What does the event log tell you ? There should be an entry about the starting service. There might be permission or service account problem.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

My ERRORLOG shows this error:

2006-10-19 20:14:59.51 spid5s Starting up database 'mssqlsystemresource'.
2006-10-19 20:14:59.51 spid5s The resource database build version is 9.00.2047. This is an informational message only. No user action is required.
2006-10-19 20:14:59.65 spid5s Error: 15209, Severity: 16, State: 1.
2006-10-19 20:14:59.65 spid5s An error occurred during encryption.

This KB article gave me the information necessary to complete the install although the .\Protect folder did not yet exist.

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B920114

Problem solved. Thanks for the nudge in the right direction, Jens.

John

|||

I also found this thread VERY helpful, and I would just like to add two comments:

1) This applies to intel 32bit processors as well.

2) When you attempt to check the security tab for folder C:\Documents and Settings\NetworkService\Application Data\Microsoft\Protect, you may notice that there is no security tab. In that case you are using "simple file sharing", which will need to be disabled. Disable by: control panel-> folder options->view and uncheck "use simple file sharing (Recommended)" at bottom. Then, follow KB920114.

Jim

|||I am getting exactly the same error as above. I followed the directions in KB920114, but the Network Service already had full authority. So there is nothing for me to change. Needless to say, it doesn't work. Any other ideas?

Cannot install SQL Server Express

I'm not savvy enough to solve this one. Can anyone help?

What does the event log tell you ? There should be an entry about the starting service. There might be permission or service account problem.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

My ERRORLOG shows this error:

This KB article gave me the information necessary to complete the install although the .\Protect folder did not yet exist.

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B920114

Problem solved. Thanks for the nudge in the right direction, Jens.

John

|||

I also found this thread VERY helpful, and I would just like to add two comments:

1) This applies to intel 32bit processors as well.

Jim

cannot install SQl server 2005 from Hard drive

Hi,
I copied SQL 2005 server (2CDs) to the hard drive, and named disk1 and
disk2. But when I finish the installation of disk one, I was not reminded to
put disk2. The screen always show " could not find the files in disk one",
but actually these files are stored in disk2.
Does anyone here help to fix this issue?
Thanks
Hi
I assume you have a legitimate copy? Have you tried copying them over each
other?
John
"Michael" wrote:

> Hi,
> I copied SQL 2005 server (2CDs) to the hard drive, and named disk1 and
> disk2. But when I finish the installation of disk one, I was not reminded to
> put disk2. The screen always show " could not find the files in disk one",
> but actually these files are stored in disk2.
> Does anyone here help to fix this issue?
> Thanks
|||Hi John,
Thanks for your reply. Would you please explain " Have you tried copying
them ove each other?" in details?
Of course, we use legitimate copy. Normally, I copy all applications from
CD/DVD to network hard drive in case these optical disks are scrached and
cannot be used.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> I assume you have a legitimate copy? Have you tried copying them over each
> other?
> John
> "Michael" wrote:

cannot install SQl server 2005 from Hard drive

Hi,
I copied SQL 2005 server (2CDs) to the hard drive, and named disk1 and
disk2. But when I finish the installation of disk one, I was not reminded to
put disk2. The screen always show " could not find the files in disk one",
but actually these files are stored in disk2.
Does anyone here help to fix this issue?
ThanksHi
I assume you have a legitimate copy? Have you tried copying them over each
other?
John
"Michael" wrote:
> Hi,
> I copied SQL 2005 server (2CDs) to the hard drive, and named disk1 and
> disk2. But when I finish the installation of disk one, I was not reminded to
> put disk2. The screen always show " could not find the files in disk one",
> but actually these files are stored in disk2.
> Does anyone here help to fix this issue?
> Thanks|||Hi John,
Thanks for your reply. Would you please explain " Have you tried copying
them ove each other?" in details?
Of course, we use legitimate copy. Normally, I copy all applications from
CD/DVD to network hard drive in case these optical disks are scrached and
cannot be used.
"John Bell" wrote:
> Hi
> I assume you have a legitimate copy? Have you tried copying them over each
> other?
> John
> "Michael" wrote:
> > Hi,
> >
> > I copied SQL 2005 server (2CDs) to the hard drive, and named disk1 and
> > disk2. But when I finish the installation of disk one, I was not reminded to
> > put disk2. The screen always show " could not find the files in disk one",
> > but actually these files are stored in disk2.
> >
> > Does anyone here help to fix this issue?
> >
> > Thanks

Cannot install SQL Server 2005 Express

Whole installation works fine until it comes to "Selected components are being configured" and there it shows:

MSXML6 - Setup FAILED. refer to the Setup log for details.

SQL Setup support files - Setup FINISHED.

SQL Native Client - Setup FINISHED.

SQL VSS Writter - - Setup FINISHED.

SQL Server Database Services - Setup FAILED. refer to the Setup log for details

And that's it. I cannot install SQL Server 2005 express.

I guess the problem is MSXML6 it cannot install because there is a newer version already there but I cannot uninstall it. How can I solve this problem ?

Thanks.

Try installing the Express Advanced it has most features except the Agent. Hope this helps.

http://msdn.microsoft.com/vstudio/express/sql/download/

|||

No still cannot install - again problem with MSXML6 - cannot install it.

tnx for reply.

|||

I solve the problem thanks to this tread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1419155&SiteID=1

Cannot install SQL Server 2000 Developer edition on Windows XP Pro

Hi, I tried to install the SQL Server 2000 on
Windows XP Pro without success. There is
no error message either. The installation process
stalked on the server configuration step for
more then 30 minutes. I restarted the computer
and tried it again and it is still stalked there.
The server is Dell PowerEdge 400SC, P4 with
hyper threading.
Any ideas?
Thanks!
-Y.C.Yi,
have a look at this installation troubleshooting checklist, particularly the
reference to the 3 logfiles:
http://www.mssqlcity.com/Articles/Adm/installation_troubleshooting.htm
Regards,
Paul Ibison

Cannot install SQL Server 2000 Developer edition on Windows XP Pro

Hi, I tried to install the SQL Server 2000 on
Windows XP Pro without success. There is
no error message either. The installation process
stalked on the server configuration step for
more then 30 minutes. I restarted the computer
and tried it again and it is still stalked there.
The server is Dell PowerEdge 400SC, P4 with
hyper threading.
Any ideas?
Thanks!
-Y.C.
Yi,
have a look at this installation troubleshooting checklist, particularly the
reference to the 3 logfiles:
http://www.mssqlcity.com/Articles/Ad...leshooting.htm
Regards,
Paul Ibison

Cannot install SQL Server 2000 Developer edition on Windows XP Pro

Cannot install SQL Express; peculiar error

SQL Express installation is bombing out with the "A beta version of the .NET Framework 2.0 or SQL Server was detected on the computer...".

From the log file:

Running: PerformSCCAction2 at: 2007/6/26 8:17:27
Loaded DLL:C:\WIN\system32\msi.dll Version:3.1.4000.2435
Product "{7131646D-CD3C-40F4-97B9-CD9E4E6262EF}" versioned 2.0 is not compatible with current builds of SQL Server.Expected at least version: 2.0.50727.42
The Product Name is ".NET Framework"

Now what is peculiar to me is that

1) this machine should have never had the beta software on it;

2) I have seen people with similar issues except their versioned info always said "versioned 2.0.50727" and the product guid is different, this one only says "2.0"; and

3) I thought that product guid was for the RTM 2.0.50727.42 release!

What is going on here and where is it getting this version information?

brian

Try running the removal tool from here: http://go.microsoft.com/fwlink/?LinkId=47598

Jens K. Suessmeyer

http://www.sqlserver2005.de

Cannot install SQL E Service Pack 2 (KB921896)

Hi, i have a clean install of VB2005 Express and it's accompanying SQL Server 2005 Express (yes i'm new to .net).

After installation i ran Windows Update and it found about 40mb of updates including SP1 for SQL Server. All installed correctly up to a reboot point, after which it continued with the update process.

When it reached SP2 (for SQL Server) it tried to install but just says "Updates were unable to be successfully installed" and "The following updates were not installed: Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896)".

Now i have a permanent icon in my system tray which when clicked tries to do the install with the same result.

During the attempted install my floppy drive 'buzzes' a couple of times.

I'm running an AMD3000+ (64bit) cpu with Windows 2000 Pro SP4

As mentioned in another post (on the VB Install forum) my MyDocuments folder is on a networked pc which has caused other non related problems, not sure if this could be responsible for the error. It would seem unlikely as SQL SP1 installed without any errors.

Any help appreciated.

Any official word on this ?|||

Depends on the issue you're encountering, what does the installer log say? You'll find it at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix.

Mike

|||

Hi Mike, not too sure which file you need as the folder you mention contains many files and more folders !

However here is the latest 'summary.txt'

Code Snippet

Time: 04/28/2007 03:01:27.078
KB Number: KB921896
Machine: MyPcName
OS Version: Microsoft Windows 2000 Professional Service Pack 4 (Build 2195)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
/quiet
/allinstances
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Express Database Services (SQLEXPRESS) ENU RTM 2005.090.1399.00 x86 EXPRESS
Express Database Services (SQLExpress) ENU RTM x86 EXPRESS

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Product Installation Status
Product : Express Database Services (SQLEXPRESS)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR.EXE
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
Error Number : 70095
Error Description : Unable to install Windows Installer MSI file
-
Product : Express Database Services (SQLExpress)
Product Version (Previous):
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR.EXE
SQL Express Features : Client_Components,Connectivity,SDK
Error Number : 70095
Error Description : Unable to install Windows Installer MSI file
-

**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 70095

However there is also a 'Hotfix.log' file:

Code Snippet

04/28/2007 03:00:24.312 ================================================================================
04/28/2007 03:00:24.312 Hotfix package launched
04/28/2007 03:00:24.343 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
04/28/2007 03:00:24.343 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files\Common Files
04/28/2007 03:00:24.343 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
04/28/2007 03:00:24.343 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files
04/28/2007 03:00:24.343 Local Computer:
04/28/2007 03:00:24.343 Target Details: MyPcName
04/28/2007 03:00:24.343 commonfilesdir = C:\Program Files\Common Files
04/28/2007 03:00:24.343 lcidsupportdir = c:\3b642267874f8d43d14991c2\1033
04/28/2007 03:00:24.343 programfilesdir = C:\Program Files
04/28/2007 03:00:24.343 programfilesdir_wow = C:\Program Files
04/28/2007 03:00:24.343 supportdir = c:\3b642267874f8d43d14991c2
04/28/2007 03:00:24.343 supportdirlocal = c:\3b642267874f8d43d14991c2
04/28/2007 03:00:24.343 windir = C:\WINNT
04/28/2007 03:00:24.343 winsysdir = C:\WINNT\system32
04/28/2007 03:00:24.343 winsysdir_wow = C:\WINNT\SysWOW64
04/28/2007 03:00:24.343
04/28/2007 03:00:24.343 Enumerating applicable products for this patch
04/28/2007 03:00:24.343 Found SQL 2005 Express product definition
04/28/2007 03:00:25.250 Enumeration: Determining QFE level for product instance SQLEXPRESS
04/28/2007 03:00:25.265 Enumeration: Associated hotfix build information not found for the following file: c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLServr.exe
04/28/2007 03:00:25.265 Enumeration: Found following QFE level for product instance SQLEXPRESS: 1399
04/28/2007 03:00:25.265 Enumeration: Determining GDR branching Hotfix for product instance SQLEXPRESS
04/28/2007 03:00:25.265 Enumeration: Associated hotfix build information not found for the following file: c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\SQLServr.exe
04/28/2007 03:00:25.265 Enumeration: No GDR branch Hotfix found for product instance SQLEXPRESS
04/28/2007 03:00:25.265 Enumeration: Determining QFE level for product instance
04/28/2007 03:00:25.296 Enumeration: Cannot find following key file for product instance : c:\Program Files\Microsoft SQL Server\90\Tools\\Binn\SQLServr.exe
04/28/2007 03:00:25.296 Enumeration: Determining GDR branching Hotfix for product instance
04/28/2007 03:00:25.296 Enumeration: Cannot find following key file for product instance : c:\Program Files\Microsoft SQL Server\90\Tools\\Binn\SQLServr.exe
04/28/2007 03:00:25.296 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
04/28/2007 03:00:25.296 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files\Common Files
04/28/2007 03:00:25.296 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
04/28/2007 03:00:25.296 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files
04/28/2007 03:00:25.296 Product discovery completed during the install process for SQLEXPRESS
04/28/2007 03:00:25.296 SP Level check completed during the install process for SQLEXPRESS
04/28/2007 03:00:25.296 Product language check completed during the install process for SQLEXPRESS
04/28/2007 03:00:25.296 Product version check completed during the install process for SQLEXPRESS
04/28/2007 03:00:25.296 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
04/28/2007 03:00:25.296 Registry: Read registry key value "CommonFilesDir", string value = C:\Program Files\Common Files
04/28/2007 03:00:25.296 Registry: Opened registry key "SOFTWARE\Microsoft\Windows\CurrentVersion"
04/28/2007 03:00:25.296 Registry: Read registry key value "ProgramFilesDir", string value = C:\Program Files
04/28/2007 03:00:25.296 Product discovery completed during the install process for SQLExpress
04/28/2007 03:00:25.296 SP Level check completed during the install process for SQLExpress
04/28/2007 03:00:25.296 Product language check completed during the install process for SQLExpress
04/28/2007 03:00:25.296 Product version check completed during the install process for SQLExpress
04/28/2007 03:00:25.296 Command-line instance name check completed during the install process
04/28/2007 03:00:25.296 SKU check completed during the install process for SQLEXPRESS
04/28/2007 03:00:25.296 SKU check completed during the install process for SQLExpress
04/28/2007 03:00:25.296 Baseline build check completed during the installation process for SQLEXPRESS
04/28/2007 03:00:25.296 Baseline build check completed during the installation process for SQLExpress
04/28/2007 03:00:25.296 Baseline build check completed during the install process
04/28/2007 03:00:25.312 Product Enumeration Results:
04/28/2007 03:00:25.312 INF File Name: c:\3b642267874f8d43d14991c2\HotFixExpress.inf
04/28/2007 03:00:25.312 baselinebuild = 1399
04/28/2007 03:00:25.328 build = 3042
04/28/2007 03:00:25.328 description = Express Database Services
04/28/2007 03:00:25.328 details = Service Pack for the SQL Server database engine, and the tools for managing relational and XML data, Replication, and Full-Text Search.
04/28/2007 03:00:25.328 installerlogpath = <PROGRAMFILESDIR>\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
04/28/2007 03:00:25.328 kbarticle = KB921896
04/28/2007 03:00:25.328 kbarticlehyperlink = http://support.microsoft.com/?kbid=921896
04/28/2007 03:00:25.328 lcid = 1033
04/28/2007 03:00:25.328 legalproductname = SQL Server Express Database Services 2005
04/28/2007 03:00:25.328 machinetype = x86
04/28/2007 03:00:25.328 package = HotFixExpress
04/28/2007 03:00:25.328 packagetype = SP
04/28/2007 03:00:25.328 productname = SQL9Express
04/28/2007 03:00:25.328 relatedlinks = <LCIDSUPPORTDIR>\FinalSQL2005Information.rtf
04/28/2007 03:00:25.328 servicepackname = Microsoft SQL Server 2005 Service Pack 2 Setup
04/28/2007 03:00:25.328 sku = EXPRESS
04/28/2007 03:00:25.328 splevel = 2
04/28/2007 03:00:25.328 sqlutility = sqlcmd.exe
04/28/2007 03:00:25.328 supportdir = c:\3b642267874f8d43d14991c2
04/28/2007 03:00:25.328 validateauthentication = true
04/28/2007 03:00:25.328 version = 9
04/28/2007 03:00:25.328
04/28/2007 03:00:25.328 File Group Details: EXE
04/28/2007 03:00:25.328 parameters = INSTANCENAME=<NAME>
04/28/2007 03:00:25.328 sourcepath = <SUPPORTDIR>\<PACKAGE>\Files
04/28/2007 03:00:25.328 File Details: SQLEXPR.EXE
04/28/2007 03:00:25.328
04/28/2007 03:00:25.328 Instance Details: SQLEXPRESS
04/28/2007 03:00:25.328 clustername =
04/28/2007 03:00:25.328 features = SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
04/28/2007 03:00:25.328 fullversion = 2005.090.1399.00
04/28/2007 03:00:25.328 hiveregpath = Software\Microsoft\Microsoft SQL Server\MSSQL.1
04/28/2007 03:00:25.328 id = MSSQL.1
04/28/2007 03:00:25.328 installsqldatadir = c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
04/28/2007 03:00:25.328 installsqldir = c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
04/28/2007 03:00:25.328 lcid = 1033
04/28/2007 03:00:25.328 name = SQLEXPRESS
04/28/2007 03:00:25.328 productcode = {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}
04/28/2007 03:00:25.328 qfelevel = 1399
04/28/2007 03:00:25.328 servicename = MSSQL$SQLEXPRESS
04/28/2007 03:00:25.328 sku = EXPRESS
04/28/2007 03:00:25.328 sp = 0
04/28/2007 03:00:25.328 type = SQL Server Standalone Product
04/28/2007 03:00:25.328 vermajbld = 1399
04/28/2007 03:00:25.328 version = 9
04/28/2007 03:00:25.328
04/28/2007 03:00:25.328 Instance Details: SQLExpress
04/28/2007 03:00:25.328 clustername =
04/28/2007 03:00:25.328 expressrsstandalone = true
04/28/2007 03:00:25.328 features = Client_Components,Connectivity,SDK
04/28/2007 03:00:25.328 hiveregpath = Software\Microsoft\Microsoft SQL Server\90\Tools
04/28/2007 03:00:25.328 id =
04/28/2007 03:00:25.328 installsqldatadir =
04/28/2007 03:00:25.328 installsqldir = c:\Program Files\Microsoft SQL Server\90\Tools\
04/28/2007 03:00:25.343 lcid = 1033
04/28/2007 03:00:25.343 name =
04/28/2007 03:00:25.343 productcode = {2750B389-A2D2-4953-99CA-27C1F2A8E6FD}
04/28/2007 03:00:25.343 servicename = MSSQL$
04/28/2007 03:00:25.343 sku = EXPRESS
04/28/2007 03:00:25.343 sp = 0
04/28/2007 03:00:25.343 type = Tools Only
04/28/2007 03:00:25.343 vermajbld = 1399
04/28/2007 03:00:25.343 version = 9
04/28/2007 03:00:25.343
04/28/2007 03:00:25.375 Authenticating user using Windows Authentication
04/28/2007 03:00:25.375 SQL Service MSSQL$SQLEXPRESS was previously running, ready for authentication
04/28/2007 03:00:27.640 Registry: Opened registry key "System\CurrentControlSet\Control\Session Manager"
04/28/2007 03:00:27.640 Registry: Cannot read registry key value "PendingFileRenameOperations"
04/28/2007 03:00:27.640 Locked file: Checking for locked files
04/28/2007 03:00:27.640 Attempting to pause the 32 bit ngen queue
04/28/2007 03:00:28.390 Installing product: SQL9Express
04/28/2007 03:00:28.390 Installing instance: SQLEXPRESS
04/28/2007 03:00:28.406 Installing target: MyPcName
04/28/2007 03:00:28.437 Validating database connections using Windows Authentication
04/28/2007 03:00:28.578 Pre-script database connection check was successful - proceeding with script execution
04/28/2007 03:00:29.687 Received list of RANU pid's
04/28/2007 03:00:29.687 Validating database connections using Windows Authentication
04/28/2007 03:00:29.828 Pre-script database connection check was successful - proceeding with script execution
04/28/2007 03:00:29.843 Stopping service: MSSQL$SQLEXPRESS
04/28/2007 03:00:35.875 Stopped service: MSSQL$SQLEXPRESS
04/28/2007 03:00:35.890 Installing file: SQLEXPR.EXE
04/28/2007 03:00:35.890 Copy Engine: Creating MSI install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR.EXE
04/28/2007 03:00:35.890 Registry: Cannot open registry key "Software\Policies\Microsoft\Windows\Installer"
04/28/2007 03:01:00.984 EXE returned 70095: *** Shared String ID 200095 Not Found ***
04/28/2007 03:01:00.984 Registry: Cannot open registry key "Software\Policies\Microsoft\Windows\Installer"
04/28/2007 03:01:01.031 Copy Engine: Error, unable to install EXE file: c:\3b642267874f8d43d14991c2\HotFixExpress\Files\SQLEXPR.EXE
04/28/2007 03:01:01.062 The following exception occurred: Unable to install Windows Installer MSI file Date: 04/28/2007 03:01:01.062 File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp Line: 1653
04/28/2007 03:01:01.703 Watson: Param1 = Unknown
04/28/2007 03:01:01.703 Watson: Param2 = 0x111cf
04/28/2007 03:01:01.718 Watson: Param3 = Unknown
04/28/2007 03:01:01.718 Watson: Param4 = 0x111cf
04/28/2007 03:01:01.734 Watson: Param5 = copyengine.cpp@.1653
04/28/2007 03:01:01.765 Watson: Param6 = Unknown
04/28/2007 03:01:01.765 Watson: Param7 = SQL9Express
04/28/2007 03:01:01.765 Watson: Param8 = @.
04/28/2007 03:01:01.781 Watson: Param9 = x86
04/28/2007 03:01:01.796 Watson: Param10 = 3042
04/28/2007 03:01:01.812 Installed product: SQL9Express
04/28/2007 03:01:01.828 Installing product: SQL9Express
04/28/2007 03:01:01.828 Installing instance: SQLExpress
04/28/2007 03:01:01.843 Installing target: MyPcName
04/28/2007 03:01:01.843 Installing file: SQLEXPR.EXE
04/28/2007 03:01:01.875 Copy Engine: Creating MSI install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9Express_Hotfix_KB921896_SQLEXPR.EXE
04/28/2007 03:01:01.875 Registry: Cannot open registry key "Software\Policies\Microsoft\Windows\Installer"
04/28/2007 03:01:26.281 EXE returned 70095: *** Shared String ID 200095 Not Found ***
04/28/2007 03:01:26.312 Registry: Cannot open registry key "Software\Policies\Microsoft\Windows\Installer"
04/28/2007 03:01:26.328 Copy Engine: Error, unable to install EXE file: c:\3b642267874f8d43d14991c2\HotFixExpress\Files\SQLEXPR.EXE
04/28/2007 03:01:26.359 The following exception occurred: Unable to install Windows Installer MSI file Date: 04/28/2007 03:01:26.359 File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp Line: 1653
04/28/2007 03:01:26.968 Watson: Param1 = Unknown
04/28/2007 03:01:26.968 Watson: Param2 = 0x111cf
04/28/2007 03:01:26.968 Watson: Param3 = Unknown
04/28/2007 03:01:26.968 Watson: Param4 = 0x111cf
04/28/2007 03:01:26.984 Watson: Param5 = copyengine.cpp@.1653
04/28/2007 03:01:26.984 Watson: Param6 = Unknown
04/28/2007 03:01:26.984 Watson: Param7 = SQL9Express
04/28/2007 03:01:26.984 Watson: Param8 = @.
04/28/2007 03:01:26.984 Watson: Param9 = x86
04/28/2007 03:01:26.984 Watson: Param10 = 3042
04/28/2007 03:01:26.984 Installed product: SQL9Express
04/28/2007 03:01:26.984 Hotfix package completed
04/28/2007 03:01:27.000 Attempting to continue the 32 bit ngen queue

Hope this is the info you needed ?

|||

I had this problem

i backed up all my databases, uninstalled the whole sha-bang and started over. worked like a charm second time around. (this time my sql express is on the default instance also, the only thing different i can think of)

Saturday, February 25, 2012

Cannot install SQL 2000

When I try to install SQL 2000 on my pc windows xp sp 2 I get previous
programme installation left pending files please restart. I already restarted
five times but it still doesn't work. Anybody got a clue why it's happening?Perhaps this applies?
http://support.microsoft.com/kb/312995/en-us
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"lc_craze" <lccraze@.discussions.microsoft.com> wrote in message
news:A2A80F8D-70FF-4A18-A49A-EBC3EAE6B02D@.microsoft.com...
> When I try to install SQL 2000 on my pc windows xp sp 2 I get previous
> programme installation left pending files please restart. I already restarted
> five times but it still doesn't work. Anybody got a clue why it's happening?|||Hi
I think there are still some registry entries remaining in the Registry of
the system. Delete the entries for SQL Server.
1) go to 'START -> RUN'
2) type 'regedit' and run it.
3) go to 'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\' folder.
4) delet the folder 'Microsoft SQL Server' in it.
CAUTION: backup your registry before doing any changes to it else you'll end
up with all haywire.
After deleting that folder, reboot once and then try installing SQL again.
Hope this helps :-)
Regards
Amer M J
MCP
"lc_craze" wrote:
> When I try to install SQL 2000 on my pc windows xp sp 2 I get previous
> programme installation left pending files please restart. I already restarted
> five times but it still doesn't work. Anybody got a clue why it's happening?

Cannot install SQL 2000

When I try to install SQL 2000 on my pc windows xp sp 2 I get previous
programme installation left pending files please restart. I already restarted
five times but it still doesn't work. Anybody got a clue why it's happening?
Perhaps this applies?
http://support.microsoft.com/kb/312995/en-us
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"lc_craze" <lccraze@.discussions.microsoft.com> wrote in message
news:A2A80F8D-70FF-4A18-A49A-EBC3EAE6B02D@.microsoft.com...
> When I try to install SQL 2000 on my pc windows xp sp 2 I get previous
> programme installation left pending files please restart. I already restarted
> five times but it still doesn't work. Anybody got a clue why it's happening?
|||Hi
I think there are still some registry entries remaining in the Registry of
the system. Delete the entries for SQL Server.
1) go to 'START -> RUN'
2) type 'regedit' and run it.
3) go to 'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\' folder.
4) delet the folder 'Microsoft SQL Server' in it.
CAUTION: backup your registry before doing any changes to it else you'll end
up with all haywire.
After deleting that folder, reboot once and then try installing SQL again.
Hope this helps :-)
Regards
Amer M J
MCP
"lc_craze" wrote:

> When I try to install SQL 2000 on my pc windows xp sp 2 I get previous
> programme installation left pending files please restart. I already restarted
> five times but it still doesn't work. Anybody got a clue why it's happening?

Cannot install SQL 2000

When I try to install SQL 2000 on my pc Windows XP sp 2 I get previous
programme installation left pending files please restart. I already restarte
d
five times but it still doesn't work. Anybody got a clue why it's happening?Perhaps this applies?
http://support.microsoft.com/kb/312995/en-us
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"lc_craze" <lccraze@.discussions.microsoft.com> wrote in message
news:A2A80F8D-70FF-4A18-A49A-EBC3EAE6B02D@.microsoft.com...[vbcol=seagreen]
> When I try to install SQL 2000 on my pc Windows XP sp 2 I get previous
> programme installation left pending files please restart. I already restar
ted
> five times but it still doesn't work. Anybody got a clue why it's happening?[/vbco
l]|||Hi
I think there are still some registry entries remaining in the Registry of
the system. Delete the entries for SQL Server.
1) go to 'START -> RUN'
2) type 'regedit' and run it.
3) go to 'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft'
folder.
4) delet the folder 'Microsoft SQL Server' in it.
CAUTION: backup your registry before doing any changes to it else you'll end
up with all haywire.
After deleting that folder, reboot once and then try installing SQL again.
Hope this helps :-)
Regards
Amer M J
MCP
"lc_craze" wrote:
[vbcol=seagreen]
> When I try to install SQL 2000 on my pc Windows XP sp 2 I get previous
> programme installation left pending files please restart. I already restar
ted
> five times but it still doesn't work. Anybody got a clue why it's happening?[/vbco
l]

Cannot install RS on a SQLserver 2005 SP1 installation

The situation is as follow:

Sqlserver 2005 installed, reporting services NOT installed

SP1 installed

Trying to add Reporting Services results in an eror messages about incompliant versions. Nothing happens

Is there anybody who has a clue?

No. You cannot add instance-awared components when SP1 is applied. But you can do as follows,

1. Install RS RTM

2. Apply SP1.

|||

Ok, thats why it did not work

What dou you mean with RS RTM?

And after the installation of RS RTM and SP1 this is a complete and normal Sql server 2005 installation with Reporting Services?

|||

SQL Server does not ship a slipstreamed version (1 install that brings you up to SP1 level), so as Jiongxiong mentioned, you'll need to install the RTM version of RS from your original media, then apply SP1 to the newly installed instance. Then your box will be at the normal SP1 level for all components.

Thanks,
Sam Lester (MSFT)

|||

So I am still stuck at the beginning.

on the server the installation refuse to install extra components.

I hope that there is a better solution than completely deinstall SQlserver2005 and do a complete reinstall since this is a production server and I want to avoid the risk from a deinstall

Cannot install MS SQL 2000 Developer Edition to my computer

When come to Create Instances screen and click next it prompt error message

although i had restart my computer.

A previous program Installation created pending file operations on the installation machine. You must restart the computer before running setup.

That message is normally because there is a 'runonce' flag set (and some files to be replaced).

However, if you have re-booted your computer (not just logged off and on), then the flag 'should' be cleared.

|||

yes i had restart even shutdown but still prompt the same errors.

cannot install integration services

Hi!

During the installation of integration services (SQL 05 Developer RTM) I get the following error:

TITLE: Microsoft SQL Server 2005 Setup

Failed to install and configure assemblies C:\Programme\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: Failed to generate type library 'C:\Programme\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.tlb' for 'Microsoft.SqlServer.MSMQTask, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'.

I had CTPs of SQL05 and VS05 installed before, but uninstalled them with the cleanup tool.

yeh, I had this issue and found a resolution... read my thread about the installation issue resolved (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=134853&SiteID=1)

the other workaround really is not to select to install integration services but to install it after everything else|||Thank you for your fast reply. I'm trying to install SQL05 Developer on Windows XP Pro SP2. I forgot to mention that in my first post. So I think your solution won't help me :(|||I see!
Well, try to install everything except integration services and then install integration services after everything

The thread I created STILL DOES apply to WS2003, due to installed components still breaking and during installation (I know you are running XP so you do not need to go through the thread!) :)|||

I already did that. I uninstalled Integration Services (during the first installation, I ignored the error message, but IS didn't work then), and tried to reinstall them. I always get the same error.

|||have you:

tried completly removing SQL Server 2005.
Then installing it WITHOUT the integration and reporting services? :-)|||- I uninstalled SQL server, including SQL Native Client and Everything I found that had "sql" in it's name.
- rebooted
- Installed just the SQL Server engine, Clients, Documentation
- rebooted
- Instaled everything except Integration Services
- rebooted
- Tried to install Integration Services, I still get the same error|||Hi Mathias,

I am in exactly the same situation as you. If I find anything I will post here.

Regards,

Chris|||Thank you. Good luck! :)|||Hi all,
I had the same problem. I think it was because of a incomplete uninstall of a previous Beta Version. Check if in there an old version of one of the "Microsoft.SqlServer.DtsXXX" Assemblies (take a look at the Last Modified Date in the Properties) in the Global Assembly Cache.
If there is one or more, delete them.
If you can't delete them because there are references, eliminate these first (can be done by deleting some registry-keys, but I don't know exactly which ones).
Then, after all old assemblies are removed, reinstall the Integration Services using the Setup. Should then work flawlessy.
Greetings,
Ingo
|||Have the same problem with Win2K Pro, SQL 2000 already installed and then SQL
2005 DevEd

After uninstalling SQL2005 a few times in order to get it to install with this error, which also breaks Enterprise Manager on SQL2000 in the process, I then end up reinstalling both. What a pain!

Eventually, after many hours buggering around, got SQL2000 and SQL2005 working but this 'install bug' or 'another MS featurett' (which is still not resolved from what I can see), is such a time waster, in what already is limited!

Does anyone know of an easy fix or patch, rather than have to re-install IS again and possibly cause other issues?
|||This is somewhat related to the problem I had. See my resolution with SSIS at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=124884&SiteID=1. Reinstall OS and then install SQL 2005 RTM Dev Edtion.

I still want to configure a mixed environment with SQL2000 SP4 and SQL2005 RTM Dev Edition on Win XP Pro SP2. I have tried it and cannot use SSIS to configure connections.

If someone has a workaround, please post but I do not want to go thru the pain of reinstalling the OS and my dev tools again.|||Hi centexbi,
I have SQL2000 and SQL2005 working side-by-side on my XP SP2.
Don't know if this is a solution for you and if it works, but you might give it a try:
- Completely remove anything that has to do with .NET (all framework version, VisualStudio, etc.)
- Ensure that you no longer have the directories %SYSTEMROOT%\assembly und %SYSTEMROOT%\Microsoft.NET, delete them if necessary
- Reinstall SQL2000 including SP4
- Try to install SQL2005
Greets,
Ingo
|||Appreciate Ingo and Centexbi thoughts but reinstall of OS is simply not an option.

As a developer, one has a large number of apps, tools etc installed and if the system (as in my case), is very stable apart from SQL2005 install then I would rather ditch install of SQL as opposed to spending a number of days re-assembling the PC OS etc.

Reinstall of SQL2005 has not resolved this - even from the point of painstakenly removing registry entries etc and trying to install as virgin. Maybe MS should provide a proper installer which will remove the masses of junk registry entries SQL2005 leaves behind when you unistall. How about a 'SQL2005 clean reg / os' tool - bit like what Symantec do for their AV?

This is the real world and time is as scarce as money. 'We' all spend far too much time working in this 'black art' industry and shame MS do not do more to help us!

|||Hi ComputerSolutions
An OS-Reinstall is of course _never_ an option.
I can only support your idea of a cleanup-tool.
Greets,
Ingo

cannot install integration services

Hi!

During the installation of integration services (SQL 05 Developer RTM) I get the following error:

TITLE: Microsoft SQL Server 2005 Setup

I had CTPs of SQL05 and VS05 installed before, but uninstalled them with the cleanup tool.

yeh, I had this issue and found a resolution... read my thread about the installation issue resolved (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=134853&SiteID=1)

The thread I created STILL DOES apply to WS2003, due to installed components still breaking and during installation (I know you are running XP so you do not need to go through the thread!) :)|||

I already did that. I uninstalled Integration Services (during the first installation, I ignored the error message, but IS didn't work then), and tried to reinstall them. I always get the same error.

|||have you:

I am in exactly the same situation as you. If I find anything I will post here.

Regards,

Chris|||Thank you. Good luck! :)|||Hi all,
I had the same problem. I think it was because of a incomplete uninstall of a previous Beta Version. Check if in there an old version of one of the "Microsoft.SqlServer.DtsXXX" Assemblies (take a look at the Last Modified Date in the Properties) in the Global Assembly Cache.
If there is one or more, delete them.
If you can't delete them because there are references, eliminate these first (can be done by deleting some registry-keys, but I don't know exactly which ones).
Then, after all old assemblies are removed, reinstall the Integration Services using the Setup. Should then work flawlessy.
Greetings,
Ingo|||Have the same problem with Win2K Pro, SQL 2000 already installed and then SQL
2005 DevEd

After uninstalling SQL2005 a few times in order to get it to install with this error, which also breaks Enterprise Manager on SQL2000 in the process, I then end up reinstalling both. What a pain!

Does anyone know of an easy fix or patch, rather than have to re-install IS again and possibly cause other issues?|||This is somewhat related to the problem I had. See my resolution with SSIS at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=124884&SiteID=1. Reinstall OS and then install SQL 2005 RTM Dev Edtion.

I still want to configure a mixed environment with SQL2000 SP4 and SQL2005 RTM Dev Edition on Win XP Pro SP2. I have tried it and cannot use SSIS to configure connections.

If someone has a workaround, please post but I do not want to go thru the pain of reinstalling the OS and my dev tools again.|||Hi centexbi,
I have SQL2000 and SQL2005 working side-by-side on my XP SP2.
Don't know if this is a solution for you and if it works, but you might give it a try:
- Completely remove anything that has to do with .NET (all framework version, VisualStudio, etc.)
- Ensure that you no longer have the directories %SYSTEMROOT%\assembly und %SYSTEMROOT%\Microsoft.NET, delete them if necessary
- Reinstall SQL2000 including SP4
- Try to install SQL2005
Greets,
Ingo|||Appreciate Ingo and Centexbi thoughts but reinstall of OS is simply not an option.

This is the real world and time is as scarce as money. 'We' all spend far too much time working in this 'black art' industry and shame MS do not do more to help us!|||Hi ComputerSolutions
An OS-Reinstall is of course _never_ an option.
I can only support your idea of a cleanup-tool.
Greets,
Ingo

cannot install integration services

Hi!

During the installation of integration services (SQL 05 Developer RTM) I get the following error:

TITLE: Microsoft SQL Server 2005 Setup

I had CTPs of SQL05 and VS05 installed before, but uninstalled them with the cleanup tool.

yeh, I had this issue and found a resolution... read my thread about the installation issue resolved (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=134853&SiteID=1)

The thread I created STILL DOES apply to WS2003, due to installed components still breaking and during installation (I know you are running XP so you do not need to go through the thread!) :)|||

I already did that. I uninstalled Integration Services (during the first installation, I ignored the error message, but IS didn't work then), and tried to reinstall them. I always get the same error.

|||have you:

I am in exactly the same situation as you. If I find anything I will post here.

Regards,

Chris|||Thank you. Good luck! :)|||Hi all,
I had the same problem. I think it was because of a incomplete uninstall of a previous Beta Version. Check if in there an old version of one of the "Microsoft.SqlServer.DtsXXX" Assemblies (take a look at the Last Modified Date in the Properties) in the Global Assembly Cache.
If there is one or more, delete them.
If you can't delete them because there are references, eliminate these first (can be done by deleting some registry-keys, but I don't know exactly which ones).
Then, after all old assemblies are removed, reinstall the Integration Services using the Setup. Should then work flawlessy.
Greetings,
Ingo|||Have the same problem with Win2K Pro, SQL 2000 already installed and then SQL
2005 DevEd

After uninstalling SQL2005 a few times in order to get it to install with this error, which also breaks Enterprise Manager on SQL2000 in the process, I then end up reinstalling both. What a pain!

Does anyone know of an easy fix or patch, rather than have to re-install IS again and possibly cause other issues?|||This is somewhat related to the problem I had. See my resolution with SSIS at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=124884&SiteID=1. Reinstall OS and then install SQL 2005 RTM Dev Edtion.

I still want to configure a mixed environment with SQL2000 SP4 and SQL2005 RTM Dev Edition on Win XP Pro SP2. I have tried it and cannot use SSIS to configure connections.

If someone has a workaround, please post but I do not want to go thru the pain of reinstalling the OS and my dev tools again.|||Hi centexbi,
I have SQL2000 and SQL2005 working side-by-side on my XP SP2.
Don't know if this is a solution for you and if it works, but you might give it a try:
- Completely remove anything that has to do with .NET (all framework version, VisualStudio, etc.)
- Ensure that you no longer have the directories %SYSTEMROOT%\assembly und %SYSTEMROOT%\Microsoft.NET, delete them if necessary
- Reinstall SQL2000 including SP4
- Try to install SQL2005
Greets,
Ingo|||Appreciate Ingo and Centexbi thoughts but reinstall of OS is simply not an option.

cannot install integration services

Hi!

During the installation of integration services (SQL 05 Developer RTM) I get the following error:

TITLE: Microsoft SQL Server 2005 Setup

I had CTPs of SQL05 and VS05 installed before, but uninstalled them with the cleanup tool.

yeh, I had this issue and found a resolution... read my thread about the installation issue resolved (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=134853&SiteID=1)

The thread I created STILL DOES apply to WS2003, due to installed components still breaking and during installation (I know you are running XP so you do not need to go through the thread!) :)|||

I already did that. I uninstalled Integration Services (during the first installation, I ignored the error message, but IS didn't work then), and tried to reinstall them. I always get the same error.

|||have you:

I am in exactly the same situation as you. If I find anything I will post here.

Regards,

After uninstalling SQL2005 a few times in order to get it to install with this error, which also breaks Enterprise Manager on SQL2000 in the process, I then end up reinstalling both. What a pain!

I still want to configure a mixed environment with SQL2000 SP4 and SQL2005 RTM Dev Edition on Win XP Pro SP2. I have tried it and cannot use SSIS to configure connections.

This is the real world and time is as scarce as money. 'We' all spend far too much time working in this 'black art' industry and shame MS do not do more to help us!

|||Hi ComputerSolutions
An OS-Reinstall is of course _never_ an option.
I can only support your idea of a cleanup-tool.
Greets,
Ingo

Sunday, March 11, 2012

Cannot make New role assignments

Wednesday, March 7, 2012

Cannot install SQL Server Express

Cannot install SQL Server Express

cannot install SQl server 2005 from Hard drive

cannot install SQl server 2005 from Hard drive

Cannot install SQL Server 2005 Express

Cannot install SQL Server 2000 Developer edition on Windows XP Pro

Cannot install SQL Server 2000 Developer edition on Windows XP Pro

Cannot install SQL Server 2000 Developer edition on Windows XP Pro

Cannot install SQL Express; peculiar error

Cannot install SQL E Service Pack 2 (KB921896)

Saturday, February 25, 2012

Cannot install SQL 2000

Cannot install SQL 2000

Cannot install SQL 2000

Cannot install RS on a SQLserver 2005 SP1 installation

Cannot install MS SQL 2000 Developer Edition to my computer

cannot install integration services

cannot install integration services

cannot install integration services

cannot install integration services

Cannot find mdf files

Blog Archive

About Me