SQL Server access problem
-
Hi I am running my database on a shared 3rd party server. Recently, when I try to connect to the DB from my website, Asp.net gives me the following error: "SQL Server does not exist or access denied." [SqlException: SQL Server does not exist or access denied.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 MyCompany.WebModules.Data.DbObject.RunProcedure(String storedProcName, IDataParameter[] parameters, String tableName) ..... .... For instance, this morning the website was working fine, but now suddenly, I am getting the above error. The same problem happened on other days, as well. Do you think, there is a problem with my code, or is this SQL Server problem?
-
Hi I am running my database on a shared 3rd party server. Recently, when I try to connect to the DB from my website, Asp.net gives me the following error: "SQL Server does not exist or access denied." [SqlException: SQL Server does not exist or access denied.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 MyCompany.WebModules.Data.DbObject.RunProcedure(String storedProcName, IDataParameter[] parameters, String tableName) ..... .... For instance, this morning the website was working fine, but now suddenly, I am getting the above error. The same problem happened on other days, as well. Do you think, there is a problem with my code, or is this SQL Server problem?
Hi hasanali00 Did you try pinging the server when you got the error message in order to confirm that there were no connectivity issues? Also place code so that yuo can catch the exception where it is being thrown and output the error message. That way you will be more clear on the part of code is throwing the exception and what the error message is saying.
Thanks and Regards, Aby
-
Hi I am running my database on a shared 3rd party server. Recently, when I try to connect to the DB from my website, Asp.net gives me the following error: "SQL Server does not exist or access denied." [SqlException: SQL Server does not exist or access denied.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 MyCompany.WebModules.Data.DbObject.RunProcedure(String storedProcName, IDataParameter[] parameters, String tableName) ..... .... For instance, this morning the website was working fine, but now suddenly, I am getting the above error. The same problem happened on other days, as well. Do you think, there is a problem with my code, or is this SQL Server problem?
the problem was that the log file was full: run this command to delete the log: dump transaction DATABASE_NAME with no_log