POST
|
Rex, you saved my ***! Thanks sooo much! So, I tried your 4th advice, creating a .udl file and follow along. Although my SQL instance didn't auto-show in the drop-down, typing the server domain name did the trick too. When I entered the database user login in question, it raised an error, that it couldn't read the default database of the user. So, back to SQL Manager, I set the default database ( right-click on user login: Properties > General > ..) and it worked! Now, ArcGIS is also recognizing it. Wouldn't eeeever have thought about that!! The lesson learned here is: the errors the 'raw' database connector throws should be piped directly to ArcGIS error messages in the DB connector. It would've saved me a full 3 hours of trial/error if it told me it couldn't connect to the default database for the user. And I don't think I ever read about that problem in any tutorial or forum.. Could you please pass that on Rex? Many thanks Nils
... View more
05-31-2018
01:51 PM
|
2
|
1
|
2056
|
POST
|
Hi, first, the specs: ArcGIS Desktop 10.6 MSSQL 2016 MSSQL client v13 installed I created database users a while before upgrading to ArcGIS 10.6 (from 10.4). Now, connecting remotely (and thus not being able to use OS authentication), I realized I can't connect via the database users. It tells me 'bad login'. However, I checked that they are properly set up, which seems to be the case (to me). I also read about enabling all services that MSSQL should run. So, I headed over to the SQL Server Configuration Manager and indeed, 'SQL Server Browser' and '.. Agent' were not running. I started them but realized smth weird in 'SQL Server Browser' properties: - I have no idea which 'account' to specify. If 'Built-in Account' or a domain account. Currently it's 'NT Authority\Network Service' - Also there's no 'SQL Service Type' specified, which seems to be the case for the other running services. Can anyone give me a hint what I could try? Many thanks Nils
... View more
05-31-2018
04:24 AM
|
0
|
4
|
3043
|
Title | Kudos | Posted |
---|---|---|
2 | 05-31-2018 01:51 PM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|