SQL SERVER – Fix Connection Error – [Microsoft][ODBC SQL Server Driver][DBNETLIB][ConnectionOpen(Connect())

As a part of my quick consultancy, I was contacted by a client who was having trouble where the application was not able to connect to SQL Server. We all joined the call and desktop sharing to learn more about the issue. We looked into the application and found that the SQL connection from the client application were constantly failing with the following connection error:

[Microsoft][ODBC SQL Server Driver][DBNETLIB][ConnectionOpen(Connect())

Read More

SQL Server – Understanding Connection Timeouts and Query Timeouts

Have you ever got into a situation wherein you feel you see something and work for a solution in a completely opposite direction? Recently I was out of the country for a session and at the breakfast table I found a dark red bottle of ketchup which I used for my sandwich. Lesser did I know it was actually a spicy sauce. And on closer look this time, I found the mistake I did and how I ruined my whole breakfast. These are times when you oversee something which looks like one and you land up as something completely different. This blog post we will be Understanding Connection Timeouts and Query Timeouts.

Read More

SQL SERVER – FIX: Could not connect because the maximum number of 1 user connections has already been reached

Sometimes making a change in something for which the impact is not known, could cause a heavy loss. A similar situation happened when one of my clients called me and told that he is in big trouble and losing a lot of money every minute. Without wasting any moment, I asked what is the issue, then he told that he changed some setting in SQL Server, restarted SQL and now no one is able to connect. The application is completely down! Let us see how we can fix the error: Could not connect because the maximum number of ‘1’ user connections has already been reached.

Read More

SQL SERVER – Patch Upgrade – Failed to connect to server. Error: 0x80070422

One of my recent interaction with a client was to assist in performing Upgrade the SQL Server 2008 R2 with service pack 2. As usual, I asked for setup logs from C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\ folder. There were multiple folders so I asked the one which corresponds to the time of failure. Let us see exposure how we can solve error Error: 0x80070422.

Read More

SQL SERVER – FIX Error 18456, Severity: 14, State: 6. Login failed for user

One of the blog which I wrote earlier was also on Login failed for user with state 58. Let us see how to FIX Error 18456.

After reading that blog, one of the blog reader contacted me and told that she is getting state 6. I thought this error are very common and is important to demystify some of the reasons for the same. I have asked completed error message to assist him. Here is the message she shared:

Error: 18456, Severity: 14, State: 6.

Read More
Menu