Home Forums Discussions Problems SQL Server Connection Error (Domain network issue)

Bert - here are are couple of more details that may give you a few clues..

1. When I installed the 'main' AC install on the server... I changed the default path to the D: drive. I found that AC is installed on the Program Files folder in the D: drive, but SQL Server Express is installed in the Program Files folder on the C: drive.

2. I am using both share permissions (created a share and mapped a drive for the client machines)and NTFS permissions for the folders on the share.

3. I have 2 groups - Staff and Management. The management users are also included in Domain Administrators (just two of us). The Users in the Staff group are 'Domain Users'. Not sure what 'Authenticated Users' mean.

4. The Staff has Read/Write/Modify permissions on the Program Files folder (that has AC). Also added Read/Write/Modify permissions for the Staff group on the SQL Express Folders located on the C: drive.

5. When I log into the client machines with a user_id associa - I have no problem running AC. When I log-in with the staff user_id I get a 'SQL Server Connection error'.