Error Connecting to Sql Server when running Data Warehouse Import Wizard
If you ever find that you are having a problem with the Data Warehouse Import Wizard saving and connecting to the Sql Server 2005 database, it could be because the TCP/IP protocols are disabled.
If you want to use Datawarehouse with the following versions of Sql Server 2005, you have to make sure that you have the TCP/IP configuration enabled.
- Sql Server 2005 Developer edition
- Sql Server 2005 Evaluation
It is recommended that you use Sql Server 2005 Enterprise or Standard edition with the Data Warehouse for enterprise deployment.
Take a look at: http://msdn2.microsoft.com/en-us/library/ms190198.aspx for more information.
Hope this helps!
-Alan
