Cannot open database during merge replication

Hi All,
I have previously posted in the MSDN forums with no responses, so any
hints on this would be greatly appreciated.
I am replicating an SQL2005 express machine to SQL2005 standard
edition server using merge replication.
I have a simple VB application using ADO polling msMerge_history at
the subscriber every second so that i can show the end user the
progress of the replication.
When the subscription first subscribes and after the initial snapshot
is applied replication downloads all changes from the server that have
been changed since the snapshot was created.
Towards the end of this download faze the VB polling application fails
with "Cannot open database "DBName" requested by the login. The login
failed."
This connection fails 4 or 5 times and then normal polling resumes.
The scary thing is that sometimes when the polling connection fails
the merge replication does not complete and if i check
msMerge_Sessions the "runstatus" is stuck at 3 (InProgress).
1) Is the reason the ADO polling connection fails because of some sort
of lock between replication and reading the system tables?
2) Is replication getting stuck because of locks?
3) What can i do to get around this?
cheers,
Tim
The status event is the best way to monitor progress of your sync.
Merge replication does put schema and application locks on your tables,
including the sysmergerarticles table - this is probably what you are
seeing.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mar72Vin" <mar72vin@.gmail.com> wrote in message
news:1173826362.218126.53350@.l75g2000hse.googlegro ups.com...
> Hi All,
> I have previously posted in the MSDN forums with no responses, so any
> hints on this would be greatly appreciated.
> I am replicating an SQL2005 express machine to SQL2005 standard
> edition server using merge replication.
> I have a simple VB application using ADO polling msMerge_history at
> the subscriber every second so that i can show the end user the
> progress of the replication.
> When the subscription first subscribes and after the initial snapshot
> is applied replication downloads all changes from the server that have
> been changed since the snapshot was created.
> Towards the end of this download faze the VB polling application fails
> with "Cannot open database "DBName" requested by the login. The login
> failed."
> This connection fails 4 or 5 times and then normal polling resumes.
> The scary thing is that sometimes when the polling connection fails
> the merge replication does not complete and if i check
> msMerge_Sessions the "runstatus" is stuck at 3 (InProgress).
> 1) Is the reason the ADO polling connection fails because of some sort
> of lock between replication and reading the system tables?
> 2) Is replication getting stuck because of locks?
> 3) What can i do to get around this?
> cheers,
> Tim
>
|||Hi Hilary,
Thanks for the quick reply.
We are not using the replication component to start replication so we
can't use the "status event"
We run replmerg.exe independently so that replication can be started
via windows Task Scheduler. This way we do not need to have our
replication monitor open whilst replicating.
However when we do have our replication monitor open the replmerg.exe
disappears out of the taskmanager and leaves replication stuck at the
"in progress" status. This only happens after applying the initial
snapshot. (subsequent replications succeed)
The last message recorded to msMerge_History is usually "Web
Syncronization progress xx% Complete."
Why would the replmerge.exe just "give up" at this stage?
thanks for your time.
Cheers,
Tim
On Mar 14, 12:45 pm, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:[vbcol=seagreen]
> The status event is the best way to monitor progress of your sync.
> Merge replication does put schema and application locks on your tables,
> including the sysmergerarticles table - this is probably what you are
> seeing.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com
> "Mar72Vin" <mar72...@.gmail.com> wrote in message
> news:1173826362.218126.53350@.l75g2000hse.googlegro ups.com...
>
>
>
>
|||Looks like i have been barking up the wrong tree. The connections from
the ado application are not causing this error.
I ran replmerg.exe and captured the results (see below), It looks like
replication is trying to use the SYSTEM login at some point to access
the database and it does not have access.
The SQL2005Express instance is running under the system account, I
can't see why it should have troubles connecting to this database.
Any Ideas?
cheers,
Tim
2007-03-14 04:56:34.347 Connecting to Subscriber 'BARNEYXP\MDSZINC'
2007-03-14 04:56:34.347 Connecting to OLE DB Subscriber at datasource:
'BARNEYXP\MDSZINC', location: '', catalog: 'MDS200703146',
providerstring: '' using provider 'SQLNCLI'
2007-03-14 04:56:36.811 Percent Complete: 0
2007-03-14 04:56:36.811 Category:AGENT
Source: BARNEYXP\MDSZINC
Number: 20052
Message: The process could not access database 'MDS200703146' on
server 'BARNEYXP\MDSZINC'.
2007-03-14 04:56:36.811 Percent Complete: 0
2007-03-14 04:56:36.811 Category:SQLSERVER
Source: BARNEYXP\MDSZINC
Number: 4060
Message: Cannot open database "MDS200703146" requested by the login.
The login failed.
2007-03-14 04:56:36.811 Percent Complete: 0
2007-03-14 04:56:36.811 Category:SQLSERVER
Source: BARNEYXP\MDSZINC
Number: 18456
Message: Login failed for user 'NT AUTHORITY\SYSTEM'.
|||It sounds like one of the accounts you are trying to connect to the
publisher/distributor/or subscriber is not defined. You will need to use an
account which is in the pal on the publisher and in the sysadmin or dbo_role
on the subscriber. It will need rights to read, and list files and folders
on the snapshot share.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mar72Vin" <mar72vin@.gmail.com> wrote in message
news:1173852824.327599.170440@.n59g2000hsh.googlegr oups.com...
> Looks like i have been barking up the wrong tree. The connections from
> the ado application are not causing this error.
> I ran replmerg.exe and captured the results (see below), It looks like
> replication is trying to use the SYSTEM login at some point to access
> the database and it does not have access.
> The SQL2005Express instance is running under the system account, I
> can't see why it should have troubles connecting to this database.
> Any Ideas?
> cheers,
> Tim
>
> 2007-03-14 04:56:34.347 Connecting to Subscriber 'BARNEYXP\MDSZINC'
> 2007-03-14 04:56:34.347 Connecting to OLE DB Subscriber at datasource:
> 'BARNEYXP\MDSZINC', location: '', catalog: 'MDS200703146',
> providerstring: '' using provider 'SQLNCLI'
> 2007-03-14 04:56:36.811 Percent Complete: 0
> 2007-03-14 04:56:36.811 Category:AGENT
> Source: BARNEYXP\MDSZINC
> Number: 20052
> Message: The process could not access database 'MDS200703146' on
> server 'BARNEYXP\MDSZINC'.
> 2007-03-14 04:56:36.811 Percent Complete: 0
> 2007-03-14 04:56:36.811 Category:SQLSERVER
> Source: BARNEYXP\MDSZINC
> Number: 4060
> Message: Cannot open database "MDS200703146" requested by the login.
> The login failed.
> 2007-03-14 04:56:36.811 Percent Complete: 0
> 2007-03-14 04:56:36.811 Category:SQLSERVER
> Source: BARNEYXP\MDSZINC
> Number: 18456
> Message: Login failed for user 'NT AUTHORITY\SYSTEM'.
>
sql

Cannot Install SQL Server 2005 Developer Edition - Configuration Tools Only

I have tried several times to install

SQL Server 2005 Developer Edition (most recently from MSDN Disk

3097.1) I have tried to complete an uninstall before each

attempt.

I do get the warning about Minimum Hardware Requirement, but can find

nothing in the detail requirements to exclude my PCs configuration.

I have installed: IIS and .NET Framework 2.0

I have also used ..\aspnet_regiis -r to register ASP.NET

I am, successfully, running Visual Studio 2005.

Why does the installation process stop there and what can I do next?

Look int he setup logs, they will tell you what requirements what not passed.

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

|||

There are 35 .log files. I am

guessing the one you refer to may be:

SQLSetup0001_586III800205_Core(Local).log It is a

19KB file

It confirms that the only 'Setup Consistency Check' failure is

the warning about

minimum

hardware requirement:

Article: Minimum Hardware Requirement, Result: Warning

Description: Minimum hardware requirements are not met, therefore, some

components may not perform as expected. Action: Make sure minimum

hardware requirements are met. Please refer to the readme for minimum

requirements.

I could not identify its problem: http://forums.microsoft.com/msdn/showpost.aspx?postid=551260&siteid=1

Quiite a few steps are completed:

Installing: msxml6 on target: 586III800205

Complete: InstallSqlAction.9 at: 2006/5/30 16:22:18, returned true

Then some are skipped up to a Fatal Error:

Skipped: InstallToolsAction.11

Skipped: Action "InstallToolsAction.11" was not run. Information reported during analysis:

No install request found for package: "sqlsupport", referred by package: "tools", install will be skipped as a result.

Skipped: InstallToolsAction.12

Skipped: Action "InstallToolsAction.12" was not run. Information reported during analysis:

No install request found for package: "sqlncli", referred by package: "tools", install will be skipped as a result.

Skipped: InstallToolsAction.13

Skipped: Action "InstallToolsAction.13" was not run. Information reported during analysis:

No install request found for package: "PPESku", referred by package: "tools", install will be skipped as a result.

Skipped: InstallToolsAction.18

Skipped: Action "InstallToolsAction.18" was not run. Information reported during analysis:

No install request found for package: "owc11", referred by package: "tools", install will be skipped as a result.

Skipped: InstallToolsAction.20

Skipped: Action "InstallToolsAction.20" was not run. Information reported during analysis:

No install request found for package: "BOL", referred by package: "tools", install will be skipped as a result.

Skipped: InstallToolsAction.22

Skipped: Action "InstallToolsAction.22" was not run. Information reported during analysis:

No install request found for package: "bcRedist", referred by package: "tools", install will be skipped as a result.

Skipped: InstallToolsAction.9

Skipped: Action "InstallToolsAction.9" was not run. Information reported during analysis:

No install request found for package: "msxml6", referred by package: "tools", install will be skipped as a result.

Running: InstallDTSAction at: 2006/5/30 16:22:19

Installing: dts on target: 586III800205

******* Got commit request from MSI *******

Complete: InstallDTSAction at: 2006/5/30 16:26:23, returned true

Running: InstallNSAction.10 at: 2006/5/30 16:26:24

Installing: sqlxml4 on target: 586III800205

Complete: InstallNSAction.10 at: 2006/5/30 16:26:36, returned true

Running: InstallSqlAction at: 2006/5/30 16:26:36

Installing: sql on target: 586III800205

Failed to install package

Fatal error during installation.

Setting package return code to: 28086

Complete: InstallSqlAction at: 2006/5/30 16:28:40, returned false

Error: Action "InstallSqlAction" failed during execution. Error information reported during run:

Target collection includes the local machine.

Invoking installPackage() on local machine.

Skipped: InstallToolsAction.10

Skipped: Action "InstallToolsAction.10" was not run. Information reported during analysis:

No install request found for package: "sqlxml4", referred by package: "tools", install will be skipped as a result.

Running: InstallASAction at: 2006/5/30 16:28:41

Installing: as on target: 586III800205

******* Got commit request from MSI *******

Complete: InstallASAction at: 2006/5/30 16:39:17, returned true

Running: InstallNSAction at: 2006/5/30 16:39:17

Installing: ns on target: 586III800205

******* Got commit request from MSI *******

Complete: InstallNSAction at: 2006/5/30 16:40:33, returned true

Error: Action "InstallRSAction" failed during execution. Error information reported during run:

Action: "InstallRSAction" will be marked as failed due to the following condition:

Condition "The SQL Server instance that hosts rs is installed." returned false. Condition context:

rs will be failed due to the hosting instance of SQL Server failing to install.

Installation of package: "rs" failed due to a precondition.

Skipped: InstallToolsAction

Skipped: Action "InstallToolsAction" was not run. Information reported during analysis:

No install request found for package: "tools", install will be skipped as a result.

Skipped: RepairForBackwardsCompatRedistAction

Skipped: Action "RepairForBackwardsCompatRedistAction" was not run. Information reported during analysis:

Action: "RepairForBackwardsCompatRedistAction" will be skipped due to the following condition:

Condition "sql was successfully upgraded." returned false. Condition context:

sql failed to upgrade and so the uninstall of the upgraded product will not occur.

Error: Action "UninstallForMSDE2000Action" failed during execution. Error information reported during run:

Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition:

Condition "sql was successfully upgraded." returned false. Condition context:

sql failed to upgrade and so the uninstall of the upgraded product will not occur.

Installation of package: "patchMSDE2000" failed due to a precondition.

Error: Action "UninstallForSQLAction" failed during execution. Error information reported during run:

Action: "UninstallForSQLAction" will be marked as failed due to the following condition:

Condition "sql was successfully upgraded." returned false. Condition context:

sql failed to upgrade and so the uninstall of the upgraded product will not occur.

Installation of package: "patchLibertySql" failed due to a precondition.

Error: Action "UninstallForRS2000Action" failed during execution. Error information reported during run:

Action: "UninstallForRS2000Action" will be marked as failed due to the following condition:

Condition "rs was successfully upgraded." returned false. Condition context:

rs failed to upgrade and so the uninstall of the upgraded product will not occur.

Installation of package: "patchRS2000" failed due to a precondition.

Running: ReportChainingResults at: 2006/5/30 16:40:34

Error: Action "ReportChainingResults" threw an exception during execution.

One or more packages failed to install. Refer to logs for error details. : 28086

Error Code: 0x80076db6 (28086)

Windows Error Text: Source File Name: sqlchaining\sqlchainingactions.cpp

Compiler Timestamp: Thu Sep 1 22:23:05 2005

Function Name: sqls::ReportChainingResults::perform

Source Line Number: 3097

- Context --

sqls::HostSetupPackageInstallerSynch::preInstall

Marking package: "patchRS2000" as failed due to cancel code received from cancel source: 29539

sqls

Error: Failed to add file :"C:\Program Files\Microsoft SQL

Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_586III800205_.NET

Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL

Server\90\Setup Bootstrap\LOG\SqlSetup0001.cab" Error Code : 2

Error: Failed to add file :"C:\Program Files\Microsoft SQL

Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_586III800205_.NET

Framework 2.0 LangPack.log" to cab file : "C:\Program Files\Microsoft

SQL Server\90\Setup Bootstrap\LOG\SqlSetup0001.cab" Error Code : 2

Error: Failed to add file :"C:\Program Files\Microsoft SQL

Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_586III800205_.NET

Framework Upgrade Advisor.log" to cab file : "C:\Program

Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0001.cab"

Error Code : 2

Error: Failed to add file :"C:\Program Files\Microsoft SQL

Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_586III800205_.NET

Framework Upgrade Advisor LangPack.log" to cab file : "C:\Program

Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0001.cab"

Error Code : 2

Error: Failed to add file :"C:\Program Files\Microsoft SQL

Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_586III800205_.NET

Framework Windows Installer.log" to cab file : "C:\Program

Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0001.cab"

Error Code : 2

Error: Failed to add file :"C:\Program Files\Microsoft SQL

Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_586III800205_.NET

Framework Windows Installer LangPack.log" to cab file : "C:\Program

Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0001.cab"

Error Code : 2

Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.

Message pump returning: 28086

These messages do not tell me much. I would appreciate help in intrepreting them.

|||The minimum hardware requirements should only pop a warning, not a failure, so it may be something else. The best way to navigate the logs is to search for the text string "value 3", which is the internal logging code for displaying the errors. If you can find the log containing that string and post the +/- 10 lines on each side, we can probably get a better idea of what's going on.

Thanks,
Sam Lester (MSFT)|||

I found it (4) times in file SQLSetup0001_586III800205_SCC.log:

Type: ARTICLE_WMI_TYPE_PROPERTY

Namespace: cimv2

Class name: Win32_OperatingSystem

Property name: OSProductSuite

Property type: 2

Value: 2

Type: ARTICLE_WMI_TYPE_PROPERTY

Namespace: cimv2

Class name: Win32_OperatingSystem

Property name: SuiteMask

Property type: 2

Value: 3

Type: ARTICLE_WMI_TYPE_PROPERTY

Namespace: cimv2

Class name: Win32_OperatingSystem

Property name: Version

Property type: 2

Value: 4

Type: ARTICLE_WMI_TYPE_PROPERTY

Namespace: cimv2

Class name: Win32_OperatingSystem

Property name: OSType

Property type: 2

:

:

Type: ARTICLE_WMI_TYPE_REGISTRY

DefKey: 0x80000002

Subkey name: SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib

Value name: Last Counter

Registry type: 4

Value: 2

Type: ARTICLE_WMI_TYPE_REGISTRY

DefKey: 0x80000002

Subkey name: SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib

Value name: Last Help

Registry type: 4

Value: 3

Type: ARTICLE_WMI_TYPE_REGISTRY

DefKey: 0x80000002

Subkey name: SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\009

Value name: Counter

Registry type: 4

Value: 4

Type: ARTICLE_WMI_TYPE_REGISTRY

DefKey: 0x80000002

Subkey name: SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\009

Value name: Help

Registry type: 4

:

:

Type: ARTICLE_WMI_TYPE_REGISTRY

DefKey: 0x80000002

Subkey name: Software\Microsoft\Windows\CurrentVersion\Uninstall\{3BDB182E-8371-46BD-AC39-C14A91D5EEF8}

Value name: DisplayName

Registry type: 4

Value: 2

Type: ARTICLE_WMI_TYPE_REGISTRY

DefKey: 0x80000002

Subkey name: Software\Microsoft\Microsoft SQL Server\MSSQL.3\Setup

Value name: SqlProgramDir

Registry type: 4

Value: 3

Type: ARTICLE_WMI_TYPE_REGISTRY

DefKey: 0x80000002

Subkey name: Software\Microsoft\Microsoft SQL Server\MSSQL.3\Setup

Value name: SQLPath

Registry type: 4

Value: 4

Type: ARTICLE_WMI_TYPE_REGISTRY

DefKey: 0x80000002

Subkey name: Software\Microsoft\Microsoft SQL Server\MSSQL.3\Setup

Value name: SQLBinRoot

Registry type: 4

Value: 5

Type: ARTICLE_WMI_TYPE_REGISTRY

DefKey: 0x80000002

:

:

Type: ARTICLE_WMI_TYPE_REGISTRY

DefKey: 0x80000002

Subkey name: Software\Microsoft\Windows\CurrentVersion\Uninstall\{2373A92B-1C1C-4E71-B494-5CA97F96AA19}

Value name: DisplayName

Registry type: 4

Value: 2

Type: ARTICLE_WMI_TYPE_REGISTRY

DefKey: 0x80000002

Subkey name: Software\Microsoft\Microsoft SQL Server\MSSQL.1\Setup

Value name: SqlProgramDir

Registry type: 4

Value: 3

Type: ARTICLE_WMI_TYPE_REGISTRY

DefKey: 0x80000002

Subkey name: Software\Microsoft\Microsoft SQL Server\MSSQL.1\Setup

Value name: SQLPath

Registry type: 4

Value: 4

Type: ARTICLE_WMI_TYPE_REGISTRY

DefKey: 0x80000002

Subkey name: Software\Microsoft\Microsoft SQL Server\MSSQL.1\Setup

Value name: SQLBinRoot

Registry type: 4

Value: 5

Type: ARTICLE_WMI_TYPE_REGISTRY

DefKey: 0x80000002

Subkey name: Software\Microsoft\Microsoft SQL Server\MSSQL.1\Setup

Thank you. I hope this helps.

Cannot find module in web data administrator

I just downloaded the web data administrator from MSDN and after entering my credential, I get this error:

Specified module cannot be found
at SqlAdmin.SqlServer.Connect()
at SqlWebAdmin.databases.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain()

The only page I can see is the Import page, the database and the export get the same error.
It's a fresh install, anyone know something I need to do to get a correct install ?Since I had not yet downloaded and installed the Web Data Administrator, I went just now and installed it from Microsoftlink

I just clicked on Download, chose "Open" and just left whatever defaults there might have been. I went into SQL Server and changed the authentication mode to mixed. Then I went to http://localhost/sqlwebadmin/default.aspx and logged in with my sa login and password. It all worked like a charm.

Not sure what help any of that is...

Terri|||I tried doing another clean install, but I get the same problem.

I can login just fine, but after leaving default.aspx, I get the error in the 2 other pages.

Without better error description I fear I won't be able to find the bug in all this code, more so if it work on other machines.

Here is the code of the Connect Method from where the error seem to be coming:

 dmoServer = (NativeMethods.ISqlServer)new NativeMethods.SqlServer();
 dmoServer.Connect(Name, Username, Password);

I have no idea what's this NativeMethods thing is coming from. I'm using MSDE, could that be the problem ?