Security Settings To Adjust
Search
Security Settings To Adjust
- If creating a user with SQL authentication, make sure that you allow this by going to:
- Right click on server in SQL > properties > Security tab > at the top, select the radio button to allow SQL and Windows authentication log ins
- In Sql Server Configuration Manager, under SQL Server Network Configuration > Protocols for MSSQLSERVER, make sure TCP/IP and Named Pipes are enabled (will need to restart the SQL service). Also worth mentioning we had to enable "VIA" at one location to get it to connect.