Cannot create subscription for a SQL Server 2005 Mobile database

I have been trying for almost 2 days now to create a subscription to a
SQL Server 2005 database but I haven't had any success. After reading
all of the documentation and installing everything, the problem seems
to have something to do with permissions. Here is what works:
* Created the a merge publication and checked to see that the
Replication Monitor shows that it works.
* Checked the directory where the snapshot files are located and they
exist.
* Can access the snapshot files from a browser, so I know security is
setup
* Tried setting the account for IIS 6.0 on the virtual directory to my
Windows account which has full admin permissions. Even tried
anonymous.
* Set the permission on all of the files and directories where the
snapshot files are stored.
* Added my Windows account to the PAL in the publication.
* Added my Windows account to the SQL Server login accounts
I then created an empty SQL Server 2005 mobile database locally on my
PC. Then I accessed it in SQL Server Management Studio.
Finally, I selected the New Subscription Wizard on the node of my
mobile database and tried using all kinds of login accounts.
Where it hangs is when I get to the last screen where it attempts to
create the subscription. After hanging several seconds on the part
that says "Synchronizing Data", it comes back with an error message
that either tells me that the SQL Server does not exist and/or the
user account does not exist. If I try screwing around with the various
types of login accounts, it can sometimes come back and say the IIS
account is not in SQL Server. There are a lot of accounts to setup
everywhere - publiccations, distributor, IIS, the database. Man, this
is getting to be one ugly headache. Can someone please give me some
solid steps on how to create a subscription.
Much appreciated,
Johann
I would first rule out publication properties. In SSMS create a local
sdf/mobile database and pull to it. If this works your publication is OK.
Then examine the IIS logs to see where it is getting stuck. Chances are it
is a permissions/authentication problem.
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
"Polaris431" <polaris431@.gmail.com> wrote in message
news:1173019861.533730.317880@.n33g2000cwc.googlegr oups.com...
>I have been trying for almost 2 days now to create a subscription to a
> SQL Server 2005 database but I haven't had any success. After reading
> all of the documentation and installing everything, the problem seems
> to have something to do with permissions. Here is what works:
> * Created the a merge publication and checked to see that the
> Replication Monitor shows that it works.
> * Checked the directory where the snapshot files are located and they
> exist.
> * Can access the snapshot files from a browser, so I know security is
> setup
> * Tried setting the account for IIS 6.0 on the virtual directory to my
> Windows account which has full admin permissions. Even tried
> anonymous.
> * Set the permission on all of the files and directories where the
> snapshot files are stored.
> * Added my Windows account to the PAL in the publication.
> * Added my Windows account to the SQL Server login accounts
> I then created an empty SQL Server 2005 mobile database locally on my
> PC. Then I accessed it in SQL Server Management Studio.
> Finally, I selected the New Subscription Wizard on the node of my
> mobile database and tried using all kinds of login accounts.
> Where it hangs is when I get to the last screen where it attempts to
> create the subscription. After hanging several seconds on the part
> that says "Synchronizing Data", it comes back with an error message
> that either tells me that the SQL Server does not exist and/or the
> user account does not exist. If I try screwing around with the various
> types of login accounts, it can sometimes come back and say the IIS
> account is not in SQL Server. There are a lot of accounts to setup
> everywhere - publiccations, distributor, IIS, the database. Man, this
> is getting to be one ugly headache. Can someone please give me some
> solid steps on how to create a subscription.
> Much appreciated,
> Johann
>