Solved

sql server connection - windows or sql server authentication

Posted on 2009-07-12
2
218 Views
Last Modified: 2012-05-07
I am trying to work out whether I should use windows or sql server authentication.

I have an access front end application that is connecting to sql server via odbc.

sql server authentication may be the easiest as when new windows users are created, they will not need to be setup in sql server. However, I am concerned abot having a hard coded userid and password.

What would other developers recommend - sql or windows authentication ?
0
Comment
Question by:dkmarsh
[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
2 Comments
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 500 total points
ID: 24837275
>> sql server authentication may be the easiest as when new windows users are created, they will not need to be setup in sql server. However, I am concerned abot having a hard coded userid and password.

If you have new users coming in, then its better to use a SQL user login for your application.
Kindly make sure that the particular user is not sa and grant only the privileges required for that particular user.

>> What would other developers recommend - sql or windows authentication ?

If all the users for that particular application are part of your domain, then windows authentication is preferred, otherwise SQL authentication is preferred in this scenario.
0
 
LVL 15

Expert Comment

by:rob_farley
ID: 24837652
I prefer Windows Authentication. Grant access to an Active Directory group, and then make sure that new users get put into that group.

Then you don't have a hard-coded password, and you can easily control access through AD accounts.

Rob
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

632 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