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: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to