Linked Server Setup

Discussion:

Linked Server Setup

(too old to reply)

Eric Stott

2008-07-23 15:59:06 UTC

I am attempting to create a linked server to an informix database.
I have installed the sql as documented here:
http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.oledb.doc/oledb20.htm
and set up the linked server as documented here:
http://www-1.ibm.com/support/docview.wss?uid=swg21195578

However, when I try to establish the connection I get the following error:

TITLE: Microsoft SQL Server Management Studio
------------------------------

"The linked server has been created but failed a connection test. Do you
want to keep the linked server?"

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)

------------------------------

The OLE DB provider "Ifxoledbc" for linked server "INFORMIX_TEST" reported
an error. Authentication failed.
Cannot initialize the data source object of OLE DB provider "Ifxoledbc" for
linked server "INFORMIX_TEST".
OLE DB provider "Ifxoledbc" for linked server "INFORMIX_TEST" returned
message "EIX000: (-951) Incorrect password or user
Administrator@::ffff:10.15.61.72 is not known on the database server.".
(Microsoft SQL Server, Error: 7399)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=7399&LinkId=20476

------------------------------
BUTTONS:

&Yes
&No
------------------------------

Is there anyone that has come across the same issue? I have created an ODBC
connecion successfully, but would prefer to use the OLE DB connection in the
linked server.

Eric

Todd C

2008-07-23 16:28:03 UTC

Permalink

Eric:
From you error message, it looks like you did not supply a password
anywhere. You need to set up security on your linked server. In the
properties, click on the Security page. Review the options
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]

Post by Eric Stott
I am attempting to create a linked server to an informix database.
http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.oledb.doc/oledb20.htm
http://www-1.ibm.com/support/docview.wss?uid=swg21195578
TITLE: Microsoft SQL Server Management Studio
------------------------------
"The linked server has been created but failed a connection test. Do you
want to keep the linked server?"
------------------------------
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
------------------------------
The OLE DB provider "Ifxoledbc" for linked server "INFORMIX_TEST" reported
an error. Authentication failed.
Cannot initialize the data source object of OLE DB provider "Ifxoledbc" for
linked server "INFORMIX_TEST".
OLE DB provider "Ifxoledbc" for linked server "INFORMIX_TEST" returned
message "EIX000: (-951) Incorrect password or user
(Microsoft SQL Server, Error: 7399)
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=7399&LinkId=20476
------------------------------
&Yes
&No
------------------------------
Is there anyone that has come across the same issue? I have created an ODBC
connecion successfully, but would prefer to use the OLE DB connection in the
linked server.
Eric

Eric Stott

2008-07-23 16:53:13 UTC

Permalink

That was the answer, after I supplied it, it worked!

Thanks,
Eric

Post by Todd C
From you error message, it looks like you did not supply a password
anywhere. You need to set up security on your linked server. In the
properties, click on the Security page. Review the options
--
Todd C
[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]