locked
Enable Server Proxy Account RRS feed

  • Question

  • In some of our Machines we are not installing the Management Studio. In a machine where Management Studio is not there how to do Enable Server Proxy Account.

    Or is there any way to Invoke Server properties window through a Exe / command prompt.

    --

    Best Regards,

    R.Janakiraman

    Friday, November 26, 2010 7:41 AM

Answers

All replies

  • sp_configureDisplays or changes global configuration settings for the current server

    http://msdn.microsoft.com/en-us/library/ms188787.aspx

     


    Vishal Gajjar MCITP.DBA \ MCITP.DatabaseDeveloper
    Friday, November 26, 2010 8:48 AM
  • Also you can open SSMS on some other instance and connect to this instance (which does not have SSMS) to make the changes


    Pradeep Adiga
    My blog: http://www.sqldbadiaries.com

    Recent posts on my blog
    Friday, November 26, 2010 9:09 AM
  • Hi,

    Once you login to SSMS and right click the server and go to properties and click the Security tab

    or

    Run the below script

    USE [master]
    GO
    CREATE CREDENTIAL [##xp_cmdshell_proxy_account##] WITH IDENTITY = N'aaa', SECRET = N'password'
    GO


    Thiru - MS SQL World Regards, RM Thirunavukkarasu MCP, MCITP, ITIL V3 | "http://thiruna.blog.com" |Click "Propose As Answer" if solution is helpful to you.
    • Proposed as answer by WeiLin Qiao Tuesday, November 30, 2010 10:49 AM
    Friday, November 26, 2010 10:17 AM
  • Hi ,

     

    To enable this option, we could use the sqlcmd, here is a sample:

     

    sqlcmd -s server_name -e -q "USE [master]CREATE CREDENTIAL [##xp_cmdshell_proxy_account##] WITH IDENTITY = N'server_name\proxy_name', SECRET = N'password'"

     

    Please refer to the below links:

    http://msdn.microsoft.com/en-us/library/ms162773.aspx sqlcmd utility

    http://msdn.microsoft.com/en-us/library/ms189522.aspx CREATE CREDENTIAL

     

    Please feel free to ask if you have any questions.

     

    Thanks,
    Weilin Qiao

    • Marked as answer by WeiLin Qiao Wednesday, December 8, 2010 8:43 AM
    Tuesday, November 30, 2010 10:47 AM