Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

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?
0
2addietoo
Asked:
2addietoo
  • 9
  • 7
1 Solution
 
jonnietexasCommented:
You don't need to be a member of a domain to access a database.  Any SQL Server Client should be able to do this.  You could try creating an odbc connection and connect to it from Access, for instance.  Once the ODBC is created you choose file open and choose the ODBC that you created.  Or you can use SQL Server Management studio and login with the 'sa' account.
0
 
2addietooAuthor Commented:
can this be done even if the pc does not see the server?   If please tell me the steps
0
 
jonnietexasCommented:
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.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
2addietooAuthor Commented:
Also the application is an excell form that is used to update the sql database
0
 
2addietooAuthor Commented:
I cannot ping the server from the PC, but I can ping the pc from the server
0
 
jonnietexasCommented:
You'll just need to configure your transport (ODBC, etc.)
0
 
jonnietexasCommented:
Firewalls?  Norton Internet Security, McAfee Security?
0
 
jonnietexasCommented:
They would be on the server.
0
 
2addietooAuthor Commented:
no Norton, no McAfee,  where do I look for firewall info
0
 
2addietooAuthor Commented:
>You'll just need to configure your transport (ODBC, etc.)
on which machine the PC or the server and please give steps
0
 
jonnietexasCommented:
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
0
 
jonnietexasCommented:
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.  
0
 
jonnietexasCommented:
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.
0
 
2addietooAuthor Commented:
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
0
 
2addietooAuthor Commented:
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
0
 
jonnietexasCommented:
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.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 9
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now