I got error: An existing connection was forcibly closed by the remote host!!
string connstr = "Provider=MSOLAP.3;Data Source=amsserver;Password=;User ID=administrator;Initial Catalog=MIP2ASProject";
Client in XP, with AS9.0 provider installed, server is sqlserver 2005 in win2003 xp1.
Both machines are not under domain controller...
Moving to SQL Server Analysis Services forum.|||Analysis Services does not support non-Windows authentication when connecting through TCP/IP.
You should be able to setup HTTP connectivity to SSAS.
See following:
http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx
And then use different type of authentication avaliable in IIS to connect to Analysis Server.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
No comments:
Post a Comment