Windows Authentication login error
Duplicate: Invalid Windows Authentication Connection
I registered Windows Server ( Machine 1 ) as " abc \ user1 ". The Windows Server computer is in the abc domain. The MSSQL server is in domain "abc" on computer 1 and has mixed mode. Authentication. It has an account "abc \ user1" and "abc \ user2". Both have the role of sysadmin and serveradmin.
I logged into another computer ( Machine 2) using abc \ user2 . The same domain. Run ant that connect to MSSQL Server. The URL is formed as follows.
JDBC: SQLServer: //% DB_IP%:% DB_PORT%; SelectMethod = cursor; integratedSecurity = TRUE; database_name = database_name;
1) From Machine 2, if I use the credentials "abc \ user2" to connect, then it works fine. since integerSecurity = true.
2) From Machine 2, if I use the credentials "abc \ user1" to connect, it is not as integerSecurity = true and accepts the system credentials ie "abc \ user2". Even if I create integerececurity = false then it also fails to connect with "abc \ user1"
What changed is the url I created to work with "abc \ user1" from Machine2 to connect. what properties will be added to the url? OR Does the driver not support using a different domain \ User Credentials?
What should be installed on the MSSQL server?
Deepak
a source to share
When you use integrSecurity = true , you do not need to provide any credentials, the user who is currently logged in will be used to authenticate against the SQLserver.
If integratedSecurity = false . then you need to provide Sql server credentials (user and password) in connString
a source to share
I think Deepak wants to basically do this:
Data source = myServerAddress; Home directory = myDataBase; Integrated Security = SSPI; User ID = myDomain \ myUsername; Password = myPassword;
However, this only works on CE devices.
On normal machines, it goes to the Integrated part and uses the current credentials.
I think it wants to specify the domain user to use instead of the current login.
a source to share