Database Password

Question

Database Password

casper197634

Valued Member

Points: 68
More actions
May 21, 2018 at 4:49 am

#356476

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 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

Thom A SSC Guru Points: 99130 More actions · Answer 1

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

casper197634 Valued Member Points: 68 More actions · Answer 2

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

Thom A SSC Guru Points: 99130 More actions · Answer 3

casper197634 - Monday, May 21, 2018 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

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

casper197634 Valued Member Points: 68 More actions · Answer 4

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

Thom A SSC Guru Points: 99130 More actions · Answer 5

casper197634 - Monday, May 21, 2018 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

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

HappyGeek SSCoach Points: 18729 More actions · Answer 6

casper197634 - Monday, May 21, 2018 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

It sounds like you have an application logon set up between the os and SQL, Thom is correct in saying check the logs.

...

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 7

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.