RSS Forums RSS
Please support our ASP.NET advertiser: Lunarpages ASP Web Hosting

SQL not a trusted connection?!

Join Date: Feb 2002
Location: New York
Posts: 862
Reputation: Tekmaven is a glorious beacon of light Tekmaven is a glorious beacon of light Tekmaven is a glorious beacon of light Tekmaven is a glorious beacon of light Tekmaven is a glorious beacon of light 
Rep Power: 12
Solved Threads: 15
Moderator
Tekmaven's Avatar
Tekmaven Tekmaven is offline Offline
The C# Man, Myth, Legend

Re: SQL not a trusted connection?!

  #4  
Jun 20th, 2004
"Server=.;Database=sladesfaculty;User ID=username;Password=password"

^ Should work fine. Also, you need to make sure your SQL Server is set for SQL Server Authentication (and not just Windows Authentication). Just because you've made SQL Server Authentication usernames and passwords doesn't mean its set properly.

In SQL Server Enterprise Manager, right click on your server, and go to properties. On the "Security" tab, make sure the "SQL Server and Windows" radio button is selected.

FYI, the "." is a shortcut for localhost in an SQL Server connection string .
-Ryan Hoffman

ASP.NET Specialist / Webmaster, Extended64.com.
Please do not email or PM me with support questions. Please direct them to the forums instead.
Reply With Quote  
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 8:46 pm.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC