search

MicrosoftDocs / mslearn-azure-sql-fundamentals

Sample code repo for the Azure SQL fundamentals Microsoft Learn learning path
MIT License
53 stars 89 forks source link

Running ostress.exe fails #1

Open alxy opened 4 years ago

alxy commented 4 years ago

I tried following the labs in 04-Performance, but the sqlworkload command fails for me with the following output:

09/14/20 09:49:58.090 [0x00001FF4] Starting query execution...
09/14/20 09:49:58.094 [0x00001FF4]  BETA: Custom CLR Expression support enabled.
09/14/20 09:49:58.094 [0x00001FF4] Creating 10 thread(s) to process queries
09/14/20 09:49:58.094 [0x00001FF4] Worker threads created, beginning execution...
09/14/20 09:50:13.613 [0x00001098] Attempt to establish connection failed.  See the detailed errors that follow:

09/14/20 09:50:13.613 [0x00001098] SQLState: 08001, Native Error: 18
[DBNETLIB]SSL Security error

09/14/20 09:50:13.614 [0x00001098] SQLState: 01S00, Native Error: 0
Invalid connection string attribute

09/14/20 09:50:13.615 [0x00001098] Input file: C:\Users\alxy\Documents\Projects\MSLearn\mslearn-azure-sql-fundamentals\04-Performance\monitor_and_scale\topcustomersales.sql

09/14/20 09:50:13.617 [0x00001098] NOTE: If the target server is running SQL Server 2000 or older version and the connection failed with an error such as "Encryption not supported on SQL Server" then you must add -T146 to the command line parameters to be able to connect.  However, doing so will not encrypt data transmitted between the client and SQL Server unless you specifically configure it per the SQL Server documentation.

I used the same credentials I used to connect via SSMS or Data Studio which worked fine.

amthomas46 commented 3 years ago

Hi @alxy . So sorry for the delay. I am unable to reproduce unfortunately.