[AccessD] Access 2007 Upsizing Wizard Missing

Doug Murphy dw-murphy at cox.net
Mon Feb 17 17:14:18 CST 2014


This can be done from SQL Server Management Studio. See
http://technet.microsoft.com/en-us/library/ms140052.aspx. Your problem may
be that the tool your trying to use does not recognize the newer version of
SQL Server. That is a guess on my part.

Doug

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Monday, February 17, 2014 2:45 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access 2007 Upsizing Wizard Missing

Jim,

As suggested, I installed SSMA and tried to run it. Step 1, Choose an Access
database, worked fine. Step 2, Connect to SQL Server, failed. The message
suggests that I ensure that SQL Server is configured to allow remote
connections (provider: Named Pipes provider, error 40 - Could not open a
connection to SQL Server)

I have SSMS open at the moment. The server name is (localhost) and it works
fine. I'm using the same server name in SSMA but getting the error above.

I've forgotten how to check that remote connections are allowed. Can you (or
someone else) remind me?

Thanks,
Arthur


On Mon, Feb 17, 2014 at 1:45 PM, Arthur Fuller
<fuller.artful at gmail.com>wrote:

> Thanks, Jim. I also recall a 3rd Party implementation from SSW 
> Software in Australia. Maybe I'll have a look there as well as Googling
SSMA.
>
> Arthur
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list