Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Uninstalled CCR because of issues… Can't reinstall 1

Status
Not open for further replies.

sayvandelay

IS-IT--Management
Nov 30, 2009
26
US
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?
 
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
 
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
 
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
 
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

 
Manky,

We are using a full SQL 2008 install. I'm assuming I should subsitute MSSQLSERVER for sqlexpress?
 
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!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top