[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Connecting to SQL Server 2005 from the client machine

Posted on 2007-11-20
3
Medium Priority
?
462 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
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 1500 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
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.
Suggested Courses

872 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