Options

Is Windows authentication broken in SQL Data Generator?

dwainewdwainew Posts: 59 Bronze 4
edited January 13, 2020 6:34PM in SQL Data Generator
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

I'm using 4.2.3.1975

All other SQL tooling is working fine.  (SSMS, VS2019, DBeaver, etc.)

Please advise
Tagged:
· Share on Twitter

Best Answers

  • Options
    DanCDanC Posts: 591 Gold 4
    Answer ✓
    Hi @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?

    · Share on Twitter
  • Options
    DanCDanC Posts: 591 Gold 4
    Answer ✓
    Hi @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?

    · Share on Twitter

Answers

  • Options
    dwainewdwainew Posts: 59 Bronze 4
    Additionally, despite using the sa account, another fairly complex project is having a similar issue.  During project refresh, it hangs for literally 5 minutes (at either 96% or 98%) during "Reading Dependencies," and then completes.  But a callout on two tables shows an error similar to the windows auth issue above.
     

    If it hangs at 96%, then two errors show up for the same two tables, not one.  The additional error just has a different "initialization" value.  It turns out these two tables are using the same existing data source (which is also being generated), and that the preview pane is stuck on that source table.



    Please advise.
    · Share on Twitter
  • Options
    dwainewdwainew Posts: 59 Bronze 4
    dwainew said:
    Additionally, despite using the sa account, another fairly complex project is having a similar issue.  During project refresh, it hangs for literally 5 minutes (at either 96% or 98%) during "Reading Dependencies," and then completes.  But a callout on two tables shows an error similar to the windows auth issue above.
     

    If it hangs at 96%, then two errors show up for the same two tables, not one.  The additional error just has a different "initialization" value.  It turns out these two tables are using the same existing data source (which is also being generated), and that the preview pane is stuck on that source table.



    Please advise.

    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.
    · Share on Twitter
  • Options
    dwainewdwainew Posts: 59 Bronze 4
    not much help there.  It stopped after a second restart and hasn't occurred since.
    · Share on Twitter
  • Options
    dwainewdwainew Posts: 59 Bronze 4
    yes, you can close it.  no issues since.
    · Share on Twitter
Sign In or Register to comment.