Login Failed: SQL Server Database Connection

Login Failed: SQL Server Database Connection

  
Hi all,

Trying to connect to our SQL Server by creating a connection via the Service Centre. It seems to acknowledge the server, but wont let me login, saying 'Connection String test failed: Login failed for user 'emea\Ellinghamt'.'

Am I missing some sort of permissions to allow access. I know the server is set up for Remote Connections, but wondering if I need something extra. The server is run by out main IT department (among many other servers) so wondering if I need something at a higher level or not. I take it that typing my Windows Authentication password in to the password box is also correct?

Cheers,

Tom
Hi Tom

You cannot use Windows Authentication when creating connections in Service Center.
Try creating a SQL Server Authentication user, and connect with that one instead.

Please reply with your results.
Cheers,
Thanks Acácio, thats part of what I needed to here!

Still couldn't get it to work but realised you have to set the security settings to allow both SQL and NT logins. Now need to wait for the server to reboot over the weekend for those changes to take affect.

Will let you know how it goes.

Cheers,

Tom
Hi, i have the same problem although i am using sql authentication !
Hi Khaled,

Do you get the same exact error message? Have you confirmed that the credentials you supplied are valid (e.g. by logging in in SQL Server Management Studio?

Joao

Acácio Porta Nova wrote:

Hi Tom

You cannot use Windows Authentication when creating connections in Service Center.
Try creating a SQL Server Authentication user, and connect with that one instead.

Please reply with your results.
Cheers,

Hi, is there a way to connect an external database through window authentication?


Hi,


did you ever get an answer if it's possible to connect to an external database through the windows authentication?

The first step in connecting to an external database is to configure the connection in Service Center, as explained in https://success.outsystems.com/Documentation/Development_FAQs/How_to_integrate_with_an_external_SQL_Server_or_ORACLE_database.

This procedure does not support Windows Authentication, as described previously on this thread.


In theory, you can write a C# or Java extension that uses Windows Authentication to connect to a database, but you would lose all the OutSystems visual modeling capabilities that are available for the "external database connection" feature described in the previous link.

So, despiste this theoretical possibility, the short answer to your question is "no".

Frank Sprengers wrote:

Hi,


did you ever get an answer if it's possible to connect to an external database through the windows authentication?

Hi, 

I attempt creating a connection string and is able to connect to an external database through windows authentication eventually.

https://www.outsystems.com/forums/discussion/18446/connection-to-external-sql-server-database/ 


Hi Xue,

I am facing the exact same problem, our client that we are developing for has a security policy that only allows Windows Authentication to their SQL Server database, would you mind please sharing an example of the connection string? Much appreciated!

Hi, 

Incase you still need an example:

user id=sa;password=<hidden>;data source = mydatasource,1433; initial catalog = mydatabasename; integrated security = yes;

Reference:

https://www.outsystems.com/forums/discussion/18446/connection-to-external-sql-server-database/