I'm using Tomcat 5.0.28, installed the option to start as a windows
service, and my question relates to an issue I've posted earlier about
sqljdbc.
For some reason, I cannot get a connection to our sql database using a
simple JSP page.
I'm using this connection information:
Class.forName( "com.microsoft.sqlserver.jdbc.SQLServerDriver");
String connectionUrl =
"jdbc:sqlserver://SSQLB:1433;instanceName=gis;databaseName=permits;integ
ratedSecurity=true;";
Connection con = DriverManager.getConnection(connectionUrl);
When I use this information, I cannot get past "Login failed for user
'(null)'. Reason: Not associated with a trusted SQL Server connection."
My dba and sysadmin suggested trying to change the user account under
which Tomcat starts/runs. My dba won't create a sql login to test
whether I have a database connection issue or a Tomcat issue. I'd like
to bypass the "integratedSecurity" and see if a reqular sql login even
works. But that isn't an option for me today.
Changing the log on as user from "Local System account" to a domain
account seems straight forward. Under the Windows Services tool, I
double click Apache Tomcat and I specify the "This account", under the
"Log On" tab, and put in some domain\domain_name user, which has access
to the SQL Server view.
I stop and restart tomcat and I can't even get to http://localhost:8080
anymore. No Tomcat page.
What am I doing wrong here?
Leo Donahue
---------------------------------------------------------------------
To start a new topic, e-mail: [email protected]
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
