Forum
Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal Installation
 Reversion of SQLServer caused login failure
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dbooth

United Kingdom
69 Posts

Posted - 09/21/2012 :  12:31:39  Show Profile  Reply with Quote
As the version of SQL Server 2008R2 on our live machine was an Evaluation one (thanks to the DBA) I've had to revert back to 2008 R2 Standard. SQL is functioning, however I can't log into ReportPortal, errors with 'Login failed for user odbc' (which is the standard user for the application).

No changes were made to IIS or to the app prior to the backup - uninstall - reinstall - restore process.

xmla.udl is reporting a login failure for user odbc.

Does RP have to be reinstalled following a database change or is there a simple solution?

Thanks,
Dave Booth

admin

1609 Posts

Posted - 09/21/2012 :  14:46:12  Show Profile  Reply with Quote
Are you able to login to the ReportPortal database with odbc user using SQL Server Management Studio?

Please try to create new login and user (odbc2) that would have access to ReportPortal database. Change xmla.udl to use the new user.
Go to Top of Page

dbooth

United Kingdom
69 Posts

Posted - 09/22/2012 :  03:56:52  Show Profile  Reply with Quote
Sorry, I'm a twit. I had set SQL up in Windows Authentication Mode instead of Mixed Mode.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Forum © ReportPortal Go To Top Of Page
Snitz Forums 2000