I am trying merge replication between two instances of MSDE on two
different machines on LAN.
I have setup the snapshot agent . when I try running the agent using
sp_start_job @.job_name='MergeSnapshot'
I get an error message saying job name ('MergeSnapshot') does not exist
I am new to replication and trying this for the first time...
Any help is appreciated.
Hello,
Please check out this article:
http://support.microsoft.com/default...b;en-us;324992
regards,
Henk Steunenberg
<prabhusangeeta@.yahoo.com> wrote in message
news:1133288220.042242.206490@.g44g2000cwa.googlegr oups.com...
>I am trying merge replication between two instances of MSDE on two
> different machines on LAN.
> I have setup the snapshot agent . when I try running the agent using
> sp_start_job @.job_name='MergeSnapshot'
> I get an error message saying job name ('MergeSnapshot') does not exist
> I am new to replication and trying this for the first time...
> Any help is appreciated.
>
Showing posts with label machines. Show all posts
Showing posts with label machines. Show all posts
Monday, March 26, 2012
MSDE Replication in Workgroup Enviromnet
We currently have two machines in a workgroup environment and both are
running WIndows XP Pro SP1 and MSDE Sp3.
The problem we have is with the Merge Replication. The publisher writes
snapshot data to the snapshot folder, but the subscriber is unable to open
this file across the network. We get error 5 access denied.
From the subscriber PC through explorer/notepad we can open the file. The
file name is MSmerge_genhistory.bcp
If we were to put the pc into a domain we have no problem. Replication wor
Replication is probably accessing this file through a admin share
something like \\servername\d$\xxxxx\repldata\ which needs admin access to
the distributor machine.
Try configuring a named share like \\servername\repldata and allow access to
relevant user and set that to be the working directory. You can set the
working directory when configuring publisher
or through sp_adddistpublisher or sp_changedistpublisher.
This posting is provided "AS IS" with no warranties, and confers no rights.
OR if you wish to include a script sample in your post please add "Use of
included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm"
"Colin M" <ColinM@.discussions.microsoft.com> wrote in message
news:027D0BE9-2D57-4DF4-888C-173A7FCD3404@.microsoft.com...
> We currently have two machines in a workgroup environment and both are
> running WIndows XP Pro SP1 and MSDE Sp3.
> The problem we have is with the Merge Replication. The publisher writes
> snapshot data to the snapshot folder, but the subscriber is unable to open
> this file across the network. We get error 5 access denied.
> From the subscriber PC through explorer/notepad we can open the file. The
> file name is MSmerge_genhistory.bcp
>
> If we were to put the pc into a domain we have no problem. Replication wor
running WIndows XP Pro SP1 and MSDE Sp3.
The problem we have is with the Merge Replication. The publisher writes
snapshot data to the snapshot folder, but the subscriber is unable to open
this file across the network. We get error 5 access denied.
From the subscriber PC through explorer/notepad we can open the file. The
file name is MSmerge_genhistory.bcp
If we were to put the pc into a domain we have no problem. Replication wor
Replication is probably accessing this file through a admin share
something like \\servername\d$\xxxxx\repldata\ which needs admin access to
the distributor machine.
Try configuring a named share like \\servername\repldata and allow access to
relevant user and set that to be the working directory. You can set the
working directory when configuring publisher
or through sp_adddistpublisher or sp_changedistpublisher.
This posting is provided "AS IS" with no warranties, and confers no rights.
OR if you wish to include a script sample in your post please add "Use of
included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm"
"Colin M" <ColinM@.discussions.microsoft.com> wrote in message
news:027D0BE9-2D57-4DF4-888C-173A7FCD3404@.microsoft.com...
> We currently have two machines in a workgroup environment and both are
> running WIndows XP Pro SP1 and MSDE Sp3.
> The problem we have is with the Merge Replication. The publisher writes
> snapshot data to the snapshot folder, but the subscriber is unable to open
> this file across the network. We get error 5 access denied.
> From the subscriber PC through explorer/notepad we can open the file. The
> file name is MSmerge_genhistory.bcp
>
> If we were to put the pc into a domain we have no problem. Replication wor
Wednesday, March 21, 2012
MSDE on machine with SQL Server
Hello,
A named instance of MSDE will be installed on our clients machines along with our VB.Net during the installation. Will this work fine even if the client already has SQL Server on his/her machine. I mean will the installation of named instance of MSDE wor
k smoothly even if SQL Server already exists. If yes, then does that apply for both SQL Server 7 & 2000. If no, then what should I do.
Thanks
dev
You should have no problems, as long as you are installing a uniquely named
instance. This is true even if SQL Server 7 is already installed on the
system.
Jim
"dev" <anonymous@.discussions.microsoft.com> wrote in message
news:B46C4961-748E-47E1-AD22-2A712100428F@.microsoft.com...
> Hello,
> A named instance of MSDE will be installed on our clients machines along
with our VB.Net during the installation. Will this work fine even if the
client already has SQL Server on his/her machine. I mean will the
installation of named instance of MSDE work smoothly even if SQL Server
already exists. If yes, then does that apply for both SQL Server 7 & 2000.
If no, then what should I do.
> Thanks
> dev
sql
A named instance of MSDE will be installed on our clients machines along with our VB.Net during the installation. Will this work fine even if the client already has SQL Server on his/her machine. I mean will the installation of named instance of MSDE wor
k smoothly even if SQL Server already exists. If yes, then does that apply for both SQL Server 7 & 2000. If no, then what should I do.
Thanks
dev
You should have no problems, as long as you are installing a uniquely named
instance. This is true even if SQL Server 7 is already installed on the
system.
Jim
"dev" <anonymous@.discussions.microsoft.com> wrote in message
news:B46C4961-748E-47E1-AD22-2A712100428F@.microsoft.com...
> Hello,
> A named instance of MSDE will be installed on our clients machines along
with our VB.Net during the installation. Will this work fine even if the
client already has SQL Server on his/her machine. I mean will the
installation of named instance of MSDE work smoothly even if SQL Server
already exists. If yes, then does that apply for both SQL Server 7 & 2000.
If no, then what should I do.
> Thanks
> dev
sql
Friday, March 9, 2012
MSDE installation problem in Windows XP
Dear All,
We have been facing problems in installing MSDE 2000 in machines having
Windows XP. The installation starts and then after sometime it retraces back.
The error seems to be because of something related to SQLAgentSecurity.
I am attaching the error log details ( the portion which mentions about the
error) below.
Has anyone faced any similar issues? Can anyone help?
Regards,
Ani
Error log details
Starting custom action DisableNetAccess()
Ending custom action DisableNetAccess()
Action 17:11:59: WriteEnvironmentStrings. Updating environment strings
WriteEnvironmentStrings: Name: PATH, Value: c:\Program Files\Microsoft SQL
Server\80\Tools\Binn\, Action 1610612738
Action 17:11:59: RegisterTypeLibraries. Registering type libraries
RegisterTypeLibraries: LibID: {10010001-E260-11CF-AE68-00AA004A34D5}
RegisterTypeLibraries: LibID: {10010001-EB1C-11CF-AE6E-00AA004A34D5}
RegisterTypeLibraries: LibID: {10010200-740B-11D0-AE7B-00AA004A34D5}
Action 17:12:03: InstallServices. Installing new services
Action 17:12:04: InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
Action 17:12:05: InstallSQLAdHlp.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B.
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.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
Action 17:12:06: RollbackAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2 C064397B.
Action 17:12:06: InstallAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2C 064397B.
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (BSTRAW001A,LocalSystem,87).
Action ended 17:12:07: InstallFinalize. Return value 3.
Action 17:12:07: Rollback. Rolling back action:
Rollback: InstallAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2C 064397B
Rollback: RollbackAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2 C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action UnInstSQLAgentSecurity
Starting custom action UnInstSQLAgentSecurity
Rollback: InstallSQLAdHlp.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B
Rollback: InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B
Rollback: Installing new services
Rollback: Registering type libraries
Rollback: Updating environment strings
Rollback: DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B
Rollback: Writing system registry values
Rollback: Unregistering program identifiers
Rollback: Registering Class servers
Rollback: Creating shortcuts
Rollback: Creating duplicate files
Rollback: InstallSqlRedis.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B
Rollback: NoRebootReplace.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B
Rollback: RollbackNoRebootReplace.2D02443E_7002_4C0B_ABC9_EA B2C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action NoRebootReplace
TempFolder Property is C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\
Source Dir Property is C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\SqlSetup\Temp
Rollback: InstallDTC.2D02443E_7002_4C0B_ABC9_EAB2C064397B
Rollback: Copying new files
Rollback: Creating folders
Rollback: Removing ODBC components
Rollback: Deleting services
Rollback: Stopping services
Rollback: Updating component registration
Rollback: RollbackStreamSupportFiles.2D02443E_7002_4C0B_ABC9 _EAB2C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\setupex.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqdedev.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlsut.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlunirl.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlresld.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.rll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.rll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
Rollback: RollbackDeferProperties.2D02443E_7002_4C0B_ABC9_EA B2C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Start custom action DeferProperties
Defer Properties returns: 0
Action ended 17:12:14: INSTALL. Return value 3.
Action ended 17:12:14: INSTALL. Return value 3.
=== Logging stopped: 4/28/2005 17:12:14 ===
MSI (c) (94:24): Product: Microsoft SQL Server Desktop Engine --
Installation operation failed.
hi,
Aniruddha wrote:
> Dear All,
> We have been facing problems in installing MSDE 2000 in machines
> having Windows XP. The installation starts and then after sometime it
> retraces back. The error seems to be because of something related to
> SQLAgentSecurity.
> InstallSQLAgentSecurity failed (BSTRAW001A,LocalSystem,87).
> Action ended 17:12:07: InstallFinalize. Return value 3.
you probably do not have File & Printer Sharing Services turned on.
please chek the control panel, Admin Tools - Services and (eventually) set
it to on.
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
We have been facing problems in installing MSDE 2000 in machines having
Windows XP. The installation starts and then after sometime it retraces back.
The error seems to be because of something related to SQLAgentSecurity.
I am attaching the error log details ( the portion which mentions about the
error) below.
Has anyone faced any similar issues? Can anyone help?
Regards,
Ani
Error log details
Starting custom action DisableNetAccess()
Ending custom action DisableNetAccess()
Action 17:11:59: WriteEnvironmentStrings. Updating environment strings
WriteEnvironmentStrings: Name: PATH, Value: c:\Program Files\Microsoft SQL
Server\80\Tools\Binn\, Action 1610612738
Action 17:11:59: RegisterTypeLibraries. Registering type libraries
RegisterTypeLibraries: LibID: {10010001-E260-11CF-AE68-00AA004A34D5}
RegisterTypeLibraries: LibID: {10010001-EB1C-11CF-AE6E-00AA004A34D5}
RegisterTypeLibraries: LibID: {10010200-740B-11D0-AE7B-00AA004A34D5}
Action 17:12:03: InstallServices. Installing new services
Action 17:12:04: InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B.
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
Action 17:12:05: InstallSQLAdHlp.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B.
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.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
Action 17:12:06: RollbackAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2 C064397B.
Action 17:12:06: InstallAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2C 064397B.
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (BSTRAW001A,LocalSystem,87).
Action ended 17:12:07: InstallFinalize. Return value 3.
Action 17:12:07: Rollback. Rolling back action:
Rollback: InstallAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2C 064397B
Rollback: RollbackAgentSecurity.2D02443E_7002_4C0B_ABC9_EAB2 C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action UnInstSQLAgentSecurity
Starting custom action UnInstSQLAgentSecurity
Rollback: InstallSQLAdHlp.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B
Rollback: InstallPerfMon.2D02443E_7002_4C0B_ABC9_EAB2C064397 B
Rollback: Installing new services
Rollback: Registering type libraries
Rollback: Updating environment strings
Rollback: DisableNetAccess.2D02443E_7002_4C0B_ABC9_EAB2C0643 97B
Rollback: Writing system registry values
Rollback: Unregistering program identifiers
Rollback: Registering Class servers
Rollback: Creating shortcuts
Rollback: Creating duplicate files
Rollback: InstallSqlRedis.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B
Rollback: NoRebootReplace.2D02443E_7002_4C0B_ABC9_EAB2C06439 7B
Rollback: RollbackNoRebootReplace.2D02443E_7002_4C0B_ABC9_EA B2C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
TempFolder is
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\
Loading extended custom action library
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Starting custom action NoRebootReplace
TempFolder Property is C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\
Source Dir Property is C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\SqlSetup\Temp
Rollback: InstallDTC.2D02443E_7002_4C0B_ABC9_EAB2C064397B
Rollback: Copying new files
Rollback: Creating folders
Rollback: Removing ODBC components
Rollback: Deleting services
Rollback: Stopping services
Rollback: Updating component registration
Rollback: RollbackStreamSupportFiles.2D02443E_7002_4C0B_ABC9 _EAB2C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\setupex.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqdedev.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlsut.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlunirl.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlresld.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.rll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.dll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlstp.rll
Deleted Support file :
C:\DOCUME~1\BSTRAW~1\LOCALS~1\Temp\{E09B48B5-E141-427A-AB0C-D3605127224A}\sqlcax.dll
Rollback: RollbackDeferProperties.2D02443E_7002_4C0B_ABC9_EA B2C064397B
SOFTWARE\Microsoft\Microsoft SQL Server
Setup.{E09B48B5-E141-427A-AB0C-D3605127224A}
Start custom action DeferProperties
Defer Properties returns: 0
Action ended 17:12:14: INSTALL. Return value 3.
Action ended 17:12:14: INSTALL. Return value 3.
=== Logging stopped: 4/28/2005 17:12:14 ===
MSI (c) (94:24): Product: Microsoft SQL Server Desktop Engine --
Installation operation failed.
hi,
Aniruddha wrote:
> Dear All,
> We have been facing problems in installing MSDE 2000 in machines
> having Windows XP. The installation starts and then after sometime it
> retraces back. The error seems to be because of something related to
> SQLAgentSecurity.
> InstallSQLAgentSecurity failed (BSTRAW001A,LocalSystem,87).
> Action ended 17:12:07: InstallFinalize. Return value 3.
you probably do not have File & Printer Sharing Services turned on.
please chek the control panel, Admin Tools - Services and (eventually) set
it to on.
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Wednesday, March 7, 2012
MSDE Installation Error on Win9x
I am installing MSDE on win 9x machines and am having a problem. The installation aborts and the installshield unattend.iss script rolls back the installation. It seems the failure is in the cnfgsvr.exe program (based on the sqlstp.log file).
the command line that I use is:
msdex86 -s -a -f1 "c:\unattend.iss"
The log files sqlstp.log and cnfgsvr.out are included below.
I have seen some postings similar to this, but never a resolution. Any help would be appreciated...
Here are the log files...
Sqlstp.log file
~~~~~~~~~~~~~~~~~~~sqlstp.log~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~
13:53:56 Begin Setup
13:53:56 7.00.623
13:53:56 Mode=Silent
13:53:56 ModeType=NORMAL
13:53:57 ValueFTS returned: 0
13:53:57 ValuePID returned: 0
13:53:57 ValueLic returned: 0
13:53:57 GetDefinitionEx returned: 0, Extended: 0x0
13:53:57 System: Windows 95
13:53:57 SQL Server ProductType: MSDE [0x4]
13:53:57 Begin Action: SetupInitialize
13:53:57 End Action SetupInitialize
13:53:57 Fixed install: 0
13:53:57 Begin Action: CheckRequirements
13:53:57 Platform ID: 0xf0000
13:53:57 Version: 4.0.67109975
13:53:57 DCOM95 has been detected.
13:53:57 File Version - C:\WINDOWS\SYSTEM\shdocvw.dll: 5.50.4134.600
13:53:57 ComputerName: JMCGUIRE1
13:53:57 User Name: cbauerle
13:53:57 Domain: JMCGUIRE1
13:53:57 OS Language: 0x409
13:53:57 End Action CheckRequirements
13:53:57 Begin Action: Detection
13:53:57 End Action Detection
13:53:57 Begin Action: ODBCLocked
13:53:57 C:\WINDOWS\TEMP\_ISTMP0.DIR\odbcinst.exe -IsLocked -Silent 1 -SourceDir C:\WINDOWS\TEMP\PFT234~1\X86\ODBC -LogFile C:\WINDOWS\sqlodbci.log
13:53:58 Process Exit Code: (-1)
13:53:58 End Action ODBCLocked
13:53:58 This combination of Package and Operating System allows a full product install.
13:53:58 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
13:53:58 CommonFilesDir=C:\Program Files\Common Files
13:53:58 Windows Directory=C:\WINDOWS\
13:53:58 Begin Action: ShowDialogs
13:53:58 Begin Action: DialogShowSdWelcome
13:53:58 End Action DialogShowSdWelcome
13:53:58 Begin Action: DialogShowSdLicense
13:53:58 End Action DialogShowSdLicense
13:53:58 Begin Action: DialogShowSdRegisterUserEx
13:53:58 End Action DialogShowSdRegisterUserEx
13:53:58 Begin Action: DialogShowSdSetupType
13:53:58 [SetupTypeSQL]
13:53:58 Result=302
13:53:58 szDir=C:\MSSQL7
13:53:58 final szDir=C:\MSSQL7
13:53:58 szDataDir=C:\MSSQL7
13:53:58 final szDataDir=C:\MSSQL7
13:53:58 End Action DialogShowSdSetupType
13:53:58 Begin Action: DialogShowSdComponentMult
13:53:58 End Action DialogShowSdComponentMult
13:53:58 Begin Action: DlgCpSortUnicode
13:53:58 Result=1
13:53:58 [DlgCpSortUnicode]
13:53:58 SortId=52
13:53:58 LCID=1033
13:53:58 CompStyle=196609
13:53:58 End Action DlgCpSortUnicode
13:53:58 Begin Action: DlgNetwork
13:53:58 Result=1
13:53:58 [DlgServerNetwork]
13:53:58 NetworkLibs=4095
13:53:58 TCPPort=1433
13:53:58 TCPPrxy=
13:53:58 NMPPipeName=\\.\pipe\sql\query
13:53:58 End Action DlgNetwork
13:53:58 Begin Action: DlgServices
13:53:58 [DlgServices]
13:53:58 Result=1
13:53:58 Local-Domain=3855
13:53:58 AutoStart=61455
13:53:58 End Action DlgServices
13:53:58 Begin Action: DialogShowSdStartCopy
13:53:58 End Action DialogShowSdStartCopy
13:53:58 Begin Action: DlgCPLLicense
13:53:58 End Action DlgCPLLicense
13:53:58 End Action ShowDialogs
13:53:58 Begin Action ProcessBeforeDataMove:
13:53:58 DeinstallStart returned (C:\MSSQL7): 0
13:53:58 End Action ProcessBeforeDataMove:
13:53:58 Begin Action ProcessComponentSelection:
13:53:58 End Action ProcessComponentSelection
13:53:58 Begin Action LogSelectedComponents:
13:53:58 SQLProg
13:53:58 SQLProg\SQLServr
13:53:58 SQLProg\SQLServr\Help
13:53:58 SQLProg\SQLServr\SCMDev
13:53:58 SQLProg\SQLServr\SCMDev\SCMh
13:53:58 SQLProg\SQLServr\SCMDev\SCMX86Lb
13:53:58 SQLProg\SQLServr\SCMDev\SCMALb
13:53:59 SQLProg\ReplSupp
13:53:59 SQLProg\ReplSupp\ReplSys
13:53:59 SQLProg\ReplSupp\ReplSys1
13:53:59 SQLProg\ReplSupp\RepComm
13:53:59 SQLProg\Dat
13:53:59 SQLProg\BaseSys
13:53:59 SQLProg\BaseBinn
13:53:59 Core
13:53:59 CoreSys
13:53:59 ODBC
13:53:59 OLEDB
13:53:59 CoreMisc
13:53:59 Jet
13:53:59 NetCore
13:53:59 CoreInst
13:53:59 Core1033
13:53:59 CoreIntl
13:53:59 CrMi1033
13:53:59 CrMiIntl
13:53:59 SysCore
13:53:59 VOLEDB
13:53:59 VODBC
13:53:59 CrRepCom
13:53:59 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
13:53:59 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
13:53:59 End Action LogSelectedComponents
13:54:00 SQL program folder: C:\MSSQL7
13:54:00 SQL data folder: C:\MSSQL7
13:54:00 Windows system folder: C:\WINDOWS\SYSTEM\
13:54:00 Prog req: 15751, Data req: 20447, Sys req: 4433
13:54:00 Prog avail: 792068, Data avail: 792068, Sys avail: 792068
13:54:00 Prog req vs. avail, 40631, 792068
13:54:00 Data req vs. avail, 20447, 792068
13:54:00 Sys req vs. avail, 24880, 792068
13:54:00 DisplaySystemPreReq
13:54:00 Begin Action MoveFileData:
13:54:32 End Action MoveFileData
13:54:32 Begin Action ProcessAfterDataMove:
13:54:32 DeinstallSetReference (C:\MSSQL7\sqlservr.exe) returned: 0
13:54:32 End Action ProcessAfterDataMove
13:54:32 Begin Action InstallPkgs:
13:54:32 Setup is installing Microsoft Data Access Components (MDAC) ...
13:54:32 C:\WINDOWS\TEMP\pft2344~TMP\x86\Other\mdac_typ.exe /q:a /c:"setup.exe /qtn"
13:55:44 Process Exit Code: (3010)
13:55:44 Setup is installing Microsoft Distributed Transaction Coordinator (MSDTC) ...
13:55:44 C:\WINDOWS\TEMP\pft2344~TMP\x86\Other\dtcsetup.exe /q:a /r:n
13:56:04 Process Exit Code: (0)
13:56:04 End Action InstallPkgs
13:56:04 Begin Action BuildServer:
13:56:04 SetNewPath returned: 3010
13:56:04 Path successfully updated.
13:56:04 C:\MSSQL7\binn\cnfgsvr.exe -Silent 1 -NoSampleDB 1 -SQLPath "C:\MSSQL7\" -SQLDataPath "C:\MSSQL7\" -SortID 52 -LCIDCompStyle "1033-196609" -HWND 732 -User sa -Pwd
13:58:14 Process Exit Code: (-1)
13:58:14 Setup failed to configure the server. Refer to the server error logs and cnfgsvr.out for more information.
13:58:14 Action CleanUpInstall:
13:58:14 C:\WINDOWS\TEMP\_ISTMP0.DIR\scm.exe -Silent 1 -Action 4 -Service SQLServerAgent
13:58:14 Process Exit Code: (0)
13:58:14 Installation Failed.
~~~~~~~~~~~~~~~end sqlstp.log~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
cnfgsvr.out file
~~~~~~~~~~~~~~~~~~~cnfgsvr.out~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~
Starting Service ...
Connecting to Server ...
driver={sql server};server=JMCGUIRE1;UID=sa;PWD=;database=mast er
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
driver={sql server};server=JMCGUIRE1;UID=sa;PWD=;database=mast er
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
driver={sql server};server=.;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (Connect()).
SQL Server configuration failed.
~~~~~~~~~~~~~~~end cnfgsvr.out~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~I am able to easily reproduce the error with the following steps:
1. Install WIN95b
2. Install IE5.5
3. Install MDAC 2.6SP1
4. Install MSDE
MSDE does not install on a win95 machine that has MDAC installed.
If I install MSDE, then MDAC it is OK.
Any thoughts??
the command line that I use is:
msdex86 -s -a -f1 "c:\unattend.iss"
The log files sqlstp.log and cnfgsvr.out are included below.
I have seen some postings similar to this, but never a resolution. Any help would be appreciated...
Here are the log files...
Sqlstp.log file
~~~~~~~~~~~~~~~~~~~sqlstp.log~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~
13:53:56 Begin Setup
13:53:56 7.00.623
13:53:56 Mode=Silent
13:53:56 ModeType=NORMAL
13:53:57 ValueFTS returned: 0
13:53:57 ValuePID returned: 0
13:53:57 ValueLic returned: 0
13:53:57 GetDefinitionEx returned: 0, Extended: 0x0
13:53:57 System: Windows 95
13:53:57 SQL Server ProductType: MSDE [0x4]
13:53:57 Begin Action: SetupInitialize
13:53:57 End Action SetupInitialize
13:53:57 Fixed install: 0
13:53:57 Begin Action: CheckRequirements
13:53:57 Platform ID: 0xf0000
13:53:57 Version: 4.0.67109975
13:53:57 DCOM95 has been detected.
13:53:57 File Version - C:\WINDOWS\SYSTEM\shdocvw.dll: 5.50.4134.600
13:53:57 ComputerName: JMCGUIRE1
13:53:57 User Name: cbauerle
13:53:57 Domain: JMCGUIRE1
13:53:57 OS Language: 0x409
13:53:57 End Action CheckRequirements
13:53:57 Begin Action: Detection
13:53:57 End Action Detection
13:53:57 Begin Action: ODBCLocked
13:53:57 C:\WINDOWS\TEMP\_ISTMP0.DIR\odbcinst.exe -IsLocked -Silent 1 -SourceDir C:\WINDOWS\TEMP\PFT234~1\X86\ODBC -LogFile C:\WINDOWS\sqlodbci.log
13:53:58 Process Exit Code: (-1)
13:53:58 End Action ODBCLocked
13:53:58 This combination of Package and Operating System allows a full product install.
13:53:58 Reading Software\Microsoft\Windows\CurrentVersion\CommonFi lesDir ...
13:53:58 CommonFilesDir=C:\Program Files\Common Files
13:53:58 Windows Directory=C:\WINDOWS\
13:53:58 Begin Action: ShowDialogs
13:53:58 Begin Action: DialogShowSdWelcome
13:53:58 End Action DialogShowSdWelcome
13:53:58 Begin Action: DialogShowSdLicense
13:53:58 End Action DialogShowSdLicense
13:53:58 Begin Action: DialogShowSdRegisterUserEx
13:53:58 End Action DialogShowSdRegisterUserEx
13:53:58 Begin Action: DialogShowSdSetupType
13:53:58 [SetupTypeSQL]
13:53:58 Result=302
13:53:58 szDir=C:\MSSQL7
13:53:58 final szDir=C:\MSSQL7
13:53:58 szDataDir=C:\MSSQL7
13:53:58 final szDataDir=C:\MSSQL7
13:53:58 End Action DialogShowSdSetupType
13:53:58 Begin Action: DialogShowSdComponentMult
13:53:58 End Action DialogShowSdComponentMult
13:53:58 Begin Action: DlgCpSortUnicode
13:53:58 Result=1
13:53:58 [DlgCpSortUnicode]
13:53:58 SortId=52
13:53:58 LCID=1033
13:53:58 CompStyle=196609
13:53:58 End Action DlgCpSortUnicode
13:53:58 Begin Action: DlgNetwork
13:53:58 Result=1
13:53:58 [DlgServerNetwork]
13:53:58 NetworkLibs=4095
13:53:58 TCPPort=1433
13:53:58 TCPPrxy=
13:53:58 NMPPipeName=\\.\pipe\sql\query
13:53:58 End Action DlgNetwork
13:53:58 Begin Action: DlgServices
13:53:58 [DlgServices]
13:53:58 Result=1
13:53:58 Local-Domain=3855
13:53:58 AutoStart=61455
13:53:58 End Action DlgServices
13:53:58 Begin Action: DialogShowSdStartCopy
13:53:58 End Action DialogShowSdStartCopy
13:53:58 Begin Action: DlgCPLLicense
13:53:58 End Action DlgCPLLicense
13:53:58 End Action ShowDialogs
13:53:58 Begin Action ProcessBeforeDataMove:
13:53:58 DeinstallStart returned (C:\MSSQL7): 0
13:53:58 End Action ProcessBeforeDataMove:
13:53:58 Begin Action ProcessComponentSelection:
13:53:58 End Action ProcessComponentSelection
13:53:58 Begin Action LogSelectedComponents:
13:53:58 SQLProg
13:53:58 SQLProg\SQLServr
13:53:58 SQLProg\SQLServr\Help
13:53:58 SQLProg\SQLServr\SCMDev
13:53:58 SQLProg\SQLServr\SCMDev\SCMh
13:53:58 SQLProg\SQLServr\SCMDev\SCMX86Lb
13:53:58 SQLProg\SQLServr\SCMDev\SCMALb
13:53:59 SQLProg\ReplSupp
13:53:59 SQLProg\ReplSupp\ReplSys
13:53:59 SQLProg\ReplSupp\ReplSys1
13:53:59 SQLProg\ReplSupp\RepComm
13:53:59 SQLProg\Dat
13:53:59 SQLProg\BaseSys
13:53:59 SQLProg\BaseBinn
13:53:59 Core
13:53:59 CoreSys
13:53:59 ODBC
13:53:59 OLEDB
13:53:59 CoreMisc
13:53:59 Jet
13:53:59 NetCore
13:53:59 CoreInst
13:53:59 Core1033
13:53:59 CoreIntl
13:53:59 CrMi1033
13:53:59 CrMiIntl
13:53:59 SysCore
13:53:59 VOLEDB
13:53:59 VODBC
13:53:59 CrRepCom
13:53:59 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
13:53:59 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
13:53:59 End Action LogSelectedComponents
13:54:00 SQL program folder: C:\MSSQL7
13:54:00 SQL data folder: C:\MSSQL7
13:54:00 Windows system folder: C:\WINDOWS\SYSTEM\
13:54:00 Prog req: 15751, Data req: 20447, Sys req: 4433
13:54:00 Prog avail: 792068, Data avail: 792068, Sys avail: 792068
13:54:00 Prog req vs. avail, 40631, 792068
13:54:00 Data req vs. avail, 20447, 792068
13:54:00 Sys req vs. avail, 24880, 792068
13:54:00 DisplaySystemPreReq
13:54:00 Begin Action MoveFileData:
13:54:32 End Action MoveFileData
13:54:32 Begin Action ProcessAfterDataMove:
13:54:32 DeinstallSetReference (C:\MSSQL7\sqlservr.exe) returned: 0
13:54:32 End Action ProcessAfterDataMove
13:54:32 Begin Action InstallPkgs:
13:54:32 Setup is installing Microsoft Data Access Components (MDAC) ...
13:54:32 C:\WINDOWS\TEMP\pft2344~TMP\x86\Other\mdac_typ.exe /q:a /c:"setup.exe /qtn"
13:55:44 Process Exit Code: (3010)
13:55:44 Setup is installing Microsoft Distributed Transaction Coordinator (MSDTC) ...
13:55:44 C:\WINDOWS\TEMP\pft2344~TMP\x86\Other\dtcsetup.exe /q:a /r:n
13:56:04 Process Exit Code: (0)
13:56:04 End Action InstallPkgs
13:56:04 Begin Action BuildServer:
13:56:04 SetNewPath returned: 3010
13:56:04 Path successfully updated.
13:56:04 C:\MSSQL7\binn\cnfgsvr.exe -Silent 1 -NoSampleDB 1 -SQLPath "C:\MSSQL7\" -SQLDataPath "C:\MSSQL7\" -SortID 52 -LCIDCompStyle "1033-196609" -HWND 732 -User sa -Pwd
13:58:14 Process Exit Code: (-1)
13:58:14 Setup failed to configure the server. Refer to the server error logs and cnfgsvr.out for more information.
13:58:14 Action CleanUpInstall:
13:58:14 C:\WINDOWS\TEMP\_ISTMP0.DIR\scm.exe -Silent 1 -Action 4 -Service SQLServerAgent
13:58:14 Process Exit Code: (0)
13:58:14 Installation Failed.
~~~~~~~~~~~~~~~end sqlstp.log~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
cnfgsvr.out file
~~~~~~~~~~~~~~~~~~~cnfgsvr.out~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~
Starting Service ...
Connecting to Server ...
driver={sql server};server=JMCGUIRE1;UID=sa;PWD=;database=mast er
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
driver={sql server};server=JMCGUIRE1;UID=sa;PWD=;database=mast er
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()).
driver={sql server};server=.;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen (Connect()).
SQL Server configuration failed.
~~~~~~~~~~~~~~~end cnfgsvr.out~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~I am able to easily reproduce the error with the following steps:
1. Install WIN95b
2. Install IE5.5
3. Install MDAC 2.6SP1
4. Install MSDE
MSDE does not install on a win95 machine that has MDAC installed.
If I install MSDE, then MDAC it is OK.
Any thoughts??
MSDE Installation
I have tried intalling MSDE on 2 machines and on each of
them after the installation i get the small server icon
running in system tray, but the circle is white and says
cannot connect.
Thanks
Hi ezahnle,
Try double-clicking on the icon and then, in the spot for a servername, try
your computer name and then click connect. If you specified an INSTANCE NAME
while installing, you'll need to put:
computername\instancename
instead.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"ezahnle" <anonymous@.discussions.microsoft.com> wrote in message
news:1b2001c5016d$d4bf0a40$a401280a@.phx.gbl...
>I have tried intalling MSDE on 2 machines and on each of
> them after the installation i get the small server icon
> running in system tray, but the circle is white and says
> cannot connect.
> Thanks
>
them after the installation i get the small server icon
running in system tray, but the circle is white and says
cannot connect.
Thanks
Hi ezahnle,
Try double-clicking on the icon and then, in the spot for a servername, try
your computer name and then click connect. If you specified an INSTANCE NAME
while installing, you'll need to put:
computername\instancename
instead.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"ezahnle" <anonymous@.discussions.microsoft.com> wrote in message
news:1b2001c5016d$d4bf0a40$a401280a@.phx.gbl...
>I have tried intalling MSDE on 2 machines and on each of
> them after the installation i get the small server icon
> running in system tray, but the circle is white and says
> cannot connect.
> Thanks
>
Subscribe to:
Posts (Atom)