SQL Server : Authorize User not in domain

Question

I have notebook with Windows 8 and SQL Server 2014 Express installed.

The authentication mode is set to Mixed Mode (Windows + SQL Server authentication).

I need to create a new SA user for my friend in order to let him work on my database.

We are working on a local private LAN (2 notebooks + routed).

How do I have to proceed?

Thanks

Answer 1

In Sql server Express you must allow Remote Connection to user can login from other computer

then add user with sysadmin privilege for each user
note that port 1433 tcp ,1434 udp and port in the link bellow must be open in firewall
SQL Server Ports
note that I you have antivirus with firewall you must open port in antivirus too

Answer 2

Ok, now it works, the problem was the Firewall and AntiVirus. This post can help you for troubleshouting the problem.

http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/

Thanks