Ozeki NG SMS Gateway logo OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"

OZEKI NG SMS Gateway - Product Guide

Connection problem Contents | SearchSQL Server 2005 remote connection

Home > Product Manual > Installation Guide > Users and applications > SMS from or to database > MSSQL > Create user


Contact Us!
If you wish to get further information, do not hesitate to contact us!

E-mail: info@ozekisms.com

If you have a technical question, please submit a support request on-line.

How to create a user in MS SQL that can be used by Ozeki NG

To create a SQL Server login that uses SQL Server Authentication (SQL Server Management Studio) follow these steps.

  1. In SQL Server Management Studio, open Object Explorer and expand the folder of the server instance in which to create the new login.
  2. Right-click the Security folder, point to New, and then click Login.
  3. On the General page, enter a name for the new login in the Login name box.
  4. Select SQL Server Authentication. Windows Authentication is the more secure option.
  5. Enter a password for the login.
  6. Select the password policy options that should be applied to the new login. In general, enforcing password policy is the more secure option.
  7. Click OK.

To create a SQL Server login that uses SQL Server Authentication (Transact-SQL) In Query Editor, enter the following SQL command:

CREATE LOGIN [login name] WITH PASSWORD = '[password]' ; GO

More information

Next page: SQL Server 2005 remote connection