Connecting to SQL Server 2005 from the client machine

From the sage client I am trying to connect to the SAGE Server residing on another machine. The sage database is on SQL Server 2005. When I try to connect it gives me the above error message. Where as if i install SAGE client on the server machine and try to connect, it works fine. Could any body help me please?
LVL 1
shieldguyAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
imitchieConnect With a Mentor Commented:
when you connect on the server, you are authenticating (with the SQL Server) as the login you used on the server (i.e. SERVER\user) - this is a local user and probably was added by SAGE client install. on the other machine, you are logged in as (COMP1\user1). that user is unknown to SQL Server so you cannot connect.  it works better if you are on a domain and use the SAME domain login when logging on to/installing the client on both machines
0
 
James MurrellProduct SpecialistCommented:
what connection string did you try?
0
 
shieldguyAuthor Commented:
I am connecting this using SAGE client. I am not using any connection string but use the SAGE utility to connect.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.