How to connect to an SQL server
OK, I have managed to recover a PC running XP from removing it from a domain to a workstation.
I need to connect the said PC to a server but keep all of the PC settings and data intact. I only want to get to the SQL server that is located on the server (MS server2003)
How can I do this without loosing the PC again?
I need to connect the said PC to a server but keep all of the PC settings and data intact. I only want to get to the SQL server that is located on the server (MS server2003)
How can I do this without loosing the PC again?
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
It depends on what you mean by "see". You should be able to ping the server. You don't need to have file and printer sharing access to it or see it in the browse list.
ASKER
Also the application is an excell form that is used to update the sql database
ASKER
I cannot ping the server from the PC, but I can ping the pc from the server
You'll just need to configure your transport (ODBC, etc.)
Firewalls? Norton Internet Security, McAfee Security?
They would be on the server.
ASKER
no Norton, no McAfee, where do I look for firewall info
ASKER
>You'll just need to configure your transport (ODBC, etc.)
on which machine the PC or the server and please give steps
on which machine the PC or the server and please give steps
The Windows Firewall isn't on by default. Are you sure that your SQL Server processes are running? Are you connecting the PC and server by a switch or is there a router in between them? Turn off the firewall on the client computer
we need to get to a ping before we can configure the transport. Then it will depend on the form in Excel that you are using.
I'm about to head out. Right now this is a connection issue. Perhaps someone else can pick this up. I'll check in again when I get to the house.
ASKER
I will have to leave the site in 10 mins as they are closing...I will came back tomorrow....This is very important...Thanks To ALL
Addie
Addie
ASKER
Hello everyone...This just seems to keep going...How do I configure my transport ODBC?
If the physical computer box is running Server 2003, does the OS have to be configured for DNS or any of that stuff...I just want to connect pcs to this box to access the SQL database from an excel form? There are only 4 PCs and one database box
Addie
If the physical computer box is running Server 2003, does the OS have to be configured for DNS or any of that stuff...I just want to connect pcs to this box to access the SQL database from an excel form? There are only 4 PCs and one database box
Addie
Sorry it's been so long. I had to go out of town. You configure odbc in the administrative tools on each workstation. It will be able to work with Netbios broadcasts (windows networking) but DNS is always a good idea.
ASKER