Networks

General discussion

SQL: Windows Authentication

What type of security level must a user have to gain access to a SQL database through Windows Authentication? It seems to only work for me if I assign a user Admin access, and I don't see any built in groups for SQL.

All Comments

There are now 2 kinds of authentication, Windows Authentication (which does default to Administrators only if you don't change it) and SQL Authentication, which is the old fashioned SQL method with local SQL accounts.

So, you need to check how your SQL Server is configured. Open Enterprise Manager, expand the groups until your SQL Server is listed, then right-click the Server and choose Properties.

Click the Security tab. In the top Security section, is it selected for Windows Only, or "SQL Server and Windows"? The default install method is Windows Authentication only. So, if you want to make local SQL accounts on the SQL server for SQL Authentication, make sure "SQL Server and Windows" is selected.

Start or search

Create a new discussion

If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.

Post type

Subject title

Topic Tags

Select up to 3 tags (1 tag required)

Cloud

Piracy

Security

Apple

Microsoft

IT Employment

Google

Open Source

Mobility

Social Enterprise

Community

Smartphones

Operating Systems

Windows

Mac

Malware

Tablets

Networking

Browser

Hardware

Software

Web Developerment

Linux

Off Topic

Message Body

Track this discussion and email me when there are updates

Please note: Do not post advertisements, offensive material, profanity, or personal attacks. Please remember to be considerate of other members. If you're new to the TechRepublic Forums, please read our TechRepublic Forums FAQ. All submitted content is subject to our Terms Of Use.