sql-serversql-server-2014-expresssql-server-authentication
SQL Server : Authorize User not in domain
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
Solution
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
- Logic edits all existing rows instead of adding new when using Save stored procedure
- SQL : remove last comma in string
- Optimizing SQL join query with date comparison
- SSIS - The process cannot access the file because it is being used by another process
- What's a good way to trim all whitespace characters from a string in T-SQL without UDF and without CLR?
- SQL : ISNULL in Join condition
- Preventing Blank SSRS Reports from Emailing without Enterprise Edition (No Data-Driven Option)
- Why MS Access works with SQL server ODBC via internet so slow?
- Exclude most recent date when grouping by an attribute through a JOIN
- What’s the difference among connection, session and request in Sql Server?
- Execute Raw SQL in EF Core 6.0.6
- Auto-update calculated column values
- How to optimize a query?
- Joining together 2 tables while joining one table twice with different filters
- Check if starting characters of a string are alphabetical in T-SQL
- Add column name as XML node and join with other table
- How to check Palindrome in SQL Server
- A SQL Query to select a string between two known strings
- STRING_AGG alternative
- Strategy for cleaning data from multiple sources
- How to remove duplicate in the same row
- Add a column to a table, if it does not already exist
- Issue searching down columns
- CTE vs View Performance in SQL Server
- Create a user on AWS SQL Server Read replica
- Split an email in a query
- What is the use of a cursor in SQL Server?
- Ordinal enum mapping with Hibernate 6.5
- Entity Framework "SELECT IN" not using parameters
- DACPAC and SQL Sequence