Knowledge Base100Cannot connect to Microsoft SQL Server
During creation of a new portal different error messages may appear after the Microsoft SQL Server has been chosen:

1) Cannot connect to server "localhost".
Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection.

2) Cannot connect to server "localhost".
Network error IOException: Connection refused: connect

3) Cannot connect to server "localhost".
Login failed for user 'sa'.
1) The authentication settings of the SQL Server are set to Windows authentication only. The correct setting would be "mixed mode (Windows Authentication and SQL Server Authentication)"
--> http://support.microsoft.com/kb/889615/en

2) The TCP/IP protocol is not enabled and / or is wrongly configured.
Correct TCP/IP protocol configuration (found in the SQL Server Configurationsmanager):
For IPALL enter no dynamic TCP/IP port and for the static TCP/IP port enter the default port 1433.

3) Wrong password has been entered for the user "sa".

-------------------------------------------------------------------

If none of those solutions worked, please contact the United Planet support or try the Intrexx forum.
Anhang:

Intrexx Version:

    Details:

    Kategorie:Datenintegration
    Betriebssystem:Windows Server
    Datenbank:MSSQL
    Stand von:03-02-2014