IN2BI, Microsoft Business Intelligence
data, stories & insights
rss | email | twitter

Category: 'SQL Server 2012'

  • wo
    dec 13

    Run as Different User

    As a consultant I often need to run a program as a different user. For future reference I collected the information about RunAs in this article.

    In Windows 7 en Windows Server 2008R2 you can run an application as a different user  by holding down the shift key and right clicking the application shortcut.


    To use this functionality in windows 8 you need some extra steps to configure it. These steps are described by Taylor Gibb in: How to Run Windows 8 Apps as a Different User from the Start Screen

    Another option is to use the ShellRunAs utility that is provided by the Windows Sysinternals website. If you install this utility you can right-click on a shortcut and select “Start as different user”.

    Runas Command

    You can also use the runas command line tool from a command prompt or in a .bat file as in these examples:

    %windir%\System32\runas.exe /netonly /user:domain\username "C:\Program Files\Microsoft SQL Server\110\Tools\Binn\VSShell\Common7\IDE\Ssms.exe”

    This will prompt you for the password of “domain\user” and open Sql Server Management Studio. The \netonly parameter means that the provided identity will be used only with a remote resource the remote site will authenticate you as 'domain\username'.

    As an alternative, first ask for the user name and use the input in the runas command:

    set /P user="Type the domain\username: "
    %windir%\System32\runas.exe /netonly /user:%user% "C:\Program Files\Microsoft SQL Server\110\Tools\Binn\VSShell\Common7\IDE\Ssms.exe”

  • ma
    okt 11

    SQL Server 2012 (Denali)

    Microsoft made significant Business Intelligence investments in SQL Server since 2000.

    The next (2012) release will also include many new BI features. In the next posts I will explore some of these features. This post will act as an overview of / index to these articles:

    • …..