Re: type of authentication in SQL

[_Venu]

New Message on dotNET User Group Hyd type of authentication in SQL Reply   Reply to Sender   Recommend Message 2 in Discussion From: _Venu This question is two-fold. If the question regarding setting the authentication modes while installing SQL Server, its two modes. 1) Windows authentication mode(allows only windows user/pwd) 2) Mixed Mode (allows either Windows user/pwd or SQL login user/pwd).   If the question regarding connecting to SQL Server after installation, then again its two modes 1) Widows authentication and 2) SQL Server authentication. In the later case you would need to supply with a username/pwd created in SQL Server.   For more information refer: http://msdn.microsoft.com/library/en-us/instsql/in_runsetup_6p9v.asp http://msdn.microsoft.com/library/en-us/adminsql/ad_security_47u6.asp   and refer this if you need to connect to SQL Server from ASP http://support.microsoft.com/default.aspx?scid=kb;en-us;247931   Until unless required specifically, better use Windows authentication.   Shd you have any questions, write me back.   -Venu   View other groups in this category. Also on MSN: Start Chatting | Listen to Music | House & Home | Try Online Dating | Daily Horoscopes To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. Need help? If you've forgotten your password, please go to Passport Member Services. For other questions or feedback, go to our Contact Us page. If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. Remove my e-mail address from dotNET User Group Hyd.