If you are using SQL Server authentication rather Windows-based authentication, the local system account must have the permissions necessary to communicate with the database.Īn error like Error: Login failed for user 'domain\user$' indicates that the local system account does not have these permissions. See Configure Database above.īy default, when Collaborator is installed, the service runs under the Local System account. error, you probably need to enable TCP/IP for your database. If you get the The TCP/IP connection to the host has failed. Clear the TCP Dynamic Ports check box and specify the desired port number in TCP Port. To use a static port instead, open the TCP/IP settings and change the IPAll setting value. Make sure TCP/IP is enabled.īy default, SQL Server is configured to use dynamic ports, which means that the port used is changed each time the service is restarted. To enable it, open the SQL Server Configuration Manager and navigate to Network Configuration > Protocols. By default, in SQL Server this protocol is disabled.
If you decide to use Windows-based authentication, you may need to change the Collaborator settings – see below.Ĭollaborator uses the TCP/IP protocol for data exchange. SQL Server uses its native authentication by default, so no additional actions will be required. We recommend using a native SQL Server account authentication instead of Windows-based authentication, because the Collaborator service might not be running under a normal Windows-based login. It is recommended that you create a user account just for Collaborator and give this account at a minimum db_owner permissions to Collaborator database and no access to other databases. When creating the database, be sure to select a case insensitive collation so that the case of column names (and user names and text searches) does not matter. When you log in to the Collaborator web client for the first time after installation, it detects that you have a new database and will create all tables, indexes, and views for you automatically. The wizard will report any connectivity errors.
MICROSOFT JDBC DRIVER FOR SQL SERVER 2014 PASSWORD
When installing Collaborator on a server, the installation wizard will prompt for the SQL Server host name, TCP/IP port number, the database name, user name, password and path to JDBC driver. You can do this, for example, in SQL Server Management Studio. You need to create an empty database for Collaborator.
0 kommentar(er)
