Hi @Rubin, Avi ,
What driver/provider you are using?
Please edit your post and add a source code for connectivity to a DB.
You can always use a *.udl file to troubleshoot the connectivity.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi all,
i'm using C# code to read from DB using sql 2008 R2.
sometimes the connection is valid and for random time it seems that the connection is failed, although the username and password didn't changed.
I try to install again but no luck.
i have 3 of the same computers, with the same windows version and HW and it happened only in one computer.
what should I do to get to the root of this? it is clear that is not username\password error.
Hi @Rubin, Avi ,
What driver/provider you are using?
Please edit your post and add a source code for connectivity to a DB.
You can always use a *.udl file to troubleshoot the connectivity.
Check in the SQL Server errorlog for messages relating to these login failures. In later error versions of SQL Server there is an actual error message, but it may be that in SQL 2008 R2, there is only the state., but you can use this page to get reason and an explanation that particular state.
For further assistance, it helps to know
Hi @Rubin, Avi ,
Please share us the information that others mentioned above. We need more message about the error 18456 for analysis. Connenction error 18456 is a genaral connection error message.
In addition, whether your network is stable , due to the issue is occurred randomly? SQL server 2008 R2 is too old , it is out of support for a long time. What is version of your SQL server ? Did you apply the SP3 for SQL server 2008 R2?
If the response is helpful, please click "Accept Answer" and upvote it, thank you.