Solved

MS SQL 2005 and XP Home

Posted on 2006-07-01
6
236 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
migration MS SQL database to Oracle 30 61
Query Help - MSSQL - Averages 5 27
How to search for strings inside db views 4 28
Proper Case SQL Command 2 10
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

809 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