This sounds like your SQL server may be running off of Windows NT authentication, taking (simply passing, like through Active Directory possibly) your network logon credentials. Are you logging on to a network through Windows each morning? Try that logon combo, if so. See if it doesn't pass those credentials through.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 16, 2008 7:42 PM To: users@tomcat.apache.org Subject: username/password in DataSource configuration Hi everyone, The connection to SQL server in my machine is by default so username and password are not needed to login. In this case, what should I specify in <Resource.../> for username and password attributes? I tried not to include them but got an error of "Login failed for user ''. The user is not associated with a trusted SQL Server connection." <Context path="/DBTest" docBase="DBTest" debug="5" reloadable="true" crossContext="true"> <Resource name="jdbc/EmployeeDB" auth="Container" type=" javax.sql.DataSource" username="<user name>" password="<pwd>" driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver" url="jdbc:sqlserver://localhost:1433;databaseName=EmployeeDB" maxActive="8" maxIdle="4"/> </Context> Thanks. --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
