Post reply

Problem Connecting To SQL Server Express With Microsoft SQL Server 2008 Data Mining Add-ins

  • February 13, 2011 at 6:49 pm

    #231290

    Hi all,

    Running SQL Server Express 2008 R2, MS Office Pro 2010 (32 Bit)

    I downloaded and installed Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office

    When I attempt to create a connection through the Data Mining Add-In (DMAI), I receive this error:

    Test Connection failed.

    A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running

    No connection could be made because the target machine actively refused it 127.0.0.1:2382

    I pasted the name of the server into DMAI from SSMS

    I can login using Windows Authentication through SSMS - no problem

    I checked in services - SQL Browser service is automatic and started

    Any other ideas what may be wrong?

    Thanks

    w

  • February 14, 2011 at 3:26 am

    #1286356

    Hi to use the data mining add-in you need to run analysis services that is not in supported by SQL express edition.

    Here you can find more info:http://msdn.microsoft.com/en-us/library/ms365248.aspx.

  • February 14, 2011 at 7:06 am

    #1286454

    Thanks Claudio,

    I appreciate your assistance

    Kind regards,

    w

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply