Install probs ver2

Hi All,
I posted before a question about an installation problem and the reply was
to get the verbose log file. I've done that so here is the section around
the error. I've added some spaces after the error to make it easier to find.
Thanks in advance.
Michael Culley
Loading extended custom action library
C:\DOCUME~2\RVERBR~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sq
lcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action CallSQLAdHlp
C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqladhlp.exe : 0
MSI (s) (A0:F0): Executing op:
ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,
,)
Action 11:47:10: RollbackAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2 C064397B.
MSI (s) (A0:F0): Executing op:
CustomActionSchedule(Action=RollbackAgentSecurity. 2D02443E_7002_4C0B_ABC9_EA
B2C064397B,ActionType=1281,Source=BinaryData,Targe t=UnInstSQLAgentSecurity,)
MSI (s) (A0:F0): Executing op:
ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,
)
Action 11:47:10: InstallAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2C 064397B.
MSI (s) (A0:F0): Executing op:
CustomActionSchedule(Action=InstallAgentSecurity.2 D02443E_7002_4C0B_ABC9_EAB
2C064397B,ActionType=1025,Source=BinaryData,Target =InstallSQLAgentSecurity,)
MSI (s) (A0:F0): Creating MSIHANDLE (201) of type 790536 for thread 1520
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~2\RVERBR~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~2\RVERBR~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sq
lcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (NOTEBOOK,LocalSystem,87).
Action ended 11:47:11: InstallFinalize. Return value 3.
MSI (s) (A0:F0): User policy value 'DisableRollback' is 0
MSI (s) (A0:F0): Machine policy value 'DisableRollback' is 0
MSI (s) (A0:F0): Executing op:
Header(Signature=1397708873,Version=200,Timestamp= 825056664,LangId=1033,Plat
form=0,ScriptType=2,ScriptMajorVersion=21,ScriptMi norVersion=4,ScriptAttribu
tes=1)
MSI (s) (A0:F0): Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (A0:F0): Executing op: DialogInfo(Type=1,Argument=Microsoft SQL
Server Desktop Engine)
MSI (s) (A0:F0): Executing op:
RollbackInfo(,RollbackAction=Rollback,RollbackDesc ription=Rolling back
action:,RollbackTemplate=,CleanupAction=RollbackCl eanup,CleanupDescription=R
emoving backup files,CleanupTemplate=File: )
Action 11:47:11: Rollback. Rolling back action:
Rollback: InstallAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2C 064397B
MSI (s) (A0:F0): Executing op:
ActionStart(Name=InstallAgentSecurity.2D02443E_700 2_4C0B_ABC9_EAB2C064397B,,
)
MSI (s) (A0:F0): Executing op:
ProductInfo(ProductKey={E09B48B5-E141-427A-AB0C-D3605127224A},ProductName=Mi
crosoft SQL Server Desktop
Engine,PackageName=SqlRun01.msi,Language=1033,Vers ion=134218488,Assignment=1
,ObsoleteArg=0,,,PackageCode={43D02102-CDCE-4
0C6-8D1E-4DF809870C28},,,InstanceType=0)
Rollback: RollbackAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2 C064397B
MSI (s) (A0:F0): Executing op:
ActionStart(Name=RollbackAgentSecurity.2D02443E_70 02_4C0B_ABC9_EAB2C064397B,
,)
"Michael Culley" <mculley@.NOSPAMoptushome.com.au> wrote in message
news:exX0LremEHA.2764@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> I posted before a question about an installation problem and the reply was
> to get the verbose log file. I've done that so here is the section around
> the error. I've added some spaces after the error to make it easier to
find.
I solved the problem, File and Print Sharing needs to be installed for the
MSDE install to work. Obvious huh? ;-)
Michael Culley

Install MSDE2000 by InstallShield Professional 6.1

How can I include the MSDE2000 installation in an InstallShield Professional 6.1 project?
I have get a set of MSDE setup files including an MSI file, and how can I use it?
Thank you for any reply!Have you gotten this to work? I am looking at doing something similar.

Thanks.

Install MSDE from Delphi

I can install MSDE from command prompt or batch file, but
I can not install it from delphi, using
shellexecute/winexec calling the batch or setup file with
parameter.
I have not problem executing other executable file from
delphi using function above.
the msde is hanging on the progress of remaining
installation for 15 sec. the progress bar doesn't move on
that point.
other question,
how can I uninstall msde from program ?
any body can help?
thanks,
sebastian.
hi Sebastian,
"sebastian" <contactus@.ikiapik.com> ha scritto nel messaggio
news:13e101c47b98$27d4a7f0$a601280a@.phx.gbl...
> I can install MSDE from command prompt or batch file, but
> I can not install it from delphi, using
> shellexecute/winexec calling the batch or setup file with
> parameter.
> I have not problem executing other executable file from
> delphi using function above.
> the msde is hanging on the progress of remaining
> installation for 15 sec. the progress bar doesn't move on
> that point.
> other question,
> how can I uninstall msde from program ?
please add the /L*v "c:\..\Log.txt" command line parameter in order to
inspect the resulting log file..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Install issue for Business Contact Manager for Outlook 2007 and SQL Express

Hi,

We try to install Business Contact Manager for Outlook 2007 and get installation failed without any error. It simply refers to the log file. I have posted below the last 40 lines of this huge log file. The information in there are not vary help full since it refers to error codes that nobody seem to be able to explain. Now this is happening on 3 brand new dell computers running XP Pro. I would be happy for any assistance to either explain the error coded (if any MS guy is monitoring this) or maybe someone had a similar problem and could let me know some options on what I could try to get this resolved and my program installed.

Thank you all very much for assisting me.

Thom

Log file last 40 lines (more on request)
Property(S): RemoteAdminTS = 1
Property(S): WindowsVolume = C:\
Property(S): MsiNTProductType = 1
Property(S): ServicePackLevelMinor = 0
Property(S): AdminUser = 1
Property(S): ServicePackLevel = 2
Property(S): WindowsBuild = 2600
Property(S): DigitalProductID = #xA40000000300000038393431302D3238312D323037393634372D3034383138000800000000000000000000000000000000000000003AD3F42CD592998379FDEF3D020300000000005C9495464B6CAB0D0000000000000000000000000000000000000000000000003236333037000000000000009B2D00008555946CBF070000EC3E0000000000000000000000000000000000000000000000000000000000003316ABDF
Property(S): VersionMsi = 3.01
Property(S): VersionDatabase = 200
Property(S): CLIENTPROCESSID = 200
Property(S): CLIENTUILEVEL = 3
Property(S): CURRENTDIRECTORY = C:\Documents and Settings\Justin Jong\My Documents\ShareFiles\Business Contact 2007
Property(S): BOOTSTRAPPED = 1
Property(S): REBOOT = ReallySuppress
Property(S): PackagecodeChanging = 1
Property(S): ProductState = -1
Property(S): PackageCode = {A8529450-48A4-4346-92F8-8A9634381267}
Property(S): CostingComplete = 1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): SOURCEDIR = C:\Documents and Settings\Justin Jong\My Documents\ShareFiles\Business Contact 2007\
Property(S): SourcedirProduct = {B32C4059-6E7A-41EF-AD20-56DF1872B923}
Property(S): ProductToBeRegistered = 1
MSI (s) (64:0C) [02:39:28:441]: Note: 1: 1708
MSI (s) (64:0C) [02:39:28:441]: Product: Business Contact Manager for Outlook 2007 -- Installation operation failed.

MSI (s) (64:0C) [02:39:28:441]: Cleaning up uninstalled install packages, if any exist
MSI (s) (64:0C) [02:39:28:441]: MainEngineThread is returning 1603
MSI (s) (64:04) [02:39:28:535]: Destroying RemoteAPI object.
MSI (s) (64:9C) [02:39:28:535]: Custom Action Manager thread ending.
=== Logging stopped: 7/12/2007 2:39:28 ===
MSI (c) (C8:50) [02:39:28:550]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (C8:50) [02:39:28:550]: MainEngineThread is returning 1603
=== Verbose logging stopped: 7/12/2007 2:39:28 ===

I have same issue, XP sp 2, bcm 2007.

Any one help, cant find any info on this issue.

Thanks

Steve

|||

Hi Thom

Did you fix the error? I also get the same arror on a dell notebook running Vista.

Any advice will be appreciated.

Barry-Dean

Install issue for Business Contact Manager for Outlook 2007 and SQL Express

Hi,

We try to install Business Contact Manager for Outlook 2007 and get installation failed without any error. It simply refers to the log file. I have posted below the last 40 lines of this huge log file. The information in there are not vary help full since it refers to error codes that nobody seem to be able to explain. Now this is happening on 3 brand new dell computers running XP Pro. I would be happy for any assistance to either explain the error coded (if any MS guy is monitoring this) or maybe someone had a similar problem and could let me know some options on what I could try to get this resolved and my program installed.

Thank you all very much for assisting me.

Thom

Log file last 40 lines (more on request)
Property(S): RemoteAdminTS = 1
Property(S): WindowsVolume = C:\
Property(S): MsiNTProductType = 1
Property(S): ServicePackLevelMinor = 0
Property(S): AdminUser = 1
Property(S): ServicePackLevel = 2
Property(S): WindowsBuild = 2600
Property(S): DigitalProductID = #xA40000000300000038393431302D3238312D323037393634372D3034383138000800000000000000000000000000000000000000003AD3F42CD592998379FDEF3D020300000000005C9495464B6CAB0D0000000000000000000000000000000000000000000000003236333037000000000000009B2D00008555946CBF070000EC3E0000000000000000000000000000000000000000000000000000000000003316ABDF
Property(S): VersionMsi = 3.01
Property(S): VersionDatabase = 200
Property(S): CLIENTPROCESSID = 200
Property(S): CLIENTUILEVEL = 3
Property(S): CURRENTDIRECTORY = C:\Documents and Settings\Justin Jong\My Documents\ShareFiles\Business Contact 2007
Property(S): BOOTSTRAPPED = 1
Property(S): REBOOT = ReallySuppress
Property(S): PackagecodeChanging = 1
Property(S): ProductState = -1
Property(S): PackageCode = {A8529450-48A4-4346-92F8-8A9634381267}
Property(S): CostingComplete = 1
Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): SOURCEDIR = C:\Documents and Settings\Justin Jong\My Documents\ShareFiles\Business Contact 2007\
Property(S): SourcedirProduct = {B32C4059-6E7A-41EF-AD20-56DF1872B923}
Property(S): ProductToBeRegistered = 1
MSI (s) (64:0C) [02:39:28:441]: Note: 1: 1708
MSI (s) (64:0C) [02:39:28:441]: Product: Business Contact Manager for Outlook 2007 -- Installation operation failed.

MSI (s) (64:0C) [02:39:28:441]: Cleaning up uninstalled install packages, if any exist
MSI (s) (64:0C) [02:39:28:441]: MainEngineThread is returning 1603
MSI (s) (64:04) [02:39:28:535]: Destroying RemoteAPI object.
MSI (s) (64:9C) [02:39:28:535]: Custom Action Manager thread ending.
=== Logging stopped: 7/12/2007 2:39:28 ===
MSI (c) (C8:50) [02:39:28:550]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (C8:50) [02:39:28:550]: MainEngineThread is returning 1603
=== Verbose logging stopped: 7/12/2007 2:39:28 ===

I have same issue, XP sp 2, bcm 2007.

Any one help, cant find any info on this issue.

Thanks

Steve

|||

Hi Thom

Did you fix the error? I also get the same arror on a dell notebook running Vista.

Any advice will be appreciated.

Barry-Dean

install in customer server

Hello,

I'm looking for a script to export all reports from server A (include all folder tree/datasource and reports) to a file in order to import in server B ?

I'm looking the export and import scrip in order to install my reports in the customer server

(I'm using SQL 2005)

Thanks

There are some KB Articles see http://support.microsoft.com/default.aspx?scid=kb;en-us;842425 and some links in it...
Here is the way I do it:
-Install SQL Server + Reporting Services on the destination maschine.
-Export the ReportServer and ReportServerTempDB on source maschine via SQL Server Management Studio
-Export the key with the ReportServer-config tool.
-Run my bat-File (see below) on destination maschine

You have to adjust the bold parts!
For RSKeyMgmt key.snk is the file containing your key and report is the password.
The bat file should stop the specific services on Win2k and WinXP (maybe in Win2003), if you expierence problems stop SQL Server Reporting Services and WWW- Publishing manually before running the .bat file.
create a .bat file containing:
net stop "SQL Server Reporting Services (MSSQLSERVER)"
net stop "World Wide Web Publishing Service"
net stop "WWW-Publishing"
sqlcmd -i restore.sql
net start "World Wide Web Publishing Service"
net start "WWW-Publishing"
net start "SQL Server Reporting Services (MSSQLSERVER)"

RSConfig -c -s localhost -d ReportServer -a Windows
RSKeyMgmt -a -f key.snk -p report
create restore.sql containing:
/****** Drop Databases ******/

EXEC msdb.dbo.sp_delete_database_backuphistory @.database_name = N'ReportServerTempDB'
GO
USE [master]
GO
DROP DATABASE [ReportServerTempDB]
GO

EXEC msdb.dbo.sp_delete_database_backuphistory @.database_name = N'ReportServer'
GO
USE [master]
GO
DROP DATABASE [ReportServer]
GO

/****** Restore Databases ******/
RESTORE DATABASE [ReportServer] FROM
DISK = N'E:\Program Files\Microsoft SQL Server\Scripts\backup\ReportServer.bak' WITH FILE = 1,
/* Specify Source! Absolute pathnames */

MOVE N'ReportServer' TO N'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ReportServer.mdf',
MOVE N'ReportServer_log' TO N'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ReportServer_log.LDF',
/* if the installation is on a different drive you need to move the files */

NOUNLOAD, STATS = 10
GO


RESTORE DATABASE [ReportServerTempDB] FROM
DISK = N'E:\Program Files\Microsoft SQL Server\Scripts\backup\ReportServerTempDB.bak' WITH FILE = 1,
/* Specify Source! Absolute pathnames */

MOVE N'ReportServerTempDB' TO N'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ReportServerTempDB.mdf',
MOVE N'ReportServerTempDB_log' TO N'E:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\ReportServerTempDB_log.LDF',
/* if the installation is on a different drive you need to move the files */

NOUNLOAD, STATS = 10
GO



/****** Restore rights ******/
USE master
GO

DECLARE @.AccountName nvarchar(260)
SET @.AccountName = 'MASCHINENAME\ASPNET'

if not exists (select name from syslogins where name = @.AccountName and hasaccess = 1 and isntname = 1)
BEGIN
EXEC sp_grantlogin @.AccountName
END
GO

USE [ReportServer]
GO

DECLARE @.AccountName nvarchar(260)
SET @.AccountName = 'MASCHINENAME\ASPNET'

DECLARE @.name_in_db nvarchar(260)
select @.name_in_db = sysusers.name from sysusers inner join master.dbo.syslogins logins on logins.sid = sysusers.sid where logins.name = @.AccountName and logins.isntname = 1
if @.name_in_db IS NULL
BEGIN
EXEC sp_grantdbaccess @.AccountName, @.name_in_db OUTPUT
END
IF @.name_in_db IS NOT NULL AND @.name_in_db != 'dbo' AND @.name_in_db != 'sys'
BEGIN
EXEC sp_addrolemember 'RSExecRole', @.name_in_db
END
GO

USE [ReportServerTempDB]
GO

DECLARE @.AccountName nvarchar(260)
SET @.AccountName = 'MASCHINENAME\ASPNET'

DECLARE @.name_in_db nvarchar(260)
select @.name_in_db = sysusers.name from sysusers inner join master.dbo.syslogins logins on logins.sid = sysusers.sid where logins.name = @.AccountName and logins.isntname = 1
if @.name_in_db IS NULL
BEGIN
EXEC sp_grantdbaccess @.AccountName, @.name_in_db OUTPUT
END
IF @.name_in_db IS NOT NULL AND @.name_in_db != 'dbo' AND @.name_in_db != 'sys'
BEGIN
EXEC sp_addrolemember 'RSExecRole', @.name_in_db
END
GO

USE msdb
GO

DECLARE @.AccountName nvarchar(260)
SET @.AccountName = 'MASCHINENAME\ASPNET'

DECLARE @.name_in_db nvarchar(260)
select @.name_in_db = sysusers.name from sysusers inner join master.dbo.syslogins logins on logins.sid = sysusers.sid where logins.name = @.AccountName and logins.isntname = 1
if @.name_in_db IS NULL
BEGIN
EXEC sp_grantdbaccess @.AccountName, @.name_in_db OUTPUT
END
IF @.name_in_db IS NOT NULL AND @.name_in_db != 'dbo' AND @.name_in_db != 'sys'
BEGIN
EXEC sp_addrolemember 'RSExecRole', @.name_in_db
END
GO

USE master
GO

DECLARE @.AccountName nvarchar(260)
SET @.AccountName = 'MASCHINENAME\ASPNET'

DECLARE @.name_in_db nvarchar(260)
select @.name_in_db = sysusers.name from sysusers inner join master.dbo.syslogins logins on logins.sid = sysusers.sid where logins.name = @.AccountName and logins.isntname = 1
if @.name_in_db IS NULL
BEGIN
EXEC sp_grantdbaccess @.AccountName, @.name_in_db OUTPUT
END
IF @.name_in_db IS NOT NULL AND @.name_in_db != 'dbo' AND @.name_in_db != 'sys'
BEGIN
EXEC sp_addrolemember 'RSExecRole', @.name_in_db
END
GO

|||

Thanks for response

I'm looking just export the reports and import the report on the client machine (my client have other reports so I can't use the database recovery method

Install fails on SQL Express (part of setup for Accounting Express 2007)

I am having the same problem as Michael, with the exception that my laptop is running windows XP SP2.

BUT when I look at the SETUP LOG FILE there is NOTHING in it. This is what I get:

Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Tue Apr 03 19:36:54 2007
(LAPTOP NAME HERE) : Unknown article Result.

SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.

Time : Tue Apr 03 19:36:56 2007

(As you can see, there is nothing in the file)

Any ideas what could be wrong?

Thanks

Pedro

Are there any logs created in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG? How is the installer getting launched?

Thanks,
Sam Lester (MSFT)

Install fails on SQL Express (part of setup for Accounting Express 2007)

I am having the same problem as Michael, with the exception that my laptop is running windows XP SP2.

BUT when I look at the SETUP LOG FILE there is NOTHING in it. This is what I get:

Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Tue Apr 03 19:36:54 2007
(LAPTOP NAME HERE) : Unknown article Result.

SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.

Time : Tue Apr 03 19:36:56 2007

(As you can see, there is nothing in the file)

Any ideas what could be wrong?

Thanks

Pedro

Are there any logs created in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG? How is the installer getting launched?

Thanks,
Sam Lester (MSFT)

Install Error: Previous Program ... Pending File Operations

Here's an interesting one ...
I'm trying to install SQL Server 2000 Developers client tools on XP Pro Svc
Pk2. When I get to the "Computer Name Window" I get the following error
message:
"A previous program installation created pending file operations on the
installation machine. You must restart the computer before running setup."
Obviously I've restarted the machine, run Windows Update, etc. No luck.
I've also tried to look for any other "update operations" from other
products, but no luck there either.
Note: I've installed Virtual PC 2004 Svc Pk 2, XP 2000 Pro Svc Pk 2 and
this Dev SQL Server 2000 and Svc Pk 4 software successfully on this machine,
but under a guest OS. No problems. I've run the same Windows Updates here
too.
Any suggestions? Tons of fun!
Thanks so much!
--
DougGoogle is your friend :-)
http://www.google.se/search?hl=sv& ...3%B6kning&meta=
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Doug" <Doug@.discussions.microsoft.com> wrote in message
news:AF5AB8C4-FCE5-4FEB-AED2-B7DBEDAAFB1D@.microsoft.com...
> Here's an interesting one ...
> I'm trying to install SQL Server 2000 Developers client tools on XP Pro Sv
c
> Pk2. When I get to the "Computer Name Window" I get the following error
> message:
> "A previous program installation created pending file operations on the
> installation machine. You must restart the computer before running setup.
"
> Obviously I've restarted the machine, run Windows Update, etc. No luck.
> I've also tried to look for any other "update operations" from other
> products, but no luck there either.
> Note: I've installed Virtual PC 2004 Svc Pk 2, XP 2000 Pro Svc Pk 2 and
> this Dev SQL Server 2000 and Svc Pk 4 software successfully on this machin
e,
> but under a guest OS. No problems. I've run the same Windows Updates her
e
> too.
> Any suggestions? Tons of fun!
> Thanks so much!
> --
> Doug|||Google is my friend, and you are too. Thank you very much, that did the tri
ck!
--
Doug
"Doug" wrote:

> Here's an interesting one ...
> I'm trying to install SQL Server 2000 Developers client tools on XP Pro Sv
c
> Pk2. When I get to the "Computer Name Window" I get the following error
> message:
> "A previous program installation created pending file operations on the
> installation machine. You must restart the computer before running setup.
"
> Obviously I've restarted the machine, run Windows Update, etc. No luck.
> I've also tried to look for any other "update operations" from other
> products, but no luck there either.
> Note: I've installed Virtual PC 2004 Svc Pk 2, XP 2000 Pro Svc Pk 2 and
> this Dev SQL Server 2000 and Svc Pk 4 software successfully on this machin
e,
> but under a guest OS. No problems. I've run the same Windows Updates her
e
> too.
> Any suggestions? Tons of fun!
> Thanks so much!
> --
> Doug

Install error "failure compiling WMI registration file"

Help!
I've tried for days just to simply install Reporting Services. Didn't think
it would be so damn fiddly.
I'm getting an error which has been reported a few times before but with no
answer. Someone must've gotten their way around it.
The installation proceeds nicely then up pops "Failure compiling WMI
registration file".
Clicking OK then pops up "Error code -2147217406".
No clues in event viewer.
I have XP professional. SQL Server 2000 SP3a, Visual Studio .Net 2003,
Framework 1.1, SQL Analysis ServicesHello Danny,
I don't recall seeing this particular exception. However the installation
log files might give you more to go on
they are placed in a cab file...called "RSStp_.cab" in "\Microsoft SQL
Server\80\RS Setup Bootstrap\Log".
Peter Blackburn MVP
www.sqlreportingservices.net
"Danny Costa" <qq@.qq.com> wrote in message
news:esCP%23yltEHA.1276@.TK2MSFTNGP12.phx.gbl...
> Help!
> I've tried for days just to simply install Reporting Services. Didn't
> think
> it would be so damn fiddly.
> I'm getting an error which has been reported a few times before but with
> no
> answer. Someone must've gotten their way around it.
> The installation proceeds nicely then up pops "Failure compiling WMI
> registration file".
> Clicking OK then pops up "Error code -2147217406".
> No clues in event viewer.
> I have XP professional. SQL Server 2000 SP3a, Visual Studio .Net 2003,
> Framework 1.1, SQL Analysis Services
>
>|||Thx Peter.
I looked in the log files, but it makes no sense to me. What do I need to
look for?
cheers
Danny
"Danny Costa" <qq@.qq.com> wrote in message
news:esCP%23yltEHA.1276@.TK2MSFTNGP12.phx.gbl...
> Help!
> I've tried for days just to simply install Reporting Services. Didn't
think
> it would be so damn fiddly.
> I'm getting an error which has been reported a few times before but with
no
> answer. Someone must've gotten their way around it.
> The installation proceeds nicely then up pops "Failure compiling WMI
> registration file".
> Clicking OK then pops up "Error code -2147217406".
> No clues in event viewer.
> I have XP professional. SQL Server 2000 SP3a, Visual Studio .Net 2003,
> Framework 1.1, SQL Analysis Services
>
>|||I have exactly the same problem. Did you get any solution for this problem?
"Danny Costa" wrote:
> Help!
> I've tried for days just to simply install Reporting Services. Didn't think
> it would be so damn fiddly.
> I'm getting an error which has been reported a few times before but with no
> answer. Someone must've gotten their way around it.
> The installation proceeds nicely then up pops "Failure compiling WMI
> registration file".
> Clicking OK then pops up "Error code -2147217406".
> No clues in event viewer.
> I have XP professional. SQL Server 2000 SP3a, Visual Studio .Net 2003,
> Framework 1.1, SQL Analysis Services
>
>sql

install error

I have tried to change the name of the file in the regedit and I am still receiving the same error that a previous program installtion created pending file operations on the installation machine. You must restart computer before running setup. What do I do now? i ahve restarted 3 times.

---

mlissaw

Can you try this?

1. Run command regedit.

2. Check whether the the key

HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\Session Manager\Pendingfilerenameoperations

exists. If yes, please remove it and reboot the machine. Then you can retart installing.

|||

Also please review the following before you modify registry...

IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 (http://support.microsoft.com/kb/256986/EN-US/) Description of the Microsoft Windows Registry

|||

I tried this process with backing up the registry and it did not work. any other suggestions?

install error

I have tried to change the name of the file in the regedit and I am still receiving the same error that a previous program installtion created pending file operations on the installation machine. You must restart computer before running setup. What do I do now? i ahve restarted 3 times.

---

mlissaw

Can you try this?

1. Run command regedit.

2. Check whether the the key

HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\Session Manager\Pendingfilerenameoperations

exists. If yes, please remove it and reboot the machine. Then you can retart installing.

|||

Also please review the following before you modify registry...

IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 (http://support.microsoft.com/kb/256986/EN-US/) Description of the Microsoft Windows Registry

|||

I tried this process with backing up the registry and it did not work. any other suggestions?

install DTS package

Hi guys!

How do you install a DTS package from another server.

I have a .dts file (coming from another SQL Server) and I want to transfer it to another SQL Server?

Please advise.

Thanks!

Assuming this is SQL 2000, in enterprise manager right click on the DTS node and select open package(in 7.0 this is all tasks open package). The package should now be open in the designer, now just save it locally as normal.|||http://www.sqldts.com/204.aspx

Installation - Only help file installs, No virtual directories or

Hi,
I am trying to install Reporting Services on Windows 2003 server (with no
service pack). Initially it says Visual Studio is not present which is fine,
i press next, then it goes into installation and there are no prompts for rs
components, sql database creation etc. once installation is finished, only
thing i can see is the reporting services help file in the menu. there are no
virtual directories.
Please help.
thanks
dhariwalWeird. I have two installations on 2003. Do you have IIS running. In 2003
you need to configure it to have asp.net applications supported. 2003 comes
much more locked down. You are correct that you can just ignore VS not being
present.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"K M Dhariwal" <KMDhariwal@.discussions.microsoft.com> wrote in message
news:E9F35571-D726-4F77-BE62-50BA9A363175@.microsoft.com...
> Hi,
> I am trying to install Reporting Services on Windows 2003 server (with no
> service pack). Initially it says Visual Studio is not present which is
> fine,
> i press next, then it goes into installation and there are no prompts for
> rs
> components, sql database creation etc. once installation is finished, only
> thing i can see is the reporting services help file in the menu. there are
> no
> virtual directories.
> Please help.
> thanks
> dhariwal|||Hi,
I also have Reporting Services running on 2003 at other customers and it
works like a charm. This is the first time i am stuck like this with RS. IIS
is up and running as well as asp.net, i have got front page extension
installed as well (do u think extensions are the culprit), one thing i
noticed is that there is default website as well as Microsoft Sharepoint
Administration. Do you think sharepoint is throwing this thing down.
If i re-install IIS, will it make any difference.
thanks
khalid
"Bruce L-C [MVP]" wrote:
> Weird. I have two installations on 2003. Do you have IIS running. In 2003
> you need to configure it to have asp.net applications supported. 2003 comes
> much more locked down. You are correct that you can just ignore VS not being
> present.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "K M Dhariwal" <KMDhariwal@.discussions.microsoft.com> wrote in message
> news:E9F35571-D726-4F77-BE62-50BA9A363175@.microsoft.com...
> > Hi,
> > I am trying to install Reporting Services on Windows 2003 server (with no
> > service pack). Initially it says Visual Studio is not present which is
> > fine,
> > i press next, then it goes into installation and there are no prompts for
> > rs
> > components, sql database creation etc. once installation is finished, only
> > thing i can see is the reporting services help file in the menu. there are
> > no
> > virtual directories.
> > Please help.
> > thanks
> > dhariwal
>
>|||I don't know. Seems like you should have gotten an error message. Sorry, no
brainstorms on what it might be.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"K M Dhariwal" <KMDhariwal@.discussions.microsoft.com> wrote in message
news:8D4C9377-EE84-4535-90D2-88BAA4809964@.microsoft.com...
> Hi,
> I also have Reporting Services running on 2003 at other customers and it
> works like a charm. This is the first time i am stuck like this with RS.
> IIS
> is up and running as well as asp.net, i have got front page extension
> installed as well (do u think extensions are the culprit), one thing i
> noticed is that there is default website as well as Microsoft Sharepoint
> Administration. Do you think sharepoint is throwing this thing down.
> If i re-install IIS, will it make any difference.
> thanks
> khalid
> "Bruce L-C [MVP]" wrote:
>> Weird. I have two installations on 2003. Do you have IIS running. In 2003
>> you need to configure it to have asp.net applications supported. 2003
>> comes
>> much more locked down. You are correct that you can just ignore VS not
>> being
>> present.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "K M Dhariwal" <KMDhariwal@.discussions.microsoft.com> wrote in message
>> news:E9F35571-D726-4F77-BE62-50BA9A363175@.microsoft.com...
>> > Hi,
>> > I am trying to install Reporting Services on Windows 2003 server (with
>> > no
>> > service pack). Initially it says Visual Studio is not present which is
>> > fine,
>> > i press next, then it goes into installation and there are no prompts
>> > for
>> > rs
>> > components, sql database creation etc. once installation is finished,
>> > only
>> > thing i can see is the reporting services help file in the menu. there
>> > are
>> > no
>> > virtual directories.
>> > Please help.
>> > thanks
>> > dhariwal
>>

Installation - How do you get it to run?

I have downloaded the SQLce package from Microsoft and have run the .msi file.

How do I actually start the product and create tables and data?

Thanks,
Fred

You can't. It only really runs as part of your code (or someone else's).

If you want to create tables, etc. you're probably going to want to use SQL Server Management Studio, the express version is free.

Install an mdf file

Can anyone give me the command line text to install an mdf file? I have a file called contacts.mdf from a Microsoft book and need to install it to MSDE in order to complete the examples in the book.

Thanks in advance.NOt sure if this will work in MSDE, but try sp_attach_db

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp

Actually, it looks like it will work. Look at step 2 here:

http://support.microsoft.com/kb/q231923/|||Thanks, Chrisrock. I finally got it to work using sp_attach_db.

Inside MDF file

Hi,
Is there any place where I can learn about the internal structure of a typical database file MDF ?
I'm not planning to do a competitor product Just want to know how it is internally organized.
Any link, articles, books recommendations are welcome.
Thanks,
"Inside SQL Server 2000" is a good start.
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,
|||Hi,
Have a look into the below link:-
http://msdn.microsoft.com/library/de...us/architec/8_
ar_da2_9sab.asp
Thanks
Hari
MCDBA
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,
|||Inside SQL Server 2000 by Kalen Delaney is one of the best books on the
subject. Books online has some information and Ken Henderson's Guru's Guide
to SQL Server Architecture looks promising (although I have not yet added
this one to my library).
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,

Inside MDF file

Hi
Is there any place where I can learn about the internal structure of a typical database file MDF
I'm not planning to do a competitor product :) Just want to know how it is internally organized
Any link, articles, books recommendations are welcome
Thanks,"Inside SQL Server 2000" is a good start.
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product :) Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,|||Hi,
Have a look into the below link:-
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_
ar_da2_9sab.asp
Thanks
Hari
MCDBA
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product :) Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,|||Inside SQL Server 2000 by Kalen Delaney is one of the best books on the
subject. Books online has some information and Ken Henderson's Guru's Guide
to SQL Server Architecture looks promising (although I have not yet added
this one to my library).
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product :) Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,

Inside MDF file

Hi,
Is there any place where I can learn about the internal structure of a typic
al database file MDF ?
I'm not planning to do a competitor product Just want to know how it is i
nternally organized.
Any link, articles, books recommendations are welcome.
Thanks,"Inside SQL Server 2000" is a good start.
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,|||Hi,
Have a look into the below link:-
http://msdn.microsoft.com/library/d...-us/architec/8_
ar_da2_9sab.asp
Thanks
Hari
MCDBA
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,|||Inside SQL Server 2000 by Kalen Delaney is one of the best books on the
subject. Books online has some information and Ken Henderson's Guru's Guide
to SQL Server Architecture looks promising (although I have not yet added
this one to my library).
"Craig Kenisston" <craigkenisston@.hotmail.com> wrote in message
news:6A1F69A7-DB09-4180-8691-40BB1F2D3202@.microsoft.com...
> Hi,
> Is there any place where I can learn about the internal structure of a
typical database file MDF ?
> I'm not planning to do a competitor product Just want to know how it is
internally organized.
> Any link, articles, books recommendations are welcome.
>
> Thanks,

InsertParameters for SqlDataSource

Hello, I have a SqlDataSource named "OrderHistoryDataSource" that I want to add a parameter to from the code behind file. THe reason I want to do this is todynamicly add the UserID from a currently logged on user. What am I doing wrong? Is there a better way?My code below:

---------------------Code behind file-----------------------

using System;using System.Data;using System.Configuration;using System.Collections;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;public partialclass OrderHistory : System.Web.UI.Page{protected void Page_Load(object sender, EventArgs e) {//If the user is not logged in this will redirect to Login.aspxif (!Request.IsAuthenticated) { Response.Redirect("~/Login.aspx"); }//test to display userID MembershipUser myObject = Membership.GetUser();string UserGUID = myObject.ProviderUserKey.ToString(); SqlDataSource DataSource = Page.FindControl("OrderHistoryDataSource"); DataSource.InsertParameters.Add("CurrentUserId", UserGUID.ToString()); DataSource.Select(); }}

---------------------Asp.netfile-----------------------

<%@. Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="OrderHistory.aspx.cs" Inherits="OrderHistory" Title="Untitled Page" %><asp:Content ID="Content1" ContentPlaceHolderID="CONTENT" Runat="Server"> <table id="ContentTable"> <tr> <td id="ContentTitleCell" colspan="3" style="width: 684px"> ORDER HISTORY</td> </tr> <tr> <td colspan="3" rowspan="2" style="width: 684px"> <asp:GridView ID="OrderHistoryGrid" runat="server"> </asp:GridView>   <asp:SqlDataSource ID="OrderHistoryDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString%>" SelectCommand="SELECT * FROM [UserOrders] WHERE ([UserID] = [CurrentUserID]) ORDER BY [OrderID] VALUES (@.UserId, @.Address, @.City, @.State, @.Zip)" ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName%>"> <InsertParameters></InsertParameters> </asp:SqlDataSource> </td> </tr> <tr> </tr> </table></asp:Content>

Hello,

By looking in the code that you have given, I can definitely say there is some thing wrong. Please check youe code again.

You can follow the code below.

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
<Columns>
<asp:BoundField DataField="UserID" HeaderText="UserID" SortExpression="UserID" />
<asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
<asp:BoundField DataField="FirstName" HeaderText="FirstName" SortExpression="FirstName" />
<asp:BoundField DataField="MiddleName" HeaderText="MiddleName" SortExpression="MiddleName" />
<asp:BoundField DataField="LastName" HeaderText="LastName" SortExpression="LastName" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="OrderHistoryDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT [UserID], [Title], [FirstName], [MiddleName], [LastName] FROM [UserOrders] WHERE ([UserID] = @.UserID)">
<SelectParameters>
<asp:Parameter Name="UserID" Type="String" />
</SelectParameters>
</asp:SqlDataSource>

---------------------Codebehindfile-----------------------

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partialclass OrderHistory : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
 {
//If the user is not logged in this will redirect to Login.aspx
if (!Request.IsAuthenticated)
 {
 Response.Redirect("~/Login.aspx");
 }
//test to display userID
 MembershipUser myObject = Membership.GetUser();
string UserGUID = myObject.ProviderUserKey.ToString();
OrderHistoryDataSource.SelectParameters["UserID"].DefaultValue = UserGUID;
        GridView1.DataBind();
 }
}

Thanks,

Deepesh Verma

|||

Thank you very much. I figured I had the general idea; I was just off by a bit.

|||

I would typically suggest moving the code to the SqlDatasource_Selecting event. Within that event, you can set any parameters you want through the e.Command property. It also will get executed each time a select will fire, and only when a select will fire.