Member Avatar for Paua

Hi, I hope some-one can help.
I am trying to create a mobile application that uses merge replication. I am having problems synchronising CE db to coporate db.
I have had major trouble setting up my laptop for this, and have been unable to fix my final error.
What I'm using;
Vista business
MS sqlServer 2005 (SP3) developer edition
" " Compact edition

ERROR occurs when I try to create a Login.
------------------------------
TITLE: Microsoft SQL Server Management Studio

Create failed for Login '<computername>\IIS_IUSRS'. (Microsoft.SqlServer.Smo)

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Windows NT user or group '<computername>\IIS_IUSRS' not found. Check the name again. (Microsoft SQL Server, Error: 15401)
------------------------------

I don't know why it won't let me use this group, as it does exist. I've checked SID duplication and found nothing.

I really need help getting login going so I can add this user to the subscription so I can use the Virtual Directory. (I have already created a login for my snapshot agent - after working through various errors).

WOW! thanks in advance.

  • 1 Contributor
  • 3 Replies
  • 165 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by Paua
Member Avatar for Paua

UPDATE:
Fixed error by granting iiusr db permissions via Sql Server 2005.
& granting permission (I just can't remember the steps - but it was off
http://msdn.microsoft.com/en-gb/netframework/bb495180.aspx (merge rep part 1 & 2)
NOTE: In one of these steps you may get an error, use this link to sort it out
http://social.msdn.microsoft.com/forums/en-US/sqlce/thread/fb5cb5fb-c7ef-44e3-802d-ca00f2a8c439/

NEW ERROR: (Sql Compact Edition)
Trying to set up subscription using subscription wizard;
Synchronizing Data (100%) (Error)
Messages
Initializing SQL Server Reconciler has failed. Try again.
HRESULT 0x80045005 (29045)
The subscription to publication 'MainAll' could not be verified. Ensure that all Merge Agent command line parameters are specified correctly and that the subscription is correctly configured. If the Publisher no longer has information about this subscription, drop and recreate the subscription.
HRESULT 0x80045005 (0)
The operation could not be completed.
Any Advice would be appreciated.

Member Avatar for Paua

UPDATE:
After much googling around got sql server side (publisher etc) going...but what do ya know, just couldn't get compact side finalised, kept spitting out error "invalid path" to virtual directory (which I knew existed) or on my fresh new database and virtual directory that I'd created to test another way (with correct permissions, logins, and access to the snapshot share folder etc...even added these logins to my local authority) the sql server compact side wouldn't let me create a subscription (something to do with sql server agent (but I even tried using the default one rather then one I'd created myself, permission's all ok), so since my deadline is near and I've frustrated myself enough for the past 2 weeks, I'm going to create my mobile device using RDA to sync.
If your having a go at this here are some links you might find useful.
ERRORS
http://support.microsoft.com/kb/819261/en-us
http://www.windows-tech.info/15/0642051d9fb3639a.php
http://www.mydatabasesupport.com/forums/sqlserver-server/338289-server-principal-domain-name-already-exists.html
http://www.bigresource.com/MS_SQL-SQL-2005-Add-New-Login-Fails-Error-msg-15025--gRY2njOU.html#
http://social.msdn.microsoft.com/forums/en-US/sqlsecurity/thread/4f1200c6-84dc-4561-a75b-dbfc520415ac/

#NOTE: I think the root of my problem was installing the requried hotfixes, in the wrong order, and maybe the versions got missed up along the way. But I've run out of time to see if this is true. Good luck to other newbie's like myself giving merge rep. a go.

Member Avatar for Paua

UPDATE: IT WORKS!
Thought I might give it one more go, and SUCCESS.
I done things differently in the New Subscription Wizard, as follows;
PopupWindow: Webserver Authenciation
enter full url of VD:
e.g http://localhost/SqlMobile/sqlcesa35.dll or sqlcesa30.dll
Then on option: "How will the Subscriber connect to the web server?
Select checkbox "The Subscriber will be authenciated. Use the following user name and password" DONT use anonyomous.
Input desired Username and password into text box, then complete the rest of the wizard as required.

N.B - this will only work if you have already set up SQL Server Distributor,Publisher, Publication.
Here is a step by step guide from technet;
http://technet.microsoft.com/en-us/library/ms171908(SQL.90).aspx

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.