I am trying to connect to a sql 2k database using a Microsoft Application block. I get the following error. It is saying about 2005, I verified that SQL 2K is running on the server.
System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings
Any help will be appreciated.
Hi,
1. Verify the firewall have open the port of SQL 2K,
2. the Service pack versión I have some problems with versions under sp4
greetings.
|||Hi jijo_robert,
That's a common issue. If you perform a search through google for the error message you are getting, you will find many valuable solutions.
The first thing for you to do is to check your connection string, make sure you have used the correct server name, database name , authentication mode,,.etc
If you still cannot figure it out, open up your query analyzer and connect to your database manually, see if you can login this way(there is a possibility that there maybe some problem in the server side)
Hope my suggestion helps
|||I could connect using sql query analyzer. I can also connect during design time (Gridview --> SQLDatasource --> and see the records with a connection string) but when I run it it gives this error.|||Make sure that you don't have any other program using the database other than Visual Web Developer if that is what u're using, or having the connection open. What mostly cause this kind of problem is when you have your database open in the database explorer of your VWD or VS.Hope this works.Please give me the appropriate make if this works for this is my first post on the forums|||
No other program is using SQL server databsae
No comments:
Post a Comment