by Mega » Wed, 02 Apr 2003 01:36:20
I am running sqll 2000 sp3 on a windows 2000 server.
thanks!!
by Gene Lemcoo » Wed, 02 Apr 2003 04:32:35
I'm not sure what your question is...?
Gene
Quote:> I need to create a linked server that will be called fred
> and I want it to point to server fred.corp.com then I have
> dns setup to resolve fred.corp.com to another location....
> I have no idea how to specify the the linked server called
> fred pointing to the full name... is there a stored proc
> that I can run to point a linked server to a full server
> name or a parm at setup time?
> I am running sqll 2000 sp3 on a windows 2000 server.
> thanks!!
Hi
I noticed, when linking servers, only pure SQL7 Servers
(sp_addlinkedserver 'ServerM',
N'SQL Server')
I'm linking SQL server M to server N both are NT security only, using the
SQL service account in the M server as a user with security permissions on a
database.
When I logon to server N directly I can do selects on a view of a table in
the connected database.
But when I log on to server N from another machine via Enterprise manager, I
can not get my select statements to work. It comes up with user / can't log
in or something like that. I've tried all sorts of NT impersonations, none
of them made a difference.
The links views, probably work with stored procedures because they are run
in their own space.
I don't have this problem with ODBC Linked Servers.
Is this a feature of linking SQL7 servers?
Thanks
3. Linked Server Question 7.0 / 6.5 (ASAP would be great)
4. DATABASE MANAGEMENT ARCHIVE ON THE WEB!
6. Looking for Unify mailing groups & Unify user groups
8. Help Me Get Rid of - - - Dashed - - - Lines - - - in Output