?
Solved

SQL 2008 authentication: safe to change from Windows to mixed mode ?

Posted on 2013-01-14
6
Medium Priority
?
543 Views
Last Modified: 2013-01-14
I have been asked to use an existing SQL 2008 server for a new database for a new client-server app. Currently, SQL authentication on this SQL server is Windows and it is being used for a production line-of-business app. However, the new app requires mixed mode authentication. I know how to change from Windows to mixed authentication. However, is it safe to do this? Are there likely to be any implications for the original app?
0
Comment
Question by:askrabbit
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
6 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 38774008
there is no implications for the original app.
the implication is only security for the database, as all the non-windows logins will be able to be used.
you may consider installing a dedicated instance for this app, if it's a small one ...
0
 
LVL 2

Author Comment

by:askrabbit
ID: 38774063
Is it possible to create an sa-type SQL login which only has superuser rights on the new database? Would this be easier than giving the implementation team for the new app the sa credentials?
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 38774070
logins with sa power (sysadmin server role) have permissions on all databases.
you can create a normal login with no special server roles and make it db_owner (full power) on that database, the login will not be able to do anything on the other databases.
0
Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
LVL 2

Author Comment

by:askrabbit
ID: 38774089
Re normal login with no special server roles, making it db_owner - OK.

Re "all the non-windows logins will be able to be used" - if the new app implementation team had neither the sa credentials nor a Windows account with admin rights over SQL, would this be an issue?
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 38774199
no
0
 
LVL 2

Author Closing Comment

by:askrabbit
ID: 38774224
Thanks for your speedy responses!
0

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Resolving an irritating Remote Desktop connection that stops your saved credentials from being used.
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question