Test connection to Linked server failed

SQL2000 database migration, setting up linked server failed, error prompting test connection to linked server failed

650) this.width=650; "title=" QQ picture 20160301191517.png "Src=" http://s3.51cto.com/wyfs02/M00/7C/AC/ Wkiom1bvedxzmvu0aaapac1-cvg834.png "alt=" Wkiom1bvedxzmvu0aaapac1-cvg834.png "/>

Check the port policy account permissions are no problem, prompt invalid connection, meaning that the database is not found

Check the information, the reason string in the server address only write IP address, workaround:

Workaround 1:
Change into
"Provider=SQLOLEDB.1; Persist Security Info=false; User id=**; Pwd=**;initial Catalog=databasename;data Source=ip,1433″
is to change "Data Sourse = IP" to "Data Sourse = IP, port", the connection is normal
Workaround 2:
Change into
"Provider=SQLOLEDB.1; Persist Security Info=false; User id=**; Pwd=**;initial Catalog=databasename;data Source=ip,1433″
is to change "data Sourse = IP" to "data Sourse = Server alias (such as Localhost\sqlexpress, which is when opening SQL Server Management Studio Express on the left upper Name) ", the connection is normal

Reference article: http://blog.sina.com.cn/s/blog_81e5f9f901012vgq.html

This article is from the "Lixiangqian" blog, make sure to keep this source http://lixiangqian.blog.51cto.com/2848430/1746440

Test connection to Linked server failed