User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 456,471 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,789 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 1369 | Replies: 2
Reply
Join Date: Nov 2007
Posts: 32
Reputation: Jihad is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 1
Jihad Jihad is offline Offline
Light Poster

How to change DB from windows authentication to Server authentication?

  #1  
Apr 25th, 2008
I am developing a website,where I am using windows authentication for my connection. I want to change that to server authentication. I want to know what are the steps needed, at what should I watch out, and is there any problems that will appear in my project due to this change in the connection type?
Thank you
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Nov 2007
Posts: 51
Reputation: Nige Ridd is an unknown quantity at this point 
Rep Power: 1
Solved Threads: 9
Nige Ridd Nige Ridd is offline Offline
Junior Poster in Training

Re: How to change DB from windows authentication to Server authentication?

  #2  
Apr 25th, 2008
In SQL Server Management Studio, connect to your server. Then right mouse click on the Server in on Object Explorer window and select Properties.
This should show a new dialog, and a 'Select a page' panel on the left - choose Security and the you should see the settings to change the Authentication mode.
As the option is SQL server and windows authentication - I can't see it affecting your existing work. Just be careful that things don't just work as it's you logged into windows!
Nige
Reply With Quote  
Join Date: Nov 2007
Posts: 32
Reputation: Jihad is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 1
Jihad Jihad is offline Offline
Light Poster

Re: How to change DB from windows authentication to Server authentication?

  #3  
Apr 26th, 2008
Thanks for the help Nige. Its that I am using windows auth in the connection string in my website. I want to change it to server auth, but in my server its windows server auth mode.
I can login as windows auth, but i cann't as server auth. I don't know how to make that database that I am working on be logged on as server auth, and how to get the admin pass if it ever existed to change it.
I have no experience in server security, I need a help to setup the server auth.I mean how to login if I dunno what the password ad username for the first time and where to change it.

Thank you
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

DaniWeb MS SQL Marketplace
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes

Similar Threads
Other Threads in the MS SQL Forum

All times are GMT -4. The time now is 2:29 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC