Accounting 2009 Pro on SQL Server 2008 Express

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 Microsoft Office Accounting Professional from 2008 to 2009 using SQL Express 2008

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 

3.how can I upgrade accounting express 2008 to 2009

I am currently using Microsoft Office Accounting Express 2008 in the UK.

Can I upgrade this to Microsoft Office Accounting Express 2009 (UK Version)

4.SQL Server 2008 Express connection from Visual Studio 2009 (C# .net)

Hi

I have SQL Server Express 2008 installed, along with Visual Studio
2009. I'm coding in C# .net for windows mobile 5.

I've successfully added a new Data Connection to testing things out,
and this connects fine and I can browse tables, etc within Visual
Studio.

I can also connect using osql on the command line using "osql -S BEN-
PC
\SQLEXPRESS -U scanner"

However, when I want to connect in my code, using SQLConnection, I'm
having problems

If I view the properties of the data connection I created, is says the
connection string is:

"BEN-PC\SQLEXPRESS;Initial Catalog=bentest;User
ID=scanner;Password=xxxx" (** This works when connecting using Visual
Studio Server Explorer**)

So I've set my connection string in my code to

myCon = new SqlConnection();
myCon.ConnectionString = "Data Source = BEN-PC\\SQLEXPRESS;Initial
Catalog=bentest;User ID=scanner;Password=xxxx";
myCon.Open();

However I get the error "Specified SQL Server not found: BEN-PC
\SQLEXPRESS".

I've read that I might need to connect without the instance name, so I
tried just "Data Sorouce = BEN-PC; ..."

This gave the same error. I've also tried replacing BEN-PC with my ip
address, but no luck.

This occurs whether I'm using an emulator, or a windows mobile device
(directly connected to my pc via USB. The database is on the
development machine).

So, how can I successfully connect from my code? I've looked all over
for examples but many are for sql server 2005 and everything seems
different for 2008.

Thanks in advance

Ben

5.Accounting Express 2008 installation and SQL Server 2008 Express

Using the Advanced Setup and the Select the SQL instance name Office 
Accounting should use, I am attempting to point Accounting Express to SQL 
Server Express 2008 and there is no instances of SQL Server 2008 Express in 
the drop down box.  I have even typed in my SQL Server 2008 Express Instance 
Name and I am getting an Instance Name is Incorrect error.

What am I doing incorrect?

Thank you.

6. BCM Admin Tool on a Windows 2008 x64 Server running SQL 2008

7. MOAPro 2009 on SBS 2008 with SQL 2008

8. Importing Excel data into SQL 2008 Express server?