Solved

SQL Express and Windows XP Home working with SBS foundation

Posted on 2010-11-25
1
441 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 500 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
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.

688 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