How to connect Microsoft Visio 2013 to a Microsoft SQL Server LocalDB instance

If you connect Microsoft Visio 2013 to a Microsoft SQL Server LocalDb instance by using the standard (localdb)\V11.0 instance name, you might get the error:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

 

image

 

To fix this error use the following instance name: np:\\.\pipe\LOCALDB#92FE49CE\tsql\query

The number in bold can be found in the Microsoft SQL Server Management Studio 2012 Server Properties dialog, when connected to the (localdb)\V11.0 instance:

 

image

Solving: Microsoft Office 2010 does not support upgrading from a prerelease version of Microsoft Office 2010

After removing Microsoft Office 2010 beta 1 from my system I could install Microsoft Office 2010 RTM but not Microsoft Visio 2010 RTM or the SharePoint Designer 2010.

The setup errors:

Setup is unable to proceed due to the following error(s):

Microsoft Office 2010 does not support upgrading from a prerelease version of Microsoft Office 2010. You must first uninstall any prerelease versions of Microsoft Office 2010 products and associated technologies. Crrect the issue(s) listed above and re-run setup.

 

clip_image002

 

Solution