WebMonitor 2009 & Reporting Database Problem
|
Logged in as: Guest
|
|
Users viewing this topic:
none
|
|
Login  | |
|
WebMonitor 2009 & Reporting Database Problem - 21.May2009 5:40:10 AM
|
|
|
bad_request
Posts: 5
Joined: 21.May2009
Status: offline
|
Hi;
I installed MsSql Server 2008 and then installed GFI WebMonitor and GFI WebMonitor Report Pack. All installations done successfully but no database create on MsSql.
After then i uninstall all GFI products, create webmon database on Mssql server manually and i install webmonitor and report pack, installations done successfully again but no tables in my webmon database.
On GFI monitor management page reporting tab, there is a some settings. I enabled Reporting check box, set SQL Server user, password and database (on table webmon database  ), click Update Reporting Now, but nothing change it database, webmon database table still blank.
Could you help me please ?
|
|
|
|
|
RE: WebMonitor 2009 & Reporting Database Problem - 22.May2009 8:34:09 AM
|
|
|
bad_request
Posts: 5
Joined: 21.May2009
Status: offline
|
Yes i use it, bu nothing change...
|
|
|
|
|
RE: WebMonitor 2009 & Reporting Database Problem - 22.May2009 11:15:13 AM
|
|
|
DrewE
Posts: 1246
Joined: 28.Apr.2008
From: Cary, NC
Status: offline
|
A. Open ODBC Data Sources
1. -Click button Windows 'Start'
2. -Select from list 'Control Panel'
3. -Double click on icon 'Administrative Tools'
4. -Double click on icon 'Data Sources (ODBC)'
B. -Register your database
1. -Select tab 'System DSN'
2. -Click button 'Add'
C. -Select your driver
1. -Select from list 'Sql Server'
2. -Click button 'Finish'
D. -Fill in the data
1. Choose the real database name of for your database
2. Fill in possibly a description
3. Choose which SQL server you want to connect to
(you might have to start your Microsoft SQL server first so
that it can be found when you click on the list, and or
install it on your local machine, if not already done)
e.g. <yoursqlservername>
e.g. TEST
(e.g. the name of the Microsoft SQL server
installed on your computer, to see which name,
hold e.g. your cursor above the Microsoft SQL server
name on the taskbar) or you can skip the name if you are working locally, by using (local)
4. -In the screen 'How should SQL Server verify the authenticity of the login ID?'
i. -Enable radio button 'With SQL Server authentication
using a login ID and password entered by the user'
ii. -Enable checkbox 'Connect to SQL Server to obtain default
settings for the additional configuration options'
1. Enter a 'Login ID'
e.g.
sa
2. Enter a password
5. -Click button 'Next'
6. -Enable checkbox 'Change the default database to'
1. -Select from list the database created for GFI
E. -Click button 'Next'
F. -Click button 'Finish'
You should now see information similar to
the following: Please copy and paste the information into a reply to this e-mail.
--- cut here: begin --------------------------------------------------
Microsoft SQL Server ODBC Driver Version 03.81.9042
Data Source Name: northwind
Data Source Description: test
Server: (local)
Database: (Default)
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Integrated Security: Yes
Use Regional Settings: No
Prepared Statements Option: Drop temporary procedures on disconnect Use Failover Server: No Use ANSI Quoted Identifiers: Yes Use ANSI Null, Paddings and Warnings: Yes Data Encryption: No
--- cut here: end ----------------------------------------------------
7. Test, by clicking
button 'Test Data Source'
If should show information similar
to the following: Copy and paste the information below to me as well please.
--- cut here: begin --------------------------------------------------
Microsoft SQL Server ODBC Driver Version 03.81.9042
Running connectivity tests...
Attempting connection
Connection established
Verifying option settings
Disconnecting from server
TESTS COMPLETED SUCCESSFULLY!
--- cut here: end ----------------------------------------------------
3. -You should now see that in the tab 'System DNS'
your database name (e.g. 'northwind') has been added
4. -Click button 'OK'
(These instructions are taken and modified from the following source: http://www.faqts.com/knowledge_base/view.phtml/aid/33020/fid/147)
_____________________________
Drew Easley
GFI Software
Talk Tech To Me (GFI Blog) – Follow Us (Twitter) - Watch Us (YouTube) - Join us (Facebook)
|
|
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
 Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts |
|
|
Printable Version
