Uninstalled CCR because of issues… Can't reinstall 1

[sayvandelay]

I uninstalled CCR because we kept getting errors, I intended to reinstall, so I left all housekeeping data in place. Problem is I don't know the CCR SQL db passwords, and can't re-install!!!

I really don't want to lose the historical data.

Any ideas?

 

[IanRichIcom]

Hi There,

Had similar issue and the only way to fix it is to re-install from scratch- sorry

Ian@Icom

http://www.icomtel.com

 

[jamie77]

Use windows authentication if you don't have the sa p/w??

Jamie Green

[bold]A[/bold]vaya [bold]R[/bold]egistered [bold]S[/bold]pecialist [bold]E[/bold]ngineer

 

[MankyWarrior]

err you can hack that password via very very basic SQL commands at the command prompt. I have done it before and it worked a treat, also dangerously easy. Google is your friend on this one

 

[MankyWarrior]

1. Start SQL Server Configuration Manager
2. Stop the SQL server service
3. Right click and go to it’s properties
4. Change the startup parameters of the SQL service by adding a “–m;“ in front of the existing parameters
5. Start the service
6. Go to the command prompt and type the following:
• sqlcmd -E -S server-ccr\sqlexpress (<-where server-ccr is the server name)
• CREATE LOGIN recovery WITH PASSWORD = 'passme'
• go
• sp_addsrvrolemember 'recovery','sysadmin'
• go
7. Stop the service again
8. Right click and go to it’s properties
9. Remove the added parameters
10. Start the service
11. Log into the database via Sql server management studio using the new account and password you created earlier in steps 6
12. Reset the sa password (you will find it under logins

 

[hairlessupportmonkey]

And if you call Avaya for help. They turn around and say "sorry we dont support SQL" so you say, "WTF! you tell us to install your crap onto MS SQL and you cant offer any support or advise?"

OK, so you got me started with CCR.....

ACSS - SME
General Geek

 

[sayvandelay]

Manky,

We are using a full SQL 2008 install. I'm assuming I should subsitute MSSQLSERVER for sqlexpress?

 

[sayvandelay]

Ok. Solved.

I put the service in single user using the -m; prefix on the service in advanced via sql service manager.

I reset the sa password, then put it back in normal by removing the -m;

I logged into the sql management studio and expanded the AvayaSBCCRT tables and found .tblUSERS

I edited the first 200 rows

I logged into CCR with a new user, it asks you to create a new password.

I copied that new password from the table to the Administrator user, restarted the db, and voila!!!!

I'm in!!