MobileTogether Support Forum
»
Designer
»
MobileTogether Designer
»
DB connection to MS SQL Server / Database Connection Error
Rank: Newbie
Groups: Registered
Joined: 9/24/2020(UTC) Posts: 2  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.
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Joined: 9/15/2014(UTC) Posts: 123  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?
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 9/24/2020(UTC) Posts: 2  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?
|
|
|
|
Rank: Administration
Groups: Registered, Administrators Joined: 9/15/2014(UTC) Posts: 123  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.
|
|
|
|
MobileTogether Support Forum
»
Designer
»
MobileTogether Designer
»
DB connection to MS SQL Server / Database Connection Error
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.