•
•
•
•
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
![]() |
•
•
Join Date: Nov 2007
Posts: 32
Reputation:
Rep Power: 2
Solved Threads: 1
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
Thank you
•
•
Join Date: Nov 2007
Posts: 51
Reputation:
Rep Power: 1
Solved Threads: 9
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
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
•
•
Join Date: Nov 2007
Posts: 32
Reputation:
Rep Power: 2
Solved Threads: 1
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
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
![]() |
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
antivirus apple browser computer crack daniweb dell desktop development doubleclick france gartner google hoax install internet leopard linux mac merger microsoft mobile news novell office open operating operating system os photo pirate red hat research root safari security server software source sp1 system ubuntu unix upgrade vista windows windows update windows vista xp yahoo
- Regarding Database-Reply early-Urgent (Visual Basic 4 / 5 / 6)
- Unable to connect a 2003 server to a 2000 Domain (Windows NT / 2000 / XP / 2003)
- Active Directory based Intranet web application problems (ASP.NET)
- Error in creating ODBC connection."Reason: Not assosiated with a trusted SQL Server" (ASP)
- Cannot edit the sql server from windows authentication to sql server authtentication (MS SQL)
- Why app is looking for "Default.aspx" (ASP.NET)
- Can't get samba to work! (*nix Software)
- Windows to Linux Migration (Getting Started and Choosing a Distro)
- Forms Authorization/ Authentication using asp .net and vb .net (ASP.NET)
- Create Windows Authentication (VB.NET)
Other Threads in the MS SQL Forum
- Previous Thread: where can i type the command?
- Next Thread: Sql for xml explicit - help needed!


Linear Mode