|
|
|
|
|
|||||||
 |
ASP Net - Migrating ASPNETDB from SQL 2005 Express edition to SQL 2000 |
|
|
Thread Tools | Search this Thread |
06-09-2006, 02:06 PM
|
#1 |
Migrating ASPNETDB from SQL 2005 Express edition to SQL 2000
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 =?Utf-8?B?RGVyZWs=?= |
|
|
|
06-09-2006, 02:40 PM
|
#2 |
|
Posts: n/a
|
RE: Migrating ASPNETDB from SQL 2005 Express edition to SQL 2000
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 =?Utf-8?B?RGVyZWs=?= |
|
|
|
| Thread Tools | Search this Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Fox Studio Classics - R1 vs R2 | ayric | DVD Video | 1 | 05-10-2006 05:56 PM |
| A-1 Cheap Dvds | CHEAPDVDS | DVD Video | 0 | 06-19-2005 03:30 AM |
| requesting a hand up - read for your Mom [short message with Quotes] | Miss Marple | DVD Video | 1 | 03-17-2005 10:07 PM |
| New Releases: More WB 2 Packs, Discontinued titles: Updated complete downloadable R1 DVD DB & info lists | Doug MacLean | DVD Video | 0 | 10-19-2004 05:45 AM |
| More New Silver Pressed DVDs Added.. | SPW | DVD Video | 0 | 05-13-2004 12:30 AM |
