Cannot Connect To SQL Server.

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 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 SolomonTry forcing a "shared memory" connection by putting "lpc:" before the name.
For example, if the instance name is MyServer\MyInstance, the servername of
lpc:MyServer\MyInstance will force it to connect with shared memory. If
it's a named instance you should also consider that the firewall may be
blocking UDP port 1434 which would mean you have to specify the port in the
connection string for TCP to work:
tcp:MyServer\MyInstance,1111 (if the sql error log shows that sql is
listening on tcp port 1111).
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.|||Cindy:
Thanks.
'lpc:" works like a charm.
I knew about memory sharing but Books Online make no mention of lpc.
I just looked at some other online versions of books and I can't find it
there either.
This is a great help as I really need to use the large screen of the
desktop.
Ira
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!