sql 2012 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

sql 2012

Author

Topic

inbs
Aged Yak Warrior

860 Posts

Posted - 2012-12-04 : 03:21:00

when i create link server in sql 2012 to sql 2000,i get error
"Access is Denied"

what is the solution for that?

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2012-12-04 : 03:28:54

May be you don't have permission to link with that server

--
Chandu

inbs
Aged Yak Warrior

860 Posts

Posted - 2012-12-04 : 06:35:01

no, i am administrator...

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2012-12-04 : 07:47:12

Check this link. It may help you
http://blogs.msdn.com/b/dataaccesstechnologies/archive/2010/08/19/permissions-needed-to-set-up-linked-server-with-out-of-process-provider.aspx

--
Chandu

inbs
Aged Yak Warrior

860 Posts

Posted - 2012-12-05 : 15:44:00

it didn't help ,this error:


SQL Server Native Client 11.0 does not support connections to SQL Server 2000 or earlier versions.
OLE DB provider "SQLNCLI11" for linked server "LINKSQL" returned message "Client unable to establish connection". (Microsoft SQL Server, Error: 22)

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2012-12-05 : 15:50:00

Maybe this will help

http://www.biadmin.com/2012/06/sql-2012-upgrade-gotcha-sql-2000-not.html

Jim

Everyday I learn something that somebody else already knew

inbs
Aged Yak Warrior

860 Posts

Posted - 2012-12-05 : 16:48:13

it doesn't help me to create link server.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2012-12-05 : 17:02:48

I don't think it supports SQL 2000 from SQL 2012.

Check this :http://msdn.microsoft.com/en-us/library/cc280356(v=SQL.110).aspx

inbs
Aged Yak Warrior

860 Posts

Posted - 2012-12-06 : 01:41:29

what is soultion for that?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-12-06 : 01:50:16

you need to use SQL Server Native Client 10.0 or use SQLOLEDB instead

http://www.winadmins.com/2012/05/kbcreate-sql-2000-linked-server-at-sql.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

inbs
Aged Yak Warrior

860 Posts

Posted - 2012-12-06 : 04:33:23

i don't have sql native 10.0 in the list.

i try to install sqlncli.msi from the web :
[url]http://www.microsoft.com/en-us/download/details.aspx?id=29065[/url]

when i install it i get this error:
"installation of sql server 2012 native client failed because a higher version" (maybe sql native 11.0 already installed)

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-12-07 : 07:34:57

quote:
Originally posted by inbs

i don't have sql native 10.0 in the list.

i try to install sqlncli.msi from the web :
[url]http://www.microsoft.com/en-us/download/details.aspx?id=29065[/url]

when i install it i get this error:
"installation of sql server 2012 native client failed because a higher version" (maybe sql native 11.0 already installed)

can you see sqloledb listed in providers?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources