Friday, February 24, 2012

Error in connect to SQL Sever

I have a problem with the connection to the DB…

I wrote this connection string in the web.config

<addname="dbConnectionString"connectionString="server=(local);database=2C2M;Trusted_connection = True"providerName="System.Data.SqlClient"/>But then when I creat ( SQLdataSource ) and chose this connection , this message is appeared

DataBase schema could not be retrieved for this connection . Please make sure the connection setting are correct and that the database is online. An error has occurred while establishing a connection to the sever . When connection to SQL Server 2005 , this failure may be caused by the fact that under the default setting SQL Server does not allow remote connections. ( provider : Named Pipes provider , error : 40 – Could not open connection toSQL Server )

How I can solve this problem ?

Note : I use SQL EXRESS SERVER

you need to change the connection string then try it, in order to get the well formed connection string do the following:

on your desktop create a new text document and change its extension to .udl

No comments:

Post a Comment