Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 449
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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