dbTalk Databases Forums  

Access 2003 Upsizing Wizard won't connect to SQL Server

comp.database.ms-access comp.database.ms-access


Discuss Access 2003 Upsizing Wizard won't connect to SQL Server in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ira Solomon
 
Posts: n/a

Default 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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.