SOI Installation fails because the connection to SQL Server is unavailable.
book
Article ID: 70731
calendar_today
Updated On:
Products
CA Service Operations Insight (SOI)
Issue/Introduction
The installation of SOI does not finish when the connection to the SQL Server is unavailable.
Resolution
Here is an easy method to test connectivity to a remote SQL Server without having any SQL Server Utilities installed:
- Create a file with extension .udl on the system where you want to install SOI. For example...test.udl
- Double-click on this file in explorer and you will get the Properties Window:
- Here you can enter the SQL Server name, user and password ( SOI uses sa ) and select the master database.
- Click to test the connection.
Feedback
thumb_up
Yes
thumb_down
No