avaz_1 Absent Member.
Absent Member.
1570 views

DB Connection failing while installing HP OO Central 9.00

Jump to solution

Hi All,

 

I am new to HP OO and also to Windows platforms. Mostly i am unix guy.

 

I am trying to install HP OO 9.00 on Win2k8 R2.

I have setup MS SQL Server 2008 R2 successfully. When i provide the details of MS SQL Server during the Central installation, it fails during "Test Database Connection" and i get the error popup saying

 

"Could not connect to database. Log files at: "C:\Users\.........". Would you like to view it?"

 

I have attached the screen shot and also the log file.

 

I have also disabled UAC and Firewall.

 

Any help would be highly appreciated.

 

Thanks,

Ashraf

 

Labels (1)
0 Likes
1 Solution

Accepted Solutions
Trusted Contributor.. jarodb Trusted Contributor..
Trusted Contributor..

Re: DB Connection failing while installing HP OO Central 9.00

Jump to solution
You need to create a database for oo prior to running the installer
//Actively seeking HPOO opportunities
0 Likes
10 Replies
Trusted Contributor.. jarodb Trusted Contributor..
Trusted Contributor..

Re: DB Connection failing while installing HP OO Central 9.00

Jump to solution
Wouldnt your instance be mssqlserver (assuming that is your instance name) and the database be what youre going to utilize as the db for oo?
//Actively seeking HPOO opportunities
0 Likes
avaz_1 Absent Member.
Absent Member.

Re: DB Connection failing while installing HP OO Central 9.00

Jump to solution

Yes, "mssqlserver" is my MS SQL Server instance name.

I am using this DB instance on the same host for OO.

 

Attached the screenshot with the details that i am providing for OO during installation.

 

Thanks,

Ashraf

 

0 Likes
Trusted Contributor.. jarodb Trusted Contributor..
Trusted Contributor..

Re: DB Connection failing while installing HP OO Central 9.00

Jump to solution
Can you post the error reported by mssql from the event log?
//Actively seeking HPOO opportunities
0 Likes
avaz_1 Absent Member.
Absent Member.

Re: DB Connection failing while installing HP OO Central 9.00

Jump to solution

Here it is:

 

 

Log Name: Application
Source: MSSQLSERVER
Date: 4/19/2013 10:34:42 AM
Event ID: 18456
Task Category: Logon
Level: Information
Keywords: Classic,Audit Failure
User: N/A
Computer: ashraf-cdl
Description:
Login failed for user 'sa'. Reason: Failed to open the explicitly specified database. [CLIENT: 127.0.0.1]
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQLSERVER" />
<EventID Qualifiers="49152">18456</EventID>
<Level>0</Level>
<Task>4</Task>
<Keywords>0x90000000000000</Keywords>
<TimeCreated SystemTime="2013-04-19T05:04:42.000000000Z" />
<EventRecordID>739</EventRecordID>
<Channel>Application</Channel>
<Computer>ashraf-cdl</Computer>
<Security />
</System>
<EventData>
<Data>sa</Data>
<Data> Reason: Failed to open the explicitly specified database.</Data>
<Data> [CLIENT: 127.0.0.1]</Data>
<Binary>184800000E0000000B0000004100530048005200410046002D00430044004C000000070000006D00610073007400650072000000</Binary>
</EventData>
</Event>

 

Thanks,

Ashraf

 

0 Likes
Trusted Contributor.. jarodb Trusted Contributor..
Trusted Contributor..

Re: DB Connection failing while installing HP OO Central 9.00

Jump to solution
Can you post the user defined databases expanded in ssms?
//Actively seeking HPOO opportunities
0 Likes
avaz_1 Absent Member.
Absent Member.

Re: DB Connection failing while installing HP OO Central 9.00

Jump to solution

as i am new learner, Can you please let me know how do i get that information?

 

Thanks,

Ashraf

 

0 Likes
Trusted Contributor.. jarodb Trusted Contributor..
Trusted Contributor..

Re: DB Connection failing while installing HP OO Central 9.00

Jump to solution
Login to sql server management studio (ssms) - probably under - start > program files > microsoft sql server
Once logged in
Expand databases
Expand user defined
//Actively seeking HPOO opportunities
0 Likes
avaz_1 Absent Member.
Absent Member.

Re: DB Connection failing while installing HP OO Central 9.00

Jump to solution

There is no User defined DBs under Databases.

 

Find attached the screen shot for the same.

 

Thanks,

Ashraf

 

0 Likes
Trusted Contributor.. jarodb Trusted Contributor..
Trusted Contributor..

Re: DB Connection failing while installing HP OO Central 9.00

Jump to solution
You need to create a database for oo prior to running the installer
//Actively seeking HPOO opportunities
0 Likes
avaz_1 Absent Member.
Absent Member.

Re: DB Connection failing while installing HP OO Central 9.00

Jump to solution

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.