SQL Server connection problem - TechRepublic
General discussion
August 31, 2005 at 08:00 AM
hunterzh

SQL Server connection problem

by hunterzh . Updated 20 years, 10 months ago

I?ve installed SQL Server 2000 on my computer, also built an Access project to connect it. In SQL Server Enterprise Manager, I set up a new user, for example, “user1”; but from the Access project file (.adp), cannot use user1 to connect with database.
I just set up in Enterprise Manager (local) ? Security ? Logins, new user “user1”, Server Access “Permit”; also in that specific database, Users, add user “user1”, Database Access “Permit”.
What else do I need to set up, in order to connect database from my adp file using “user1”?

This discussion is locked

All Comments