Re: Linked Databases

Hi Chunk,
Thanks for your updating and response.

For the password sync issue, you may consider to add your SQL Server
machines into a domain and use Windows authentication for adding the linked
server. You just need to add the client servers Windows login accounts to a
custom user group on your SQL Server 2005 machine, then you can just assign
permissions to the group in your SQL Server 2005 instance. In the client
SQL Server 2000 instances, you can add the linkedserver with Windows
authentication by using "exec sp_addlinkedsrvlogin
'your2005servername','true'".

Saving your presence, I feel a little confused of your issue. I understand
that you have a lot of databases, however if you have only several SQL
Server instances, even if you create several login accounts for the client
SQL Server 2000 instances, the job of adding linked server should not be
fussy. How do you think?

Look forward to your reply. If you have any other questions or concerns,
please feel free to let me know. It is my pleasure to be of assistance.

Charles Wang
Microsoft Online Community Support

======================================================
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

.

Relevant Pages

  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Slow booting xp home.
    ... Thirty seconds to boot Windows? ... I read somewhere that Microsoft suggest 30s boot up on xp home, I have seen videos on youtube of 8s boot up on xp, I'd be delighted with 30s and happy just to get below a minute. ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Windows security
    ... sp_change_users_password only works with SQL Server ... Authentication, not Windows Authentication. ... > Windows NT environment but still have entries in the Microsoft SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: Why do I have to enable File and Printer sharing to connect through the XP firewall?
    ... connecting using a Windows account or using a SQL Server account? ... For Windows authentication, SQL Server need to enumerate the SIDs for the account you pass with Windows. ...
    (microsoft.public.sqlserver.clients)
  • Re: Trouble connecting to SQL Server express over Peer to Peer network
    ... I have a program that accesses an SQL Server Express database. ... Configuration and I connect using Windows Authentication. ... that have never been connected to the domain, I have an issue connecting. ...
    (microsoft.public.vb.general.discussion)