SQL Server Blog

Reading large SQL Server error log files

February 27th, 2011

SQL Server error logs can grow quite large due to an issue or from infrequent cycling of the log file. If these log files get to large then you are not able to read the contents either through SSMS or a file editor. This blog takes you through how to read the log using xp_readerrorlog.

Read More

Test connection failed because of an error initializing provider

February 20th, 2011

Test connection failed because of an error initializing provider [DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not exist or access denied. This message is not very meaningful and is hard to investigate. In this blog I take you through a scenario of how to identify and fix this issue.

Read More
Blog

Hi, I'm Warwick Rudd, I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting.
In my blog I will look at all things SQL Server as well as some things outside of the SQL Server relm but hopefully you will find them helpful and interesting.

Search