It is very appreciated if someone can help me on this problem:
I have 2 machines, connected with workgroup (not domain machine), 1 is win2003 sp1, 1 is xp.
How can I connect SSAS from XP machine with windows authentication
Looks the Native client fix the windows authentication with local user name.
When I connect from XP, my application with following codes:
string connstr = "Provider=MSOLAP.3;Data Source=amsserver;Password=accenture;User ID=administrator;Initial Catalog=MIP2ASProject";
AdomdConnection objConnection = new AdomdConnection();
// Assign the connection string and try to
//open a connection.
objConnection.ConnectionString = connstr;
objConnection.Open();
It give me this error:
An existing connection was forcibly closed by the remote host
An existing connection was forcibly closed by the remote host
Quicker
What version of ADOM.NET are you using
Try downloading and installing "Microsoft ADOMD.NET " from http://www.microsoft.com/downloads/details.aspx familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
wicked_mk
it is an antivirus problem
uninstall antivirus and try again
what antivirus do you have
RickK
Hi Edward,
Yes, I have installed oledb AS9 provider.
If you think SSAS only support windows authentication which must use inside the domain, I really couldn't understand why oledbconnection works fine with same connection string
I am not sure about whether impersonation belong to windows authentication, but, my testing prove that oledb can connect in this way, adomd can't.
BTW, thankful if anyone can let me know how to enable SSAS's anonymous connection
Jerry
Sai Shyam
First of all, you dont need the User ID and Password in the connection string if you are connecting using TCP/IP (you would use them only when connecting with HTTP using Basic auth).
Second, in order to use "Provider=MSOLAP.3" you will need to install "Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider" provider from http://www.microsoft.com/downloads/details.aspx familyid=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.