This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problem in making connection

 
Parham Emami
Greenhorn
Posts: 15
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 68
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
same problem here...
 
age spets
Ranch Hand
Posts: 68
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

Age
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic