Cannot Connect to SQL Data Source
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.
James
Microsoft SQL Server Login Error Message:
Connection Failed:
SQLState: '01000'
SQL Server Error: 10055
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Connectio
Connection Failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC Sql Server Driver][DBNETLIB]SQL Server does not exist or access denied.
James
Microsoft SQL Server Login Error Message:
Connection Failed:
SQLState: '01000'
SQL Server Error: 10055
[Microsoft][ODBC SQL Server Driver][DBNETLIB]Connectio
Connection Failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC Sql Server Driver][DBNETLIB]SQL Server does not exist or access denied.
ahmed_sabe
your problem seem to be permission
ASKER
I'm not sure I follow. If I can connect with the same user and password on another machine, shouldn't I be able to do that on this one, too?
ok make sure of this
1- you can ping your sql server from this pc
2- try to ping the pc from sql server
feed back
1- you can ping your sql server from this pc
2- try to ping the pc from sql server
feed back
ASKER
I can ping both ways with no problem. The server is a Win SBS 2003 R2 which has my exchange stuff and it is all working fine.
your problem was the same problem when you install sp2 vista,
ok
go to this links it will help you
http://support.microsoft.com/?kbid=888228
http://support.microsoft.com/default.aspx?scid=kb;[LN];318432
ok
go to this links it will help you
http://support.microsoft.com/?kbid=888228
http://support.microsoft.com/default.aspx?scid=kb;[LN];318432
ASKER
I'm still digging through the two support links you gave, but I do have a question... it looks like these two solutions are needed when SQL is in a cluster environment. Well, I don't have any clusters. Do they still apply?
Also, I have started up another Win 7 machine and am having the same problem on that one too. Again, all XP machines are doing fine and now I have two Win 7 Pro (one 64 bit and one 32 bit) that are having the same problem...
Also, I have started up another Win 7 machine and am having the same problem on that one too. Again, all XP machines are doing fine and now I have two Win 7 Pro (one 64 bit and one 32 bit) that are having the same problem...
the problem you face is started from windows vista till 7 with sql 2005, xp not face this problem with sql 2005, vice versa vista and 7 not facing any problem with sql 2008, microsoft recommended that you upgrade to sql 2008 when you have vista and 7, but you didnt want that, you use this link
http://support.microsoft.com/default.aspx?scid=kb;[LN];318432
it more helpful in this situation
http://support.microsoft.com/default.aspx?scid=kb;[LN];318432
it more helpful in this situation
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.