dimanche 26 juin 2016

Database schema could not be retrieved for this connection

In my asp.net application, I have a SQL datasource this no longer able to connect from my PC. Everything is working fine with the connection when loading the website normally. But in development when trying to configure the datasource I get an error that "the Database schema could not be retrieved for this connection. Connection timeout expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgment..."

My connection string:

Data Source=Server;Initial Catalog=Databasename;User ID=user;Password=password

As a test, I setup a ODBC from my computer and it connects just fine. Any ideas why I cannot connect through visual studio? TIA

Update: I was able to access this connection no problem last week in visual studio. I have only one version of the web config. Event viewer does not show anything for this issue. I am using VS 2013 and SQL Server 2008 R2.

I increased the timeout value and now it gets connected but then throws the error "tcp provider the semaphore timeout period has expired"

Aucun commentaire:

Enregistrer un commentaire