.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> Others >> Post New QuestionBookmark and Share Subscribe to Forum

About MS SqlServer 2005

Posted By: Vikramraj     Posted Date: February 10, 2011    Points:2   Category :Others
Installed MS SQl Sever 2005 on windows Server 2003. While installation by default it took Local System. But after it installed i want to create SqlServer Authentication mode with user 'sa' how its possible?

Responses
Author: kamlesh             
Posted Date: February 10, 2011     Points: 5   

Hi..

Simply u choose while connecting below The Server Name their is option..

Authentication: SQL Server Authentication

thanks
Kamlesh Nikam

Thanks And Regards.
Kamlesh Nikam
Author: Narayanan             
Posted Date: July 28, 2011     Points: 20   

http://msdn.microsoft.com/en-us/library/ms144284.aspx

Regards, Lakshmi Naraayanan.S
http://dotnettechrocks.blogspot.in/
Author: Ravi Ranjan Kumar             
Posted Date: July 30, 2011     Points: 20   

There is option of Choosing Authentication Mode while opening SQL server. you can change it.


Thanks & Regards
Ravi Ranjan Kumar
http://raviranjankr.wordpress.com
Author: Ravi Ranjan Kumar             
Posted Date: July 30, 2011     Points: 20   

In addition to my previous answer you can also try the given link which will help you how to Enable Mixed Mode Authentication After Installation of MSDE
http://www.arcomit.co.uk/support/kb.aspx?kbid=000002

Thanks & Regards
Ravi Ranjan Kumar
http://raviranjankr.wordpress.com


Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend