ASP Is Fun

Learning ASP
Free Course
Basics
Functions
SQL Commands
Sample Code


Servers / Setup
Host Reviews
Server Setup
Error Tips


Contract ASP
Development

Search For:


Intro to ASP


 


MSSQL Error - Not associated with a trusted SQL Server connection



When you're setting up a new MS-SQL connection, you might get the following error:

Not associated with a trusted SQL Server connection

What this means is that you have a logon that was defined in MSSQL - but you also have MSSQL set to only use Windows logon accounts.

To fix this, load up the SQL management tool. Expand out the SQL Server Group. When you click on SQL Server Group in the left window, it'll show an entry in the right window. Click on that and get its properties. Under "security", set authentication to allow SQL Server logins.
SQL Command Listing for ASP



Bookmark this site so you can reference it any time you have ASP questions in the future!




ASP Main Page | ASP Ebooks | Free ASP Course | Contact Lisa
All content copyright © 2012 Minerva WebWorks LLC. All rights reserved.

French Wedding


Free Newsletter!

Ebooks
Intro to ASP
ASP SQL DB
Members
Shopping


Introduction to ASP

Romance Tips
Irish Romance
Italian Romance
French Romance

ASP Poll
How do you handle 500 errors?
I don't
Page does nothing
Displays error
Emails error