Just adding the fact that I'm using jtds-1.2.5 in case it's relevant.

I have the same question

So what I found was this.  If you are adding a new data source and you have that large text box to enter in multiple datasources, one per line,  it works if you also add the instance name.

sqlserver://database.host.name:1433/database_name;instance=myinstance,username,password,maxrows

If you have already created the datasource and then are going back to add in a max row count,  there is a separate box down at the bottom of the edit window for that datasource where you enter in the max row number.

One question I still have is that max rows total for that datasource, or per table within the datasource.  It makes much more sense for it to be per table,  but short of inspecting the traffic it's hard to know what it's really doing.  It definitely decreases the scan time on large databases.

--Joe

Here is what I got working, so it only pulls 10 rows (the scan object is configured to use an Active Directory credential using <username> format and not <domain\username> format):

sqlserver://server.contoso.com:1433/database1;domain=contoso.com;useNTLMv2=true;10

I also confirmed the max rows setting is per/table