Connecting to MSDE database?? (Full Version)

All Forums >> [ISA Server 2004 Firewall] >> General



Message

dfosbenner -> Connecting to MSDE database?? (9.Jun.2005 2:58:00 PM)

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.



tshinder -> RE: Connecting to MSDE database?? (13.Jun.2005 5:45:00 AM)

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



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

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!



crockettg -> RE: Connecting to MSDE database?? (13.Jun.2005 8:44:00 AM)

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



Jim Harrison -> RE: Connecting to MSDE database?? (13.Jun.2005 9:12:00 AM)

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



Guest -> RE: Connecting to MSDE database?? (30.Jun.2005 7:46:00 AM)

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?



mfhall -> RE: Connecting to MSDE database?? (29.Jan.2006 11:22:19 PM)

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.



Page: [1]