Solved

sql server connection - windows or sql server authentication

Posted on 2009-07-12
2
213 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
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Pivot not using aggregate yield error 3 41
sql query Help 12 52
Query Peformance + mulitple query plans 9 47
SQL Server Question 5 25
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
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 …
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now