ryank85
asked on
SQL 2012 Error
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=S ERVERNAME\ SQLEXPRESS ;Database= customer;T rusted_Con nection=ye s;
We have tried turning off the firewall with no luck.
any ideas?
thanks again
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=S
We have tried turning off the firewall with no luck.
any ideas?
thanks again
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
Ryan
great news please close question
http://skamie.wordpress.com/2012/01/16/sql-server-connectivity-error-sql-server-does-not-exist-or-access-denied/