Solved

MS SQL 2005 and XP Home

Posted on 2006-07-01
6
234 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 Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

 

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 Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Powershell SMO script not working. 18 101
SQL server 2008 SP4 29 34
Change part of a string 2 24
SQL JOIN + SUBQUERY? 3 14
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.
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

759 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now