While installing SCCM 2012 I came across one more error as Could
not connect or execute SQL query as shown below hence tried to Google for the
solutions to rectify the same .
If many instances are running on sql server they try to run
on port 1433 for specific IP hence it is better to turn off Listen All but the changes
which would matter here are protocols for instance under IP All settings through configuration manager
on SQL server should have 1433 listed and listen all setting to be given as NO.
Specifying the port number is the key here, clear all the dynamic ports number
and don’t forget to restart the SQL services once changes are made.
No comments:
Post a Comment