Connection SQL server 2008

sven2

Registered User.
Local time
Today, 17:00
Joined
Apr 28, 2007
Messages
297
Hello,

how can I connect an adp database with SQL server Express on a SQL server 2008.

For the moment I have a project (adp) database using access 2007.
I'm able to create an ODBC connection and I can access the remote server without any problem.

When I open in access the server connection, type in the ip adress, I get an error regarding the fact that the user isn't recognized.

I use the same user and password as the ODBC connection and doing so,
I still have the error. What is wrong here?

Thanks in advance,
Sven.
 
You need to ensure you have a login on the sql server and that you have been registered as a user on the db you are trying to connect to.
 

Users who are viewing this thread

Back
Top Bottom