none
Cannot connect to SQL Server 2008 Express

    Question

  • I install SQL Server 2008 Express on Windows 7 and make sure SQL Server(SQLEXPRESS) service is running. Then I write a program via Visual C++ & ADO, and try to connect to the local SQL Service instance by using the following SQL connection string:

    “Provider=sqloledb;Data Source=(local);Integrated Security=SSPI;”

    But the connection fails. I try the same code on a computer with SQL Server 2008 Professional installed and it works without problems.

    Please advise. Thanks.

    Wednesday, March 05, 2014 2:41 PM

All replies