ASPNETDB.MDF, My Own Database And Deployment

May 29, 2006

This question has been asked before, with vague responses

I'm using Visual Web Developer 2005 Express, SQL Server 2005 Express and SQL Server Management Studio Express.

When I create an application with Login controls, VWD automaticlly creates a ASPENTDB.MDF security database. I also create my own database for my application e.g. abc.mdf. In other words, I have two databases. However, my hosting company supports only one database. What do I (we) do?

I have seen articles on: aspnet_regsql . Does this create a new database with all the security features of ASPNETDB.MDF built into my new database i.e. abc.mdf?

(A) If yes, how do you run it with SQL Server Managment Studio Express? It sounds silly, but I need instructions here please ... Also, do you run this against abc.mdf or do you use it create abc.mdf?

(B) If not, how do you achieve a single database scenario?

I'm sure this is a very common deployment question, which is very confusing for most of us hobbyists that want to deploy their web applications

View 2 Replies


ADVERTISEMENT

Moved Aspnetdb To SQL Server - What Permissions Do I Need To Give The ASP IIS Service Account For That? (Getting: Cannot Open Database Aspnetdb Requested By The Login. The Login Failed.)

May 12, 2008

I am getting the error:
Cannot open database "aspnetdb" requested by the login. The login failed.
When I browse to my ASP.NET 3.5 LINQ web application on the IIS 6.0 server on Server 2003.
I imagine this is because while I granted SQL Server 2005 login and permissions to my database that the application stores its data in, I did NOT grant any rights to the service account the IIS Application Pool uses for its identity to the aspnetdb database on SQL Server which is where all my roles information is stored at.
My question is what are the MINIMUM permissions needed for this database so it can perform its roles related functions?
I'm using Windows Authentications with the SQL Role provider for authorization.
 
Thank you.
 
 
EDIT: I think I only need to open the aspnetdb database and add my login to the aspnet_Roles_FullAccess role.  Is that correct?

View 2 Replies View Related

ASPNETDB To Another Database

Apr 19, 2007

Hi there readers of this post,
Do you know how to transfer the database (ASPNETDB.mdf) tables made by the ASP.NET admin tool into another database?
I want to run everything from 1 database.
regards
Sat

View 1 Replies View Related

How Can I Open A .mdf AspnetDB DataBase ?

Jul 24, 2007

Hello everybody, I am working with SqlExpress and MSSQL Server Management Studio Express and do not manage to open the aspnetDB .mdf database in which I am storing all data about my users.I woulds like to open it and to be able to request it in order to check some strange things.Actually, I'm experiencing an isssue with that database since the request just below gives me two results for only one user: SELECT Member.Password, Member.PasswordAnswer
FROM aspnet_MemberShip Member, aspnet_Users Users
WHERE Member.UserId=Users.UserId AND Users.UserName='Admin'  Using this request returns me a user whom password is clear and an identical user whom password is hashed whereas I set PasswordFormat="Clear" in my Web.ConfigCould you explain me how I may proceed please? Thanx for your help   

View 3 Replies View Related

Avoiding ASPNETDB SQL Database?

Sep 7, 2007

Hello.
I have been developing a small site that has two backend SQL Server databases.  One for my application data and one for the ASPNETDB database that is created by the ASP .NET Configuration utility.
Is it possible to configure the ASP .NET Configuration tool to use my custom database instead of creating a second database called ASPNETDB?
Thanks in advance.
Kev

View 2 Replies View Related

Default ASPNETDB Database

Nov 28, 2007

Hi
I want to set up my web app to use a web parts personalization, I notice that a default database named aspnetdb is made, I also made one in my sql server using the aspnet_regsql.exe to make it.  Now what I need to find out is how to make my app point to the database in the sql server instead of making that default one.
 
Thanks

View 8 Replies View Related

Aspnetdb To Main Database?

Jan 6, 2008

When I created my website in Visual Studio 2008, I ended up with two databases.  The one I created (Speedway.mdf), then VS2008 added a new one (aspnetdb) when I added membership data (roles, users..etc).  Since the host I'm using charges for each database, I just want to move all my membership information into Speedway.mdf.  I exported the tables from aspnetdb.mdf to Speedway.mdf, but now I don't know how to tell the site to look at Speedway.mdf to find the membership info?

View 6 Replies View Related

Combine Aspnetdb With The Application's Database

Sep 19, 2006

I have tried to find all the threads related to this topic.  At this point I would like to find out what the best practices are for doing this. I plan to use Membership, Roles, and the login controls to handle my authentication and permissions issues.  I want to use the same database for my application data as for Application Services, using a standard SQL Server. So far, the easiest way to set this up that I can think of is to:1. Use aspnet_regsql.exe to create the Application Services Database schema2. Edit the "LocalSqlServer" entry in <connectionStrings> to point to the above database3. Add the tables, views, stored procedures, etc., that I need for my application into the database created in step 1Is there any more configuration I need to do to get Membership and Roles working?  When I did the Walkthrough, step 2 seemed to be the only requirement for getting Membership and Roles to work.Will I run into any trouble using LocalSqlServer for my application data updates?I would be interested in any other approaches to setting up a combined database, including opinions why and why not to do it.

View 1 Replies View Related

Need To Select From ASPNETDB And Other Database In One Query

Feb 3, 2007

Hello everyone,
I have a problem with making such a query. I have two databases: DB1 and ASPNETDB - default asp database. I get data from DB1.Books and want to join (INNER JOIN) UserID with UserName from ASPNETDB.Users.
The ponint is that I don't know how to access ASPNETDB in the query. I use SQLDataSource control in which I specified the ConnectionString pointing to DB1 database on my local SQL Server 2005 Express.
On the other hand, if I use a ConnectionString pointing to ASPNETDB as a database dynamically attached from file (~/App_Data/ASPNETDB.MDF), I gain access to the Users table but I get an error message when I try to access DB1.dbo.Books...
I'm getting sick of it.. thanks for any help!
 
kind regards

View 3 Replies View Related

ASPNETDB Replaces My Database In Connection

Aug 17, 2007

Hi,I've a little problem. When I connect my local server by this connection string: Data Source=NB126SQLEXPRESS;Initial Catalog=TVRM;Integrated Security=True I get content of ASPNETDB.MDF (placed in App_Data directory) instead content of my own database named TVRM. Please help...

View 2 Replies View Related

ASPNETDB - Unable To Connect To SQL Server Database

Dec 5, 2006

Hi Eevryone:
I seem to have corrupted my ASP.net Web Site Administration Tool some how.  It worked fine a few days ago, but reloaded SQL Server 2005 Express Edition W Adv Services SP1 yesterday I can not get past the "Unable to connect to SQL Server database" error.  I have run the aspnetdb.exe and created both a aspnetdb.mdf and loaded the tables to into a existing mdf.  I have checked all the permissions. 
So any ideas on what I am doing wrong, or can you point me to some documentation on the 'AspNetSqlProvider'
 
Thanks in advance, Gene

View 4 Replies View Related

Error Connecting To ASPNETDB - Cannot Open Database

Feb 15, 2007

Hi everyone, i have already created posts about this problem and im aware theres millions of replys, but i still cant get this to work and its driving me mad. The posts i have seen i dont understand?
 Im using the standard ASPNETDB Database, i have never opened up SQL Server Management studio, although i do have the express edition.
i have tried everything and i am totally stumped as to what to do. Heres my web.config.
It works in VWD 2005 Express, but not in WWWROOT or on webserver?
PLEASE PLEASE PLEASE Can someone help me!!!!!!!!!
 Dan :)
<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<appSettings/>
<connectionStrings>
<add name="northwindsConnectionString1" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.mdf;Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />
<add name="ConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|MyDatabase.mdb;Persist Security Info=True"
providerName="System.Data.OleDb" />
</connectionStrings>
<system.web>
<profile>
<properties>
<add name="FullName" defaultValue=""/>
</properties>
</profile>
<roleManager enabled="true" />
 
<compilation debug="false" />
<authentication mode="Forms" />
 
</system.web>
</configuration>

View 6 Replies View Related

Multiple Users Of A Website Using Aspnetdb.mdf Database

Jul 15, 2007

I don't know whether this question belong here, but....
In the past I had many customers using the same website each with their own domain name and their own database. To accomplish that, I used MS Access and placed each customers database in separate directories. I steered the customer to the correct directory using their domain name. I am now trying to accomplish the same thing using aspnetdb.mdf and other .mdf database files. I am using the aspnetdb.mdf database for membership, etc. I want the aspnetdb.mdf database file to be unique for each customer. Does anyone know how to accomplish what I was doing with MS Access using aspnetdb.mdf? Is there any way to have multiple web.config files each of which would be dedicated to a particular customer?
 

View 1 Replies View Related

Aspnet_regsql - Aspnetdb Working With My Existing Database

Jan 2, 2008

I installed ASPNETDB with the standard script, but then learned it was possible to integrate this membership db into my existing db (haven't done this yet, but will tomorrow then I'll delete the auto-created ASPNETDB for clarity).That's Great. Now.....I'm not sure the best way to tie this information into with my existing data. I assume I should use the UserID field but how should I do it? Should I update my existing customers table with a copy of the UserID value upon creation? If so, how do I do that?  I can create the relations between whichever tables, but I am curious as to your recommended method.Thanks for your help.jb 

View 5 Replies View Related

Detach Aspnetdb Database Database

May 6, 2008

Hi,
Iam facing problems to connect to the new database after detach the aspnetdb.Simply the new database disappear (In SQL 2005 Management studio express the database contents disappear ! and I get an error when try to open it).If I try to connectto aspnetdb again I get an error telling me it is used by another process.I don't understand what is going on could any one explain to me?  

View 12 Replies View Related

Aspnetdb Is On A Network Path That Is Not Supported For Database Files

Sep 1, 2006

I have two, probably related, problems:I have a very simple site. It will be used on the local intranet only. I want to use the windows authentication so users do not have to log on. The aspnetdb has been created using the configuration tool. If I use Server Explorer in vs to work on the site on my local machine, I can open aspnetdb, look at its tables, etc. If I use Server Explorer in vs to work on the site on the server, aspnetdb will not open and gives this error message:           ..."network path that is not supported for database files"...Other sites on the same server give the same message, but the sites work. I think this is because they can read the file but not write it; but that is a guess. We have tried everything; my head is ready to explode. We are using SQLServerExpress. It resides on the server's C drive (as does our data database). The web site, and hence the aspnetdb are on the F: drive of the same machine. Does SQLServerExpress treat the F: drive as a UNC drive? If so, are we in deep doo doo? I'm at a loss.As far as logging in: If I debug from vs, the login works beautifully both on my local machine and running from the server using vs. Login does not work when accessing the site from iexplorer. Mystified by that one, too. I tried to implement profiles and they crash, too; that led me to consider a write problem.Don't know what to do; any help is appreciated.

View 1 Replies View Related

Using Aspnetdb Express Database For Private Website Tables

Mar 23, 2007

Hi, I am using express database and tools. I have an aspnetdb express database because I am using the login controls, personalisation...Can I use this database for my private tables also? Or do I need a separate express database for my private tables? Will using aspnetdb database, which contains special asp.net tables, for my private website tables create any kinds of problems in using my website? I want to use a single express database for my website, not two different express databases.
Regards, Sandy

View 1 Replies View Related

Aspnetdb Connection Could Not Establish But Database Correctly Created.

Sep 2, 2007

I installed netframework 2.0 Visual Web developer and MSSQL 2005 express edition with SQL Server management express.I have got this configuration: 2*256 mb ram Intel Pentium 3.2Ghz Windows XP HUN SP2 latest version.server name: localhostSQLEXPRESSAuthentication: Windows AuthenticationI run aspnet_regsql.exe and the setup wizard created aspnetdb see here, Microsoft sql server management studio can see the database:But! When I run to the asp.net web application administration tool in Provider Configuration and chooseAspNetSqlProvider only 1then I click Select a single provider for all site management data link -> then testThe Tool write this:Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site
Administration tool, use the aspnet_regsql command-line utility to
create and configure the database, and then return to this tool to set
the provider. 

View 5 Replies View Related

Change Datatype For The UserID Column In The Aspnetdb Database

Jan 30, 2008

Is it possible to change the data type of the UserID column in the aspnetdb database from uniqueidentifier to int?

View 1 Replies View Related

Problem In Deploying Userlogin Database On Webserver Aspnetdb.mdf

Feb 3, 2007

I read scott's tutorial for Deploying database to Hoster's server

"Recipe: Deploying a SQL Database to a Remote Hosting Environment (Part 1)"

bt cud nt upload n get the user login functinality wrking..

so plz help me..

View 1 Replies View Related

SQLEXPRESS Database Issue - Cannot Open Database ASPNETDB.MDF Requested By The Login, Login Failed

Aug 29, 2006

Hello Guys

This is my connection string

<add name ="ASPNETDBConnectionString1" connectionString ="Data Source= .SQLEXPRESS; Integrated Security = True; DataBase = ASPNETDB.MDF; User ID = MyWindowsUserName; Password = MyWindowsPassword; User Instance = False; Connect Timeout = 30" providerName ="System.Data.SqlClient"/>

I tried to research on the internet and i got a solution on changing the permissions for this database to enable user SystemName/ASPNET, but iam not able to access this ASPNETDB.MDF from SqlServer and if i go to server explorer in vs2005, i dint know where to chage the permissions.

Can anyone help me on this.

Thanks a lot

View 15 Replies View Related

An Attempt To Attach An Auto-named Database For File Aspnetdb.mdf

May 1, 2007

having exhaustively searched the forum and tried everything over the pas few days im still recieving :Error Caught in Application_Error eventError in: http://mysite.com/site1/index.aspxError Message: An attempt to attach an auto-named database for file E:Inetpubwwwrootmvate.comWapCmsApp_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.Stack Trace:   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)   at System.Data.SqlClient.SqlConnection.Open()   at System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate)   at System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation)   at System.Web.Profile.SqlProfileProvider.GetPropertyValuesFromDatabase(String userName, SettingsPropertyValueCollection svc)   at System.Web.Profile.SqlProfileProvider.GetPropertyValues(SettingsContext sc, SettingsPropertyCollection properties)   at System.Configuration.SettingsBase.GetPropertiesFromProvider(SettingsProvider provider)   at System.Configuration.SettingsBase.GetPropertyValueByName(String propertyName)   at System.Configuration.SettingsBase.get_Item(String propertyName)   at System.Web.Profile.ProfileBase.GetInternal(String propertyName)   at System.Web.Profile.ProfileBase.get_Item(String propertyName)   at System.Web.Profile.ProfileGroupBase.GetPropertyValue(String propertyName)   at ProfileGroupUser.get_ClientID()   at InfoPage.Page_PreInit(Object sender, EventArgs e)   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)   at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)   at System.Web.UI.Page.OnPreInit(EventArgs e)   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)help and suggestions appreciated 

View 1 Replies View Related

Why No Config.exe File In Book ASPnet 2.0 SBS By George Shepherd, To Install ASPNETDB Database?

Feb 7, 2008

For MS Press Book, ADO.NET 2.0 Step by Step, 2005 Edition by Rebecco Riordan, installing the code samples created a ConfigDB.exe file
under SampleDBs folder. Running this exe file created a AdoStepByStep into the Database
folder in SQL Server 2005 Express. 

However, for ASP.NET 2.0 Step by Step, 2005 Edition, by George Shepherd, there is no Config.exe to install the ASPNETDB SQL Server
2005 Express database. I right clicked the Database folder to 'Attach' the database.  But,
the database just showed a 'c: ASPNETDB.MDF filfe path as a name. Further, running
the aspx files in Chapters 7 and 12 showed a 'Timeout Expired' error msg, indicating
something wrong with accessing the SQL Server database.

How can I run the aspx files in Chapters 7 and 12?  How can I install the ASPNETDB?

TIA,
Jeffrey

View 4 Replies View Related

SSIS File System Deployment Vs SQL Server Deployment

Aug 15, 2007

Hi,


Please can you let me know which of the following 2 is a better method to deploy SSIS packages

File System deplyment OR SQL Server deployment

What are the advantages of one over the other?

Thanks,
Mrinali

View 4 Replies View Related

SQL Server 2005 And Express Permissions Nightmare/Cannot Open Database ASPNETDB.MDF Requested By The Login

Apr 12, 2007

I just spent the better par of 3 days creating a prototype in ASP.Net 2.0 and SQL Server Express only to discover that nobody from outside can see it...
ERROR with impersonation=true
User does not have permission to perform this action.
ERROR with impersonation=false
Unable to open the physical file "c:inetpubwwwroot------.mdf". Operating system error 5: "5(Access is denied.)".An attempt to attach an auto-named database for file c:inetpubwwwroot-----.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.  
What makes this so difficult?
What am I missing?
 

View 9 Replies View Related

Database Changes Deployment

Mar 26, 2007

Please forgive me if I'm in the wrong category...

How do you deploy changes to a database? Is there something you can run to compare the two versions and create a script to do this? I've heard about the DTS package (now DTSX I believe) but am not sure how to set one up. If anyone could point me to an article or something that might clear things up, it would be greatly appreciated. Thank you!

View 4 Replies View Related

Deployment With Database

May 17, 2008

Hello

I am currently developing a big winforms project that connects to a SQL Server 2005 database.

The idea is that the application will be deployed on random clients whenever needed. These clients have neither SQL Server installed, nor is there a server to provide a central database. The only option is to include the database file with the deploy.

Now, I've searched all around the internet on how to do this. I just can't seem to connect to the database-file from my deployed version. Is there something special that needs to be done?

Regards

- Varcour

View 1 Replies View Related

Database Deployment - SQL Express

Oct 22, 2007

I have an application being developed in VS 2005 using SQL Express.  I've built up some new roles and have several users pre-populated that I'd like to deploy to a shared hosting evironment.
The problem is that I seem to keep getting:
 Database 'd:hostingmemberasangaApp_DataASPNETDB.mdf' already exists. Choose a different database name.Cannot attach the file 'd:hostingmember
2agilitysite1App_DataASPNETDB.MDF' as database 'ASPNETDB'.
 I saw another post with a similar issue, but that resolution has not seemed to help.  Can anybody give me insights as to where the "asanga" is coming from? That might help me diagnose the issue.
 Thanks in advance

View 1 Replies View Related

Deployment - Database Configurations

Nov 14, 2007

Greetings,I've been looking around all morning and can't seem to find a good answer on this so I thought I'd post a message here.I'm using the recommended practice of keeping the ASPNETDB.MDF data separate from my site data. (I have my site data located in separate databases but still keep them in the App_Data directory.)I'm using SQL Server 2005 Express on a Server 2003 box and I've implemented scheduled backups on the databases in the Sql Server.The questions I'm having are:1. Why isn't the ASPNETDB.MDF database getting attached to the server? Is it using User Instances?2. If it is using User Instance then isn't this degrading performance? If so, how to force it to not use User Instance?3. If  User Instance is how it is supposed to work then how are we supposed to do a full backup of the ASPNETDB.MDF database if it isn't attached in the server? (xcopy doesn't seem to work on User Instances because of the dreaded "is being used by another process" error.)Any recommendations, advice, links, or answers to my questions would be greatly appreciated.

View 1 Replies View Related

Database Object Deployment

Feb 8, 2006

I have a Visual Studio 2005 Database Project, with SQL Server 2005 scripts in it.

How do I make a deployment package with it?

How do guys deploy your database objects/scripts?

 

View 4 Replies View Related

Accesing Database After Website Deployment

Sep 21, 2006

HiI'm using sqlexpress on development machine and on client server. I'm building a webapp using membership and role provided for asp. In web.config I have definet membership provider and role provider to point to my database.After web site deployment I get allways message : Failed to update database "c:appapp.MDF" because the database is read-only, and I'm forced to apply rights for ASPNET. More than that somethimes I must re-register users.I have tried to modify in web.config with <remove name="LocalSqlServer"/> <add name="LocalSqlServer"...> but I get errors if I try to design my dataset file:"Cannot get web application service".TIAPaul 

View 4 Replies View Related

SQL EXPRESS DATABASE DEPLOYMENT QUESTION

Oct 13, 2007



Hi Guys/Gals,

I have developed a database in Visual Studio 2005 (c#) ,using SQL Express as my database, on my local machine and deployed it to a different machine where it is being used in a live environment. No problems.

However, I have continued developing the application on my local machine and have made numerous additions to the structure of the database (on the development machine).

My question...How do I go about deploying the new database structure to the live machine without losing the live data?

Best regards

Jonny M.

View 6 Replies View Related

Creating A Database For Deployment In SQL Server

Nov 15, 2005

I am in the process of designing a Windows Forms 2.0 app, and need advice on the recommended deployment/creation of the database for my customers.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved