Access 2003 Upsizing Wizard does not work.

[isolomon]

I can not get the Upsizing Wizard to work.
System is:
XPPro
SQLServer 2k Developer
Access 2003
Norton Firewall

I can get the Wizard to run on my laptop, same OS and SQL. Access 2002, no firewall.

No matter what I do, when I run the Upsizing Wizard it always tells me the it can't find the server or access denied. I've tried both kinds of authentication to no avail.
I am the Admin. I have granted myself every permission I can find.
I can go into EM and work with the DBs. I can link them to Access via ODBC and it works.
I updated the MDAC libraries.
I suspect the Firewall but I have disabled it to no avail.
Any help would be appreciated

 

[John Nurick]

I'm no expert on SQLS or the upsizing wizard, but the fact that you see
the firewall as a factor makes me suspicious. If the SQL server is on
the other side of a firewall it's presumably also on the other side of a
VPN or WAN ... and unless there's documentation to the contrary I'd
assume that the upsizing wizard assumes that the SQL server is on the
LAN.

 

[david epsom dot com dot au]

1) Check that the you are using TCP/IP for connections,
not named pipes.

2) Check that you have TCP/IP enabled on your network.

3) I have not used the 2K3 upsizing wizard. Is it trying
to start from an OLEDB or native SQL connection? Try using
ADO to test the connection, using connection strings that
doesn't use ODBC, to see if you can identify a problem there.

(david)

I can not get the Upsizing Wizard to work.
System is:
XPPro
SQLServer 2k Developer
Access 2003
Norton Firewall

I can get the Wizard to run on my laptop, same OS and SQL. Access 2002, no firewall.

No matter what I do, when I run the Upsizing Wizard it always tells me the

it can't find the server or access denied. I've tried both kinds of
authentication to no avail.