SQL Server Performance Forum – Threads Archive

Linking to Sybase

Hi I created the linked server to Sybase
And everything : my stored procedure works fine when I connect under one
account
but when i use an other acount to connect I am geting an error Both account have admin rights on this box. But the successfull one is NT account and the failing one is local system account

What was the error when connecting with that account? And the login used must have privileges on the corresponding server in order to access the task. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

A System account resticts access to other servers.
Oh here I found an exerpt from BOL. Using the Local System Account
The local system account does not require a password, does not have network access rights in Windows NT 4.0 and Windows 2000, and restricts your SQL Server installation from interacting with other servers. Using a Domain User Account
A domain user account uses Windows Authentication, that is, the same user name and password used to connect to the operating system is also used to connect to SQL Server. A domain user account is typically used because many server-to-server activities can be performed only with a domain user account, for example: Remote procedure calls.
Replication.
Backing up to network drives.
Heterogeneous joins that involve remote data sources.
SQL Server Agent mail features and SQL Mail. This restriction applies if using Microsoft Exchange. Most other mail systems also require clients (the SQL Server and SQL Server Agent services) to be run on accounts with network access

Have you mapped this local system account(NT) on to the linked server? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>