[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

Some pc's do not see the SQL server database.

Dear Experts,

I have the next problem: we have a program made in Delphi that's using SQL Server Express 2005. It's on a server with Windows 2003 SBS and the are four cliënts.
On two, the program works fine (Vista and XP Pro), the other two (Both XP Pro) don't see the
database.
While connecting the next error occurs:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

When I press the OK button, the program runs without data.
If I  try the tool SSEUTIL, I get the same results for the working and not working cliënts.
I set the Remote Connections in SQLserver to TCP/IP and Named pipes.
I compared settings like Services, Updates etc. of the working one's with the not working one's but I don't finds differences.
Is there anybody who can help me with this?
Thanks in advance
0
PeterSijm_ChristianeGiguere
Asked:
PeterSijm_ChristianeGiguere
  • 6
  • 4
1 Solution
 
Jon BrelieSystem ArchitectCommented:
Are you calling the server directly or using a DSN?

Can the systems that don't see SQL ping the SQL server by name?
0
 
PeterSijm_ChristianeGiguereAuthor Commented:
Yes all the cliënts can ping the server, everything works fine on all cliënts, like Exchange, Remote Desktop, accesing the server share, etc...  only two of them don't connect with SQL server.
0
 
Jon BrelieSystem ArchitectCommented:
Is everything on a domain or workgroup?
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
PeterSijm_ChristianeGiguereAuthor Commented:
It's in a doain
0
 
Jon BrelieSystem ArchitectCommented:
Does the working XP box have any ODBC DSNs that the other two don't?

Also, check your firewall settings on the two that cannot see sql:
http://support.microsoft.com/default.aspx/kb/841251
0
 
PeterSijm_ChristianeGiguereAuthor Commented:
I don't know how I can find if they have ODBC DSN's?

The link you send me was very interesting, I tried it but unfortunally it din't work.
I want to thank you very much for you support...
I can't react more today because it's 01:00 and I have to got up at 06:30 ;-(

Peter Sijm
0
 
Jon BrelieSystem ArchitectCommented:
Control Panel -> Administrative Tools -> Data Sources (ODBC)
Check the working XP system for any DSNs referencing your SQL Server.  If you find any, re-create them on the two non-functional boxes using the same settings.
0
 
PeterSijm_ChristianeGiguereAuthor Commented:
Thank you very much for your help, it might give the solution but on this
moment I can't reach the working XP machine, I think it's swiched off.
I'll call them tomorow to ask them to let it on for the weekend.
Thanks again
Peter Sijm
0
 
PeterSijm_ChristianeGiguereAuthor Commented:
Dear Enphyniti,

Your tip brought me on the right track, finnaly it was the personal firewall of
Norman, I did't know it was installed.
Thank you vvery much for you help

Peter Sijm
0
 
PeterSijm_ChristianeGiguereAuthor Commented:
Thanks...
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now