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.
Are you got any error message/information while connect to SQL Server express instance faild via VC++ & ADO? If so, please post them for further investigation.
Please also check the windows firewall. Firewall systems help prevent unauthorized access to computer resources. If a firewall is turned on but not correctly configured, attempts to connect to SQL Server might be blocked. For more information, please see:
TechNet Community Support