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