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.
Server Principal Name (SPN) errors can cause you large amounts of time to find and fix. In this blog I work through 1 particular issue that you may come across when trying to connect remotely through SSMS using kerberos.
SQL Server 2005 SP4 RTM was made available on December-17-2010. If you want to stay up to date with your..
Do you have SQL Server Reporting Services 2008 and you need to keep track of who has access to the different Report Folder Structures and the permissions they have for those folders? Read on and I will show you how you can keep on top of this.
SQL Server 2005 SP4 CTP was made available in November 2010. If you want to stay up to date with..
Whether you are a Team Leader or Department Manager in a large multi-national organisation or from a small IT business,..
SQL Server 2008 SP2 was made available in September 2010. If you want to stay up to date with your..
SQL Server 2008 SP1 was made available in August 2009. If you want to stay up to date with your..
I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting. When I am not working with the SQL Server Stack I like to get away to the Snow and spend time Snowboarding.