Encore Pro Analyzer for 64bit Windows

[jskinner]

I have released an tiny update to Encore Pro Analyzer to allow it to work on 64bit versions of Windows. It should work on the 64bit versions of Windows Vista and Windows.

Download EPA Version 0.9 from http://james.istop.com/EncoreProAnalyzer/

Let me know if you have any problems.

[builta]

James,

Having issue with your 64 bit program. When I go to install it it tells me that it is not a valid Win32 application and refuses to install. Using Vista 64 bit

[jskinner]

When I go to install it it tells me that it is not a valid Win32 application and refuses to install.

That's usually a file download corruption problem. Download the installer again and PM me if the problem continues.

[deerhound]

Works great on Windows 7 RC 64 bit.
Thanks James.
Dale

[builta]

When I go to install it it tells me that it is not a valid Win32 application and refuses to install.

That's usually a file download corruption problem. Download the installer again and PM me if the problem continues.

Hi again,

I uninstalled the original attempt and redownloaded the setup file and reinstalled it. The installation completed. So, that worked but, I still cannot launch the program under Vista 64 Bit. It now fails when EPA is launched and reports that it cannot attach to the SQL Server. Everything for Encore Pro v1.8.49 was installed normally except for following Gregor's process to make it operate under Vista 64 Bit

viewtopic.php?f=1&t=40234&st=0&sk=t&sd=a&hilit=gregor.

I've been using Encor Pro v 1.8.49 for months now under Vista 64 and it runs just fine. Even went back after EPA failure and confirmed that I can still launch Encore Pro--and Encore Pro continues to function normally.

Thanks for your effoert and assistance.

[Ender519]

Same here, was initially unable to get it to run under Vista x64 Ultimate, Encore Pro 1.8.49

"A network-related or instance-specific error occurred while establishing a connection to SQL server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. Named Pipes Provider, error: 40 - Could not open a connection to SQL Server"

That said, I was able to fix it with some tinkering around and Google, and here's how. I believe this is because of some of the default settings for SQL 2005 on Vista x64

1. Configure SQL to allow TCP/IP and Named Pipes connections
a. Go to Start --> Run --> cliconfg.exe
b. On General tab, enable "Named Pipes" and "TCP/IP". Leave the properties settings on these to default.
c. Press OK.

2. Open ports and programs in the Windows Firewall
a. Go to Start --> Control Panel --> Windows Firewall
b. On left, click on "Allow a Program through Windows Firewall"
c. Click "Add Port", name SQL 1, Port number 1433, TCP, press OK.
d. Click "Add Port", name SQL 2, Port number 1434, TCP, press OK.
e. Click "Add Program, Browse, navigate to "C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe" This assumes you installed it on C: drive.
f. Click "Add Program, Browse, navigate to "C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" This assumes you installed it on C: drive.
g. Press OK.

3. Configure SQL networking to use port 1433
a. Go to Start --> All Programs --> Microsoft SQL Server 2005 --> Configuration Tools --> SQL Server Configuration Manager
b. Click on SQL Server 2005 Network Configuration (32 bit)
c. Click on Protocols for <DATABASE NAME>
d. Over on the right hand pane, double click TCP/IP
e. Click on IP Addresses tab
f. Scroll to the bottom to find "IPAll" section
g. If there is a value for TCP Dynamic Ports, delete it. There should be nothing here. Change TCP Port to 1433."
h. On the left pane, go to "SQL Server 2005 Services", you should see two services running.
i. Right click on each service and restart it. This is necessary to enact the changes.

You should now be able to run Encore Pro Analyzer. Have fun!

- Sean

[jskinner]

That said, I was able to fix it with some tinkering around and Google, and here's how. I believe this is because of some of the default settings for SQL 2005 on Vista x64

Sean, Thanks. (It would be interesting to know which of those steps actually fixes the problems or if they are all necessary.)

I which someone could figure out the password that Encore Pro uses to log into the SQL database. If we could figure out that it would no longer be necessary to run EPA as admin...

-James

[builta]

Same here, was initially unable to get it to run under Vista x64 Ultimate, Encore Pro 1.8.49

"A network-related or instance-specific error occurred while establishing a connection to SQL server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. Named Pipes Provider, error: 40 - Could not open a connection to SQL Server"

That said, I was able to fix it with some tinkering around and Google, and here's how. I believe this is because of some of the default settings for SQL 2005 on Vista x64

1. Configure SQL to allow TCP/IP and Named Pipes connections
a. Go to Start --> Run --> cliconfg.exe
b. On General tab, enable "Named Pipes" and "TCP/IP". Leave the properties settings on these to default.
c. Press OK.

2. Open ports and programs in the Windows Firewall
a. Go to Start --> Control Panel --> Windows Firewall
b. On left, click on "Allow a Program through Windows Firewall"
c. Click "Add Port", name SQL 1, Port number 1433, TCP, press OK.
d. Click "Add Port", name SQL 2, Port number 1434, TCP, press OK.
e. Click "Add Program, Browse, navigate to "C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe" This assumes you installed it on C: drive.
f. Click "Add Program, Browse, navigate to "C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" This assumes you installed it on C: drive.
g. Press OK.

3. Configure SQL networking to use port 1433
a. Go to Start --> All Programs --> Microsoft SQL Server 2005 --> Configuration Tools --> SQL Server Configuration Manager
b. Click on SQL Server 2005 Network Configuration (32 bit)
c. Click on Protocols for <DATABASE NAME>
d. Over on the right hand pane, double click TCP/IP
e. Click on IP Addresses tab
f. Scroll to the bottom to find "IPAll" section
g. If there is a value for TCP Dynamic Ports, delete it. There should be nothing here. Change TCP Port to 1433."
h. On the left pane, go to "SQL Server 2005 Services", you should see two services running.
i. Right click on each service and restart it. This is necessary to enact the changes.

You should now be able to run Encore Pro Analyzer. Have fun!

- Sean

Thanks Sean,

After following your procedure EPA will now launch but does not run right still have lots of errors. But the program launches. I'll work on the errors later today and summarize. Basically, it says "Unhandlesed errors occured in you application......."

Thanks for your help.

[janp]

James,

Thank you for the Vista 64 update. I'm running the Vista 64 Home Premium Edition.

I've downloaded it and am still wandering through the various functions.

I confess that I am NOT Windows literate and that may be the root of my problem with EPA.

I'd appreciate help on the following ...

I right click on the program's icon and select "run as an Administrator". However, after I've closed the program and re-opened it ... it denies me access and I have to go back in and go through the selection of "run as an Administrator" all over again.

Why doesn't the "run as an Administrator" selection stay active after I've closed and re-opened the program? Why do I have to keep "re-selecting" it? What am I doing wrong?

Jan

[janp]

I just ran across another problem ...

Why can't I print directly from the report that is "on screen"?

The print function doesn't seem to work.

Thanks.

Jan

[jskinner]

I right click on the program's icon and select "run as an Administrator". However, after I've closed the program and re-opened it ... it denies me access and I have to go back in and go through the selection of "run as an Administrator" all over again.

Why doesn't the "run as an Administrator" selection stay active after I've closed and re-opened the program? Why do I have to keep "re-selecting" it? What am I doing wrong?

Jan,

You need to right click and then go into properties. Then select the tab 'Compatibility' and select the 'run as an Administrator'

When you select the 'Run as Administrator' from the right click menu its just for that single execution.

[janp]

I right click on the program's icon and select "run as an Administrator". However, after I've closed the program and re-opened it ... it denies me access and I have to go back in and go through the selection of "run as an Administrator" all over again.

Why doesn't the "run as an Administrator" selection stay active after I've closed and re-opened the program? Why do I have to keep "re-selecting" it? What am I doing wrong?

Jan,

You need to right click and then go into properties. Then select the tab 'Compatibility' and select the 'run as an Administrator'

When you select the 'Run as Administrator' from the right click menu its just for that single execution.

James,

Thank you for the response.

OK ... so each time that I want to run the Analyzer, I find the program icon and right click to run it as the administrator.

Sorry, I thought that once selected, it stayed that way until changed.

Jan

[junie]

Keeps telling me I need to down load .net frame, I been doing nothing but downloading these thing for a couple of hours, It still
won't download,

[jskinner]

OK ... so each time that I want to run the Analyzer, I find the program icon and right click to run it as the administrator.
Sorry, I thought that once selected, it stayed that way until changed.

If you follow the directions you will only need to do it once.

[rocketdork]

Same here, was initially unable to get it to run under Vista x64 Ultimate, Encore Pro 1.8.49

"A network-related or instance-specific error occurred while establishing a connection to SQL server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. Named Pipes Provider, error: 40 - Could not open a connection to SQL Server"

That said, I was able to fix it with some tinkering around and Google, and here's how. I believe this is because of some of the default settings for SQL 2005 on Vista x64

1. Configure SQL to allow TCP/IP and Named Pipes connections
a. Go to Start --> Run --> cliconfg.exe
b. On General tab, enable "Named Pipes" and "TCP/IP". Leave the properties settings on these to default.
c. Press OK.

2. Open ports and programs in the Windows Firewall
a. Go to Start --> Control Panel --> Windows Firewall
b. On left, click on "Allow a Program through Windows Firewall"
c. Click "Add Port", name SQL 1, Port number 1433, TCP, press OK.
d. Click "Add Port", name SQL 2, Port number 1434, TCP, press OK.
e. Click "Add Program, Browse, navigate to "C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe" This assumes you installed it on C: drive.
f. Click "Add Program, Browse, navigate to "C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe" This assumes you installed it on C: drive.
g. Press OK.

3. Configure SQL networking to use port 1433
a. Go to Start --> All Programs --> Microsoft SQL Server 2005 --> Configuration Tools --> SQL Server Configuration Manager
b. Click on SQL Server 2005 Network Configuration (32 bit)
c. Click on Protocols for <DATABASE NAME>
d. Over on the right hand pane, double click TCP/IP
e. Click on IP Addresses tab
f. Scroll to the bottom to find "IPAll" section
g. If there is a value for TCP Dynamic Ports, delete it. There should be nothing here. Change TCP Port to 1433."
h. On the left pane, go to "SQL Server 2005 Services", you should see two services running.
i. Right click on each service and restart it. This is necessary to enact the changes.

You should now be able to run Encore Pro Analyzer. Have fun!

- Sean

Thanks for the detailed information...but I'm running on Windows 7 beta, and there are several differences. I'm hopeful that someone can help.

There is no Run, I've done a search for CLICONFIG.exe, no joy
Windows Firewall is completely different...
I don't find anything on the start/all programs menu that indicates that I even have SQL server installed...and I can't find it in the control panel.

HELP, I'd really like to be able to use EPA!!!