Microsoft Visio cannot connect to a Microsoft SQL Server

Asked By 20 points N/A Posted on -
qa-featured

Hi,

Recently, I just tried to connect Microsoft Visio 2013 to a Microsoft SQL Server but an error message displayed and the access is denied. I tried to connect this using different ways as I can but there was nothing to fix this problem. I am looking for an expert’s advice so provide a proper solution so that I may fix this issue. Any idea would be greatly appreciated. Thanks in advance.

Microsoft Visio

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

SHARE
Answered By 0 points N/A #174273

Microsoft Visio cannot connect to a Microsoft SQL Server

qa-featured

Hi Ricky, 

I believe your problem lies primarily with the configuration of your connection to the instance. There are two methods to solve this.

1. You could launch SQL Browser using SQL Server Configuration Manager. Connect to the instance using servernameinstancename.

2. You could also try to verify the TCP/IP protocols using servername as 

tcp:servernameinstancename, portnumber

For NamedPipe, use np:servernameinstancename

Login/Register to Answer

Related Questions