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

Options
View
Go to last post Go to first unread
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.
AFC  
#2 Posted : Thursday, September 24, 2020 10:02:11 AM(UTC)
AFC

Rank: Administration

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

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

Did you check "Allow saving password" and the "Persist Security Info" setting on the "All" tab?
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?
AFC  
#4 Posted : Friday, September 25, 2020 7:39:14 AM(UTC)
AFC

Rank: Administration

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

Was thanked: 16 time(s) in 16 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.
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.