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.