Friday, March 16, 2018

SQL Connection Validation


  1. SQL Server 2014
  2. SQL Server 2014 SP2
  3. Installed SQL Server 2014
    1. Arpit, Rick and Robert are SQL Server Admins
  4. Installed SQLServer 2014 SP2
  5. Configure CLMCRPOC2 SQL Server 2014 to accept incoming remote SQL connections
    1. IP address for CLMCRPOC2 = 10.220.126.188
  6. Open SQL Server Configuration Services
    1. Expand SQL Server Network Configuration
      1. Protocols for MSSQLSERVER and enable TCP/IP
  7. Create a blank file on your desktop name it SQLConnectionTest.udl
  8. Then open and test your connection.

No comments:

Streaming Data Processing: An Informational Guide for US Business Decision-Makers

Streaming Data Processing: An Informational Guide for US Business Decision-Makers Introduction to Streaming Data Processing Streamin...