Post reply

How To Setup Windows Authentication

  • August 24, 2012 at 1:42 pm

    #260994

    Dear Expert DBA's

    I have installed SQL Server 2008 on Windows Server 2008 (not using Domain)

    and Chosen windows authentication.

    and I have installed SSMS on Windows 7.

    I want to connect to SQL Server from windows 7

    How I configure windows 7/Server 2008 to allow me connect to SQL Server

    using windows authentication

    I can connect through SA Login

    Thanks in Advance

    SQLKHAN

  • August 24, 2012 at 5:32 pm

    #1530005

    In Management Studio:

    1. Expand the "Security" folder underneath your server.

    2. Right-click on the "Logins" folder, select "New Login..."

    3. In the New Login window, add your Windows Logon name, with the domain name (like Domain\Logon).

    4. Make sure the the "Windows Authentication" option is selected.

    5. If you want to be a sysadmin, then select the "Server Roles" page and select that server role.

    6. Click OK and you're ready to go.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • August 25, 2012 at 9:55 am

    #1530060

    Barry - the server is not on a domain, therefore you cannot add a domain user to SQL Server and authenticate.

    For Windows Authentication to work in a WORKGROUP - you have to manage it by adding the users to both machines.

    For example, UserA on the Windows 7 machine would have an account like: win7\UserA. Add a new local user on the SQL Server machine as UserA with the same password as the user on win7\UserA. Add the new local user to SQL Server (sql\UserA).

    The user on the windows 7 box should now be able to connect to SQL Server. Of course, when the password is changed on the windows 7 bos - someone has to change it on the SQL Server box to match.

    Jeffrey Williams
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster
    Managing Transaction Logs

  • August 25, 2012 at 12:43 pm

    #1530069

    Thank You Very Much for sharing precious knowledge

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply