SQL Connection Failling

[Former Member]

Hi,

I am trying to activate Active portal for the first time and it is getting failed.

I was able to login to SQL server and I even added my user id with read write permission in the SQL server.

When I checked in logs I found this.

Fatal error while filling connection pool for jdbc:inetdae:usalxap1:1433?database=ActivePortal&sql7=true com.inet.tds.SQLException: []Login failed for user 'XXXXX'. at com.inet.tds.e.a(Unknown Source) at com.inet.tds.e.a(Unknown Source) at com.inet.tds.e.<init>(Unknown Source) at com.inet.tds.TdsDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at com.lighthammer.Illuminator.tools.database.ConnectionPool.createConnectionObject(ConnectionPool.java:318) at com.lighthammer.Illuminator.tools.database.ConnectionPool.fill(ConnectionPool.java:263) at com.lighthammer.Illuminator.tools.database.ConnectionPool.initialize(ConnectionPool.java:129) at com.lighthammer.Illuminator.tools.database.ConnectionPool.<init>(ConnectionPool.java:41) at com.lighthammer.Illuminator.tools.database.ConnectionHolder.addDBConnectionPool(ConnectionHolder.java:121) at com.lighthammer.Illuminator.server.Server.createHolder(Server.java:231) at com.lighthammer.Illuminator.server.Server.setEnabled(Server.java:114) at com.lighthammer.Illuminator.server.Server.parseProperties(Server.java:212) at com.lighthammer.Illuminator.server.Server.<init>(Server.java:40) at com.lighthammer.Illuminator.server.ServerManager.add(ServerManager.java:81) at com.lighthammer.Illuminator.server.ServerManager.update(ServerManager.java:143) at com.lighthammer.Illuminator.gui.handlers.ServerHandler.processServer(ServerHandler.java:232) at com.lighthammer.Illuminator.gui.handlers.ServerHandler.process(ServerHandler.java:75) at com.lighthammer.Illuminator.servlet.Admin.service(Admin.java:50) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.newatlanta.servletexec.SERequestDispatcher.forwardServlet(SERequestDispatcher.java:638) at com.newatlanta.servletexec.SERequestDispatcher.forward(SERequestDispatcher.java:236) at com.newatlanta.servletexec.SERequestDispatcher.internalForward(SERequestDispatcher.java:283) at com.newatlanta.servletexec.SEFilterChain.doFilter(SEFilterChain.java:96) at com.lighthammer.cms.system.CMSFilter.doFilter(CMSFilter.java:140) at com.newatlanta.servletexec.SEFilterChain.doFilter(SEFilterChain.java:60) at com.newatlanta.servletexec.ApplicationInfo.filterApplRequest(ApplicationInfo.java:2159) at com.newatlanta.servletexec.ApplicationInfo.processApplRequest(ApplicationInfo.java:1823) at com.newatlanta.servletexec.ServerHostInfo.processApplRequest(ServerHostInfo.java:937) at com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:1091) at com.newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java:973) at com.newatlanta.servletexec.ServletExecService.processServletRequest(ServletExecService.java:167) at com.newatlanta.servletexec.ServletExecService.Run(ServletExecService.java:204) at com.newatlanta.servletexec.HttpServerRequest.run(HttpServerRequest.java:487)

Can some one help me.

Thanks,

Srinivas.

[Former Member · Accepted solution]

Make sure the SQL Server is set up for SQL Server AND Windows Authentication mode. xMII connects to SQL Server using SQL Server Authentication and most default installs of SQL Server are only set up for Windows Authentication.

You can check this in Enterprise Manager by selecting the Properties of the DB Server and looking at the Security settings.

[Former Member · Accepted solution]

Ryan,

I just checked it. It was set up as SERVER and WINDOWS.

Anyother thoughts.

Thanks,

Srinivas.

[Former Member · Accepted solution]

Are you sure you are entering the correct username AND password?

[Former Member · Accepted solution]

Ryan,

Once again I checked my user id and password after seeing your message.

Still it didn't worked.

Any more.....

Srinivas.

[Former Member · Accepted solution]

Is 'usalxap1' the same server as xMII? If it is, try changing that to localhost.

If it isn't the same server, can you ping usalxap1 from the xMII server?

[Former Member · Accepted solution]

Ryan,

They are same, and I changed it to localhost and still doesn't work.

Thanks,

Srinivas.

[Former Member · Accepted solution]

Try connecting to the database using SQL Server Query Analyzer and make sure to login as the same user you are trying to connect xMII with.

[Former Member · Accepted solution]

Ryan,

YUP.. I got the same error as Login failed for user "xxxxx" through query analyzer. I am entirely new to SQL server side. Can you suggest me what I need to do.

Thanks,

Srinivas.

[Former Member · Accepted solution]

Ah! Well now we know the problem is on the SQL Server side!

First, see if you can connect by using the default SQL Server Admin "sa" username and password. Then, check the settings for the user "xxxxx". Query Analyzer may give you a more specific error message than xMII. If it does, you can Google it.

[Former Member · Accepted solution]

Ryan,

Thanks you very much. the mistake is I didn't added my user into users list in ActivePortal. After adding my user id it connected again.

Srinivas.