- Product Manual
- Introduction
- SMS technology
- Installation Guide
- Prerequisites
- Download Information
- Installation Steps
- GSM Modem Setup
- Service Provider Connections
- Users and applications
- Standard user
- SMPP user
- SMS from or to database
- MSSQL
- SQL Express
- Connection problem
- Create user
- SQL Server 2005 remote connection
- MSSQL Server 2008 Connection
- MSSQL Server 2012/2014 Connection
- International characters
- MySQL
- Oracle
- Sybase SQL Anywhere
- PostgreSQL
- Pervasive SQL
- Date Format Strings
- Scheduled SMS
- SQL templates
- Informix
- Access
- Video
- Connection string builder
- Keywords
- MS SQL high speed
- Oracle High Speed
- SQL statements
- Polling technology
- Dynamic Keywords
- Dynamic SMPP parameters
- Autoreply SMS from database
- Autoreply SMS using a script
- Simple autoreply SMS
- SMS from/to file
- SMS through E-mail
- SMS via HTTP Request
- SMS via colour protocol
- Application starter SMS
- SMS Voting
- SMS from MS Outlook
- SMS from/to FTP server
- PDF Request in SMS
- SMS to WCF service
- SMS Forwarder
- RSS to SMS
- Linux
- User Guide
- Developers Guide
- Examples and Solutions
- Appendix
- SMS FAQ
- Feature list
- Commercial Information
- Search
Ozeki NG SMS Gateway
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.
- In SQL Server Management Studio, open Object Explorer and expand the folder of the server instance in which to create the new login.
- Right-click the Security folder, point to New, and then click Login.
- On the General page, enter a name for the new login in the Login name box.
- Select SQL Server Authentication. Windows Authentication is the more secure option.
- Enter a password for the login.
- Select the password policy options that should be applied to the new login. In general, enforcing password policy is the more secure option.
- 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]' ; GOMore information