• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 464
  • Last Modified:

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?
0
shieldguy
Asked:
shieldguy
1 Solution
 
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
 
imitchieCommented:
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now