Tag to be used for all authentication questions regarding Microsoft's SQL Server product.
Questions tagged [sql-server-authentication]
18 questions
0
votes
1 answer
SQL Server SA Password for SQL Server Authentication?
I am working on SQL Server 2008 and currently I am using my local server with windows authentication. Can i set SA password for SQL Server Authentication? What are the steps and also I want to know what is the difference between Windows and SQL…
user3688418
0
votes
4 answers
How do I connect to a SQL Server which is usually a machine I remote desktop into
Typically I remote into a machine with IP Address 00.00.00.00 and then I have an account in a domain, let's call it myspecialaccount\firstname.lastname.
Then I use Windows auth to connect to SQL Server instance for example:
ABCLACSQLC123\DEV04A
So…
Tom Stickel
- 19,633
- 6
- 111
- 113
-1
votes
2 answers
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…
DarioN1
- 2,460
- 7
- 32
- 67