Grant login Access to Sql Server to a User on Windows 8
Hi!
We have Sql Server installed on Windows 8.1 PC and on this PC, we have multiple Users with Microsoft email accounts. As we just migrated from WIndows 7 to WIndows 8, I am finding it challenging to grant permissions to every User with an account on the PC. 
Please I anticipate your reply. Thanks 
  • Edited by saintgr8 16 hours 26 minutes ago
January 31st, 2015 10:31am

Hello,<o:p></o:p>

If those PCs are not part of an active directory domain, and they
are just part of a workgroup of computers, then you need to create SQL Server
logins to provide access to users working from other PCs.<o:p></o:p>

Please read instructions on the following article about how to
create SQL Server logins on SQL Server and use them to access SQL Server
databases.<o:p></o:p>

http://www.codeproject.com/Articles/37274/Working-with-SQL-Server-Logins

Hope this helps.
<o:p></o:p>

Regards,<o:p></o:p>

Alberto Morillo

SQLCoffee.com<o:p></o:p>


Free Windows Admin Tool Kit Click here and download it now
January 31st, 2015 11:15am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics