Category Archives: SQL

Windows Service Accounts and Permissions for SQL Server (2016)

Posted on June 28, 2015 by livestreak

There is a great article on MSDN covering Windows Service Accounts and Permissions for SQL Server. https://msdn.microsoft.com/en-us/library/ms143504.aspx Couple of key points include: Always use SQL Server tools such as SQL Server Configuration Manager to change the account used by the … Continue reading →

Posted in SQL | Leave a comment

Running SSMS as an alternate user or from a PC not connected to the Domain

Posted on February 11, 2011 by livestreak

From Pinaki’s Tech Zone and CB-Net and many other sites RUNAS /netonly /user:DOMAIN\Account “C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe” The problem is, we have to create many  script files like this to use the software. Fortunately, there is a easier way. Download … Continue reading →

Posted in SQL | Tagged , | Leave a comment