Access 2003 Upsizing Wizard won't connect to SQL Server -
01-25-2004
, 01:54 PM
I'm relatively new to SQLServer. On one machine I have Access 2002
and the Developers edition of SQLServer 2000 and the Upsizing Wizard
works fine. On the other machine I have the same version of
SQLServer, but Access 2003. No matter what I have tried I can't get
the 2003 Wizard to connect to SQLServer. It tells me it can't find
the server or access denied. I have set SQL Server to mixed
authentication and have tried both domain and SQL login, and have
failed both ways.
I don't think I'm doing anything different on this machine, with one
exception. I am using a Firewall (Norton) on the machine that fails.
I tried disabling it, but I still have the problem. I can link to SQL
Tables via ODBC so the server is working. It is only the Wizard that
is having problems (perhaps he was a Hogwarts dropout). Any help
would be appreciated.
Thanks
Ira Solomon |