| Hal Berenson 2002-11-20, 8:23 pm |
| Create the view using the CREATE VIEW command in Query Analyzer.
--
Hal Berenson
True Mountain Consulting
"D DeBow" <ddebow@mcskc.com> wrote in message
news:cbde01c290ea$e98c53b0$8af
82ecf@TK2MSFTNGXA03...
> Having trouble creating a view that pulls data from a
> different server on my network. I have set up the server
> I am trying to pull from as a LINKED server. When
> creating the view using Enterprise Manager I get an error:
>
> Query Designer encountered a MS Design Tools error:
> ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]
> Could not find server '"MCS-INFOMIN"' in sysservers.
> Execute sp_addlinkedserver to add the server to sysservers.
>
> When I enter through that error it is followed by:
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]login
> failed for user ''
>
> When I try to add linked server it states that the server
> already exists (confirmed with sp_linkedservers).
>
> I am able to pull the data using the same SQL Statment in
> Query Analyzer. Only seems to be a problem when creating
> a view. Any suggestions?
>
> (See File Attachment)
|