I have some difficulties in setting up a new SQL Server database for the Microsoft forecaster. Whenever I use the database setup wizard that comes along with the Forecaster program I get an error message that no connection with the server could be established.
What I cannot understand is that I can actually successfully test a connection between the Forecaster and the SQL Server when opening the demo application of the Forecaster program.
I installed the Forecaster on a VPC with the standard Dynamics AX features setup. I use SQL Server 2008 R2 and cannot identify any error in the setup.
Hope anybody can help me.