Linked Server Setup
in [Programming SQL]
|
From: Eric Stott on 23 Jul 2008 11:59 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
From: Todd C on 23 Jul 2008 12:28 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] "Eric Stott" wrote: > 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 > > >
From: Eric Stott on 23 Jul 2008 12:53 That was the answer, after I supplied it, it worked! Thanks, Eric "Todd C" <ToddC(a)discussions.microsoft.com> wrote in message news:CD285BD5-F13D-4D9D-9D86-62A670D90AC4(a)microsoft.com... > 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] > > > "Eric Stott" wrote: > >> 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 >> >> >>
|
Pages: 1 Prev: SCOPE_IDENTITY issue with INSTEAD_OF trigger Next: Experts Required |