ODBC for sevice now from SQL 2012 is not working. below is the error.

[suniln]

This is the issue I see when I expand Linked server. I have verified "test connection " successfully for both Linked server and also ODBC.

I have Updated the providers on SQL 2012 as well. Thanks for you advise in advance.

Cannot obtain the schema rowset "DBSCHEMA_TABLES" for OLE DB provider "MSDASQL" for linked server "SERVICENOW". The provider supports the interface, but returns a failure code when it is used. (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.6537&EvtSrc=MSSQLServ...

------------------------------
Server Name:&&&&&&&
Error Number: 7311
Severity: 16
State: 2
Procedure: sp_tables_ex
Line Number: 41

[suniln]

  saketh,

Do you mean SOAP and ITIL?

that account has soap_query and ITIL.   should I include soap as well?

[Natsufab3]

Sunil,

                ODBC is a specific role that is to be added for user, this is oob, try adding this role and see if it works. I'm not sure if this is the right reason for this error but can be.

Also did you check if it is 32 bit or 64bit that is installed and if your server supports this?! try looking into these two link I found with error 7311

Linked Server Error: Cannot obtain the schema rowset "DBSCHEMA_CATALOGS"

Solved: Impala ODBC performance - Cloudera Community

might be helpfull.

Thank you

[suniln]

Saketh,

1) This a 64 Bit environment.

2) Similar to me, an App dev person is also ruerying ServiceNow and he setup his profile 2 months ago. He uses a separate account. He is able to successfully query.

3) I performed same steps as he did. I compared the permissions for both and doesn't seems to be working.

Thanks,

Sunil.