UniStream SQL troubleshouting
Eduardo Margulis
Nov-6th, 2017 13:19
  1. Please make sure that the IP address and Host name of the configured MS SQL server are correct. (In case of using Host name , please make sure to set DNS in UniStream 
1
  1. Server Name – The server name is the instance name of the SQL.In the example below the name of the SQL instance is SQLEXPRESS
2

In case there is no SQL instance name (installing the SQL with default instance) the instance name should be MSSQLSERVER.

  1. Please make sure to set the security to “SQL Server and Windows Authentication mode” since UniStream does not support Windows Authentication

  1. Please make sure that user and password are correct. Also make sure to give permissions to access the data base such as db_datareader and db_datawriter.
4
  1. Please make sure the TCP/IP protocol is enabled in the SQL Server Configuration manager: 
5
  1. Check Firewall settings that the SQL Server program and the port UDP 1434 are allowed

Attached instalation and Trouble shooting guide for MS SQL.

Was this article helpful?
0 out of 0 found this helpful