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 December 9th, 2004, 11:46 AM
Registered User
Join Date: Aug 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Help!!!! MSSQL will not connect

Do any of you gurus know what this problem is and know the fix.


I am getting the following error message

Connection failed to open.

System.Data.SqlClient.SqlException: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at ASP.sql_connection_aspx.Page_Load()

John T. Smith
Certified Residential Appraiser
P.O. Box 1647
Demorest, Georgia 30535
Phone:  678-936-2274   Fax:  678-868-1135

Email:  [email protected]

Please click on the link below to visit our website:
Old December 12th, 2004, 11:34 PM
Authorized User
Join Date: Dec 2004
Posts: 19
Thanks: 0
Thanked 0 Times in 0 Posts

looks like you are logged into a domain and the server you are trying to connect is not part of the domain. Go to the Primary Domain Controller and add the server you are trying to connect to and add it to the domain.


Similar Threads
Thread Thread Starter Forum Replies Last Post
Connecting to MSSQL-- All about it Chrisman ASP.NET 3.5 Basics 3 May 17th, 2008 03:23 AM
MSSQL 2005 and MSSQL 2000 tiredcat Visual Basic 2005 Basics 0 April 9th, 2007 12:56 AM
Connect to MSSQL without PHP Library echovue Pro PHP 0 April 2nd, 2007 07:19 PM
Connect to MSSQL 2005 express salemkoten SQL Server 2005 2 October 11th, 2006 04:46 AM
Connect to MSSQL using IP Address echovue PHP How-To 1 April 12th, 2006 03:15 AM

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