Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Changing back to Windows authentication Mode Problem

Status
Not open for further replies.

sanan

Technical User
Apr 15, 2004
139
IR
Hi Every Body
I just fixed my Problem of not being able to connect to my SQL server.
But at first I was using the Windows Authentication Mode,Then I changed to SQL and Then back to Windows, Which the Problem “Not being able to Connect” aroused.
Now my Question is how can I Change it back to Windows Mode?
I tried the Right Clicking the Sever and>Edit Server Registration>choosing the >Windows But no Success, Could it be because that in SQL Server Mode I deleted some of the users including the Guest and Admin “I think”?

Best Regards
Sanan
 
In Enterprise Manager, right click on the instance name, select Properties, click on the Security tab. That's where you make the change.

-SQLBill
 
Hi SQLBill
Thanks for reply
But I just find out about this from your Older rplies, which you explained in more details.
Best regards
Sanan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top