Solved

Connecting to SQL Server 2005 from the client machine

Posted on 2007-11-20
3
448 Views
Last Modified: 2010-05-18
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
Comment
Question by:shieldguy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 31

Expert Comment

by:James Murrell
ID: 20319250
what connection string did you try?
0
 
LVL 1

Author Comment

by:shieldguy
ID: 20319458
I am connecting this using SAGE client. I am not using any connection string but use the SAGE utility to connect.
0
 
LVL 25

Accepted Solution

by:
imitchie earned 500 total points
ID: 20322475
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question