none
SQLCLI service not registered on the local machine error

    Question

  • Hi,

    With reference to the above title, I am trying to connect an SQL Server 2008 Express instance which came along with Visual Studio 2010 Ultimate from my C# app. My connection string is:

    Provider= SQLNCLI;Server=host\SQLEXPRESS;Database=database;

    When I try connecting with the above connection string, it says:

    SQLNCLI provider not registered on the local machine

    followed by my connection string.

    What am I supposed to do to solve this issue?

    Thank You in advance for your reply.

    Regards,

    Clifford

    Sunday, September 05, 2010 1:14 PM

Answers

  • Hi Vinu,

    Thank You for your quick reply.

    I guess I found a way out for my issue without installing the files that you just suggested.

    I changed my connection string to:

    Provider=SQLNCLI10;Server=HOST\SQLEXPRESS;Database=Database;UID=UID;PWD=PWD;Integrated Security=SSPI;

    The above connection string worked just fine for me, after changing the SQL Server EXPRESS instance properties to 'Use the following username and password'.

    Thank You for your reply. I really appreciate it.

    Regards,

    Clifford

    Monday, September 06, 2010 4:08 AM

All replies