Welcome to ISAserver.org
Forums |
Register |
Login |
My Profile |
Inbox |
RSS
|
My Subscription |
My Forums |
Address Book |
Member List |
Search |
FAQ |
Ticket List |
Log Out
Connecting to MSDE database??
|
Users viewing this topic:
none
|
Logged in as: Guest
|
Login | |
|
Connecting to MSDE database?? - 9.Jun.2005 2:58:00 PM
|
|
|
dfosbenner
Posts: 116
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.
|
|
|
|
RE: Connecting to MSDE database?? - 13.Jun.2005 5:45:00 AM
|
|
|
tshinder
Posts: 46637
Joined: 10.Jan.2001
From: Texas
Status: offline
|
Hi Dave,
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.
Thanks! Tom
|
|
|
|
RE: Connecting to MSDE database?? - 13.Jun.2005 8:44:00 AM
|
|
|
crockettg
Posts: 3
Joined: 7.Dec.2003
From: Randolph AFB, TX
Status: offline
|
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
Have fun!
greg
|
|
|
|
RE: Connecting to MSDE database?? - 13.Jun.2005 9:12:00 AM
|
|
|
Jim Harrison
Posts: 214
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
|
|
|
|
RE: Connecting to MSDE database?? - 30.Jun.2005 7:46:00 AM
|
|
|
Guest
|
I'm having the same problem. However i have no idea about the ISA log database structure.
How can i do a osql script if i don't even know what fields to search.
Any idea what happens if i install SQl client tools on ISA server?
|
|
|
|
RE: Connecting to MSDE database?? - 29.Jan.2006 11:22:19 PM
|
|
|
mfhall
Posts: 10
Joined: 8.Jan.2006
Status: offline
|
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 >
|
|
|
|
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 |
|