Solved

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

Posted on 2014-04-29
2
123 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
[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
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 82

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
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…
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…

628 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