We have a church management piece of software called Shelby. It runs off of a SQL database. I have about 15 PCs (all running Win XP Pro) onsite with workstation installs of the software that talks to this DB. Through cliconfg I have the protocols NamePipes and TCP/IP enabled. Well, now I'm on my first Win 7 Pro 64 bit machine and cannot talk to this DB. I've gone as far as manually trying to connect to the DB through the ODBC Data Source Administrator. When I do this, I get the error listed at the bottom of this post. I can successfully make this manual connection on any other machine. I have tried killing firewalls and A/V, and with it all off, I still cannot make the connection. Don't know where to go next. Thanks for any help that can be provided.
Microsoft SQL Server Login Error Message:
SQL Server Error: 10055
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).
SQL Server Error: 17
[Microsoft][ODBC Sql Server Driver][DBNETLIB]SQL Server does not exist or access denied.