wood burning stoves 2.0*
The moose likes JDBC 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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Problem in making connection" Watch "Problem in making connection" New topic
Author

Problem in making connection

Parham Emami
Greenhorn

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.

Age
 
Consider Paul's rocket mass heater.
 
subject: Problem in making connection
 
Similar Threads
Strange SQLException
How to convert Blob Type back to File
Tomcat 5.0 throws "cannot creat PoolableConnectionFactory"
forum regarding insert data
No ResultSet set was produced