Is Windows authentication broken in SQL Data Generator?

• 
  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.

   
  

  https://www.screencast.com/t/6fS4NhHg0
  

  https://www.screencast.com/t/cGrCF2voJwTK 

  
  

  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.
  

  
  

  https://www.screencast.com/t/GaWqSwL7
  

  
  

  
  

  Please advise.
  

  dwainew January 13, 2020 19:07

  - 0 +
• 

  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.

   
  

  https://www.screencast.com/t/6fS4NhHg0
  

  https://www.screencast.com/t/cGrCF2voJwTK 

  
  

  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.
  

  
  

  https://www.screencast.com/t/GaWqSwL7
  

  
  

  
  

  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.
  

  dwainew January 13, 2020 19:31

  - 0 +
• 
  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!
  

  DanC January 15, 2020 11:16

  - 0 +
• 
  not much help there.  It stopped after a second restart and hasn't occurred since.
  

  dwainew January 17, 2020 16:40

  - 0 +
• 
  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?
  

  DanC January 20, 2020 09:00

  - 0 +
• 
  yes, you can close it.  no issues since.
  

  dwainew January 20, 2020 09:35

  - 0 +

Add comment

Please sign in to leave a comment.