Solved

SQL Express and Windows XP Home working with SBS foundation

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

A quick step-by-step overview of installing and configuring Carbonite Server Backup.
When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

776 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