• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 448
  • Last Modified:

SQL Express and Windows XP Home working with SBS foundation

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
Ripla5
Asked:
Ripla5
1 Solution
 
james-ct16Commented:
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now