Re: Problem upgrading Microsoft Office Accounting Professional from 2008 to 2009 using SQL Express 2008
- From: "Rick Byham, \(MSFT\)" <rickbyh@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 19 Jan 2009 09:19:58 -0800
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" <gerald_barber_100@xxxxxxx> wrote in message news:90F7AE41-E094-424E-A534-C9ABF43A41DF@xxxxxxxxxxxxxxxx
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
.
- Follow-Ups:
- References:
- Prev by Date: Help: Problem upgrading Microsoft Office Accounting Professional from 2008 to 2009 using SQL Express 2008
- Next by Date: Re: Problem upgrading Microsoft Office Accounting Professional from 2008 to 2009 using SQL Express 2008
- Previous by thread: Help: Problem upgrading Microsoft Office Accounting Professional from 2008 to 2009 using SQL Express 2008
- Next by thread: Re: Problem upgrading Microsoft Office Accounting Professional from 2008 to 2009 using SQL Express 2008
- Index(es):
Relevant Pages
|
