Showing posts with label firewall. Show all posts
Showing posts with label firewall. Show all posts

Thursday, March 22, 2012

Can't Select Data Mining Technique....Cause: Issue with Firewall Software

Colleagues:

I'm working through the DM tutorials and I can't select a data mining technique when creating a new mining structure in BI Studio - BI Studio locks up totally. Have installed SQL Svr 20005 SP1 and components from feature pack. Analysis Server service is running, have set the properties in the DM project properties to the running instance of Analysis Services. Have read the various posts on the forum and have double checked my configuration - all seems as it should be.

All suggestions appreciated - very much looking forward to working with the technology.

Michael (michael.dataSense@.sympatico.ca)

We have Zone Alarm Pro installed on all our development boxes. When ZAP is shut down, the problem goes away. ZAP allows you to set access permissions on a machine for exe and dll files. As there are hundreds of interdependencies within the SQL Server system and the .NET Framework, I'm not sure exactly where the access issue is.

I'd be grateful for any suggestions, and I will follow up with Zone Labs.

Michael (michael.dataSense@.sympatico.ca)

|||

Hi Michael,

As far as I know, the firewalls track Internet access per process; my recommendation is to grant permission to the following EXEs: devenv.exe, sqlwb.exe and msmdsrv.exe.

On the server computer, for de default instance, you need to open TCP port 2383, unless you have customized that. If you have multiple instances, please take a look at a file named “msmdredir.ini” (most of the time under c:\Program Files\Microsoft SQL Server\90\Shared\ASConfig) – the section “Instances” enumerates what port is assigned to each instance. However, keep in mind that those assignments are random and may change if the service restarts.

Hope this helps,

--

Raymond [MSFT]

Can't Select Data Mining Technique....Cause: Issue with Firewall Software

Colleagues:

I'm working through the DM tutorials and I can't select a data mining technique when creating a new mining structure in BI Studio - BI Studio locks up totally. Have installed SQL Svr 20005 SP1 and components from feature pack. Analysis Server service is running, have set the properties in the DM project properties to the running instance of Analysis Services. Have read the various posts on the forum and have double checked my configuration - all seems as it should be.

All suggestions appreciated - very much looking forward to working with the technology.

Michael (michael.dataSense@.sympatico.ca)

We have Zone Alarm Pro installed on all our development boxes. When ZAP is shut down, the problem goes away. ZAP allows you to set access permissions on a machine for exe and dll files. As there are hundreds of interdependencies within the SQL Server system and the .NET Framework, I'm not sure exactly where the access issue is.

I'd be grateful for any suggestions, and I will follow up with Zone Labs.

Michael (michael.dataSense@.sympatico.ca)

|||

Hi Michael,

As far as I know, the firewalls track Internet access per process; my recommendation is to grant permission to the following EXEs: devenv.exe, sqlwb.exe and msmdsrv.exe.

On the server computer, for de default instance, you need to open TCP port 2383, unless you have customized that. If you have multiple instances, please take a look at a file named “msmdredir.ini” (most of the time under c:\Program Files\Microsoft SQL Server\90\Shared\ASConfig) – the section “Instances” enumerates what port is assigned to each instance. However, keep in mind that those assignments are random and may change if the service restarts.

Hope this helps,

--

Raymond [MSFT]

Friday, February 10, 2012

Can't get MSDE2000RelA to install

I am doing a test install on a XPsp2 with the firewall turned off prior to
prod on WinStd2003.
I just want a single install as the default instance?
This is my line:
c:\setup /settings "install.ini" /L*v C:/MSDELog.log
I tired c:\ instead of / thinking a typo...still no go.
The ini contains
[Options]
SAPWD="XXXXX"
DISABLENETWORKPROTOCOLS=0
DATADIR="C:\MSDE2000\"
SECURITYMODE=SQL
Per
http://msdn.microsoft.com/library/?u...asp?frame=true
I tired copying all the 16msi to the setup dir. It is acting like it wants
a msi file specified?
All it does is throw up a GUI Window Installer showing the switches for:
Windows Installer. V 3.00.3790.2180
msiexec /Option <Required Parameter> [Optional Parameter]
Install Options
</package | /i> <Product.msi>
Installs or configures a product
/a <Product.msi>
Administrative install - Installs a product on the network
/j<u|m> <Product.msi> [/t <Transform List>] [/g <Language ID>]
Advertises a product - m to all users, u to current user
</uninstall | /x> <Product.msi | ProductCode>
Uninstalls the product
Display Options
/quiet
Quiet mode, no user interaction
/passive
Unattended mode - progress bar only
/q[n|b|r|f]
Sets user interface level
n - No UI
b - Basic UI
r - Reduced UI
f - Full UI (default)
/help
Help information
Restart Options
/norestart
Do not restart after the installation is complete
/promptrestart
Prompts the user for restart if necessary
/forcerestart
Always restart the computer after installation
Logging Options
/l[i|w|e|a|r|u|c|m|o|p|v|x|+|!|*] <LogFile>
i - Status messages
w - Nonfatal warnings
e - All error messages
a - Start up of actions
r - Action-specific records
u - User requests
c - Initial UI parameters
m - Out-of-memory or fatal exit information
o - Out-of-disk-space messages
p - Terminal properties
v - Verbose output
x - Extra debugging information
+ - Append to existing log file
! - Flush each line to the log
* - Log all information, except for v and x options
/log <LogFile>
Equivalent of /l* <LogFile>
Update Options
/update <Update1.msp>[;Update2.msp]
Applies update(s)
/uninstall <PatchCodeGuid>[;Update2.msp] /package <Product.msi |
ProductCode>
Remove update(s) for a product
Repair Options
/f[p|e|c|m|s|o|d|a|u|v] <Product.msi | ProductCode>
Repairs a product
p - only if file is missing
o - if file is missing or an older version is installed (default)
e - if file is missing or an equal or older version is installed
d - if file is missing or a different version is installed
c - if file is missing or checksum does not match the calculated value
a - forces all files to be reinstalled
u - all required user-specific registry entries (default)
m - all required computer-specific registry entries (default)
s - all existing shortcuts (default)
v - runs from source and recaches local package
Setting Public Properties
[PROPERTY=PropertyValue]
Consult the Windows Installer SDK for additional documentation on the
command line syntax.
Copyright Microsoft Corporation. All rights reserved.
Portions of this software are based in part on the work of the Independent
JPEG Group.
Suggestions?
hi,
CD wrote:
> I am doing a test install on a XPsp2 with the firewall turned off
> prior to prod on WinStd2003.
> I just want a single install as the default instance?
did you get an error installing MSDE?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks for the reply
According to the command it should have created a log...no log exist as
specifed on the switch
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:36et5uF50pbjlU1@.individual.net...
> hi,
> CD wrote:
> did you get an error installing MSDE?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi,
CD wrote:
> Thanks for the reply
> According to the command it should have created a log...no log exist
> as specifed on the switch
>
try
c:\...\>setup /L*v "C:/MSDELog.log"
enclosing the file name...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I tired and it started to insall...I cancelled.
I then went to the ini
I was trying to add some comment for future reference. I was using // to
comment the line.
I changed them to ;
Sorry ... I should have posted all the ini...
I guess I screwed myself...I had searched locally and found some ini that
had both ; and //
I guess ; is prefered.
I am up and running...
THANK YOU FOR YOUR HELP!
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:36etmrF52uobqU1@.individual.net...
> hi,
> CD wrote:
> try
> c:\...\>setup /L*v "C:/MSDELog.log"
> enclosing the file name...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>