Post reply

use frim user sa instead of windows authentication

  • December 4, 2014 at 1:34 pm

    #292598

    hi

    i use from sql server 2008.

    for execute it i must select "windows authentication"

    how can i change it which that run with user sa

    thanks

  • December 4, 2014 at 1:50 pm

    #1762816

    To enable SQL Server authentication, if that is your question, right-click the server-node in Object Explorer, select Properties, go to the Securities page. You need to restart the server for the setting to take effect.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

  • December 11, 2014 at 11:40 pm

    #1764279

    Hi,

    In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.

    On the Security page, under Server authentication, select the new server authentication mode, and then click OK.

    In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.

    In Object Explorer, right-click your server, and then click Restart. If SQL Server Agent is running, it must also be restarted.

    ##Taken from msdn

    Regards

    Shafat Husain

    Regards,
    Shafat Husain
    🙂
    And Your Lord Never Forgets...!! (64:19 -- Quran)

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

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