ASPNETDB.mdf ...already In Use... Error And Broader Questions

Jul 26, 2007

When you create and host an ASP.Net 2.0 site on your local computer and then configure .Net 2.0's drop-in user registration and management system it creates a SQL file named ASPNETDB.mdf with a whole bunch of tables and stored procedures (…as most of you know).  If you add your own custom tables to that database file and then try to call those tables you get an error that says that ASPNETDB.mdf is already in use.  One way to get around this is to create a separate database in the form of another ".mdf" file and then put all of your own custom tables in it.  You avoid the "...already in use..." errors that way but all your user accounts and the primary key structure that identifies them are in the original ASPNETDB.mdf file.  This makes it impossible to do primary/foreign key relationships between those tables and those in the new separate database you created.  It's kind of a catch-22 situation...unless I'm missing something that relates to releasing the ASPNETDB.mdf file from use whenever it is called so that additional tables and queries against that database file can be made without the "…already in use…" error cropping up. I am wondering if this problem is because the ASPNETDB.mdf file is not a "real" SQL database and as such imposes multiple-connectivity limitations such as those I am seeing.  If this is true, migrating to a real SQL database would alleviate this? Finally, from a broader security and scalability standpoint…what are the best practices relating to use of the ASPNETDB.mdf database for all your custom tables?  Should an additional database be created for all my application's custom tables (leading to the primary/foreign key problems) or should the additional tables be put into the ASPNETDB.mdf file (with some way of working around the "…already in use…" error)? A long-winded and broad question…thanks in advance for any responses. 

MDCragg

View 3 Replies


ADVERTISEMENT

ASPNETDB.MDF Questions

Jan 29, 2008

I developed an ASP.NET 3.5 site in VWD 2008 Express (with SQL Server 2005 Express) on Vista Home Basic (no IIS).  So I then moved my source over to an XP Pro machine with IIS 5.1 and installed .NET 3.5 and SQL Server 2005 Express. Brought up the site, but it failed when I attempted to login.  What do I have to do to get this to work? Do I need to attach the ASPNETDB.MDF in my APP_DATA directory to my SQLServerExpress?  Was this taken care of by the ASP.NET config tool when I set up users/roles on the Vista machine?Do I need to set some permissions? Like I said this was working only on through the built in webserver in VWD 2008 Express.ThanksEric 

View 1 Replies View Related

Error Inserting Data In ASPNETDB.net

May 9, 2008

I created my own table on the ASPNETDB.mdf file.
When i try to insert data on it, i get an exception:
System.Data.SqlClient.SqlException was unhandled by user code  Message="String or binary data would be truncated.
The statement has been terminated."  Source=".Net SqlClient Data Provider"  ErrorCode=-2146232060  Class=16  LineNumber=1  Number=8152  Procedure=""  Server="\\.\pipe\33189AFE-4730-4B\tsql\query"....
My C# code to insert:SqlConnection conexao =
new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["LocalSqlServer"].ConnectionString);
string query = "Insert Into NovasMaquinas " +"(NomeDaMaquina, FicheiroExecutavel, FicheiroXML, AdminQueSubmeteu, Autor, VmID)" +
"Values (@NomeDaMaquina, @FicheiroExecutavel, @FicheiroXML, @AdminQueSubmeteu, @Autor, @VmID)";SqlCommand cmd = new SqlCommand(query, conexao);
cmd.Parameters.AddWithValue("@NomeDaMaquina", textboxNomeVM.Text);cmd.Parameters.AddWithValue("@FicheiroExecutavel", path + fileUploadEXE.PostedFile.FileName);
cmd.Parameters.AddWithValue("@FicheiroXML", path + fileUploadEXE.PostedFile.FileName);cmd.Parameters.AddWithValue("@AdminQueSubmeteu", User.Identity.Name);
cmd.Parameters.AddWithValue("@Autor", textboxAutorVM.Text);cmd.Parameters.AddWithValue("@VmID", Guid.NewGuid().ToString());
conexao.Open();
//cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();    //THAT IS THE LINE WHERE THE EXCEPTION IS THROWN
conexao.Close();
 
Any ideas wath i'm doing wrong?
 

View 2 Replies View Related

Error Message Logging In (aspnetDB)

May 17, 2008

Hi,
construir
build
© Webster's
I am programing a site in aspnet 2005
I contructed space from my host for my Database.
In the web.config I added a connection string with username and password <configuration>
<appSettings/><connectionStrings><add name="oseriConnectionString" connectionString="Data Source=sql2005.digiweb.com.br;
Initial Catalog=zzz;
User Id=xxx;Password=yyy"
providerName="System.Data.SqlClient"/>
and I have access to this database when I work on my station as well when I am working on line.
Unfortunately I also gained for free the ASPNETDB.mdf file...
The ASPNETDB is automaticaly created in the ~/app_data together with a web.config.
I use the following connectionstring:<add name="aspNetDBConnectionString" connectionString="Data Source=sql2005.digiweb.com.br;
initial Cataloge=htdocsapp_DataASPNETDB.MDF;
Integrated Security=True"/>
Working on my station I have access to the aspnetDB file, I can add users roles etc..
notice that I use ConnectionString to my provider!
My first question is whether I really load the information also to the file in my site Because on my station I can find the changes.
If the answer is no then do I load the file simply through the FTP ?
and how can I open the file in the provider side?
In any case when I run the site on line, trying to log in, I get an error message 26
 
Exception Details: System.Data.SqlClient.SqlException: 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 Locating Server/Instance Specified)
If I insert a wrong password I get the same error message. Which means that I don’t have access to the file.
I definitely could use some help since from my provider I get none.
Thank you
Dov Kruman

View 4 Replies View Related

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

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

Sql Server Sp1 Error Messages Questions

Jun 27, 2006

Hello,

I have installed Sp1 for Sql Server 2005
I also received "locked files" and "reboot required". These errors I can find on all forums and do not worry me anymore.
However i still would like to know more about the messages in the log files.

- What does this mean: "Failed to read associated hotfix build information for the following file"......
- What does this men: "Failed to read version information for the following file".........

- Why are some products NOT APPLIED, while in the other log file it says "SUCCES" for the same product?
These beneath the 2 log files.

File C:WINDOWSHotfix HotFix.log shows "success"
-------------------------------------------
06/23/2006 13:45:01.131 Product Status Summary:
06/23/2006 13:45:01.162 Product: SQL Server Native Client
06/23/2006 13:45:01.241 SQL Server Native Client (RTM ) - Success
06/23/2006 13:45:01.287
06/23/2006 13:45:01.350 Product: Setup Support Files
06/23/2006 13:45:01.412 Setup Support Files (RTM ) - Success
06/23/2006 13:45:01.491
06/23/2006 13:45:01.584 Product: Database Services
06/23/2006 13:45:01.647 Database Services (SP1 2047 ENU) - Success
06/23/2006 13:45:01.772 Analysis Services (SP1 2047 ENU) - Success
06/23/2006 13:45:01.834 Reporting Services (SP1 2047 ENU) - Success
06/23/2006 13:45:01.866
06/23/2006 13:45:01.928 Product: Notification Services
06/23/2006 13:45:02.069 Notification Services (SP1 2047 ENU) - Success
06/23/2006 13:45:02.147
06/23/2006 13:45:02.194 Product: Integration Services
06/23/2006 13:45:02.225 Integration Services (SP1 2047 ENU) - Success
06/23/2006 13:45:02.256
06/23/2006 13:45:02.319 Product: Client Components
06/23/2006 13:45:02.366 Client Components (SP1 2047 ENU) - Success
06/23/2006 13:45:02.397
06/23/2006 13:45:02.459 Product: MSXML 6.0 Parser
06/23/2006 13:45:02.491 MSXML 6.0 Parser (RTM ) - Success
06/23/2006 13:45:02.553
06/23/2006 13:45:02.616 Product: SQLXML4
06/23/2006 13:45:02.678 SQLXML4 (RTM ) - Success
06/23/2006 13:45:02.725
06/23/2006 13:45:02.772 Product: Backward Compatibility
06/23/2006 13:45:02.788 Backward Compatibility (RTM ) - Success
06/23/2006 13:45:02.803
06/23/2006 13:45:02.850 Product: Microsoft SQL Server VSS Writer
06/23/2006 13:45:02.881 Microsoft SQL Server VSS Writer (RTM ) - Success
06/23/2006 13:45:02.897
06/23/2006 13:45:02.913 Hotfix package completed
06/23/2006 13:59:42.596 Hotfix package closed
-------------------------------------------


But file C:WINDOWSHotfixSQLTools9Logs shows "not applied"
-------------------------------------------
06/23/2006 13:44:33.565 Product Status Summary:
06/23/2006 13:44:33.596 Product: SQL Server Native Client
06/23/2006 13:44:33.627 SQL Server Native Client (RTM ) - Success
06/23/2006 13:44:33.643
06/23/2006 13:44:33.659 Product: Setup Support Files
06/23/2006 13:44:33.674 Setup Support Files (RTM ) - Success
06/23/2006 13:44:33.721
06/23/2006 13:44:33.737 Product: Database Services
06/23/2006 13:44:33.768 Database Services (SP1 2047 ENU) - Success
06/23/2006 13:44:33.799 Analysis Services (SP1 2047 ENU) - Success
06/23/2006 13:44:33.846 Reporting Services (SP1 2047 ENU) - Success
06/23/2006 13:44:33.877
06/23/2006 13:44:33.893 Product: Notification Services
06/23/2006 13:44:33.924 Notification Services (SP1 2047 ENU) - Success
06/23/2006 13:44:33.940
06/23/2006 13:44:33.955 Product: Integration Services
06/23/2006 13:44:33.971 Integration Services (SP1 2047 ENU) - Success
06/23/2006 13:44:34.002
06/23/2006 13:44:34.018 Product: Client Components
06/23/2006 13:44:34.034 Client Components (SP1 2047 ENU) - Success
06/23/2006 13:44:34.065
06/23/2006 13:44:34.096 Product: MSXML 6.0 Parser
06/23/2006 13:44:34.127 MSXML 6.0 Parser (RTM ) - Not Applied
06/23/2006 13:44:34.143
06/23/2006 13:44:34.174 Product: SQLXML4
06/23/2006 13:44:34.190 SQLXML4 (RTM ) - Not Applied
06/23/2006 13:44:34.206
06/23/2006 13:44:34.221 Product: Backward Compatibility
06/23/2006 13:44:34.268 Backward Compatibility (RTM ) - Not Applied
06/23/2006 13:44:34.284
06/23/2006 13:44:34.315 Product: Microsoft SQL Server VSS Writer
06/23/2006 13:44:34.331 Microsoft SQL Server VSS Writer (RTM ) - Not Applied
06/23/2006 13:44:34.362
06/23/2006 13:59:42.424 Hotfix package closed

Any anwers are appreciated

Harry

View 3 Replies View Related

2 Questions: SQL Timeout Error, Can I Email Info From App To Me ?

Mar 29, 2007

Question 1: SQL TimeOut Error
I get this when i run my program and when it happens the program no longer displays data from the database. When i restart the program it seems to work fine. Is there away to fix this or at least make a message to the user telling them to restart the program?


Question 2: Can I e-mail form info to myself?
I want the user to be able to fill a form and click submit and have it emailed to myself. how can i go about doing that?

{Edit}The Below is for a different project
Question 3: Picture Box' and SQL
Can I make it so the user a browse for a picture as his Avatar or Just his Picture and the save it to the Database again?

ie
Fill In This Form To Complete Registration:
Picture: {Pic Box Goes Here} [Browse]
Name:
Date of Birth:
(at this point im going to stop)

thx so much

View 1 Replies View Related

SQL License Questions And Other Questions &&>&&>&&>&&>

Mar 3, 2006

1.    Is it legal  and OK to use a MSDN SQL copy on a production environment or is it strickly for test environments ??

2.   If I own a legal copy of SQL 7 with 5 cals, can I legally use SQL MSDE and have more than 5 people access my SQL server or am I also limited to 5 users as my original ??

 Sorry I am a newbie at this SQL thing.

View 1 Replies View Related

ASPNETDB.MDF?

Mar 13, 2007

Using VS2005, VB backend and javascript,
I have developed a relatively simple site - its got a few (12) simple aspx pages but its mostly client side javascript. Keeping disk storage costs down is a big concern with this my site. The disk usage for the site is ~24M. Since this was larger than I expected I started inspecting the files comprising my site and found that the "ASPNETDB.MDF" in my "App_data" folder is consuming 10.2M by itself. The thing is that site only has a few pages with calls to SQL Server - but I never did anything (that I know of) with ASPNETDB.MDF. Through VS2005, I opened up the MDF file and poked around, everything that I looked at was empty (NULL). 
So my questions are:

What is causing the ASPNETDB.MDF to consume 10.2M even thought I can't see any data stored in it?
Is there anyway for my to reduce the size of this file? If so, how?
Your input appreciated.

View 2 Replies View Related

Using ASPNETDB.mdf

Nov 14, 2007

I'm creating a website in VWDexpress 2005 using a database, with string "SqlDataProvider". I have only one small-sized database. When I try to run my application in login mode (not using LoginView, I create it manually), the application cannot log me in, instead there's a weird error said some kind of "cannot use the ], [ or ) in database name". I don't configure the ASP.NET Configuration (which is opened in browser to make roles etc), I create all the controls manually. I don't have any other automatically-generated databases such as ASPNETDB.mdf because it cost lots memory! Oh, I used it before and the weird error I mentioned is occur when I excluded the ASPNETDB.mdf. I'm confused, why would the same error occur since I create everything manually? Any solutions? Thank you.

View 1 Replies View Related

ASPNETDB.MDF

Jan 31, 2008

 
I am creating a new application and want to store the sql database. But i need the aspnetdb.mdf. I dont know where is the database located or do we have any scripts to create the database.
Any help would be useful
 

View 3 Replies View Related

ASPNETDB

Apr 27, 2006





In response to a problem I have, my web hosting company asked me to rename aspnetdb.mdf. When I ask why, I was given this response

...it is because SQLexpless is developed for single database. If there is a same db name in the server, it cannot attach to the server. In order to prevent conflict, so that you need to change the SQLexpress's dbname into others to prevent conflict with others db name...

Does this make sense?

View 1 Replies View Related

ASPNETDB.mdf

Aug 14, 2007

Hi,

I thought I had this corrected, but in fact don't. According to http://msdn2.microsoft.com/en-us/library/ms228037.aspx
SQL Express is supposed to automatically generate a copy of ASPNETDB.mdf in the App_Data folder of the Express edition development suites (I'm using Visual Web Developer 2005).

In my case, it doesn't, and I can't figure out how to trigger it manually. I've read every post I can find, especially http://forums.microsoft.com/msdn/showpost.aspx?postid=98346&siteid=1

However, that mainly applies to deploying a database that already exists. I have already tried deleting the files as suggested and they do reappear in the appropriate folder, but I'm still not getting the ASPNETDB.mdf file in my apps.

Any help on this would be greatly appreciated. I've had a post up on the Visual Web Developer forum, but folk are staying away in droves. Also tried uninstall and reinstall all the way down to IIS 5.1

biobot

View 4 Replies View Related

Need Help With Aspnetdb.mdf As Im Going Nuts

Aug 1, 2006

I been all over this forum trying to find out how to get the aspnetdb.mdf running on my remote site and its driving me nuts.
i been using VWD 2005 express Edition and SQL Express 
Error Server Error in '/' Application.
An attempt to attach an auto-named database for file I:DataWebqsh.eumarker_93618920-db3b-4a04-a274-3fb613afc5dfwwwApp_Dataaspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
over the last week it has been a nightmare trying to get anything working on the site but i have got all the other databases working but i can get the aspnetdb.mdf working. i am very new to ASP.net so please use the he kiss method  "Keep It Simple, Stupid!" as im a newbe to this and it will just go over my head.
Thanks 

View 3 Replies View Related

ASPNETDB.MDF Is Readonly

Nov 29, 2006

I have downloaded and installed ASP.NET Ajax Sample applications from
http://ajax.asp.net/default.aspx?tabid=47&subtabid=471
 
I am trying to run the AJAX TaskList example under C:ProgramMicrosoft ASP.NETASP.NET AJAX Sample Applicationsv1.0.61025TaskList
 
First I moved the content of the TaskList folder to a virtual IIS directory, making it possible to debug the website on my local IIS server.
 
When I run the example I get prompted to Login or register as a new user. When I submit the registration form I receive the following error message:
 
Failed to update database "C:INETPUBWWWROOTTASKLISTAPP_DATAASPNETDB.MDF" because the database is read-only.
 
How can I modify the permissions for ASPNETDB.MDF in order to run the TaskList example.
 
Thanks

View 4 Replies View Related

Embedding ASPNETDB Into My Own Db

Mar 6, 2007

Hi there,
i wanted to embed ASPNETDB into my own db, so i scripted the ASPNETDB and executed it into my db. the problem is that App Manager of my website can not connect to it,(>i've corrected the connectionstring LocalSqlServer), the problem is that, it says its schema is not as expected, i understand this problem but, is there any way to solve it?
 
thanks in advance

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

Stucture Of Aspnetdb.mdf

May 30, 2007

hello how is created asnetdb,mdf?...from where it`s get that structure?... i want some link where is explained structure and how asnetdb.mdf works. can you help me? thx 

View 9 Replies View Related

Rename Aspnetdb ?

Jun 4, 2007

 Hello,I have a shared hosting plan which already has aspnetdb.mdf on the server so of course I cannot use that db name for my site...I have renamed the db and now I get an error Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion My question is, how can I make this thing work?  All help is greatly appreciated! 

View 12 Replies View Related

ASPNETDB.MDF && SQL Server

Jul 6, 2007

When I first sign up with Visual Web Developer, Do I continue to use this database ASPNETDB.MDF or do I need to connect to the Microsoft SQL Server Database? Does Visual Web Developer Express automaticaliyy connect to SQL Server Express Edition?
Thanks
Computergirl

View 1 Replies View Related

ASPNETDB Migration

Jul 12, 2007

I created a website using Visual web developer express edition (including SQL Express). No the user management section of the site (the login/logout database) was created automatically and SQL Server express was installed at my computer under the instance name of SQLExpress. I uploaded it to my web host and he hooked up the ASPNETDB for me. Now the problem is that ASPNETDB has an id password and I was given the MSSQL Server IP. How do I configure my website to accommodate that? Any help will be extremely useful!!!

View 3 Replies View Related

How To Merger ASPNETDB With My Own One?

Apr 23, 2008

Hi I have a problem most of the hosting companies I have seen offer the hosting package I want offering 1 MS SQL Server database and if you want to then they charge twice the price. The problem is I have heard you can use your own database for the memberships, roles, etc and have other tables for your other stuff. It's just I don't know and can't find the steps to do this. 

View 1 Replies View Related

Using ASPNETDB For All Site!

May 26, 2008

Hi all,
I`m a .NET desktop-app developer and i`m new to ASP.NET and web development, i start developping a web application with SQL Server database and i want to know if i can put all my tables in ASPNETDB?
is any restriction with that?
Regards

View 3 Replies View Related

ASPNETDB.MDF Is Read-only....

Apr 25, 2006

Hello everyone.
I am to create a sample site using the club site example. I had a problem with the IIS but now it is solved.
Now i copyied the site to the IIS and it is running. But i cannot access ASPNETDB.MDF. It keep saying that the database is read only... It is not read only!!!
Can any one help me??
System.Data.SqlClient.SqlException: Failed to update database "C:INETPUBWWWROOTNEOAPP_DATAASPNETDB.MDF" because the database is read-only.
Thank you in advance.
Iasonas

View 2 Replies View Related

ASPNETDB.MDF ... Whyyyy? :(

May 3, 2006

Hello!I have my own database file, but when I run my site in debug mode it creates aspnetdb.mdf again and stores all users in there ... question is - why? :((I've attached my own db to sql server express, ran "aspnet_regsql.exe -W" on it, so it got all the schema in there.Here's what I have in my web.config-----------<connectionStrings>        <add name="SqlServices" connectionString="Data Source=MESQLEXPRESS;Initial Catalog=myOwnDB;Persist Security Info=True;User ID=user;PWD=password" providerName="System.Data.SqlClient"/>    </connectionStrings><membership defaultProvider="SqlProvider" userIsOnlineTimeWindow="20">      <providers>        <remove name="AspNetSqlProvider" />        <add name="SqlProvider"          type="System.Web.Security.SqlMembershipProvider"          connectionStringName="SqlServices"          enablePasswordRetrieval="false"          enablePasswordReset="true"          requiresQuestionAndAnswer="true"          passwordFormat="Hashed"          requiresUniqueEmail="true"          maxInvalidPasswordAttempts="5"          passwordAttemptWindow="10"          minRequiredPasswordLength="5"          minRequiredNonalphanumericCharacters="0"          applicationName="/" />      </providers>    </membership>----------so i connect straight to sql server, not local file (so i dont have to attach / detach the db all the time)but when i create new user through ASP Config, it creates them in aspnetdb.mdb file :(can anyone explain me what im doing wrong here?thanks in advance!

View 1 Replies View Related

What Is Relationship Between ASPNETDB.MDF

May 15, 2008

Hi All,

I have a question.What is relationship between ASPNETDB.MDF in application and aspnetdb databasein SQL Server 2005?

Thanks,

Jack

View 1 Replies View Related

ASPNETDB.MDF-uniqueidentifier

Jan 25, 2006

Hi:
I am using the built in securty database from vs2005
I am trying to write an insert trigger that will add a role each time a user is added but I seem to be having difficulty I believe it's with the uniqueidentifier datatype. when I run this trigger via an insert statement I get the following error.
Can anyone set me straight?
========error==============
Cannot insert the value NULL into column 'RoleId', table 'R:AAAPROJECTSASPVS2005MERCERBUCKSAPP_DATAASPNETDB.MDF.dbo.aspnet_UsersInRoles'; column does not allow nulls. INSERT fails.
==================insert statement==========

Declare @NewUserID as uniqueIdentifier
set @NewUserID=newID()
print Cast(@NewUserID as varchar(50))
insert into dbo.aspnet_Users (ApplicationID,UserID,UserName,LoweredUserName,LastActivityDate)
Values('f23f01f0-7ad7-463b-87e2-f3e9141e6426',@NewUserID,'lrchase','lrchase','7/20/2005')
======trigger============================
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


ALTER TRIGGER [InsertRole]
ON [dbo].[aspnet_Users]
AFTER INSERT
AS
DECLARE @RoleID uniqueidentifier
DECLARE @UserID uniqueidentifier
Select @UserID=Userid from inserted
Print @UserID
SELECT @RoleID = RoleID
FROM dbo.aspnet_Roles where dbo.aspnet_Roles.LoweredRoleName='user'
Print @RoleID
SET NOCOUNT ON;
Insert Into dbo.aspnet_UsersInRoles
Values(@UserID,@RoleID)

Thanks Len

View 2 Replies View Related

Help, Is It Ok To Use Same Aspnetdb ApplicationID

Mar 8, 2007

Hi, feel like i might be headed for peril

i changed the appplication name on a aspnetdb equipped mdf (SQL express) , but have another similar mdf (SQL express) in a different web application, this database has the same applicationID in the "aspnetdb" tables,

these are meant to be two different web applications running under IIS, the root folder name for each web application is also different. also the mdf (SQL express) names are different as well

but still feel like i might be headed for jeporadry, ie does IIS want a unique applicationID for each asnpnetdb equipped mdf, or is the applicationID only applicable to the mdf it is in and the web application the mdf is running under??

View 1 Replies View Related

Aspnetdb Connection String

Jul 9, 2006

Hello,  I'm getting up to speed with VS2005 and use SQL Server 2005.  I'm using the login control in a test web app.  When I run the app I get this error:
Cannot open database "aspnetdb" requested by the login. The login failed.Login failed for user 'UserIDASPNET'.
The connection string I'm using is:
data source=localhost;Integrated Security=SSPI;Initial Catalog=aspnetdb;
The AspNetSqlProvider in the web administration tool connects to the database.
My question is, Is this a connection string issue, and user ID issue, a rights issue or is it something else?
Thanks,
Gaikhe

View 1 Replies View Related

Question On ASPNETDB.MDF Usage

Jul 19, 2006

Hi,
I am building a web site that requires authentication and offers role-based services.  The standard login controls provide ample functionality for authentication and role definition as well as some additional info (e.g. e-mail addresses) that I need. 
I also need to create my own tables to contain my business data, which in many cases it tied to the logged in user, e.g. I may need to SELECT fields from my own tables WHERE users are in a specific role.
Since the login controls use ASPNETDB.MDF I wonder if I should create my application's tables inside that database to make is easier to pull information from existing tables and my own tables.
Or shuold I instead create a different database for my logic and then write code to stitch the data together from both databases?
Another alternative I can think of is to build my own database that contains my business and authentication tables, then build a custom authentication provider on top of it.
Are there any performance caveats/benefits to these approaches?
Any help/advice is greatly appreciated.
Thanks. 

View 3 Replies View Related

Can't See Added Columns In ASPNETDB.mdf

Sep 27, 2006

In developing a VWDE project I added 2 columns to the User table in the ASPNETDB.mdf database.  I can see the columns in the Data Definition and I can see the values I added when I Show Table Data but I cannot access them with a SQLDataSource control?   The SQLDataSource shows all of the columns in that table except the ones I added.  Any suggestions? Thanks.

View 2 Replies View Related

New Table To ASPNetDb.mdf And Foreign Key

Nov 30, 2006

I was thinking of adding tables to ASPNetDB.mdf and have one of those tables have column userid as a foreign key from aspnet_Users
When I try to create relationship in Diagram, I get error saying that "data typ properties does not match"
userid in aspNet_Users is uniqueidentifier and userid (fk) in new table is int
What should I use, should I do that at all?
 
Thanks

View 4 Replies View Related







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