We have a custom application developed using Access 2003 but converted to 2007 which connects to database SQL server 2008 converted from 2005. Users are unable to connect via application and get the following error. Application uses ADO.NET to connect.
But when Network library configuration and enable TCP/IP protocol with servername and portno using SQL Server Network Utility setup (cliconfg), It works fine. We have about 150 users but it is complicated to do for each users.
Also users uses windows authentication to connect. They belong to one of the three Windows Active Directory groups which are given RW permission on the database side.
'Connection Failed' error.
SQL State 01000
ODBC SQL Server Driver: ConnectionOpen(Connect())
SQL State: '08001'
SQL Server Error: 17
[ODBC SQL Server Driver] [DBNETLIB] SQL Server does not exist or access denied.
connectionstring : "ODBC;DRIVER=SQL Server;SERVER=<<server>>;DATABASE=<<database>>;Trusted_Connection=Yes"
View Complete Post