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]

Can't Select Data Mining Technique....

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 Run any DM Until Delete Lost Cube?

I (unsuccessfully) made a cube named, MSR TRANCHES. I can't find any trace of it anymore. However, I can't make a new Mining Structure because VS complains of:

Error 1 File system error: Error opening file; \\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project1.0.db\MSR TRANCHES ~MC.1.cub.xml is not a disk file or file is not accessible. Errors in the metadata manager. An error occurred when loading the MSR TRANCHES ~MC cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project1.0.db\MSR TRANCHES ~MC.1.cub.xml'. 0 0

I can't find any cube anywhere, nor do I find this missing file. How does Visual Studio know to look and how do I clear this up.

Thank you very much,

I obtain the same error when I try to develop a mining structure. Anybody know the solution?

Thanks in advance.

|||The error you're seeing indicates that the database is corrupt (internal files associated with certain system objects are missing). If you don't have any other database/objects you need to save on the server, the workaround would be to shut down the AS2005 service (SQL Server Analysis Service (<instancename>)), delete the "\Program Files\Microsoft SQL Server\MSSQL.x\OLAP\Data" folder and restart the service.