Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 1.0 and 1.1 > ASP.NET 1.1
|
ASP.NET 1.1 As of 10/6/2005, this forum is locked as part of the reorganization described here: http://p2p.wrox.com/topic.asp?TOPIC_ID=35394. No posts have been deleted. Open ongoing discussions from the last week have been moved to either ASP.NET 1.0 and 1.1 Beginners http://p2p.wrox.com/asp-net-1-0-1-1-basics-60/ or ASP.NET 1.0 and 1.1 Professional. http://p2p.wrox.com/forum.asp?FORUM_ID=50. See my sticky post inside for more.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.1 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 29th, 2005, 01:38 PM
Authorized User
 
Join Date: Jun 2004
Posts: 71
Thanks: 0
Thanked 0 Times in 0 Posts
Default Using Authentication using Sql

I am getting the following error saying:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

I building the application on my local machine. I build with not errors but I am trying to view through a web browser it gives me the following erro above.

The login has a domain\gruop name and I authenticatin use window. I am trying to figure out if I need to make some modification else were.

Your help is greatly appreciated
 
Old July 1st, 2005, 04:56 AM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 550
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hi Dear

Use the following connection string in your web.config file:

<add key="ConStr" value="server=[write your pc name here];database=[write your database name here];Trusted_Connection=yes"/>

In case of problems, let us know.

Regards
Mike

 
Old July 7th, 2005, 01:25 PM
Authorized User
 
Join Date: Jun 2004
Posts: 71
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I understand that I have to insert this code in the web.config file but where exactly should I put it?

 <authorization>
Line 50: <allow users="*" />
Line 51: <add key="ConStr" value="server=[flmirl-rmartin];database=[User_Account_Management];Trusted_Connection=yes"/>
Line 52: <!-- <allow users="[comma separated list of users]"
Line 53: roles="[comma separated list of roles]"/>

And I am getting this error:
Authorization rule must have an <allow> or <deny> tag.


 
Old July 8th, 2005, 05:10 AM
Authorized User
 
Join Date: Feb 2005
Posts: 91
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to ashokparchuri Send a message via Yahoo to ashokparchuri
Default

hi,

   You have to keep the connection string in <appsettings> tab..

   Just like the following example
<configuration>

 <appSettings>
        <add key="ConStr" value="XXXXXXXXXXXX"></add>
</appsettings>
<system.web>
</system.web>
</configuration>

    i thing the key value we are giving is case sensitive...So when You passing the value in .vb page be careful...

hope this helps-Ashok Parchuri





Similar Threads
Thread Thread Starter Forum Replies Last Post
Authentication and Authorization Using AD and SQL GailCG ASP.NET 2.0 Basics 0 November 25th, 2008 11:29 AM
SQL RS Custom Authentication and WSS paresh SQL Server 2000 0 August 3rd, 2005 09:34 AM
SQL authentication problems boucaner ADO.NET 7 February 11th, 2005 03:41 AM
Secure SQL Server authentication sal ASP.NET 1.x and 2.0 Application Design 3 October 17th, 2004 04:02 PM
SQL authentication is ASPX application saint SQL Server ASP 11 June 14th, 2003 04:19 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.