1) Update your SQL server to allow mixed authentication mode. You can do it in SSMS or by running the following TSQL code: use master; EXEC xp_instance_regwrite     N'HKEY_LOCAL_MACHINE',     N'Software\Microsoft\MSSQLServer\MSSQLServer',     N'LoginMode',      REG_DWORD, 2;

LINUX+ AND LPIC-1 GDE.TO LINUX CERTIF.
5th Edition
ISBN:9781337569798
Author:ECKERT
Publisher:ECKERT
Chapter7: Working With The Bash Shell
Section: Chapter Questions
Problem 7DE
icon
Related questions
Question

1) Update your SQL server to allow mixed authentication mode. You can do it in SSMS or by running the following TSQL code:

use master;

EXEC xp_instance_regwrite

    N'HKEY_LOCAL_MACHINE',

    N'Software\Microsoft\MSSQLServer\MSSQLServer',

    N'LoginMode', 

    REG_DWORD, 2;

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Database Functions
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
LINUX+ AND LPIC-1 GDE.TO LINUX CERTIF.
LINUX+ AND LPIC-1 GDE.TO LINUX CERTIF.
Computer Science
ISBN:
9781337569798
Author:
ECKERT
Publisher:
CENGAGE L