How do I create a user on SQL Server 2008 for EFT Server?


THE INFORMATION IN THIS ARTICLE APPLIES TO:

  • EFT Server, version 6.3 and later

QUESTION

How do I create a user on SQL Server 2008 for EFT Server?

ANSWER

To add a user to SQL Express 2008 you can use the following two commands. 

In this example, "WIN-P0\testuser" is the user. If it's local you can drop the system name and just use "testuser"

osql -E -S localhost\GLOBALSCAPE -Q "sp_grantlogin 'WIN-P0\testuser'"

osql -E -S localhost\GLOBALSCAPE -Q "sp_addsrvrolemember @loginame='WIN-P0\testuser', @rolename='sysadmin'"