Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Excerpt
nameTes

Testing connections to DataSelf Cloud Servers databases using Microsoft SSMS or Excel.

To test using Microsoft SQL Server Management Studio (SSMS) see the instructions below.
To test using Microsoft Excel see Testing Connections to DS Cloud Server with Excel.

For more information see also Why Connections to DataSelf Server Fail.

Excerpt
hiddentrue
nameInternal_Note_Top

ConnectionTest– Dummy DB to Test Connection to DS Cloud from a Customer Server

⚒️ To test a connection to DW3 from a customer’s box using SSMS or /wiki/spaces/TeckKB/pages/1793130512 use the dummy database (TestConnection#1) with a dummy user on DW3 that only has read rights for that dummy database. 

...

Connection & Credentials Info

Server

...

Names:

dw3.dataself.com,1433
dw2.dataself.com

Credentials:
Login (User): ConnectionTest
Password: Ask DataSelf support for the password.

...

Excerpt
hiddentrue
nameInternal_Note

ConnectionTest TestConnection#1

  • LastPass entry for user name & password: DW3 ConnectionTest

...

Enter Server name, select Authentication type, enter Login & Password. Finally click Options.

Enter TestConntion#1.

Successful connection to TestConnection#1 DB.

⚒️ Step by Step: How to Run a Connection Test

...

Panel
panelIconId2dc2a70d-2a35-4aa9-958c-9cc84c79f62b
panelIcon:note2:
panelIconText:note2:
bgColor#DEEBFF

  • There should be one table in TestConnection#1 named TestTable. TestTable has one column and one row.

...