|
Home > Archive > MS SQL Server security > November 2006 > tables in linked server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
tables in linked server
|
|
| lwidjaya 2006-11-20, 12:12 am |
| Hi,
I was able to register our new SQL server (S1) using 'sa'. But when I linked
it to another server (S2), I cannot see any tables in that server. I got
Error 17: SQL server does not exist or access denied. I deleted the default
Remote server and now when I tried to create a new one, it didn't let me to
leave the 'Local Login Name' blank when I selected 'Map remote logins to
different local logins'. I have administrator rights on both servers. I need
to be able to run views from S2. What should I do now?
Thanks in advance.
| |
| lwidjaya 2006-11-20, 12:12 am |
| additional information:
We have 3 other SQL servers and they are able to link to S1 and see the
tables. All servers except S2 are joined to our network domain. I don't think
this is the problem because S2 can link to those 3 servers and see the tables.
Please help.
Thanks.
"lwidjaya" wrote:
> Hi,
> I was able to register our new SQL server (S1) using 'sa'. But when I linked
> it to another server (S2), I cannot see any tables in that server. I got
> Error 17: SQL server does not exist or access denied. I deleted the default
> Remote server and now when I tried to create a new one, it didn't let me to
> leave the 'Local Login Name' blank when I selected 'Map remote logins to
> different local logins'. I have administrator rights on both servers. I need
> to be able to run views from S2. What should I do now?
> Thanks in advance.
| |
| Arnie Rowland 2006-11-20, 7:14 pm |
| It would be helpful to know what version of SQL Server (2000/2005) you are
using.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"lwidjaya" < lwidjaya@discussions
.microsoft.com> wrote in message
news:72D5F0E5-D779-4B84-BC28- A17417E2128B@microso
ft.com...
> Hi,
> I was able to register our new SQL server (S1) using 'sa'. But when I
> linked
> it to another server (S2), I cannot see any tables in that server. I got
> Error 17: SQL server does not exist or access denied. I deleted the
> default
> Remote server and now when I tried to create a new one, it didn't let me
> to
> leave the 'Local Login Name' blank when I selected 'Map remote logins to
> different local logins'. I have administrator rights on both servers. I
> need
> to be able to run views from S2. What should I do now?
> Thanks in advance.
| |
| lwidjaya 2006-11-23, 12:14 am |
| Hi Arnie,
thanks for your reply.
We use SLQ 2000. I was finally able to link the server by using the IP
address. When I pinged S1 from S2 using its name, S2 didn't recognize S1. But
it recognized its IP address. So I used alias.
Thanks.
"Arnie Rowland" wrote:
> It would be helpful to know what version of SQL Server (2000/2005) you are
> using.
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
>
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
>
> "lwidjaya" < lwidjaya@discussions
.microsoft.com> wrote in message
> news:72D5F0E5-D779-4B84-BC28- A17417E2128B@microso
ft.com...
>
>
>
|
|
|
|
|