May 21, 2018 at 4:49 am
Hi
I use Control M for batch activity. When installing Control M you specify db names and passwords. However, when trying to run a reporting tool specifying the db owner and password it says password not recognised even though I know it is correct. I don' have the sa password so is it possible to amend the db password using cmd for example?
Thanks
May 21, 2018 at 6:57 am
A database, in SQL Server, doesn't have a password; each login has a password. I'm not familiar with Control M, but it sounds like you're provided the wrong credentials. I'd suggest having a look at the logs and seeing that they say too.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 21, 2018 at 6:59 am
Hi
Thanks for the reply. I still have all my documenation from when I installed it with the password that I specified for the username in question. Unless someone else has changed it but as far as I am concerned it is still what I have listed in my install docs
Cheers
May 21, 2018 at 7:05 am
casper197634 - Monday, May 21, 2018 6:59 AMHiThanks for the reply. I still have all my documenation from when I installed it with the password that I specified for the username in question. Unless someone else has changed it but as far as I am concerned it is still what I have listed in my install docs
Cheers
Installed what, SQL Server? In your initial post you stated you don't have the sa password. I wouldn't, however, suggest using the sa account for an application anyway, create it's own login.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 21, 2018 at 7:41 am
Sorry, I meant, when I installed Control-M, I specified the username and password, and to my knowledge that password is still the same as the one in my documentation
May 21, 2018 at 7:46 am
casper197634 - Monday, May 21, 2018 7:41 AMSorry, I meant, when I installed Control-M, I specified the username and password, and to my knowledge that password is still the same as the one in my documentation
OK, but did you create that login on the SQL Server? I'm getting the idea here that that isn't the case. Have you checked the logs yet as well; what did they say?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
May 21, 2018 at 8:45 am
casper197634 - Monday, May 21, 2018 4:49 AMHiI use Control M for batch activity. When installing Control M you specify db names and passwords. However, when trying to run a reporting tool specifying the db owner and password it says password not recognised even though I know it is correct. I don' have the sa password so is it possible to amend the db password using cmd for example?
Thanks
It sounds like you have an application logon set up between the os and SQL, Thom is correct in saying check the logs.
...
May 21, 2018 at 8:59 am
My reading of this is that you installed SQL Server, created a login and/or user, and assigned a password. You then entered this in your Control M application. Is that right?
You can change a login or database user password, but you need credentials in SQL Server that can do this. If you don't have sa/sysadmin/security admin access, you can't do this. You can restart SQL Server in single user mode, and potentially connect as a local windows admin and change the sa password. Then you could change the credentials inside SQL Server.
May 25, 2018 at 6:13 am
This was removed by the editor as SPAM
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply