I am installing SQL Server 2008. What accounts to use when installing SQL Server. I can choose between NT AUTHORITY NETWORK SERVICE and NT AUTHORITY SYSTEM. I am installing MS SQL Server 2008 R2 and I got to the window where I have to set the service accounts. I want to know the difference between NT AUTHORITY SYSTEM. May 06, 2010 The NTAUTHORITY SYSTEM account is used by Microsoft Update and by Microsoft SMS to apply service packs and hotfixes to a SQL Server 2005 installation. The NTAUTHORITY SYSTEM account is also used by the SQL Writer Service for third party backup using VSS. Question: and 'why sysadmin role has been granted. For example, if SQL Server has NT AUTHORITY SYSTEM as one of its logins, then you can use this account to login to SQL Server. However, you can’t use SQL Server Management Studio or sqlcmd to login to SQL Server using NT AUTHORITY SYSTEM.

PSExec tool gives you an option to run a remote process or an application using System account, if SYSTEM account has permission on that application. Although there are many more features that are For example, if SQL Server has NT AUTHORITY SYSTEM as one of its logins, then you can use this account to login to SQL Server. However, you can’t use SQL Server Management Studio or sqlcmd to login to SQL Server using NT AUTHORITY SYSTEM. Try it yourself! Casio Lk-270 Manual Pdf more.

However, PSExec gives you an opportunity to login to SQL Server using NT AUTHORITY SYSTEM. Once you download PSExec tool bundle from use command prompt and type following command: D: PSTools>psexec -i -s 'C: Program Files (x86) Microsoft SQL Server 100 Tools Binn VSShell Common7 IDE Ssms.exe' Here, –i allow the program to run so that it interacts with the desktop of the specified session on the remote system. If no session is specified the process runs in the console session. -s runs the process in SYSTEM account. The above command will launch SQL Server Management Studio and gives you a “Connect to Server” window and the User Name will be pre-populated with NT AUTHORITY SYSTEM. If NT AUTHORITY SYSTEM has a login authority to the server, you will be able to login to the SQL Server. Tafseer Ibn Kaseer In Urdu Translation here. If you do not use “–i” switch, you won’t be able to launch management studio!