Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SMS 2.0 unable to connect to SQL server for reports
- Thread starter oneworld
- Start date
Check to see if the Info Aps service is running on your site server. Until we installed SMS 2.0 Service Pack 1, this service (which is required) was not starting up by itself (even though it was set to Automatic). We had to manually start it (and it sometimes took a couple of tries). Again, you will not be able to run Crystal Reports unless this service is running.
- Thread starter
- #3
If you are using Crystal Reports that ships with SMS (I'm assuming you are) make sure the Crystal services have started. It was very common for these services to time out starting up. SMS crystal reports doesn't use SQL authenication (if I remember correctly) it uses the WBEM. Try using the WBEM connectivity tool and test your connection.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question