Networks

Ask something
Discussion Locked

SQL Server connection problem

0 helpful
3 replies

by hunterzh

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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"?

3 replies

by dean144

For this user, you need to provide Database Access permission. Go to Security, Logins, select the User, right click, select Properties, then on the Database Access tab, select the dbs that the user should be able to access.

by gizmo59

I am assuming here you installed MSDE on your local pc. One of the things you may want to look at,is when you installed verify that you are authenticating with SQL server and Windows NOT just Windows Authentication. Check the properties on user1. Under security/users verify that the default database is the db you are logging into. Using SQL Analyzer try opening a connection using the ID/PW that you set up in SQL. Also check your connection string and make sure of all coding is correct. Hope this helps.

by trublue

Make sure TCP/IP connection to SQL Server is enabled.

To enable TCP/IP connection to MSDE 2000

- Run c:\program files\microsoft sql server\80\tools\binn\svrnetcn.exe

This discussion is closed to new replies.