Skip to Content (Press Enter)
2011-11-23 13-56-48
Tommy
474Views
11Comments
Login Failed: SQL Server Database Connection
Question
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
0
0
26 Aug 2011
Copy Link
2011-06-15 10-49-56
AcacioPN
Staff
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,
0
0
26 Aug 2011
Copy Link
UserImage.jpg
Xue Li

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?


0
0
05 Dec 2016
Copy Link
2011-11-23 13-56-48
Tommy
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
0
0
26 Aug 2011
Copy Link
UserImage.jpg
Khaled Hussein
Hi, i have the same problem although i am using sql authentication !
0
0
23 Dec 2015
Copy Link
2015-05-05 17-20-51
João Santos
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
0
0
28 Dec 2015
Copy Link
2018-03-28 15-07-25
Frank Sprengers

Hi,


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

0
0
25 Jan 2017
Copy Link
UserImage.jpg
Xue Li

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/ 


1
0
09 Feb 2017
Copy Link
2015-05-05 17-20-51
João Santos

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".

0
0
26 Jan 2017
Copy Link
2018-07-09 07-35-13
Elize van der Riet

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!

0
0
09 Feb 2017
Copy Link
UserImage.jpg
Xue Li

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/ 

0
0
27 Mar 2017
Copy Link
2018-03-28 15-07-25
Frank Sprengers

Hi Xue,

when I use your example the username and password values provided in the advanced configuration seem to be ignored. The apppool user of the platform is used. If I give this user the permissions needed on the database the integrad security works but I would like to be able to choose which user is used in making the connection. Do you know of a way to use a different user for the connection?

0
0
11 Apr 2017
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.