Welcome to ISAserver.org

Connecting to MSDE database??

Users viewing this topic: none

Logged in as: Guest

Printable Version

All Forums >> [ISA Server 2004 Firewall] >> General >> Connecting to MSDE database??

Page: [1]

Message

<< Older Topic Newer Topic >>

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.

Post #: 1

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

(in reply to dfosbenner)

Post #: 2

RE: Connecting to MSDE database?? - 13.Jun.2005 5:54:00 AM

RuiFiske

Posts: 92
Joined: 8.Dec.2004
From: London
Status: offline

Hi Dave,

You are supposed to able to connect to an MSDE instance using Enterprise Manager or osql. Here are some KB articles:

How To Connect to Microsoft Desktop Engine

How To Manage the SQL Server Desktop Engine (MSDE 2000) by Using the Osql Utility

Although I have briefly tried to do this, I have not yet had much success.

Let us know if you do manage it!

Tom, this is something that a lot of people would like to be able to do. Might be worth an article?

Hope this helps!

(in reply to dfosbenner)

Post #: 3

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

(in reply to dfosbenner)

Post #: 4

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

(in reply to dfosbenner)

Post #: 5

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?

(in reply to dfosbenner)

Post #: 6

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 >

(in reply to Guest)

Post #: 7