File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 Head First Android this week in the Android 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
jQuery in Action, 3rd edition