February 22, 2009 at 10:29 am
Hi all,
I spent one week on this problem and still stuck here. Could anyone spend a little time and help me, this would benefit other newbies like me as well. So many thanks in advance.
The problem is dat I am using Microsoft SQL Server Management Studio Express, and when I connect to the server (localhost) with the default userid, password it is working fine or with using the authentication mode of Windows Auth, it seems still nice to me. However, when I changed to use the other account (the database, login account and password will be configured as long as the Tomcat starts so the account and password should be correct), I got the following error:
- Login failed for user 'XXX'. (Microsoft SQL Server, Error: 18456)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
With the state of 5 meaning the userid is incorrect.
After that I change to the encryption mode, the following error appears:
- A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 0 - The certificate's CN name does not match the passed value.) (Microsoft SQL Server, Error: -2146762481)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-2146762481&LinkId=20476
What you guys suspect is the problem? I create a self-certificate or other types of certificate, but in the Configuration Manager, I can't add the certificate in the drop-box list, in the error log it also mentioned that the can not register with the SPN for the SQL Service, I did add my computer even I am using localhost but it seems in vain as well....
February 22, 2009 at 3:05 pm
Do you use PeopleSoft or Lawson application in your connection? Lawson system uses its own security tunnel to access SQL Server. If so, please ask your vendor for help. I used these applications several years ago. My skills are rusted.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply