Help: Problem upgrading Microsoft Office Accounting Professional from 2008 to 2009 using SQL Express 2008

Similar Threads:

1.Problem upgrading Microsoft Office Accounting Professional from 2008 to 2009 using SQL Express 2008

I don't know anything about MOA. However, if you can connect to your SQL 
Server Express Edition locally, but cannot connect remotely, and if the SQL 
Server Express Edition is listening on Named Pipes, then I suspect a 
firewall issue on the computer that is running SQL Server Express Edition. 
In particular, make sure that UDP port 1434 is open so that the SQL Server 
Browser Service on the SQL Server Express computer can provide the named 
pipe name to the client component.
Is there any particular reason you are connecting by using named pipes? 
Perhaps you should try TCP/IP?
-- 
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Gerald Barber" < XXXX@XXXXX.COM > wrote in message 
news: XXXX@XXXXX.COM ...
>I tried posting this in the Microsoft Small Business Accounting Forum and 
>have written to John Thuneby directly and have not received a response. 
>Since the problem appears to involve some sort of interaction between 
>Microsoft Office Accounting Professional(MOA) and SQL Express 2008 
>hopefully someone in this forum will understand the error message I'm 
>receiving and can suggest some possible solutions for me to try.
>
> I'm trying to upgrade my MOA installation from the 2008 to the 2009 
> release. The accounting data itself is contained in a SQL Express 2008 
> database. While this is not the standard configuration for MOA 2009 (the 
> standard configuration uses the 2005 version of SQL Express), using the 
> 2008 version of SQL Express should be a viable configuration. 
> Specifically, John Thuneby at Microsoft has written  "Whilst we didn't 
> have time to switch SQL Express 2005 out with SQL Express 2008 when it 
> finally became ready (we shipped Office Accounting 2009 months ago), we do 
> support the newer and faster SQL in Office Accounting Professional. You 
> can basically
> install SQL Server 2008 first, and then choose to install the client only 
> of Office Accounting and point to SQL 2008."
>
> However, when I try this I receive the following error message: "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. (provider: Named Pipes 
> Provider, error 30 - Could not open a connection to SQL Server)"
>
> I verified that the server is configured to allow remote connections and 
> the 2008 version of the MOA software, which is still installed on my 
> computer, has no problem connecting to it.
>
> Does anyone have any idea what I should do or try next? Thanks.
>
> Jerry 

2.Help: Problem upgrading MOA 2009 using SQL Sever 2008

Has anyone been successful or does anyone know how to upgrade MOA 2008 to 
MOA 2009 when using SQL Server 2008 for the database engine? This is a 
supported option according to John Thuneby: "Whilst we didn't have time to 
switch SQL Express 2005 out with SQL Express 2008 when it finally became 
ready (we shipped Office Accounting 2009 months ago), we do support the 
newer and faster SQL in Office Accounting Professional. You can basically 
install SQL Server 2008 first, and then choose to install the client only of 
Office Accounting and point to SQL 2008," revealed John Thuneby, Microsoft 
senior program manager." However, when I try this I receive the following 
error message: "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. (provider: Named Pipes Provider, 
error 30 - Could not open a connection to SQL Server)"

I verified that the server is configured to allow remote connections and MOA 
2008 has no problem connecting to it.

Does anyone have any idea what I should do or try next? Thanks.

Jerry

 

3.Accounting 2009 Pro on SQL Server 2008 Express

Hi there

MSOA 2009 Pro (Microsoft Office Accounting 2009 Professional) comes standard 
with Microsoft SQL Server 2005 Express.

Is it possible (as the setup suggests it is), to install MSOA 2009 Pro onto 
SQL Server 2008 (not 2005) Express?

I have performed the installation of both correctly and pointed the MSOA to 
the SQL 2008 Express using the MSOA Data Tools. It reports that the instance 
cannot be found.

I have also setup an ODBC to change the instance from the, default MSOA 
"MSSMLBIZ" to the default SQL "SQLEXPRESS", to no avail.

Regards

4.Installation Problem of Office Accounting 2008 on SQL Server 2008

Hi,

I think I cannot install Office Accounting 2008 (Professional Edition) and 
use my existing SQL Server 2008 (Standard Edition).

How can I do this?

Thanks!



-- 
Regards,

Maximilian Haru Raditya