The following MSDN article describes how to configure a Windows firewall to allow SQL Server access, however the instructions are applicable to other firewalls: Configuring the Windows Firewall to Allow SQL Server Access. Configure your firewall to allow SQL Server access - If you need to access SQL server through a firewall, you will need to configure your firewall appropriately.Screenshot: Changing the SQL Server authentication mode See this MSDN article for instructions on how to do this. You need to change the server authentication mode to SQL Server and Windows Authentication mode in SQL Server before you can connect Bamboo to SQL Server. However, if you try to connect to the database with a database user using this authentication mode, SQL Server will throw an error. Change server authentication to 'SQL Server and Windows Authentication mode' - On a typical SQL Server installation, Windows Authentication mode is the default security mode.Before you connect Bamboo to a SQL Server, you need to configure SQL Server appropriately.
0 kommentar(er)
