July 16, 2008 at 9:29 am
Hello room,
I’m newbie to SSIS. I need to transform access database from “A1” remote computer that running window XP to SQL Server 2005 (Running on Window 2003)
Here are my steps so far but I cannot connect to “A1” access database
1. I create a package and added the Data Flow.
2. Added a Excel Source and Connection Manager
3. Server name: entered the A1 ip address.
(Note: We use this ip address and config and setup on third party software to communicate with “A1” computer)
4. Log on to the server: I selected Use SQL Server authentication:
- User name: abc
- Password: confidential
Unable to Select or Enter a database name.
Can anyone give some advice?
Regards,
Edwin
July 16, 2008 at 10:13 am
probably the user credentials you are typing are incorrect , or the user doesn't exist, or the given user doesn't have select permissions.
July 16, 2008 at 11:43 am
On the "A1" computer. I created a user "abc" and assigned local administrator and replicator privilege.
Should this "abc" user have sufficient right to connect Access Database files on "A1" computer.
Suggestions please?
July 16, 2008 at 11:48 am
probably yes... make sure under database that user has connect permission. Right Click on database and go to permission page and make sure the user is listed there and has the correct permissions.
July 16, 2008 at 12:08 pm
The “A1” machine did not install Microsoft access. It only has the access mdb files.
The third party software is using and generated those files.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply