Could not connect to server Server\Database or login failed.
Article ID: 152269
Updated On:
Products
Issue/Introduction
Error from 1st time clicking on the 'Next' button:
Could not connect to server MyServer\MyDatabaseInstance or login failed.
Incorrect syntax near 's'.
Unclosed quotation mark after the character string ')'.
Error from 2nd time clicking on the 'Next' button:
Could not connect to server MyServer\MyDatabaseInstance or login failed.
A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 - The handle is invalid.)
Cause
This seems to be happening if the SA account is disabled or if the authentication is set to windows authentication only
Resolution
Enable the SA account in SQL and then use that to install the Notification Server
Once the server is installed go to the console > settings > notification server settings > database settings
The change the Database credentials to a SQL account or to a windows login with DBO access to the database
Applies To
SIM 7.0
Windows SQL Server 2005/2005 Express
Feedback
