sql reporting pack
|
Logged in as: Guest
|
|
Users viewing this topic:
none
|
|
Login  | |
|
sql reporting pack - 15.Sep.2009 2:13:06 AM
|
|
|
tasdevil
Posts: 13
Joined: 14.Jun.2009
Status: offline
|
hi,
new to sql which is probably (definately) my problem and i'm wanting to get the reporting pack installed.
I have installed sql express 2008 with sp1 (is this compatible??) on server 2008r2, created a table called webmon, using the oldest compatibility method. Have enabled tcp/ip, enabled the IP address in the tcp/ip properties in sql configuration. In SQL management studio, I somehow got my name in there as a user added myself as a user, windows authentication, and ticked all the boxes under server roles. the sql browser service is running.
On the isa machine (which is a member of the domain), on installing the report pack, i type in;
sql\sqlexpress as the server (it doesnt come up in the pulldown list, only the local machine does), webmon as the table, and domain\myusername as the user (and appropriate password). When i click Next i get error 27502 could not connect to microsoft sql server..... login failed for user domain\myusername.
windows firewall is turned off
Any ideas or is there a nice guide on installing the reporting pack i can look at. i dont know anything about sql so forgive anything stupid i have done please!
thanks
< Message edited by tasdevil -- 15.Sep.2009 2:33:01 AM >
|
|
|
|
|
RE: sql reporting pack - 15.Sep.2009 11:29:12 AM
|
|
|
DrewE
Posts: 1058
Joined: 28.Apr.2008
From: Cary, NC
Status: offline
|
Does the ISA server allow communication on port 1433 to the SQL server ?
_____________________________
Drew Easley - Technical Support Representative
GFI Software - www.gfi.com
|
|
|
|
|
RE: sql reporting pack - 15.Sep.2009 6:28:00 PM
|
|
|
tasdevil
Posts: 13
Joined: 14.Jun.2009
Status: offline
|
yes it does, i allowed all outbound from localhost (isa) to the sql server. I have run netmon on the sql server and it shows traffic on the logon request.
also, when i create the table in sql, am i supposed to do anything with it (ie. define the fields)
any other ideas? Dont discount the obvious as im new to sql server
thank you
|
|
|
|
|
RE: sql reporting pack - 16.Sep.2009 5:50:35 AM
|
|
|
Anthonys
Posts: 16
Joined: 30.May2008
Status: offline
|
Can you please ensure that the SQL Browser Service is running.
This service is responsible for the following:
Browsing a list of available servers
Connecting to the correct server instance
Connecting to dedicated administrator connection (DAC) endpoints
If it is stopped it would explain why the server is not listed in the dropdown list and why you cannot connect remotely.
_____________________________
Regards,
Anthony Spiteri
GFI Software - www.gfi.com
Messaging, Content Security & Network Security Software
|
|
|
|
|
RE: sql reporting pack - 16.Sep.2009 11:59:41 PM
|
|
|
tasdevil
Posts: 13
Joined: 14.Jun.2009
Status: offline
|
Thanks anthony! Checked that out - SQL Browser service is running (perhaps being 2008 server and isa running on 2003 the browsing doesnt work between them).
no firewall on sql server and allow all rule from isa to sql.
Typing anything other than sql\sqlexpress on the reporting install says server cannot be found. Typing sql\sqlexpress says login failed for user craig
Considering this and as i see traffic from netmon on the sql server i think it is a security issue with sql.
Here are the steps i do to create the webmon database:
1. run ms sql-server management studio, logon (windows authentication) - sql\sqlexpress.
2. right click on databases, select new database
3. type webmon as the database name, change owner to me (craig - whom i previously added to Security/Logins)
4. goto options, change compatibility to sql 2000 (80) - thought it wouldnt hurt.
5. click ok.
is there any more i have to do?
thank you
< Message edited by tasdevil -- 17.Sep.2009 12:01:13 AM >
|
|
|
|
|
RE: sql reporting pack - 17.Sep.2009 4:02:45 AM
|
|
|
Anthonys
Posts: 16
Joined: 30.May2008
Status: offline
|
If you try to logon to the SQL Server Management Studio using SQL Server Authentication and entering the Logon you created instead of using Windows Authentication are you able to logon?
_____________________________
Regards,
Anthony Spiteri
GFI Software - www.gfi.com
Messaging, Content Security & Network Security Software
|
|
|
|
|
RE: sql reporting pack - 17.Sep.2009 4:58:24 AM
|
|
|
tasdevil
Posts: 13
Joined: 14.Jun.2009
Status: offline
|
Hi Anthony
i dont get the option, its windows authentication only.
At home at the moment, I have been reading some docs just now it indicates you need to enable both windows authentication and sql authentication for remote access to work. this may be the issue???
|
|
|
|
|
RE: sql reporting pack - 17.Sep.2009 5:05:50 AM
|
|
|
Anthonys
Posts: 16
Joined: 30.May2008
Status: offline
|
Yes this could very well be the issue, SQL Authentication has to be enabled to be able to connect remotely using an SQL logon.
_____________________________
Regards,
Anthony Spiteri
GFI Software - www.gfi.com
Messaging, Content Security & Network Security Software
|
|
|
|
|
RE: sql reporting pack - 17.Sep.2009 9:19:47 PM
|
|
|
tasdevil
Posts: 13
Joined: 14.Jun.2009
Status: offline
|
YEH!!!!!!!! some success - thank you - i have managed to install the reporting center now thanks.
next possible problem:
gfi monitor Configuration/Reporting, says triggered now next to status (i clicked the button Update Reporting Data now). I guess thats good. How long before I view reports in the reporting centre? I have waited 5 mins and it doesnt work "Failed to get recordset for main report"
Also, netmon shows lots of these
249 32.205078 {SMB:80, TCP:66, IPv4:0} ISASERVER SQL SMB SMB:C; Nt Create Andx, FileName = \sql\query
250 32.205078 {SMB:80, TCP:66, IPv4:0} SQL ISASERVER SMB SMB:R; Nt Create Andx - NT Status: System - Error, Code = (52) STATUS_OBJECT_NAME_NOT_FOUND
i never like the look of the word error..... <grin> is this normal?
|
|
|
|
|
RE: sql reporting pack - 18.Sep.2009 2:43:47 AM
|
|
|
Anthonys
Posts: 16
Joined: 30.May2008
Status: offline
|
Depending on how many history database files you have and how large they are, the time can largely vary, especially since this is your first time creating information for reporting.
Another thing you must be sure of, is that inside the WebMonitor ReportPack you have to set the database source to the one you created.
This can be done by opening the Report Pack, go to "Options", right click on "Database Source", and then select "Set Database Source". Then enter the information similar to the way you did inside of the WebMonitor configuration.
_____________________________
Regards,
Anthony Spiteri
GFI Software - www.gfi.com
Messaging, Content Security & Network Security Software
|
|
|
|
|
RE: sql reporting pack - 20.Sep.2009 6:26:01 PM
|
|
|
tasdevil
Posts: 13
Joined: 14.Jun.2009
Status: offline
|
hi anthony,
i left it over the weekend, still no good. :(
I have specified the same info in the reporting module as in webmon.
I clicked update in webmon console, reporting this morning, still getting heaps of those object not founds in webmon. Also, in the SQL console, if I expand out the "webmon" database, no tables have been created or anything. The user specified to log into the database is set as the owner of the database so i would imagine this user would have permissions to create tables???
|
|
|
|
|
RE: sql reporting pack - 22.Sep.2009 5:35:08 AM
|
|
|
Anthonys
Posts: 16
Joined: 30.May2008
Status: offline
|
In order to futher assist you, can you please open a support request with us online at http://support.gfi.com/Support/support.aspx?lcode=en and reference this thread in your email?
Thanks
_____________________________
Regards,
Anthony Spiteri
GFI Software - www.gfi.com
Messaging, Content Security & Network Security Software
|
|
|
|
RE: sql reporting pack - 22.Sep.2009 7:13:29 PM
|
|
|
tasdevil
Posts: 13
Joined: 14.Jun.2009
Status: offline
|
YEAH!!!! Guess what - it started working all by itself this morning :) Funny how when you threaten it with a support call it starts working <grin>
Thank you for all your help. Very much appreciated.
(For anyone else reading this, gfi does webmon automatically create its own tables, etc, in sql).
|
|
|
|
|
RE: sql reporting pack - 23.Sep.2009 2:09:03 AM
|
|
|
Anthonys
Posts: 16
Joined: 30.May2008
Status: offline
|
Glad to see that it is working and yes GFI WebMonitor does create all of the tables inside SQL Server, all that you need to create is an empty database.
_____________________________
Regards,
Anthony Spiteri
GFI Software - www.gfi.com
Messaging, Content Security & Network Security Software
|
|
|
|
 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
