[isalist] Re: Allowing sql connections

  • From: "Jim Harrison" <Jim@xxxxxxxxxxxx>
  • To: <isalist@xxxxxxxxxxxxx>
  • Date: Tue, 8 May 2007 12:49:05 -0700

http://www.ISAserver.org
-------------------------------------------------------
  
Do not attempt to copy, delete, shrink, expand, colorize or otherwise
mangle ISA MSDE log files directly or from another machine.
ISA and MSDE own all live databases and any database "adjustment" while
it's in use will cause ISA failure.

MSDE databases will not grow beyond 2GB, and so will not benefit from
your attempts to adjust them.

-----Original Message-----
From: isalist-bounce@xxxxxxxxxxxxx [mailto:isalist-bounce@xxxxxxxxxxxxx]
On Behalf Of Michael Ross
Sent: Tuesday, May 08, 2007 11:25 AM
To: isalist@xxxxxxxxxxxxx
Subject: [isalist] Re: Allowing sql connections

http://www.ISAserver.org
-------------------------------------------------------
  
I have a couple DBs that are nearing 1.8 GB, and I wanted to use SQL'
manager to shrink the databases and the log files, but I cannot do this.
I can connect to MSDE on other servers.
 

-----Original Message-----
From: isalist-bounce@xxxxxxxxxxxxx [mailto:isalist-bounce@xxxxxxxxxxxxx]
On Behalf Of Jim Harrison
Sent: Tuesday, May 08, 2007 10:32 AM
To: isalist@xxxxxxxxxxxxx
Subject: [isalist] Re: Allowing sql connections

http://www.ISAserver.org
-------------------------------------------------------
  
This:
"I have a couple servers that ive setup to allow to connect to the ISA
box via sql, editing the system policy and allowing them on the remote
logging sql section"
..doesn't make sense..

There is *NO* system policy to allow remote connections to ISA-local
MSDE and with good reason.
What exactly are you trying to accomplish?

-----Original Message-----
From: isalist-bounce@xxxxxxxxxxxxx [mailto:isalist-bounce@xxxxxxxxxxxxx]
On Behalf Of Michael Ross
Sent: Tuesday, May 08, 2007 8:17 AM
To: isalist@xxxxxxxxxxxxx
Subject: [isalist] Allowing sql connections

http://www.ISAserver.org
-------------------------------------------------------
  
I have a couple servers that ive setup to allow to connect to the ISA
box via sql, editing the system policy and allowing them on the remote
logging sql section..
But.. I cannot connect to MSDE using SQL 2005's SQL manager. I can
connect to other MSDE databases using this manager.
Im thinking my ISA box is extra, extra secured, and I cannot determine
where its locked down so tight. I also think this is why I cannnot
configure it to log to the sql server.

Ideas?
------------------------------------------------------
List Archives: //www.freelists.org/archives/isalist/
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server Articles and Tutorials:
http://www.isaserver.org/articles_tutorials/
ISA Server Blogs: http://blogs.isaserver.org/
------------------------------------------------------
Visit TechGenix.com for more information about our other sites:
http://www.techgenix.com
------------------------------------------------------
To unsubscribe visit http://www.isaserver.org/pages/isalist.asp
Report abuse to listadmin@xxxxxxxxxxxxx 


All mail to and from this domain is GFI-scanned.

------------------------------------------------------
List Archives: //www.freelists.org/archives/isalist/
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server Articles and Tutorials:
http://www.isaserver.org/articles_tutorials/
ISA Server Blogs: http://blogs.isaserver.org/
------------------------------------------------------
Visit TechGenix.com for more information about our other sites:
http://www.techgenix.com
------------------------------------------------------
To unsubscribe visit http://www.isaserver.org/pages/isalist.asp
Report abuse to listadmin@xxxxxxxxxxxxx 

------------------------------------------------------
List Archives: //www.freelists.org/archives/isalist/  
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp 
ISA Server Articles and Tutorials:
http://www.isaserver.org/articles_tutorials/ 
ISA Server Blogs: http://blogs.isaserver.org/ 
------------------------------------------------------
Visit TechGenix.com for more information about our other sites:
http://www.techgenix.com 
------------------------------------------------------
To unsubscribe visit http://www.isaserver.org/pages/isalist.asp 
Report abuse to listadmin@xxxxxxxxxxxxx 


All mail to and from this domain is GFI-scanned.

------------------------------------------------------
List Archives: //www.freelists.org/archives/isalist/  
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp 
ISA Server Articles and Tutorials: http://www.isaserver.org/articles_tutorials/ 
ISA Server Blogs: http://blogs.isaserver.org/ 
------------------------------------------------------
Visit TechGenix.com for more information about our other sites:
http://www.techgenix.com 
------------------------------------------------------
To unsubscribe visit http://www.isaserver.org/pages/isalist.asp 
Report abuse to listadmin@xxxxxxxxxxxxx 

Other related posts: