Sage 100

I've created a link server from SQL 2014 to Sage 100 v2014. Works great. I've also created a DSN to the SQL tables and stored procedures using Windows Authentication. I can create linked tables in my Access front-end using the DSN. Now, I'm attempting to run a stored procedure and if I define the connection string with a user ID and password, all is good. I want to use a Trusted Connection instead of supplying the user ID and password but, for the life of me, I can't get it to work. Any assistance would be greatly appreciated.

Have you assigned execute permissions to the stored procedure to the windows users?

Assuming the users have connect and execute rights for the stored procedure, you should be able to just use a connection string like 'Server=SQLSERVER\INSTANCENAME;Database=DATABASENAME;Trusted_Connection=True;'. If you're running it from Access, then you would use an ADO.command where CommandText = ""sp_name"" and CommandType = adCmdStoredProc, and then Execute

It always helps to actually read the error message. Turns out the error is referencing the Sage 100 DSN I used to create the linked server. The DSN uses a Sage login, not a unified login. The SQL connection string only works with the sa user and password, even though that is not the Sage login. Stumped.

Soooooo easy to take on client characteristics!!! Happens to us all!