Wait a few moments for the service to restart before proceeding. Right click the server name and select "Restart". Under "Server authentication" select "SQL Server and Windows Authentication Mode". Take this steps to enable mixed mode authentication:Ī dialog will open. To be able to connect to the database using the 'sa' user or other database user, the mixed authentication mode should be enabled. If DbSchema is running on a Mac system, you won't be able to connect using Windows authentication, therefore please use this method to connect. This will allow login on the database only using the windows user and not using the 'sa' user. Then click Finish.Įnable Database Authentication (Mixed Mode, required for Mac DbSchema users)īy default only the Windows Authentication is enabled.
0 Comments
Leave a Reply. |