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]