Adding roles to hosted server

I need to find out how to add roles to my SQL that is on a hosted server.
I have created 2 roles, but after publishing and uploading my site, when I try and create a user, I get the error:

"Exception Details: System.Configuration.Provider.ProviderException: The role 'userAtype' was not found."

There are two other roles that the same happens with.
Running it locally all was fine, I just didn't seem to get this info where it needs to be when I uploaded it.

I'm new to messing about with SQL, so sorry if this is really elementary.
I have VS2005 Standard, and the SQL Server Management Studio Express.

The hosting provider I have does not allow remote connections to the DB on shared hosting, so I need to (?) generate a script to populate the DB? and run it in their browser-based Querry Window?
How would I do this?

Thanks.you can use an option on the aspnet_reg.exe command that creates a script. then you can use that sqlscript to load the remote database.|||I'm afraid I'll need a bit more than that.

Are you refering to "aspnet_regsql.exe"? I can't seem to find "aspnet_reg.exe"A bit more info, please?
Thanks|||

Yes, sorry. I meant aspnet_regsql.exe

http://msdn2.microsoft.com/en-us/library/x28wfk74.aspx

If you use the option-sqlexportonly filename

You can export the file it will create

|||I'll post this here as a follow up.

I tried out the new SQL Server Database Publishing Wizard CTP 1, found in the sticky at the top of this forum.
Fast, simple.
Well, there is a goof with GoDaddy's Querry Analyser [sic] and I had to adjust the generated script in a text editor, but that is GoDaddy's fault/problem.

Very straightforward - the command line goes like this:

sqlpubwiz script -C "Server=MACHINENEAME\SQLEXPRESS;AttachDbFilename=\"C:\path\to\the\local\ASPNETDB.MDF\";Integrated Security=True;User Instance=True;Database=DB_NAME" myDB.sql

Adding a table, stored procedure, or view in push tranaction repl

We are using SQL 2k and use push replication. If I want to add a table, a
view or a stored procedure to a publishing table, view or stored procedure,
can I just create them using EM or query analyzer manually in both the
publishing table or subscribing table without involving replication?
If this is not a good way, what can I do to just push the new object over
without doing a snapshot?
Wing
Yes you can create them on both sides, but the table will not be
synchronized or kept current. To do this you need to use sp_addarticle.
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
"Wingman" <Wingman@.discussions.microsoft.com> wrote in message
news:982C7152-AF5A-4E21-A2E0-58A48C894FBC@.microsoft.com...
> We are using SQL 2k and use push replication. If I want to add a table, a
> view or a stored procedure to a publishing table, view or stored
> procedure,
> can I just create them using EM or query analyzer manually in both the
> publishing table or subscribing table without involving replication?
> If this is not a good way, what can I do to just push the new object over
> without doing a snapshot?
> Wing
|||You can create the article on the publisher as per usual then use
sp_addarticle and sp_addsubscription followed by running the snapshot agent
and distribution agent. You mention that you don't want a new snapshot, but
in the case of transactional replication, running the snapshot agent in this
case will just create a snapshot of the new article and not all the others.
exec sp_addarticle @.publication = 'tTestFNames'
, @.article = 'tEmployees'
, @.source_table = 'tEmployees'
exec sp_addsubscription @.publication = 'tTestFNames'
, @.article = 'tEmployees'
, @.subscriber = 'RSCOMPUTER'
, @.destination_db = 'testrep'
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||We will be running a merge replication to multiple laptop subscribers. Will
this same concept apply to us? e.g. would we run the sp_addarticle and
sp_addsubscription ? And would we need to run a new snapshot?
Also, is there a way to retrieve all of the names of the subscribers for a
publication? Thanks.
David
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:%23wsrAKhDGHA.3820@.TK2MSFTNGP12.phx.gbl...
> You can create the article on the publisher as per usual then use
> sp_addarticle and sp_addsubscription followed by running the snapshot
> agent and distribution agent. You mention that you don't want a new
> snapshot, but in the case of transactional replication, running the
> snapshot agent in this case will just create a snapshot of the new article
> and not all the others.
> exec sp_addarticle @.publication = 'tTestFNames'
> , @.article = 'tEmployees'
> , @.source_table = 'tEmployees'
> exec sp_addsubscription @.publication = 'tTestFNames'
> , @.article = 'tEmployees'
> , @.subscriber = 'RSCOMPUTER'
> , @.destination_db = 'testrep'
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||You use sp_addmergearticle. A new snapshot is generated. IIRC if the article
is part of a join filter an entire new snapshot will be genereated.
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
"David Chase" <dlchase@.lifetimeinc.com> wrote in message
news:uXjH6cvDGHA.1676@.TK2MSFTNGP09.phx.gbl...
> We will be running a merge replication to multiple laptop subscribers.
> Will this same concept apply to us? e.g. would we run the sp_addarticle
> and sp_addsubscription ? And would we need to run a new snapshot?
> Also, is there a way to retrieve all of the names of the subscribers for a
> publication? Thanks.
> David
> "Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
> news:%23wsrAKhDGHA.3820@.TK2MSFTNGP12.phx.gbl...
>
|||David,
try sp_helpsubscription for the list of subscriptions.
For merge you can use sp_addmergearticle or just add the article through the
publication properties dialog box. You'll still need to run the snapshot
agent but it works differently and a whole snapshot is generated, even
though only the new article is applied by the merge agent.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||A new snapshot of your entire merge publication is always forced.
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
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:eZF%23FgvDGHA.3828@.TK2MSFTNGP14.phx.gbl...
> You use sp_addmergearticle. A new snapshot is generated. IIRC if the
> article is part of a join filter an entire new snapshot will be
> genereated.
> --
> 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
> "David Chase" <dlchase@.lifetimeinc.com> wrote in message
> news:uXjH6cvDGHA.1676@.TK2MSFTNGP09.phx.gbl...
>