Menu
I have set up a little network with windows workgroup. My pc (windows 8) connected with server (sql server 2012) using windows authentication. Of course I had a local account and not the microsoft account and a pure mapping of the accounts did the job.
With the upgrade to windows 8.1 and in order to use skydrive I must use a Microsoft account. How can I connect to sql server using windows authentication and using this Microsoft account?
448
In the Object Explorer, right-click the server and click Properties. On the Security page under Server authentication, select SQL Server and Windows Authentication mode and then click OK. In the Object Explorer, right-click your server and click Restart. If the SQL Server Agent is running, it must also be restarted.
SQL Server supports two authentication modes, Windows authentication mode and mixed mode. Windows authentication is the default, and is often referred to as integrated security because this SQL Server security model is tightly integrated with Windows.
Resolution to SQL error code 18456 Go to the Properties of the selected server (from the right-click menu). Now go to the Security page and under Server authentication choose the option SQL Server and Window Authentication mode. Now expand Security > Logins and right-click the server name, and select Properties.
A connection made using Windows Authentication is sometimes called a trusted connection, because SQL Server trusts the credentials provided by Windows. By using Windows Authentication, Windows groups can be created at the domain level, and a login can be created on SQL Server for the entire group.
I have figured out a work around for this issue.
First create a local account that will work with your sql server. Then switch to your Windows Live account (a seperate user) and modify the shortcut's target.
C:\Windows\System32\runas.exe /user:domainName\localAccountName /savecred “pathToExecutable”
This should work for any program that needs to use Windows Authentication.
71
If you are able to control the method that the client connects to the SQL Server, and have control of the SQL Server, then it might be best to switch the server to SQL Server and Windows Authentication mode instead of just Windows.
However, if you require the clients Windows login in order to differentiate the users accessing the SQL Server, then you may be out of luck. If the SQL Server is configured to only allow Windows Authentication, then it will only accept connections from the Windows logins defined on the Windows server - if the server is in workgroup mode and not domain mode.
The workaround for this has always been to ensure that a Windows account exists on the client and server with the same name and password, but if you are now required to use a Microsoft Account (formerly known as a Live Account) as your Windows login on your desktop I don't see how you would give that account access rights on the SQL Server.
35
Actually there is a way you can add credentials to the "Microsoft account" the same as adding credentials to accounts in previous versions.
Not sure if this will work for you but it works for me with file share access over a network.
Under Control Panel Open the User Accounts and Family Safety section, then go to User Accounts. Your Microsoft account will be listed. From the left side click Manage your Credentials.
You can add Windows Credentials in there as well as a lot of other credentials.
Hope this helps
23
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
