September 24, 2010 at 2:07 am
Hi,
I created a linked server from sqlserver 2008 to sqlserver 2000. i checked it all tables are coming properly. when i'm going to execute a select query thru query analyser.. its shows the below error
OLE DB provider "SQLNCLI10" for linked server "SYDSQLD04\SQLDEV_CRM" returned message "Unspecified error".
OLE DB provider "SQLNCLI10" for linked server "SYDSQLD04\SQLDEV_CRM" returned message "The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI10" for linked server "SYDSQLD04\SQLDEV_CRM". The provider supports the interface, but returns a failure code when it is used.
I would appreciate, if any body helps me at the earliest..
Thanks & Regards
Balaji.G
September 24, 2010 at 2:12 am
use 'sql server native client 10.0' as provider.
----------
Ashish
September 24, 2010 at 3:07 am
Hi,
could you pls shared me, where can i use this....
use 'sql server native client 10.0' as provider.
Regards
Balaji.G
September 24, 2010 at 3:21 am
right click on your linked server, go to peroperties, go to general tab--you will see provider option.
Change the provider to 'sql server native client 10.0'
----------
Ashish
September 24, 2010 at 6:12 am
any update???
is that resolved your problem???
----------
Ashish
September 24, 2010 at 6:31 am
Hi Ashish,
I checked there.. but there is no sqlserver native client option..
Meanwhile
i tried to create from 2000 to 2008.. It shows the following error
like
[DBNETLIB][ConnectionOpen(Connect()).] Sql Server does not exist or access denied..
Could you pls advice me.. how to fix it?
Thanks & Regards
Balaji.G
September 24, 2010 at 6:47 am
I checked there.. but there is no sqlserver native client option..
if you doing this in sql server 2008 and selecting 'server type' as other data source then this provider will be there.
i tried to create from 2000 to 2008.. It shows the following error
like
[DBNETLIB][ConnectionOpen(Connect()).] Sql Server does not exist or access denied..
what kind of secuirty you configuring in security tab of linked server?
----------
Ashish
September 24, 2010 at 6:55 am
final option.(not to be made)
its asking remote username and password
i given the correct credentials details..
but its shows error
thanks
balaji.g
September 24, 2010 at 7:00 am
did you tried with third option, 'be made using the login's current.......'?
Also the account you configured with password, does that user have enough permission to configure the linked server?
----------
Ashish
September 24, 2010 at 12:49 pm
Have a look at
For cannot obtain rowset you'll have to create sp_tables_info_rowset_64
I can't find the original MS KB for it at the moment
Found it:
September 26, 2010 at 11:53 pm
learningforearning (9/24/2010)
did you tried with third option, 'be made using the login's current.......'?Also the account you configured with password, does that user have enough permission to configure the linked server?
How do i check... if a user having enough permission..
Regards
Balaji.G
September 26, 2010 at 11:55 pm
Hi Ashish,
How do i check whether the user having enough permission..
Regards
Balaji.G
September 27, 2010 at 1:40 am
How do i check whether the user having enough permission..
the account you configuring in security tab, you need to be make sure that account have requried permission on remote server which you configuring in linked server.
Also have you looked into Jo suggestion?
----------
Ashish
September 27, 2010 at 3:55 am
Hi friend,
Do you have 64 bit sql server 2008 and sql server 2000 on 32 Bit ?
Then you need to create a stored procedure in master database of sql server 2000-- sp_tables_info_rowset_64 (To make it compat. to 64 Bit version)
Regards
Mayank tyagi
September 28, 2010 at 5:33 am
crazy4sql (9/27/2010)
How do i check whether the user having enough permission..
the account you configuring in security tab, you need to be make sure that account have requried permission on remote server which you configuring in linked server.
Also have you looked into Jo suggestion?
I just try to create an odbc for SQL 2000 box and configure into sql2008 database..
it shows error " Sql Server does not exist" and i ping the sql2008 servername from sql 2000 box..
its shows "unknown hostname"....
The above method which i tried to configure the linked server for other datasources option
But its failed due to sqlserver doesnot exist error..
I feel that both sqlserver 2000 box and 2008 box are in different segments..
Is it possible to create a linked server? if its possible.. pls give suggestion..
Thanks
Balaji.G
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply