In the case of a deactivated sa account, just go ahead and enable the SQL Server account again. If your sa account has been disabled then please also follow Step 2. Verify that the radio button is selected for SQL Server and Windows Authentication mode. To connect to the SQL Server using the Microsoft SQL Server Management Studio, you use these steps: First, launch the Microsoft SQL Server Management Studio. Verify that your instance is running in SQL Server and Windows Authentication mode by issuing the following command: EXEC xp_instance_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer', N'LoginMode' To start the installation, double-click the file SSMS-Setup-ENU.exe. Right-click on your SQL Server instance and select Restart from the context menu: Step 1: Navigate to Microsoft link to download Microsoft SQL Server Management Studio (SSMS) Step 2: Click on Download SQL Server Management Studio (SSMS) 19 (preview) Step 3: SSMS-Setup-ENU.exe will be downloaded to your PC. (Replace MSSQLServer with the name of your service) (Replace SQLSERVERAGENT with the name of your service) SSMS can also be used to access, configure, manage
0 Comments
Leave a Reply. |