Solved

MS SQL 2005 and XP Home

Posted on 2006-07-01
6
239 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 96

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
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

 

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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Percentage Formula 7 33
Moving away from Access 2003 adp files 4 48
mssql 7 32
Generate list for insert to sql list 44 9
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
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
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

751 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