CodeVerge.Net Beta


   Explore    Item Entry    Members      Register  Login  
NEWSGROUP
.NET
Algorithms-Data Structures
Asp.Net
C Plus Plus
CSharp
Database
HTML
Javascript
Linq
Other
Regular Expressions
VB.Net
XML

Free Download:




Zone: > NEWSGROUP > Asp.Net Forum > general_asp.net.security Tags:
Item Type: NewsGroup Date Entered: 5/10/2007 2:56:19 AM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 1 Views: 21 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
2 Items, 1 Pages 1 |< << Go >> >|
cholwerda
Asp.Net User
SQL access from 1.1 to 2.0?5/10/2007 2:56:19 AM

0/0

I used a hashed registry username/password in ASP.NET 1.1 and we are moving to 2.0. 

I am going to be using forms authentication along with membership and role providers.  I added the line - identity impersonate = true , then the locations in the registry for username/password and I keep getting an error saying there is an issue with the config file.  Has this methodology been changed for access to SQL without storing username/password in configs? Should identity impersonate only be false when using the membership/role providers?  I'm sure I'm just not putting 2 and 2 together but if anyone has any thoughts on it.  It would be greatly appreciated.

Thanks
 

XiaoYong Dai –
Asp.Net User
Re: SQL access from 1.1 to 2.0?5/14/2007 5:53:24 AM

0/0

Hi

We strongly suggest you post your web.config since we have much confused from your description. Would the following information help? 

For ASP.NET 2.0 applications, you should store connection strings in the <connectionStrings> section of your application's Web.config file.

How To: Connect to SQL Server Using Windows Authentication in ASP.NET 2.0

http://msdn2.microsoft.com/en-us/library/ms998292.aspx

How To: Connect to SQL Server Using SQL Authentication in ASP.NET 2.0

http://msdn2.microsoft.com/en-us/library/ms998300.aspx

You should also encrypt your connection string in the Web.config file to avoid disclosing server and database names. To do this, use either the DPAPI or RSA protected configuration providers. If you deploy your application in a Web farm, use RSA because it is easy to export and import RSA keys across servers.

For more information, see

  • How To: Encrypt Configuration Sections in ASP.NET 2.0 Using DPAPI
  • How To: Encrypt Configuration Sections in ASP.NET 2.0 Using RSA

  • Best Regards
    XiaoYong Dai
    Microsoft Online Community Support

    Please remember to click ?Mark as Answer? on the post that helps you, and to click ?Unmark as Answer? if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    2 Items, 1 Pages 1 |< << Go >> >|


    Free Download:

    Books:
    Beginning C# 2005 Databases Authors: Karli Watson, Pages: 501, Published: 2006
    Microsoft Office Access 2003: Professional Results Authors: Noel Jerke, Pages: 400, Published: 2003
    Microsoft SQL Server 2000 DBA Survival Guide Authors: Mark Spenik, Orryn Sledge, Pages: 1032, Published: 2002
    SQL for Microsoft Access Authors: Cecelia Allison, Neal A. Berkowitz, Pages: 337, Published: 2005
    Macromedia ColdFusion MX 7 Web Application Construction Kit: web application construction kit Authors: Ben Forta, Raymond Camden, Leon Chalnick, Angela C. Buraglia, Pages: 1440, Published: 2005
    Optimizing Oracle Performance Authors: Cary V. Millsap, Jeff Holt, Pages: 388, Published: 2003
    Mastering Oracle SQL: Putting Oracle SQL to Work. Covers Oracle 9i. Authors: Sanjay Mishra, Alan Beaulieu, Pages: 336, Published: 2002
    Visual C# 2005 Recipes: A Problem-Solution Approach Authors: Allen Jones, Matthew MacDonald, Rakesh Rajan, Pages: 565, Published: 2006
    Oracle Database 10g Performance Tuning Tips & Techniques: Tips & Techniques Authors: Richard J. Niemiec, Pages: 967, Published: 2007
    SQL All-in-One Desk Reference For Dummies Authors: Allen G. Taylor, Pages: 684, Published: 2007

    Web:
    Simple Feature Access - Part 2: SQL Option | OGC® Simple Feature Access - Part 2: SQL Option ... 1.1.0, OpenGIS Implementation Specification for Geographic information - Simple feature access -, 05-134 ...
    Oracle OLAP: Best Practice Tips : SQL Access to Oracle DB ... Jun 2, 2008 ... Best Practice Tip #2: General AW Object Naming Conventions for dimensions .... June (1). Best Practice Tips : SQL Access to Oracle DB Multi. ...
    Code generation in XSLT 2.0, Part 1: Generate SQL with XSLT 2.0 Feb 8, 2005 ... Learn to use the cutting-edge features of XSLT 2.0 and generate PHP code ... The dashed boxes in Figure 1 (SQL model and Database access ...
    SQL Server 2008: Spatial Data, Part 2 Mar 27, 2008 ... re: SQL Server 2008: Spatial Data, Part 2. POLYGON((0 0, 0 10, 10 10, 10 0, 0 0) , (1 1, 4 5, 4 1, 1 1)) --> is it your intention that the ...
    ASP.NET Hosting, ASP .NET Web Hosting, SQL Hosting, Windows 2008 ... mssql hosting with sql management studio express access ..... and .net 1.1 hosting .NET 2.0 Hosting .net framework 3.5 3.0 2.0 1.1 hosting .NET 1.1 Hosting ...
    ASP.NET.4GuysFromRolla.com: Custom Paging in ASP.NET 2.0 with SQL ... NET 1.x in my book ASP.NET Data Web Controls Kick Start. In this article we'll look at how to implement custom paging in ASP.NET 2.0 using SQL Server 2005's ...
    Tutorial 1: Creating a Data Access Layer The next step is to define the SQL query used to access the data. .... Update(" Chai", 1, 1, "10 boxes x 20 bags", 18.0m, 39, 15, 10, false, 1); ...
    Download Access 2 SQL, Access 2 SQL 1.1 Download Access 2 SQL 1.1. Description. "This script will open any Access DB and create the SQL ... Fast Bluetooth Switcher 1.0.28 · Lock It Down - Free Edition 2.0 ...
    Dave does Data (Under construction - don't read yet) : SQL 2008 ... SQL 2008 Spatial Samples, Part 1 of 9 - How to Learn SQL Spatial .... 2 0, 2 2, 0 2, 0 0))'; DECLARE @h geometry = 'POLYGON((1 1, 3 1, 3 3, 1 3, 1 1))'; ...
    Using Remote Data Access with SQL Server CE 2.0 | O'Reilly Media Features of SQL Server CE 2.0. Figure 1 shows the main components in SQL Server CE ... For simplicity, I have chosen Anonymous access, but you really should ...

    Videos:
    Data Access in the ASP.NET 2.0 Framework www.mylivelessons.com Stephen Walther, the world's leading ASP.NET authority introduces his new LiveLesson- DVD-ROM hands-on personal video instruct...
    ArsDigita 10 (Relational Database Management Systems) Lecture 2/11 ArsDigita University Course 10: Relational Database Management Systems (RDBMS) A more formal approach to Relational Database Management Systems, co...
    ArsDigita 10 (Relational Database Management Systems) Lecture 11/11 ArsDigita University Course 10: Relational Database Management Systems (RDBMS) A more formal approach to Relational Database Management Systems, co...
    ArsDigita 10 (Relational Database Management Systems) Lecture 10/11 ArsDigita University Course 10: Relational Database Management Systems (RDBMS) A more formal approach to Relational Database Management Systems, co...
    ArsDigita 10 (Relational Database Management Systems) Lecture 6/11 ArsDigita University Course 10: Relational Database Management Systems (RDBMS) A more formal approach to Relational Database Management Systems, co...
    ArsDigita 10 (Relational Database Management Systems) Lecture 7/11 ArsDigita University Course 10: Relational Database Management Systems (RDBMS) A more formal approach to Relational Database Management Systems, co...
    ArsDigita 10 (Relational Database Management Systems) Lecture 9/11 ArsDigita University Course 10: Relational Database Management Systems (RDBMS) A more formal approach to Relational Database Management Systems, co...
    ArsDigita 10 (Relational Database Management Systems) Lecture 8/11 ArsDigita University Course 10: Relational Database Management Systems (RDBMS) A more formal approach to Relational Database Management Systems, co...
    ArsDigita 10 (Relational Database Management Systems) Lecture 5/11 ArsDigita University Course 10: Relational Database Management Systems (RDBMS) A more formal approach to Relational Database Management Systems, co...
    ArsDigita 10 (Relational Database Management Systems) Lecture 3/11 ArsDigita University Course 10: Relational Database Management Systems (RDBMS) A more formal approach to Relational Database Management Systems, co...




    Search This Site:










    obtaining the windows login id from in asp.net

    autoeventwireup true/false

    asp.net 2.0 treeview indentation problems

    app_code pdb

    "parameter count does not match parameter value count." error using text/html module

    working with sourcesafe

    sql server decimal and numeric data types

    comparing the contents of two directories

    asp.net configuration within ms visual web developer express

    triggering error at installed web application, not in build.application

    operator 'and' is not defined for types 'system.web.httpcookie'?

    bitmap resizing

    dnn 3.0.8 install assistance

    checking for the existance of a root ca on the client

    reference codebehind variable in client script

    could not load type

    dnn log in failure

    site visit counter module

    web part and usercontrol problem,help me!

    asp.net 2.0: appending to master page title from content page

    user id

    how do you get an <asp:textbox> inside of your script?

    error on page

    how to access files outside the root

    publish website

    menu problem

    error while running build.bat file

    file deletion

    dnn 2.x or dnn3.x

    ais-ec

     
    All Times Are GMT