I just downloaded the reverse engineering tool and I am trying to connect to a sql server. If I use jdbc connection string as jdbc:sqlserver://ipaddress:port;databaseName=mydatabase-name -user sa -password _pwd_ I get Login failed for user '' error. The error goes away if I take out the databaseName property, but export happens for the default database which I don't want( so user id and password are accurate and user is active). Even if I add user and password properties before or after databaseName property value, I still get the same error. Any ideas? (JRE8 version). Could the issue be with the name of database containing a hyphen?
Can you verify that the user you are using has permissions to your database ("mydatabase-name")?
Perhaps, it has only permissions to your default database.
Parsing works properly, so hyphen in the database name should not cause problems.
Thanks Mariusz for the reply. Yes. the id has access to the database. I am able to run queries on the schema tables as well as "sys." tables without any issues. When I put the database name, the user id in the error is coming blanks and not the user id I am passing against the -user argument
Probably your shell interprets semicolon as a new instruction.
I was able to reproduce similar behavior.
$ java -cp .:reverse-engineering.jar:mssql-jdbc-7.2.1.jre8.jar com.vertabelo.reverse.Main -url jdbc:sqlserver://127.0.0.1:1433;databaseName=database-one -user user1 -password 'xxxxxxxxxx' -o out_reverse
Exception in thread "main" com.vertabelo.reverse.asj: Error: missing output file. Specify -o option.
No command '-user' found, did you mean:
Command 'fuser' from package 'psmisc' (main)
Command 'kuser' from package 'kuser' (universe)
-user: command not found
$ java -cp .:reverse-engineering.jar:mssql-jdbc-7.2.1.jre8.jar com.vertabelo.reverse.Main -url 'jdbc:sqlserver://127.0.0.1:1433;databaseName=database1' -user user1 -password 'xxxxxxxxxxx' -o out_reverse
No JDBC driver given. Using JDBC driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
Reverse engineering MS SQL Server database
Connecting to the database...
Database: Microsoft SQL Server 14.00.3048
Extracting table information
Extracting view information
Extracting reference information
Extracting sequence information
Preparing xml done.
Drawing the graph
Please, try again with quotation marks.
YES. It works with the quotation marks. Thanks So much....
Thanks so much. Looks to be working. More 'o' in status window than previous cases. Will update in case there is any issue.
Service d'assistance aux clients par UserEcho