Menu

Search

GlobalSCAPE Knowledge Base


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


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


Also In This Category


On a scale of 1-5, please rate the helpfulness of this article


Not Helpful
Very Helpful
Optionally provide private feedback to help us improve this article...

Thank you for your feedback!


Comments require login or registration.

Details
Last Modified: 8 Years Ago
Last Modified By: GlobalSCAPE 5
Type: HOWTO
Article not rated yet.
Article has been viewed 17K times.
Options
Find Similar