SQL connection issue with window Xp SP2

[Lisana]

Hello, Here is the problem I have, is there anyone know how to slove it? I have a Window XP SP2 machine with Microsoft SQL 2005, All my database are in this machine. I have an application is installing in another Window XP SP2 machine and in the same network. I cannot get access to the database from the second machine using my application. When I run the application, it says [DBNETLIB][ConnectionOpen(connect()).] SQL Server does not exit or access denied. I know there is a firewall issue in the window xp sp2, I have already open the port 1433 in the server machine, but it still cannot connect. I very apperiate your help. Lisa

[Colin Angus Mackay]

If I remember correctly, SQL Server 2005 is locked down and can only communicate with processes on the local machine. You have to turn on TCP/IP communications. I don't have SQL Server 2005 in front of me right now, and I don't remember the exact steps.

---

"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog

[Lisana]

will you please link some how to slove this kind problem articles for me? Thanks. Lisa

[Jerry Hammond]

Colin is absolutely correct (as always), 2005 is locked down by default. For a solution to your problem point your browser here for a solution.[^] Pictures of the menu available at the drive-thru