Search

GlobalSCAPE Knowledge Base

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

Karla Marsh
EFT Express (SMB) & Enterprise

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

Details
Last Modified: 8 Years Ago
Last Modified By: GlobalSCAPE 5
Type: HOWTO
Article not rated yet.
Article has been viewed 17K times.
Options
Also In This Category
Tags