?
Solved

SQL Express and Windows XP Home working with SBS foundation

Posted on 2010-11-25
1
Medium Priority
?
443 Views
Last Modified: 2012-05-10
Hi,
I have been tasked to deploy an SBS (probablly foundation) box on a very limited budget.

The office in question currently has around 1 Windows Vista Business, 1 Windows 7 Business, 5 Win XP pro machines, and 5 XP home machines (don't ask!)

The XP home machines are getting on a bit and probably need replacing in the next year or so, but for the meantime I need to connect them to the SBS foundation box, mainly to see an SQL express server, Internet and perhaps also for documents, no other access to the server will be required for these clients.

I have found some scripts on the internet, which seem to be legal and allow you to map a drive to connect to the domain: one example here, http://www.experts-exchange.com/Networking/Microsoft_Network/Q_20926306.html 

Is it possible to see an SQL express server when you are not 'officially' connected to the domain, could there be any other reprecussions of trying to dupe XP home into thinking its allow in?
0
Comment
Question by:Ripla5
[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
1 Comment
 
LVL 10

Accepted Solution

by:
james-ct16 earned 2000 total points
ID: 34212317
Howdy
Connecting to SQL Express will not be an issue from non domain machines although you will have to use SQL Server authentication for these clients. So you will have to enable this as from memory under latest installs the default is Windows Authentication only. eg http://support.webecs.com/KB/a374/how-do-i-configure-sql-server-express-to-enable-mixed.aspx

You will then need to enable remote access on SQL Express eg http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/

Hope that helps

James
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

800 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