C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Reviews   Communities   Interview   Jobs   Projects   Training   Your Ad Here    
Silverlight Games | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Polls | Revenue Sharing | Lobby | Gift Shop |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...






Forums » .NET » SQL Server »

conversion of windows authentication to sql server login


Posted Date: 20 Aug 2008      Posted By: ankita      Member Level: Bronze     Points: 1   Responses: 3



I have sql server 2005 management studio and when it connects it coneect through windows authnetication I want to know that without uninstalling sql server how Can I change my login from windows authentication to sql server authentication.




Responses

Author: avtar    21 Aug 2008Member Level: GoldRating: 2 out of 52 out of 5     Points: 3

Try Out..

1. Open sql server 2005 management studio
2. Unregister/disconnect sqlserver(s)
3. Connect/Register ...this time use sqlserver authetication for same.



Author: Sriram    21 Aug 2008Member Level: GoldRating: 2 out of 52 out of 5     Points: 2

open sql server click unregister u r connection and click new registration select sql server authentication mode
give user name and password



Author: Ramdas Singh Baghel    21 Aug 2008Member Level: GoldRating: 2 out of 52 out of 5     Points: 0

You must take more study on SQL Server.


Post Reply

 This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.


Next : DTS Package
Previous : Query Suggestion
Return to Discussion Forum
Post New Message
Category: SQL Server

Related Messages



dotNet Slackers

About Us    Contact Us    Privacy Policy    Terms Of Use