Skip to end of banner
Go to start of banner

Testing Connections to DS Cloud Server

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 19 Next »

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

Prerequisites & Setup

  • ⚒️ Validate your server/computer’s IP address.

  • Ask DataSelf support to verify which IP address are is whitelisted by the appropriate DataSelf server(s)

  • Verify you have the right DataSelf server name. For example dw3.dataself.com,1433

  • Get the password for ConnectionTest from DataSelf.

Connection & Credentials Info

Server Name: dw3.dataself.com,1433

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

Data Base: TestConnection#1

In Pictures: How to Test Connections to DataSelf with SSMS

Open Microsoft SQL Server Management Studio (SSMS).

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

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

Test Connections to DataSelf Server with Excel

See Testing Connections to DS Cloud Server with Excel to test your connection using Excel rather than SSMS.

Usage

ETL+ is not able to connect to DW3 even though the client’s server is whitelisted and supposedly their firewall is down.  To test connecting use TestConnection#1 to connect to the Metadata on DW3. 

  • In one instance It didn’t work for the customer because they were still blocked by something, but it did work locally. 

Keys: Firewall, fire wall, white list

  • No labels