Move databas from express to sql 2000

Hi!

I have created i webpage whos has a logged in system which is cretead in VS 2005 with the function ASP.NET configuration.

And know will i move all databas to i a MSSQL 2000 there i only can have one databas, And know i have ASP.NET logged in Databas and one site databas.

I just wondering if its possible to make i virtual connection with MSSQL 2000? If not somebody has some idés for me?

I hope you can understand me.

If I understand, right now on your development environment you have the ASPNETDB database (logged in system) and also a site database. And you need to move to SQL Server 2000 where you'll only have one database.

You can combine the security schema (aspnetdb) and the site schema into the same SQL 2000 database - this should not be a problem. To install the ASP.Net security schema into an existing SQL 2000 database, you can run aspnet_regsql.exe against the database. So if the site database is already on this SQL 2000, just run aspnet_regsql against the same database (or get the DBA to do so) and then you'll need to point your database connection (in the web.config) against the SQL Server.

|||

Ok, tanks!

But i don't know how i do that. can you explain? If you want step by step.

The sql server and the webserver is on a webhotel, so i can't do any configuration.

|||

someone who can explain for me?

Now i just have to move the login database (ASTNETDB) into another database (a SQL 2000 database)

Someone?

|||

So now i know how i have to do. But when i use the aspnet_regsql.exe so i get a error.

Error

Grantor does not have GRANT permission.

The error comes when installCommon.sql