Solved

SQL 2012 Error

Posted on 2013-06-08
4
320 Views
Last Modified: 2013-07-01
Hi All,

we have a problem with a clients server, basically they are running 2012 essentials with SQL 2012 - we have the database running and working on the server ok but the SQL string doesn't appear to let me client machines connection to it.

The errors is:-

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

SQL String Used:-

Provider=SQLOLEDB;Server=SERVERNAME\SQLEXPRESS;Database=customer;Trusted_Connection=yes;

We have tried turning off the firewall with no luck.

any ideas?

thanks again
0
Comment
Question by:ryank85
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 22

Expert Comment

by:Haresh Nikumbh
ID: 39231844
Have you gone through below link, its apply for SQL 2008 but it same for SQL 2012 too

http://skamie.wordpress.com/2012/01/16/sql-server-connectivity-error-sql-server-does-not-exist-or-access-denied/
0
 
LVL 31

Accepted Solution

by:
James Murrell earned 500 total points
ID: 39235621
1st place for connections strings is http://www.connectionstrings.com/sql-server-2012

on there trusted connection is
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

Open in new window

0
 

Author Comment

by:ryank85
ID: 39235869
Hi all. We managed to fix this. The SQL Browser service was disabled, we started this and everything started to work. Thanks for your help.

Ryan
0
 
LVL 31

Expert Comment

by:James Murrell
ID: 39235897
great news please close question
0

Featured Post

Optimum High-Definition Video Viewing and Control

The ATEN VM0404HA 4x4 4K HDMI Matrix Switch supports 4K resolutions of UHD (3840 x 2160) and DCI (4096 x 2160) with refresh rates of 30 Hz (4:4:4) and 60 Hz (4:2:0). It is ideal for applications where the routing of 4K digital signals is required.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question