October 18, 2002 at 4:46 pm
Quick question:
One programer uses Tomcat to connect to my SQL2K box with MS JDBC for SQL. My box is Mixed Mode Auth. However the programer can't connect with the error:
Cannot connect to jdbc:microsoft:sqlserver://xxx.xxx.xxx.xxx:xxxx/database=xxxxxxxxx&user=xxxxxxx&Password=xxxxxxx, reason:java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Rows:0
Why can't he connect with this specific error when my box is in mixed mode? How to fix it?
Thx.
October 18, 2002 at 5:04 pm
If you use a sql login and it fails, it'll try to use a trusted connection - well, in ADO world anyway! I'd double check how you're defining your connection.
Andy
October 18, 2002 at 5:19 pm
My SQL box is at an Exodus data center. All developers are sitting at local office. So absolutely SQL must be mixed mode to authenticate the logins. However before I got the this notification:
DATE/TIME:10/18/2002 3:41:19 PM
DESCRIPTION:18452
Login failed for user '(null)'. Reason: Not associated with a trusted SQL
Server connection.
COMMENT:(None)
JOB RUN:(None)
Now I got:
DATE/TIME:10/18/2002 3:49:00 PM
DESCRIPTION:18456
Login failed for user 'xxxxx'.
COMMENT:(None)
JOB RUN:(None)
I don't have the connection string from the programer yet.
October 18, 2002 at 5:22 pm
Forgot to mention that this login ID has read and write permissions to the database used in the connection string.
November 11, 2002 at 5:27 pm
Finally it works.
The developer just said it is something with the driver itself; he tried to blame me at first for the login fail error though.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply