Microsoft Visio cannot connect to a Microsoft SQL Server

Asked By Ricky B Barboza 20 points N/A Posted on - 09/23/2013

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.

• Status: Open
• Question Views: 1259
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Works

Answered By Ramirez Saltsman 0 points N/A #174273

Microsoft Visio cannot connect to a Microsoft SQL Server

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

• Vote Up 0 Vote Down

• Posted on - 09/25/2013
• Question Category: MS Works