Dispatcherutil SQL Server 2012 missing / JDBC 4 & JRE 1.6

[becksen]

Hi all,

I've some issues with setting up the dispatcher.

First of all I'm missing the Microsoft SQL Server 2012 entry although it should be supported.

This is finally my dispatcher configuration, I'm wondering why the DSE Class Path is missing as per screenprint in Documentation:

Once restarted the application it is asking for the password. When I enter it and confirm the following error is displayed:

As per SAP documentation I'm using the java and jdbc components mentioned and should be compatible.

Thanks for you support.

[brandonbollin · Accepted solution]

Is there some reason you can't use the sqlijdbc4 class library in your environment?

[becksen · Accepted solution]

Sorry. I've selected the wrong .jar file. The error disappeared later on.

Nevertheless either setting or password is incorrect. I'm 100% sure that it is the password I've set on installation of mxmc_db.

The log file isn't showing any hint what might be wrong. Can I use a different user for that?

I've figured out that a " is not allowed in the password of mxmc_admin. I've changed it during a reinstallation but the issue still appears. Any idea?

Thanks a lot for your feedback.

[brandonbollin · Accepted solution]

I don't see why not. I can't remember what restrictions are on each account when it comes to database connections. You would think the admin account would be the best one but maybe the DB or RT accounts will do what you need?

Modify your connection string to use those accounts and see what happens. Trial and error is sometimes the best way to troubleshoot.

[becksen · Accepted solution]

It was just about complexity of the password. Trial and error did it finally.

Thanks all for your contribution.

[brandonbollin · Accepted solution]

Trial and error sir. Sometimes that's all you have. Glad you got it fixed.

[normann]

Hi Timmy,

Choosing Driver: Using MSSLQ 2008 is the right decision. The name should be 2008+ to indicate its also supposed to be chosen for higher versions.

DSE.jar in classpath: What version are you running on? Might be it has changed in SP2 now and the documentation does not fit the version you have. Either way, if the dispatcher is starting you should not worry about that setting. The DSE.jar is always in <DSE home>\Java by standard.

Can you try using sqljdbc4.jar as the driver? I dont know a reason why you should not.

Regards

Norman