rovider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server
Hi, I have installed and reinstalled express sql 2005 with success but I am getting above error when I run on my asp.net 2.0 project. The Express SQL 2005 is residing on my local machine. My connection string is:
Data Source=(local)\SQLEXPRESS;Initial Catalog=xxx;User Id=xuser;Password=password; Trusted_Connection=True
I have visited many times the "SQL Configuration Manager" and "Surface Area Configuration for Services and Connections" with following the instructions I browsed through EE's knowledge database but still without success.
Can someone help me please?
MySQL ServerMicrosoft SQL ServerMicrosoft SQL Server 2005