search

KarthikElumalai / ETokenSln

E-Token is an online queue management system which reduces waiting time on queue, by providing live update about queue status in electronic gadgets.
https://docs.google.com/document/d/17VGdqFPdmcJriHd8aXy-ymutrQ4LejnVDnfiH8N8hms/edit
10 stars 6 forks source link

Create Azure SQL DB #8

Closed nilanjansen closed 5 years ago

nilanjansen commented 5 years ago

Create a SQL SERVER db in azure which will consumed by the EToken App. Give access to the local IP to connect to the db.

KarthikElumalai commented 5 years ago

Perfect.

nilanjansen commented 5 years ago
  1. Go to SQL Server ver. XX.
  2. Enter etoken.database.windows.net in the server name
  3. Select SQL Authentication
  4. Username: ETokenAdmin
  5. Password: EToken@123
  6. Click on Connect.
nilanjansen commented 5 years ago

### Guys Please share you IP's so that I can give you Access for this DB.

nilanjansen commented 5 years ago

Connection String

Server=tcp:etoken.database.windows.net,1433;Initial Catalog=ETokenMaster;Persist Security Info=False;User ID={your_username};Password={your_password};MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;

nilanjansen commented 5 years ago

Checked in the connection string and updated the database. Token is getting generated. Please check everyone

image

KarthikElumalai commented 5 years ago

yeah i can also generate a token at live site.

My Token no:

image

Its really good to see that.

Thanks @nilanjansen

KarthikElumalai commented 5 years ago

Hi Team,

Closing this task, since Azure Sql db has been created

Kindly let me know if any feedbacks

Thanks