SQL Server and RTC authentication
Hello all,
I am attempting to setup RTC with SQL Server 2008. I used the SQL Server command create login clmdbowner with password secret; for use with all my CLM databases (jts, clm. etc). Now, in the setup, when I attempt to connect to the jts database via JDBC I am unable to authenticate. //localhost:1433;databaseName=jts;user=clmdbowner;password={password} Since the instructions say to use "create login" and not "create login with Windows" the user account is a SQL Server account and not a Windows account. Not sure that matters. Has anyone else seen this issue? Is there a way to test from the command line with JDBC? Cheers |
3 answers
Hello all, Hi Check if there is anything about using Windows authentication on SQLSever - it might be set up to expect a Windows login. anthony |
Hello all, Hi Check if there is anything about using Windows authentication on SQLSever - it might be set up to expect a Windows login. anthony Much obliged Anthony! That was, indeed, the root cause. I had forgotten about that once SQL Server was installed and configured. I changed the setting to mixed mode and I am now able to login. I'll open an RFE to add that to the documentation. Update: It does appear in the documentation and it is in my install notes has having been ticked. Unsure what happened but all's well that ends well! Cheers |
Sometimes I have a lucky guess :-) Glad you have this working now. anthony |
Comments
I'm having a similar problem. Well, I think my case is a little bit more complicated.
Yes it is. During setup you will be prompted for the database use credentials and you can specify the windows authentication creds then.