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