Is Windows authentication broken in SQL Data Generator?
dwainew
Posts: 59 Bronze 4
I've been using data generator quite extensively for the past several months. Recently, projects that had worked before started failing. The issue seems to be related to windows auth, since switching to SQL auth is successful.
The windows auth error can be seen here
https://www.screencast.com/t/VPbzK48fx8U
Please advise
I'm using 4.2.3.1975
All other SQL tooling is working fine. (SSMS, VS2019, DBeaver, etc.)
Tagged:
Best Answers
-
DanC Posts: 641 Gold 5Hi @dwainew sorry to hear you're experiencing these issues! Could I trouble you for the logs, this should hopefully give some better insight into why it's giving an error for the Windows auth.
These can be located here: %localappdata% > Red Gate > Logs
It's a strange bug, you might see the Data Generator logs openly and not nested within a sub folder.
If you could zip them up that would be fantastic!
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center? -
DanC Posts: 641 Gold 5Hi @dwainew unfortunately the logs had nothing in them, from your last comment "It stopped after a second restart and hasn't occurred since" are you saying you're now able to use the Windows authentication?
Kind regards
Dan Calver | Redgate Software
Have you visited our Help Center?
Answers
I just realized the entirety of the second post was due to the connections to the source for each table were still using windows auth. It seems to be working now with everything set to use sa account.