Migrating ASPNETDB from SQL 2005 Express edition to SQL 2000

[Derek]

I am trying to deploy a web site on a server but I am having problems with
the ASPNETDB database.

It works fine in development on my PC but as SQL Server 2005 Express Edition
only supports local databases I need to migrate ASPNETDB to one of our SQL
Servers running SQL Server 2000.

I have used aspnet_regsql.exe to create the database and added these lines
to the web config file in the connectionstrings section.

<remove name="LocalSqlServer"/>
<add name="LocalSqlServer"
connectionString="Data Source=RH-SQL-1;Initial
Catalog=ASPNETDB;Integrated Security=True"
providerName="System.Data.SqlClient"/>

When I try to run the site now I get the following error message:

Cannot open database requested in login 'ASPNETDB' Login fails.

Can anyone tell me what I have missed?
--
Derek

[Derek]

Fixed this one.

Because I created the database my user was dbo and it would not allow me to
connect under my own name.

I recreated ASPNETDB using a tech account and I fire uo the web site
straight away.
--
Derek
"Derek" wrote:

I am trying to deploy a web site on a server but I am having problems with
the ASPNETDB database.

It works fine in development on my PC but as SQL Server 2005 Express Edition
only supports local databases I need to migrate ASPNETDB to one of our SQL
Servers running SQL Server 2000.

I have used aspnet_regsql.exe to create the database and added these lines
to the web config file in the connectionstrings section.

<remove name="LocalSqlServer"/>
<add name="LocalSqlServer"
connectionString="Data Source=RH-SQL-1;Initial
Catalog=ASPNETDB;Integrated Security=True"
providerName="System.Data.SqlClient"/>

When I try to run the site now I get the following error message:

Cannot open database requested in login 'ASPNETDB' Login fails.

Can anyone tell me what I have missed?
--
Derek