Wrox Programmer Forums
|
ASP.NET 1.x and 2.0 Application Design Application design with ASP.NET 1.0, 1.1, and 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.x and 2.0 Application Design 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 December 17th, 2003, 11:31 AM
Authorized User
 
Join Date: Jun 2003
Posts: 54
Thanks: 0
Thanked 0 Times in 0 Posts
Default Connecting to SQL Database

I'm getting the following message when I try to connect to a SQL database in my ASP.net program.

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

Does anyone know why this is happening?

Thanks

Renee C. Walker
__________________
Renee C. Walker
 
Old December 17th, 2003, 12:49 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 540
Thanks: 0
Thanked 4 Times in 4 Posts
Default

Do you have "Anonymous" access allowed in IIS. If you are using Windows Security, you will need to uncheck this.

Or you will have to give the IUSR_MachineName account access to your database.

J
 
Old December 17th, 2003, 12:52 PM
Authorized User
 
Join Date: Jun 2003
Posts: 54
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Okay, thanks.

Renee C. Walker
 
Old December 17th, 2003, 02:19 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,110
Thanks: 0
Thanked 3 Times in 3 Posts
Default

How did you set up your SQL Server? with sql authentication or mixed mode?






Similar Threads
Thread Thread Starter Forum Replies Last Post
connecting to a sql 2005 express database twisted f8 Visual Basic 2005 Basics 1 September 13th, 2007 09:49 PM
Connecting to SQL database ashes0000 VB Databases Basics 11 April 20th, 2007 08:37 AM
Connecting to SQL database misskaos Classic ASP Databases 8 October 23rd, 2006 05:57 PM
Connecting to SQL 2000 Database - New at this Tee88 Classic ASP Databases 14 October 2nd, 2004 04:23 AM
Connecting to sql database w/ asp Calibus SQL Server ASP 7 July 8th, 2004 08:37 AM





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