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 Process cube created with ASCMD - XMLA script -

Hi,

I have an XMLA-script that I use for creating my cube. Creating the cube with the tool - ascmd - is not an issue but when I try to process the cube, I get the following message:
OLE DB error: OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.; 28000.

Strange because when I open the management studio -> look at my data source, all the correct information is there (server, user name, etc.), except for the password field in impersonation account editor, which is blanco.

The only way to process my AS DB is to open the data source editor and retype my password in the impersonation account editor. Once I've done that, I can process.

But as I want to automate the cube processing, I have a problem...

Anyone?

greets,
-Tom

Here's the solution:

<ImpersonationInfo>
<ImpersonationMode>ImpersonateAccount</ImpersonationMode>
<Account>mUserName</Account>
<Password>mPassword</Password>
</ImpersonationInfo>

I just had to add the password tag in my xmla-script...

This seems to be a bug, because while I was creating the cube in VS, I've set the option 'Remove passwords' in project properties to false.

Now the only thing that really bothers me is the fact that I have to put passwords in a script file (available to anyone). Anyone has an idea?

-Tom

Cant log into remote server

Hello everyone, I am having issues with connecting to

another database on the same network. I am creating a management system for the

company that I work for and I am currently working on the database side of it

and learning as I go along which means that I am fairly new but I think I have

got the basic concepts.

The system will have multiple databases at different locations.

The idea is for all the databases to have all the same data so that the system

can keep operating if the internet goes down.

The plan is to use the merge replication function within sql 2005 (currently working with the enterprise trial); I think I need to do

publications and subscriptions on all the databases to have the dataflow in 2

directions. In order to do this I need to setup users. I have created 1 user

with the same credentials to the 2 machines that the databases are running

from.

I have linked the users to sql with the correct privileges. I can connect to

one remote database, but when I try to connect to the other I get this message

"Login failed for user 'NEAL-LAPTOP\Guest'. (.Net SqlClient Data

Provider)" other information with this error "Server Name:

NEAL-LAPTOP Error Number: 18456 Severity: 14 State: 1 Line Number: 65536"

keep in mind that the user in not "Guest" and I am logged in as the

correct user.

I would appreciate if anyone can help me out with this

Hi,

you will have to disable the simple file sharing on the server machine. If activated incoming connections will be "authenticated" as the Guest user. Disabling that will force the client to pass the credentials.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de