Linked Server Problem SQL Server 2005 to SQL Server 2000

I've been trying to add a linked server om my SQL Server 2005 Beta 2 install. The Linked Server i'm trying to add is a MS SQL Server 2000 with Service Pack 4 installed on it.

The code i've run on the SQL Server 2005 server to add the linked server is the following:

EXEC sp_addlinkedserver

@.server = N'JANET01',

@.srvproduct = N'',

@.provider = N'SQLNCLI',

@.datasrc = N'SERVER=192.168.100.150;Integrated Security=True'
The Error i'm getting is the following:

OLE DB provider "SQLNCLI" for linked server "JANET01" returned message "Login timeout expired".

OLE DB provider "SQLNCLI" for linked server "JANET01" returned message "Client unable to establish connection".

Msg 126, Level 16, State 1, Line 0

VIA Provider: The specified module could not be found.

Is there someone who can help me out with this error?

I have all protocols enabled on the MS SQL Server 2005 server and have used the Surface Area Configurator to enable remote connections and adhoc remote queries.

I really don't know what to do next :-(

Thanks in advanced...

Kind regards,

Robertino

Can you try specifying the connection string in the provstr parameter ( rather than the datasrc ) of sp_addlinkedserver?

EXEC sp_addlinkedserver
@.server = N'JANET01',
@.srvproduct = N'',
@.provider = N'SQLNCLI',
@.provstr = N'SERVER=192.168.100.150;Integrated Security=True'

Thanks,
Rakesh

|||

I had this problem also. You need to load the InstCat software on your SQL2000 server. Please look in MS KB articles for InstCat.

Also, once you establish your linked server on the SQL2005 server, if it is I64, do not view it with Mgmt Studio as it be destroyed...use sp code from that point to review and modify...its a i64 bug

|||I added a link server to my SQL Server. But I cannot execute a select statement with openquery. After lot of googling I presume there is some issue- has it to do something with Service Packs.
I am currently running a 180 days trial version.

Thanks in Advance.

Chandrakant Karale

Code:

select * from openquery ([localserver1],'select * from dummyobjects')

Msg 7356, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI" for linked server "localserver1" supplied inconsistent metadata for a column. The column "DummyObjectID" (compile-time ordinal 1) of object "select * from dummyobjects" was reported to have a "Incomplete schema-error logic." of 0 at compile time and 0 at run time.|||

Try to execute

exec sp_tables_ex localserver1

to test connection. If it works, you will get the list of tables available on localserver1.

Then you can execute

select * from localserver1..dbo.dummyobjects (two dots before dbo) and hopefully get the data out.

Linked Server Problem SQL Server 2005 to SQL Server 2000

I've been trying to add a linked server om my SQL Server 2005 Beta 2 install. The Linked Server i'm trying to add is a MS SQL Server 2000 with Service Pack 4 installed on it.

The code i've run on the SQL Server 2005 server to add the linked server is the following:

EXEC sp_addlinkedserver

@.server = N'JANET01',

@.srvproduct = N'',

@.provider = N'SQLNCLI',

@.datasrc = N'SERVER=192.168.100.150;Integrated Security=True'
The Error i'm getting is the following:

OLE DB provider "SQLNCLI" for linked server "JANET01" returned message "Login timeout expired".

OLE DB provider "SQLNCLI" for linked server "JANET01" returned message "Client unable to establish connection".

Msg 126, Level 16, State 1, Line 0

VIA Provider: The specified module could not be found.

Is there someone who can help me out with this error?

I have all protocols enabled on the MS SQL Server 2005 server and have used the Surface Area Configurator to enable remote connections and adhoc remote queries.

I really don't know what to do next :-(

Thanks in advanced...

Kind regards,

Robertino

Can you try specifying the connection string in the provstr parameter ( rather than the datasrc ) of sp_addlinkedserver?

EXEC sp_addlinkedserver
@.server = N'JANET01',
@.srvproduct = N'',
@.provider = N'SQLNCLI',
@.provstr = N'SERVER=192.168.100.150;Integrated Security=True'

Thanks,
Rakesh

|||

I had this problem also. You need to load the InstCat software on your SQL2000 server. Please look in MS KB articles for InstCat.

Also, once you establish your linked server on the SQL2005 server, if it is I64, do not view it with Mgmt Studio as it be destroyed...use sp code from that point to review and modify...its a i64 bug

|||I added a link server to my SQL Server. But I cannot execute a select statement with openquery. After lot of googling I presume there is some issue- has it to do something with Service Packs.
I am currently running a 180 days trial version.

Thanks in Advance.

Chandrakant Karale

Code:

select * from openquery ([localserver1],'select * from dummyobjects')

Msg 7356, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI" for linked server "localserver1" supplied inconsistent metadata for a column. The column "DummyObjectID" (compile-time ordinal 1) of object "select * from dummyobjects" was reported to have a "Incomplete schema-error logic." of 0 at compile time and 0 at run time.|||

Try to execute

exec sp_tables_ex localserver1

to test connection. If it works, you will get the list of tables available on localserver1.

Then you can execute

select * from localserver1..dbo.dummyobjects (two dots before dbo) and hopefully get the data out.

Linked Server Problem SQL Server 2005 to SQL Server 2000

I've been trying to add a linked server om my SQL Server 2005 Beta 2 install. The Linked Server i'm trying to add is a MS SQL Server 2000 with Service Pack 4 installed on it.

The code i've run on the SQL Server 2005 server to add the linked server is the following:

EXEC sp_addlinkedserver

@.server = N'JANET01',

@.srvproduct = N'',

@.provider = N'SQLNCLI',

@.datasrc = N'SERVER=192.168.100.150;Integrated Security=True'
The Error i'm getting is the following:

OLE DB provider "SQLNCLI" for linked server "JANET01" returned message "Login timeout expired".

OLE DB provider "SQLNCLI" for linked server "JANET01" returned message "Client unable to establish connection".

Msg 126, Level 16, State 1, Line 0

VIA Provider: The specified module could not be found.

Is there someone who can help me out with this error?

I have all protocols enabled on the MS SQL Server 2005 server and have used the Surface Area Configurator to enable remote connections and adhoc remote queries.

I really don't know what to do next :-(

Thanks in advanced...

Kind regards,

Robertino

Can you try specifying the connection string in the provstr parameter ( rather than the datasrc ) of sp_addlinkedserver?

EXEC sp_addlinkedserver
@.server = N'JANET01',
@.srvproduct = N'',
@.provider = N'SQLNCLI',
@.provstr = N'SERVER=192.168.100.150;Integrated Security=True'

Thanks,
Rakesh

|||

I had this problem also. You need to load the InstCat software on your SQL2000 server. Please look in MS KB articles for InstCat.

Also, once you establish your linked server on the SQL2005 server, if it is I64, do not view it with Mgmt Studio as it be destroyed...use sp code from that point to review and modify...its a i64 bug

|||I added a link server to my SQL Server. But I cannot execute a select statement with openquery. After lot of googling I presume there is some issue- has it to do something with Service Packs.
I am currently running a 180 days trial version.

Thanks in Advance.

Chandrakant Karale

Code:

select * from openquery ([localserver1],'select * from dummyobjects')

Msg 7356, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI" for linked server "localserver1" supplied inconsistent metadata for a column. The column "DummyObjectID" (compile-time ordinal 1) of object "select * from dummyobjects" was reported to have a "Incomplete schema-error logic." of 0 at compile time and 0 at run time.|||

Try to execute

exec sp_tables_ex localserver1

to test connection. If it works, you will get the list of tables available on localserver1.

Then you can execute

select * from localserver1..dbo.dummyobjects (two dots before dbo) and hopefully get the data out.

Linked Server Problem SQL Server 2005 to SQL Server 2000

I've been trying to add a linked server om my SQL Server 2005 Beta 2 install. The Linked Server i'm trying to add is a MS SQL Server 2000 with Service Pack 4 installed on it.

The code i've run on the SQL Server 2005 server to add the linked server is the following:

EXEC sp_addlinkedserver

@.server = N'JANET01',

@.srvproduct = N'',

@.provider = N'SQLNCLI',

@.datasrc = N'SERVER=192.168.100.150;Integrated Security=True'
The Error i'm getting is the following:

OLE DB provider "SQLNCLI" for linked server "JANET01" returned message "Login timeout expired".

OLE DB provider "SQLNCLI" for linked server "JANET01" returned message "Client unable to establish connection".

Msg 126, Level 16, State 1, Line 0

VIA Provider: The specified module could not be found.

Is there someone who can help me out with this error?

I have all protocols enabled on the MS SQL Server 2005 server and have used the Surface Area Configurator to enable remote connections and adhoc remote queries.

I really don't know what to do next :-(

Thanks in advanced...

Kind regards,

Robertino

Can you try specifying the connection string in the provstr parameter ( rather than the datasrc ) of sp_addlinkedserver?

EXEC sp_addlinkedserver
@.server = N'JANET01',
@.srvproduct = N'',
@.provider = N'SQLNCLI',
@.provstr = N'SERVER=192.168.100.150;Integrated Security=True'

Thanks,
Rakesh

|||

I had this problem also. You need to load the InstCat software on your SQL2000 server. Please look in MS KB articles for InstCat.

Also, once you establish your linked server on the SQL2005 server, if it is I64, do not view it with Mgmt Studio as it be destroyed...use sp code from that point to review and modify...its a i64 bug

|||I added a link server to my SQL Server. But I cannot execute a select statement with openquery. After lot of googling I presume there is some issue- has it to do something with Service Packs.
I am currently running a 180 days trial version.

Thanks in Advance.

Chandrakant Karale

Code:

select * from openquery ([localserver1],'select * from dummyobjects')

Msg 7356, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI" for linked server "localserver1" supplied inconsistent metadata for a column. The column "DummyObjectID" (compile-time ordinal 1) of object "select * from dummyobjects" was reported to have a "Incomplete schema-error logic." of 0 at compile time and 0 at run time.|||

Try to execute

exec sp_tables_ex localserver1

to test connection. If it works, you will get the list of tables available on localserver1.

Then you can execute

select * from localserver1..dbo.dummyobjects (two dots before dbo) and hopefully get the data out.

sql

Linked server - Access Denied

I have a problem that I am having a heck of a time figuring out.
I have a new install of SQL Server 2005 on a new install of Windows 2003.
I installed the Informix CSDK 2.90.xxx and set up connections to our test
informix database
I created a linked server to an Informix database using OLEDB and it works
if the service account is the Local System account or a domain admin.
If I change the account to a domain user, I get an access denied error when
running a query against the linked server. I added the domain user account
to the local administrator group and still get access denied.
Everything else that I tried seems to work, just a problem with the linked
server. I have made sure that the service account user has read & execute
at a minimum on the Informix OleDB dll. Even went so far as temporarily
giving everyone full control on the Informix client directory, to make sure
is was not a file permission problem.
any HELPwould be greatly appreciated!
The actual message I receive is:
Where ifxoledbc is the informix OleDB driver, and coristest is the link
server name
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Ifxoledbc" for linked server "coristest" reported an
error. Access denied.
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "Ifxoledbc" for
linked server "coristest".Hello,
You may want to try to set Allow InProcess option in linked server provider
options for Ifxoledbc linked server provider to test.
Also, you may grant the domain user account to delegate:
http://msdn.microsoft.com/library/d...-us/adminsql/ad
_security_2gmm.asp
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello,
You may want to try to set Allow InProcess option in linked server provider
options for Ifxoledbc linked server provider to test.
Also, you may grant the domain user account to delegate:
http://msdn.microsoft.com/library/d...-us/adminsql/ad
_security_2gmm.asp
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Peter,
Thanks, you made my day!
Worked perfectly.
Shannon
""privatenews"" <petery@.online.microsoft.com> wrote in message
news:RBTjU53jGHA.4688@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> You may want to try to set Allow InProcess option in linked server
> provider
> options for Ifxoledbc linked server provider to test.
> Also, you may grant the domain user account to delegate:
> [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad[/ur
l]
> _security_2gmm.asp
>
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Peter,
Thanks, you made my day!
Worked perfectly.
Shannon
""privatenews"" <petery@.online.microsoft.com> wrote in message
news:RBTjU53jGHA.4688@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> You may want to try to set Allow InProcess option in linked server
> provider
> options for Ifxoledbc linked server provider to test.
> Also, you may grant the domain user account to delegate:
> [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad[/ur
l]
> _security_2gmm.asp
>
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Welcome! :-)
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Welcome! :-)
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

Linked server - Access Denied

I have a problem that I am having a heck of a time figuring out.
I have a new install of SQL Server 2005 on a new install of Windows 2003.
I installed the Informix CSDK 2.90.xxx and set up connections to our test
informix database
I created a linked server to an Informix database using OLEDB and it works
if the service account is the Local System account or a domain admin.
If I change the account to a domain user, I get an access denied error when
running a query against the linked server. I added the domain user account
to the local administrator group and still get access denied.
Everything else that I tried seems to work, just a problem with the linked
server. I have made sure that the service account user has read & execute
at a minimum on the Informix OleDB dll. Even went so far as temporarily
giving everyone full control on the Informix client directory, to make sure
is was not a file permission problem.
any HELPwould be greatly appreciated!
The actual message I receive is:
Where ifxoledbc is the informix OleDB driver, and coristest is the link
server name
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Ifxoledbc" for linked server "coristest" reported an
error. Access denied.
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "Ifxoledbc" for
linked server "coristest".Hello,
You may want to try to set Allow InProcess option in linked server provider
options for Ifxoledbc linked server provider to test.
Also, you may grant the domain user account to delegate:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
_security_2gmm.asp
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Peter,
Thanks, you made my day!
Worked perfectly.
Shannon
""privatenews"" <petery@.online.microsoft.com> wrote in message
news:RBTjU53jGHA.4688@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> You may want to try to set Allow InProcess option in linked server
> provider
> options for Ifxoledbc linked server provider to test.
> Also, you may grant the domain user account to delegate:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad
> _security_2gmm.asp
>
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Welcome! :-)
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.