Authentication mode selection...

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: DotNetJunkies User (User_at_-NOSPAM-DotNetJunkies.com)
Date: 08/03/04 

Date: Tue, 03 Aug 2004 11:26:57 -0700

In SQL Server 2000, Which authentication mode is more effecient and more secured? Is it Mixed mode or Windows mode.

How to implement Windows authentication mode at clients place.

If our application uses SQL authentication, and if the client uses Windows authentication, a run-time error will be generated. How to solve this error? 

---
Posted using Wimdows.net NntpNews Component - 
Post Made from http://www.DotNetJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.

Relevant Pages

  • RE: How to access SQL Server from a non-privileged domain account
    ... account to be able to access the SQL Server. ... Since your SQL Server 2005 has been running with Windows Authentication ... Contact your network administrator to add your domain account to the ... Change your SQL Server 2005 authentication mode to Mix mode so that you ...
    (microsoft.public.sqlserver.setup)
  • RE: Authentication in MSDE 2000
    ... "How to remove windows Authentication mode in MSDE ... SQL Server supports two authentication modes, one is Windows Authentication ... server roles assigned to a login, you can refer to these articles: ...
    (microsoft.public.sqlserver.msde)
  • Re: Install SQL server 2000 on XP SP2
    ... When the installer ask for the Services Accounts, ... and then the Authentication Mode to Windows Authentication ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server Authentication
    ... I'm using Windows authentication in most cases. ... When a user connects through a Microsoft Windows user account, ... This is the default authentication mode, ...
    (microsoft.public.sqlserver.clients)
  • Re: Cannot register SQL Server 2000SP3 from client computer
    ... Windows Authentication mode, Mixed mode, or SQL Server mode. ... >use the sql account sa to login. ...
    (microsoft.public.sqlserver.connect)