Solved

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

Posted on 2014-04-29
2
116 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 78

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

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.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
Windows 8 came with a dramatically different user interface known as Metro. Notably missing from that interface was a Start button and Start Menu. Microsoft responded to negative user feedback of the Metro interface, bringing back the Start button a…

760 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now