Asp.net
Closed
Hello,
how do connect to sqlserver in asp.net.?? this erroe is showing ( A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
so please reactify it...please tell me how can i solve it...
and one more thing in my sql , server explorer its not showing??please tell me why?? and how can i get it .??
how do connect to sqlserver in asp.net.?? this erroe is showing ( A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
so please reactify it...please tell me how can i solve it...
and one more thing in my sql , server explorer its not showing??please tell me why?? and how can i get it .??
2 responses
cyril8727
Posts
24
Registration date
Monday July 21, 2008
Status
Member
Last seen
July 20, 2009
1
Jul 20, 2009 at 12:45 PM
Jul 20, 2009 at 12:45 PM
Make sure that your connection string is valid.
It is usually of the form:
Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DATABASENAME;Data Source=LOGININFO
It is usually of the form:
Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DATABASENAME;Data Source=LOGININFO
