Comments (17)
When you're installing SQL, make sure you add Full Text Search:
https://www.mssqltips.com/sqlservertip/6841/add-full-text-search-sql-server/
from ds3.
It worked,Can you help me with next step .
I tried using server ip /server name that i'm working with .
Thanks & Regards
Ajay Vaaka
from ds3.
When you run the driver without any parameters, it will tell you "Enter parameters with format --parm_name=parm_value"
So, change all your single "-" to "--"
from ds3.
Thanks for correcting it. still no luck
from ds3.
10.1.11.6 is there serverwhere i'm working ( win 2019; sql :2019)
from ds3.
The error you're getting is "Login failed for user ds3user".
It looks like the Heraflux guide you followed has some outdated instructions, specifically the part where it says "Do a find and replace in the entire file and replace ds3user with ds2user, as this is a holdover from the previous version of the benchmarking tool." You'll need to skip that part of the guide and re-do everything, then it should work.
The ds2user -> ds3user bug was fixed back in 2017, so that Heraflux article should be updated. I'll reach out to David Klee and let him know.
from ds3.
Error indicates that the ds3user login failed. This probably means that it wasn't successfully created when you ran the sqlserverds35_create_all.bat script for the database. Not sure why it would have failed, but you can run just the user creation step from ds35/sqlserverds35/build/sqlserverds35_create_user.sql script.
David's comment came in while I was writing the above response. Probably a better idea to re-run the whole create-all script as he recommends to make sure that everything is done correctly and it completes without errors. If you to try just rerunning the create user script you might not be as sucessful.
David - Thanks for responding to this issue.
from ds3.
ds35/sqlserverds35/build/sqlserverds35_create_user.sql : Ran successfully
didn't changed this time ds2user -> ds3user ; load successfully
Test result is same
from ds3.
Make sure you have TCP/IP enabled for your SQL Server instance: https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-or-disable-a-server-network-protocol?view=sql-server-ver15#SSMSProcedure
from ds3.
from ds3.
Maybe it is a firewall or some other networking issue. To rule that out, you could try copying ds3sqlserverdriver.exe directly to the SQL Server machine itself and run the driver directly it by specifying --target=localhost
from ds3.
i'm running on localhost , where SQL is running .
Thanks & Regards
Ajay Vaaka
from ds3.
Login to the sql server managment studio as administrator and see if ds3user exists as a user under Security -> Logins. If it does exist, delete it and rerun the script. Now, can you logon as user ds3user to sql server via the sql server management studio?
If this is successful, then the user is there and the error is being caused by something else. Try running the ds3sqlserverdriver.exe with just the target, db_size, and n_threads parameters.
If you still can't get it to work, maybe we can do a zoom call on Monday and interactively figure out what it going on.
Thanks - Todd
from ds3.
Login to the sql server managment studio as administrator and see if ds3user exists as a user under Security -> Logins. If it does exist, delete it and rerun the script. Now, can you logon as user ds3user to sql server via the sql server management studio?
- i able to see ds3user and remove it and re-ran script . I can't login with ds3user . I'm taking guidence from my SQL team. will keep you posted after that. i belive ds3user password is empty ( that is how i'm trying)
from ds3.
i'm able to communicate now.
Can you guide me next step please. is this look accurate ?
Thanks & Regards
Ajay Vaaka
from ds3.
from ds3.
Thanks Todd for huge help.
Worked after using ds3 driver
What was the issue that was preventing it from connecting that you fixed?
- SQL mixed mode
- previouly , i can't able to connect to SQL using ds3user . i make sure it worked .
Thanks & Regards
Ajay Vaaka
from ds3.
Related Issues (9)
- Create Login Script references both ds2user and ds3user HOT 1
- Server 2016 Nano support HOT 2
- Incorrect format in parameter (Generated ConfigFile) HOT 3
- Errors thrown when requesting database target size over 1TB HOT 5
- Error accessing server machine HOT 4
- Directory lookup for the file "C:\sql\dbfiles\ds.mdf" failed with the operating system error 3(The system cannot find the path specified.). HOT 4
- Connection issues to windows server HOT 1
- Running on multiple SQL servers HOT 6
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from ds3.