Use windows authentication for all users server 2008

Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community.

It only takes a minute to sign up. Connect and share knowledge within a single location that is structured and easy to search. I have two computers running SQL Server Express: c01 and c02, I setup both for remote connection using windows authentication.

Worked fine for c02 but not for c Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. So, if you are logged-in to "remote" as "John," there must be a "John" user on the machine that is hosting SQL Server Express, and unless you are going to provide different credentials, it should have the same password, too.

I think you should be able to use the runas command to set up your connection in SSMS. Create a shortcut on your desktop or wherever , and set this as the target location:. Obviously, the account you're setting here will have to exist on the computer hosting SQL Server. This setup also works for domain users trying to connect to a SQL Server instance in another domain.

Try 'mixed authentication mode' and see if that helps. I've seen this error with the opposite configuration i. Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Figure8: Increase the validity period. Figure 9: Continue by accepting the default locations.

Figure Choose to add the Certificates snap-in. Figure Request a new certificate. Select the Domain Controller , and click Enroll. Then we generated the certificate. Eric Geier is a freelance tech writer. Hi Eric Geier, It's very useful. Your email address will not be published. Learn about the latest security threats, system optimization tricks, and the hottest new technologies in the industry. Over 1,, fellow IT Pros are already on-board, don't be left out!

TechGenix reaches millions of IT Professionals every month, and has set the standard for providing free technical content through its growing family of websites, empowering them with the answers and tools that are needed to set up, configure, maintain and enhance their networks.

You can change the login credentials and revoke access per user. If you use the Personal mode, everyone would login with the same static encryption key.

This mode provides better encryption key security. You also need a way to connect to the DB on public pages pre-authentication, and a way to connect the authentication to the Active Directory account, which will limit authentication mechanisms available to you.

Not being a regular PHP user myself, and not knowing how your AD environment relates to your EC2 web server instance, this is as far as I can take you. To use windows authentication for sql server, you don't specify user name and password. Instead, you change the connection string for integrated security, as in:. On top of that, you need to be understand the Windows user connection to the db in this situation is the IIS account running your site.

The Windows Authentication stuff you did would be a local intranet: all your users are part of a Windows domain, or have a trust with it. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Ask Question. Asked 9 years, 11 months ago. Active 11 months ago. Viewed 11k times. If I cancel the popup, it will show this error: - Unauthorized: Access is denied due to invalid credentials. Joel Coehoorn k gold badges silver badges bronze badges. Are you connecting from a windows platform or other? If I understand correctly, windows authentication works fine, its just that when an incorrect login is entered you can't handle that in your web app?

So basically the SQL Server connection is not an issue, it's getting your particular web development platform to catch and manage an incorrect login — Nick. Add a comment.