Change loginMode

Make sure that the instance of SQL Server is configured to use Windows authentication and SQL Server Authentication. To do so, make sure that the following registry keys are on the computer that is running SQL Server. For the default instance of SQL Server:


For the named instance of SQL Server:

HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\<Instance Name>\MSSQLServer\LoginMode

Make sure that the following registry key values are set:

Authentication type Value
Windows authentication only 1
Mixed mode (SQL Server Authentication and Windows authentication) 2




Saving your comment....

Naam is verplicht!
Email is verplicht!
Opmerking is verplicht!