By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,718 Members | 1,220 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,718 IT Pros & Developers. It's quick & easy.

Linked Access DB to SQL 2005 Express

P: n/a
I have a two computer workgroup. On my laptop I moved Access tables
to SQL 2005Express and linked them. I use Access as the front end and
everything works from the laptop. Both the access files and the SQL
files are in the shared folder. I have given Everyone user full
rights to the shared folder. When I attempt to use my desktop to
access the linked access files the following error occurs on the

Connection Failed
Connection state: 28000
SQL Server Error: 19456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login Failed for user

The laptop SQL log file says:
Error: 18456, Severity:14, State: 11
Login failed for user 'laptop\guest'.

When I attempt to use a SQL user that has admin rights to the SQL
database from the desktop the same error message occurs.

XP Professional
Access 2002
SQL2005 Express- Mixed Authentication
Simple file sharing is unchecked
No firewalls
XP Professional
Access 2003
SQL2005 Express-Laptop SQL2005 database is registered

Why can't I access the database from the desktop?
Why does it only see it as 'laptop\guest' user?

Any suggestions would be appreciated.

Feb 23 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.