It's not a secret anymore!
The moose likes JDBC and Relational Databases and the fly likes Problem in making connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Problem in making connection" Watch "Problem in making connection" New topic

Problem in making connection

Parham Emami

Joined: Jul 11, 2003
Posts: 15
OS: Windows XP - Pro
IDE: Jbuilder 7
JDBC driver: Microsoft JDBC Driver
DBMS: MS SQLServer 2000
my Authentication mode inside SqlServer is both windows and SQLServer. But when I want to connect to db from my java program with the followingurl:
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=parham1","myWindows UID","myWindowsPWD";
I get the following Exception:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC] [SQLServer]Login failed for user 'myWindowsUID'.
Thank you for your help and support
age spets
Ranch Hand

Joined: Aug 07, 2002
Posts: 68
same problem here...
age spets
Ranch Hand

Joined: Aug 07, 2002
Posts: 68
Problem fixed:

When register user on SQL-Server, define user as SQL user on security and not windows user. Make sure yu also have mixed mode on authorization.

I agree. Here's the link:
subject: Problem in making connection
It's not a secret anymore!