Support Forum

Ask questions and get help from MobileTogether experts.
MobileTogether Product Information
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
DB connection to MS SQL Server / Database Connection Error - Failed to connect to database
Options
View
Go to last post Go to first unread
Previous Topic Next Topic
UliAdmin  
#1 Posted : Thursday, September 24, 2020 8:24:33 AM(UTC)
UliAdmin

Rank: Newbie

Groups: Registered
Joined: 9/24/2020(UTC)
Posts: 2
Germany
Location: Cologne
Hi,
we are adding a page source, new DB structure, (no change on Add Page Source), Microsoft SQL Server, SQL Server Native Client 11.0, followed by selection of the SQL server and entry of the user Name and Passwort (SQL User).
The button 'test connection' works flawless - test connection succeeded.
However, when we click on OK on the last dialogue an error message pops up stating 'Failed to connect to database'
Error connecting user ###.
It is unclear why this connection can not be established - the user name and password are correct. The user has db_datareader and db_datawriter access.
Would appreciate some advice, thank you.
Back to top
WWW
AFC  
#2 Posted : Thursday, September 24, 2020 10:02:11 AM(UTC)
AFC

Rank: Administration

Groups: Registered, Administrators
Joined: 9/15/2014(UTC)
Posts: 127
Austria

Was thanked: 18 time(s) in 18 post(s)
Hi UliAdmin!

Did you check "Allow saving password" and the "Persist Security Info" setting on the "All" tab?
Back to top
UliAdmin  
#3 Posted : Thursday, September 24, 2020 1:02:11 PM(UTC)
UliAdmin

Rank: Newbie

Groups: Registered
Joined: 9/24/2020(UTC)
Posts: 2
Germany
Location: Cologne
Hi AFC,

we just tested it with Allow saving password (which we had before) and we also changed the persist sec. info to true.
It does unfortunatley not resolve the issue. Is there an error log which might shed some light on this?
Back to top
WWW
AFC  
#4 Posted : Friday, September 25, 2020 7:39:14 AM(UTC)
AFC

Rank: Administration

Groups: Registered, Administrators
Joined: 9/15/2014(UTC)
Posts: 127
Austria

Was thanked: 18 time(s) in 18 post(s)
Hi UliAdmin!

You can also try to directly enter the connection string.
Instead of using the DB connection wizard, click on the "ADO Connections" tab and enter the connection string like:
Quote:
Provider=SQLNCLI11;User ID= _user name_ ;Password= _pwd_ ;Persist Security Info=true;Initial Catalog= _database_ ;Data Source= _server name_


If this also does not help, please directly contact our Support center.
Back to top
Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.