Question Re: MS SQL remote server procedure not found on Win 2K8 R2 in Technology Q&A

MS SQL remote server procedure not found on Win 2K8 R2

Former Member — Tue, 14 Aug 2012 08:49:18 GMT

Current installation of SQL Anywhere 9.0.2.3951 on Win 2k3 with a remote server on a MSSQL with no problems. We moved the SQL Anywhere DB a new server, Win 2k8R2. Now, when acessing the MSSQL remote server proxy tables are working, but when executing remote procedure, MSSQL return 'procedure x not found'. I deleted and recreated the remote server and remote login. When creating the proxy for the remote procedure (with Sybase Central) I see the list of stored proc on the MSSQL DB. How can I see a list of remote procs, but when executing the proxy the I get an error with the remote proc not found.

Any help appreciated.

Re: MS SQL remote server procedure not found on Win 2K8 R2

VolkerBarth — Tue, 14 Aug 2012 09:27:38 GMT

~~May you have run in a similar problem as in that [FAQ](http://sqlanywhere-forum.sap.com/questions/9865)?~~

Sorry, dumb suggestion, I thought you were using MS SQL to access SA procedures, but now I see you are trying the opposite...

Re: MS SQL remote server procedure not found on Win 2K8 R2

VolkerBarth — Tue, 14 Aug 2012 09:55:37 GMT

Is the SA database user listing the remote proc in Sybase Central the same user trying to execute the remote proc?

If not, are they mapped to the same extern login (aka MS logins)? Or may they be mapped to different MS logins having different permissions and/or MS default databases?

Yes, I know, no answers, just more questions:)

Re: MS SQL remote server procedure not found on Win 2K8 R2

VolkerBarth — Tue, 14 Aug 2012 09:58:23 GMT

Besides my comments on your question, I would try to use Remote Data Access debugging (i.e. using CIS_OPTION = 7), cf. this v12.0.1 doc page...

Re: MS SQL remote server procedure not found on Win 2K8 R2

Former Member — Tue, 14 Aug 2012 10:30:21 GMT

I use the same user, DBA, for the listing and to execute the remote proc.

Re: MS SQL remote server procedure not found on Win 2K8 R2

VolkerBarth — Tue, 14 Aug 2012 11:04:55 GMT

Could you please show the code for your external procedure and how you call it?

Re: MS SQL remote server procedure not found on Win 2K8 R2

Former Member — Tue, 14 Aug 2012 13:56:37 GMT

With the CIS_OPTION and trace, the only thing that was different between the two setup was the version of sqlsrv32.dll. Everything worked once I used the same driver version.

Re: MS SQL remote server procedure not found on Win 2K8 R2

VolkerBarth — Tue, 14 Aug 2012 15:51:27 GMT

Glad you got it working! BTW, what version of MS SQL Server are you using?

Re: MS SQL remote server procedure not found on Win 2K8 R2

Former Member — Tue, 14 Aug 2012 16:58:08 GMT

I believe it's 2005, but I'm not sure, that is/was part of the problem. It's from another software vendor of one of our client and they are not really helpful about their product.