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 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy