Migrating ASPNETDB from SQL 2005 Express edition to SQL 2000

G

Guest

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?
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top