Solved

MS SQL 2005 and XP Home

Posted on 2006-07-01
6
238 Views
Last Modified: 2012-06-27
Since I cannot instal SQL 2005 cleint in my XP Home notebook I cannot access my SQL 2005 server database. Is there an alternative?

0
Comment
Question by:robrodp
6 Comments
 
LVL 95

Accepted Solution

by:
Lee W, MVP earned 500 total points
ID: 17025203
Plenty of alternatives:
1. Export the data to an Excel file
2. Export the data to an Access file
3. Install a Virtual Machine system, install Server on the virtual machine, and install SQL on the virtual server.
4. Try using SQL Express if the database isn't too large.
0
 

Author Comment

by:robrodp
ID: 17025229
Mh....

I have no access to teh SQL server from my norebook. so 1 and 2 are out.

3. Chinese to me

4. Will SQL express sun in a XP Home system?
0
 
LVL 50

Expert Comment

by:Lowfatspread
ID: 17025301
Hi robrodp,
> SQL 2005 cleint
why can't you install the client tools?

Cheers!
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.

 

Author Comment

by:robrodp
ID: 17025322
SQL 2005 requires iis and home does not accept it
0
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 17025419
robrodp,
> SQL 2005 requires iis


Refer this to install IIS on the Home Edition
http://adamv.com/dev/articles/iis-on-xp-home


0
 
LVL 6

Expert Comment

by:so3
ID: 17026352
i think that sql server 2005 express works on Windows XP Home Edition SP2, so try to install  sp2

http://msdn2.microsoft.com/en-us/library/ms143680.aspx
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question