question

zillabaug asked Apr 21, '15

re:How to use Database mail feature in SQL Server 2000

I followed the steps outline in the url below to create a link server on SQL server 2000 . However, when I tried to execute a test job, sql server denied access. http://www.sqlservercentral.com/articles/SQL+Server+2000/69475/ error Server: Msg 17, Level 16, State 1, Line 1 SQL Server does not exist or access denied. Does anybody have a clue as to whats going on?

sql-server-2000 security linked-server data monitoring

6

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ commented · Apr 21, 2015 at 06:33 PM

does the SQL login you used have permission to the SQL 2005 server? Can you browse the catalogs in the linked server using enterprise manager?

0 ·

zillabaug commented · Apr 21, 2015 at 07:04 PM

yes , the SQL login has permission to the SQL 2005 server

0 ·

KenJ commented · Apr 22, 2015 at 02:53 AM

Can you browse the catalogs and tables in the linked server using enterprise manager?

0 ·

zillabaug commented · Apr 22, 2015 at 12:52 PM

no . I get Error 17: SQL Server does not exist or access denied when i clicked on tables under the lined server node

0 ·

zillabaug commented · Apr 22, 2015 at 12:53 PM

![alt text][1] [1]: /storage/temp/2391-capture.jpg

0 ·

capture.jpg (19.2 KiB)

KenJ commented · Apr 23, 2015 at 03:44 AM

Try creating the linked server using the GUI. Maybe some item on your command line wasn't quite right. Can you post the actual command you ran?

0 ·