DavidOverton.com
This site is my way to share my views and general business and IT information with you about Microsoft, IT solutions for ISVs, technologists and businesses, large and small.  
David Overton's Blog » Two more SQL 2005 to SQL 2008 issues fixed - Provider=SQLNCLI – Provider cannot be found error and Property Owner is not available for database
Two more SQL 2005 to SQL 2008 issues fixed - Provider=SQLNCLI – Provider cannot be found error and Property Owner is not available for database

So these are really quick snippets.  I hit an error where my Gateway monitoring software could not connect to the database.  All the errors were along the lines of “Provider cannot be found” and when I looked in the Connection String it stated “Provider=SQLNCLI” which is the SQL Native Client connector software.

The fix that worked for me was very simple, to change the “Provider=SQLNCLI …..” to “Provider=SQLNCLI10 …..”.

 

The second issue was nothing that came about from the SQL 2005 to SQL 2008 conversion, but became an issue when I could not see the properties for the database.  The error I would see was that “Property Owner is not available for database”.  The fix can be found here - http://blog.dampee.be/post/2008/06/22/MSSQL-2005-error-message-quot3bProperty-Owner-is-not-available-for-Database-databaseNamequot3b.aspx.

 

ttfn

David

Posted Wed, Dec 10 2008 8:24 AM by David Overton
Filed under: , , , ,

Comments

Mike wrote re: Two more SQL 2005 to SQL 2008 issues fixed - Provider=SQLNCLI – Provider cannot be found error and Property Owner is not available for database
on Thu, Apr 2 2009 11:16 AM

Hi Daivd, Just a quick cheers for posting this fix. Have you had any similar problems on Windows 7?

Damiaan wrote re: Two more SQL 2005 to SQL 2008 issues fixed - Provider=SQLNCLI – Provider cannot be found error and Property Owner is not available for database
on Tue, Aug 11 2009 12:19 PM

Hi David, glad my blog post fixed your problem.

mark wrote re: Two more SQL 2005 to SQL 2008 issues fixed - Provider=SQLNCLI – Provider cannot be found error and Property Owner is not available for database
on Thu, May 13 2010 9:03 PM

Thank you so much for posting this. This fixed my issue aswell.

Add a Comment

(required)
(optional)
(required)
Remember Me?

(c)David Overton 2006-23