Posts: 129
Joined: 14.Nov.2001
From: Maybrook, NY USA
Status: offline
I am posting this question here because there's not much activity over in Reporting, and I really need to figure this out ASAP.
I have ISA2004 up and running, I'm using MSDE logging, and I'm trying to access the logs on the ISA Server itself via ANYTHING that will read from SQL Server, and I can't do it.
I've tried ISAlyzer, Netfee, Crystal Reports, etc - all of these need to connect to the MSDE database, but I can't seem do that. Instead I get "server doesn't exist or access denied." What am I missing?
I need to dump all activity for about 5 users on a daily basis. If I could connect to the MSDE, it would be pretty simple.
Any help would be greatly appreciated. I've gone through the entire Reporting forum, and Tom's 2004 book, to no avail. Microsoft has explained zilch in this area.
I'm not aware of a way to do this, but I'm not a DBA sort of guy. So its likely there is a way and I don't know what it is. Maybe hang out in some DBA forums somewhere? I see if I can find out anything and call in reinforcements.
David, If my memory servers me right, I recall a post from Jim on isaserver that stated MSDE instance on ISA does not listen to the network -- providing you are using MSDE SQL that accompanied isa2k4. I believe this is your biggest problem. However, you can configure ISA to log to another msde or standard/enterprise SQL on the network. Look at this: http://support.microsoft.com/default.aspx?scid=kb;en-us;838710
Posts: 266
Joined: 5.May2001
From: Redmond, WA
Status: offline
The MSDE instance for ISA is intentionally "unbound" from the network. The last thing you need is another Slammer" hitting your ISA...
What you can do is this: 1. create an osql script that reads the previous day's logs into a remote SQL server 2. schedule that script on the ISA scheduled tasks for "daily" 3. create an access rule that allows SQL traffic from localhost to the remote SQL
ISA MSDE does not advertise. When setting-up connection, just enter the server info manually (rather than search): servername\MSFW This works on the server itself, getting to it from a remote workstaion is not so easy- I got it working once (changing FW rules) but it doesn't work for me now.
-10 mutes later see http://forums.isaserver.org/fb.aspx?m=320015611 (mntquist). Running SVRNETCN.exe GUI and enabling TCP/IP works (for remote access)- I would advise (as others have) allowing only restricted IPs to use access the ISA server this way.
< Message edited by mfhall -- 29.Jan.2006 11:38:53 PM >
|
My Subscription |
My Forums |
Address Book |
Member List |
Search |
FAQ |
Ticket List |
Log Out
Printable Version
All Forums >> [ISA Server 2004 Firewall] >> General >> Connecting to MSDE database?? 
Connecting to MSDE database?? - 
RE: Connecting to MSDE database?? - 
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