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.

  • Answer Accepted: No
  • Question Category:
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

About Ramirez Saltsman
Questions
0
Answers
13
Best Answers
0
  • Posted on -
  • Question Category:

Lingoes Start data service failed to open

Previous

Discovery Exception been occurred when generate interfaces

Next

Related Questions