Error configuiring SQl database in MII

[swapnil_bodhke]

I am trying to configure MS SQL server 2012 in MII.12.2

JDBC Driver:     com.microsoft.sqlserver.jdbc.SQLServerDriver

Server jdbc:sqlserver://URL:  jdbc:sqlserver://<serverName>\<instance>;database=<database name>(port is dynamic)

Username : abcd

wherein the user is having the windows authentication. and having role of SQLADMIN assigned to it. I can log in to the SSMS with this user.

but when i try connecting from MII i get the following error in the error log:

I have uploaded the following jdbc drivers :

Please help.

Thanks in advance

Swapnil Bodkhe

[swapnil_bodhke · Accepted solution]

Hi All,

Thanks for your reply!!

I have resolved the issue by creating another sql authenticated user and changing the security of SQL server to "Windows and SQL authenticated". I was able to create a running connection with SQL server from MII.

Also there was issue with the password complexity so I used a simple password and was successfull.

If anybody has accesed the only "Windows authentication" secure database using MII, please reply.

Regards

Swapnil.

[Former Member]

Hello Swapnil,

    If you believe your uername/password combination is correct. Then check if the SQL server is configured for both modes of Authentication (Windows and SQL Server Authentication). By default, SQL Server uses Windows Authentication, however MII/JDBC Driver would use SQL Server Authentication.

Check Troubleshooting: Login Failed for User 'x'

"Login failed for user" error message when you log on to SQL Server

Also, I see multiple SQLJDBC Driver deployed in MII, may be there is a conflict. Try removing all and adding only SQLJDBC4 driver.

Regards

Tufale Ashai.

[swapnil_bodhke]

Hi Tufale,

Thanks for ur reply.Earlier the the authentication was on for windows but SQL server is now configured for both modes of Authentication (Windows and SQL Server Authentication) and I am trying to use the earlier windows username but same error.Also tried with another user husing SQL authentication but still the error persists.

I you have done such a configuratuion please detail me the process.

Thanks,

Swapnil

[jcgood25]

Search the forum and SCN space for the article/blog concerning dynamic ports - you must configure SQL server for a fixed port (like the default 1433).

[Former Member]

Hi Swapnil,

Also, you can try telnetting the possible ports which can be assigned to your URL, if they are available for external communication or not.

Thanks & Regards,

Anuj