Solved

Connect a Windows 8 computer to a SQL on a Windows XP computer

Posted on 2014-04-29
2
121 Views
Last Modified: 2014-11-25
Whenever I try to launch an application that is based on SQL (which is installed on a Windows XP computer), from my XP computer, it works fine. When I launch the application from my other networked computers that are Windows XP OS, it also works fine. However, when I launch it from a Windows 8 computer, it gives me trouble connecting to the SQL,
0
Comment
Question by:Moshe Singer
2 Comments
 
LVL 40

Accepted Solution

by:
Jacques Bourgeois (James Burger) earned 500 total points
ID: 40030418
By default, Windows 8 does not use the same type of authentication as older versions of Windows.

Because of its greater dependence on a web connection, users log into windows 8 with a Windows Live username and password. This type of authentication is not recognized by SQL Server when a connection is set to Windows authentication.

There are 4 ways to go, and not is really interesting. That is one of the reasons Windows 8 is a flop in the enterprise.

Change the behavior of your database so that you request username and password from the application instead of Windows authentication. This can be a lot of work if you have many users/applications working with the database.

Have your users log in Windows 8 with a standard Windows account instead of a Windows Live account. This one can enrage the users, because they will lose their easy access to some of the few useful features of Windows 8, such as SkyDrive and Outlook.com (Hotmail).

Have your application connect to the server through a service. Unless this is a simple application, this implies a lot of code. You need to create the service application, and then rewrite the way your Windows application access the database.

The 4th one seems absurd, but I know at least one company that resorted to it: remove Windows 8 and install Windows 7 on the client computers.
0
 
LVL 80

Expert Comment

by:David Johnson, CD, MVP
ID: 40031095
actually if they use a local account they can associate that account with a Microsoft account

Reverting to Windows 7 is a knee-jerk reaction IMHO.
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

Suggested Solutions

Title # Comments Views Activity
Are triggers slow? 7 14
Toolbar to format all windows forms controls at design time needed 5 16
Access Schema 6 26
VB.NET Application Installation with sqlserver 8 32
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…

830 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