When connection with excel (or proclarity) we are getting an error when browsing for the server
The first error is 'An error was encountered in the transport layer', when we click ok en give it a second try the error changes into 'Erros in the OLE DB provider. Could not connect to the redirector. Ensure that the SQLBrowser service is running on the 'xxx' server.'
I've installed a developper sql on my local machine, so i'm quite sure that the the most recent files are installed. I've even reinstalled the OLE DB driver for SSAS 9.0, as i found as a suggestion in another post.
The SqlServer browser service is running on the server, but the server is running as a default instance a SQL2000 (only db) and as a named instance a SQL2005 enterprise edition.
When using the Management studio i'm able to login to the ssas with my user authentication.
Any suggestions ...
Try installing SQL Server 2005 SP1 CTP from http://www.microsoft.com/sql/ctp_sp1.mspx
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
No comments:
Post a Comment