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.e xe to create the database and added these lines
to the web config file in the connectionstrin gs section.

<remove name="LocalSqlS erver"/>
<add name="LocalSqlS erver"
connectionStrin g="Data Source=RH-SQL-1;Initial
Catalog=ASPNETD B;Integrated Security=True"
providerName="S ystem.Data.SqlC lient"/>

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

Jun 9 '06 #1

Subscribe Reply

1707

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.e xe to create the database and added these lines
to the web config file in the connectionstrin gs section.

<remove name="LocalSqlS erver"/>
<add name="LocalSqlS erver"
connectionStrin g="Data Source=RH-SQL-1;Initial
Catalog=ASPNETD B;Integrated Security=True"
providerName="S ystem.Data.SqlC lient"/>

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

Jun 9 '06 #2

Similar topics

1885

C# 2005 Express Edition/ C# in MS VS 2005

by: Lubomir | last post by:

Hi, I would like to ask, how different are C# 2005 Express Edition and C# within MS Visual Studio 2005. Than as well Visual Web Developer 2005 Express Edition and ASP within MS VS 2005. Thanks, Lubomir

C# / C Sharp

5634

ASPNETDB.mdf

by: Arne | last post by:

How do I create aspnet.mdf on a production machine? How do I administer users on a production machine?

ASP.NET

6713

ASPNETDB.MDF when no SQLExpress, only SQL Server 2005?

by: nick | last post by:

I have only SQL Server 2005 installed on my PC. And I tried to add the following rows in web.config to use SQL Server 2005 instead of Express: <connectionStrings> <clear /> <add name="LocalSqlServer" connectionString="Data Source=.\SQL2005;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;user instance=true;Integrated Security=True;Initial Catalog=ASPNETDB;" providerName="System.Data.SqlClient" /> </connectionStrings>

ASP.NET

2946

Problems when uploading ASPNETDB.MDF to production server

by: 3Dfelix | last post by:

Problems when uploading ASPNETDB.MDF to production server Hi all, I'm a little web with a login page and aspnetdb.mdf file as data base for users. I've done it on local server, with VS2005 and SQLExpress. On local it run OK. The problem araise when I upload the precompiled site to a production server. On production server I have SQLserver 2000. I have read that I need to create on server the same db using the command aspnet_regsql.exe. ...

ASP.NET

2099

MS SQL Server 2005 Express Edition

by: kress1963nov22 | last post by:

I recently purchased a good MS book ("Build a Web Site Now") by Jim Buyens. It has the Express Edition of MS-Visual Web Developer 2005 on CD and also MS SQL Server 2005 Express Edition on the CD. A couple of questions for this newbie: Can MS SQL Server 2005 Express Edition be used in place of the older MSDE product for backend database work? I also have Visual Studio .NET (VB) 2003 (Standard Edition). How compatible are all these products...

Visual Basic .NET

6711

deploying aspnetdb membership .. error: 26 - Error Locating Server/Instance

by: jobs | last post by:

Works great on my client when I test from vs.net 2005. Howevever, when I deploy to the web server, I get this error: remotely and local from the web server. An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error...

ASP.NET

1213

cannot enter users management in ASP.NET Configuration (aspnetdb database)

by: R.A.M. | last post by:

Hello, Please help in the following problem. (I translate texts and messages from Polish to English, so there may be some differences). I have created ASP.NET application with aspnetdb database and I have created one user: demo. The problem is that when I enter ASP.NET Configuration (from Visual Studio Express Edition) and I choose 'Security' tab, then 'Manage users' I receive an .aspx page with error: Generating user instances in SQL...

ASP.NET

282

aspnetdb.mdf

by: Scott M. | last post by:

I'm a newbie when it comes to SQL Server and am trying to understand why there is an aspnetdb.mdf created as a system database in SQL Server 2005 Express edition, but also another one of the same name when I use membership & roles in an ASP .NET Web Site or WAP. Actually, I guess I understand why I get one in my App_Data folder of my web site, but what is the system one for?

ASP.NET

1627

Visual Studio 2005 Login Components and ASPNETDB Options

by: greg.hart | last post by:

Hello all, Just wanted to get some clarification on something. I was setting out to create a login page for people to login and then be able to access certain aspects of the website. Instead of doing what I usually do which is store the username password in a db table then compare what the user enters from the text boxes to what's in the db, I thought I would try the login components from the toolbox.

ASP.NET

9423

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10210

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9990

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9860

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

7406

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6668

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5297

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3560

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2814

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General