http://support.microsoft.com/default.aspx?kbid=246133

Very good article (above) for moving Databases (and user Schema) between SQL Servers. I use the sp_help_revlogin script all the time to document (and move) users from Server to...

They are implementing AD for the first time, so I guess side by side NT 40.0 and AD

Thank you! Something to consider.

Thank you Thank you!!! I looked more closely at that KB article

http://support.microsoft.com/default.aspx?scid=kb;en-us;315523&Product=sql2k

about the GUEST account having been deleted directly from sysusers in a Database.

and I checked this...

THANK YOU!!! I found the KB article and I think I have the guest account set up properly. It has public access to the master...

The Source Server is SQL Server 7.0 Standard Edition sp1 and the destination SQL 2000 Server is Enterprise Edition sp3

Very good article and thank you all for the help!!!!!

would I run that for the user against the master database or the newly created user database? I guess I'm confused as to why this happened at all.....

Thank you!!!!

Thank you. rather than upgrade the client tools to 2000, I think I will try the MDAC updates. Do you think MDAC 2.8 work as...

I don't know why that didn't occur to me. Thank you!!!!!

Wes,

Thank you for all your helpful input! I will check out the rebuildm utility about the collation 'problem'.

Since I'm new to SQL Server in a Clustered Environment,...

Thank you!!!!!!!!!

The registy on both Servers (both nodes in the cluster) have no reference to the new Virtual Server name - which is why I can't understand why SQL Server setup...

The new Virtual Server Name we are using is defined in WINS and DNS and is our preferred naming convention - so I will use the same Virtual Server name...