Wrox Programmer Forums
Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Databases 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 26th, 2003, 05:52 AM
Registered User
Join Date: Jun 2003
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL Server and IIS 6.0

I am having trouble accessing my MSDE instance that I have on Windows Server 2003 box.

The error message I get is :-

Exception Details: System.Data.SqlClient.SqlException: Login failed for user '[Domain]\[MachineName]$'.

I was initially getting an error that Network Service was could not log in. I fixed this by adding the NETWORK USER to the access list in MSDE and the required database. On doing this I now get the current error. I tried adding this user/machine account in the same way as all others that I had done but this does not work.

Does anyone know where there is a guide or instructions on how to use MSDE/SQL Server 2000 on Windows Server 2003/IIS 6.0 ?

Similar Threads
Thread Thread Starter Forum Replies Last Post
Visual studio.Net, IIS, and sql server anthonyij VS.NET 2002/2003 2 May 26th, 2006 04:37 AM
SQL Server error with VWD Expres & IIS bradnerdhss BOOK: Beginning ASP.NET 2.0 BOOK VB ISBN: 978-0-7645-8850-1; C# ISBN: 978-0-470-04258-8 1 January 30th, 2006 06:09 AM
ThePhile without SQL Server or IIS Malnad BOOK: ASP.NET Website Programming Problem-Design-Solution 5 January 12th, 2006 12:29 AM
IIS server, connection to offsite database server Hazzardusa Classic ASP Databases 1 August 14th, 2005 10:03 PM

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