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'"