Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MS SQL 2005 and XP Home

Posted on 2006-07-01
6
Medium Priority
?
245 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 96

Accepted Solution

by:
Lee W, MVP earned 1500 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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 

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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

783 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