Hi All,

I am trying to transfer stored procedures from on SQL Server to another 
but keep getting this error:-

Microsoft SQL-DMO(ODBC SQL State:42000)
[Microsoft][ODBC SQL Server Driver][SQLServer]WindowsNT user or 
group 'GARNET\ASPNET' not found. Check the name again.

The .net framework has been implemented on both machines and I can 
transfer the DB via DTS but it won't let me get to the sp's...

v. confused?!

Can anyone help?

Cheers,

Simon.

How are you transferring them??

It looks like you are trying to transfer the users / rights for the sproc 
as well. Either do not include security rights when using DTS (Uncheck "Use 
Default Options" then deselect logins) or generate plain SQL from the 
sprocs. Don't forget to re-apply the rights on the target machine.

SQL Server tries to copy the user rights with the transfer as well. Since 
GARNET\ASPNET is a local account, it will not exist on the target machine.

HtH

Imar


At 03:53 PM 9/10/2002 +0000, you wrote:
>Hi All,
>
>I am trying to transfer stored procedures from on SQL Server to another
>but keep getting this error:-
>
>Microsoft SQL-DMO(ODBC SQL State:42000)
>[Microsoft][ODBC SQL Server Driver][SQLServer]WindowsNT user or
>group 'GARNET\ASPNET' not found. Check the name again.
>
>The .net framework has been implemented on both machines and I can
>transfer the DB via DTS but it won't let me get to the sp's...
>
>v. confused?!
>
>Can anyone help?
>
>Cheers,
>
>Simon.
>---
>
>ASP.NET 1.0 Namespace Reference with C#
>http://www.wrox.com/acon11.asp?ISBN=1861007442
>
>ASP.NET 1.0 Namespace Reference with VB.NET
>http://www.wrox.com/acon11.asp?ISBN=1861007450
>
>These books are a complete reference to the ASP.NET namespaces
>for developers who are already familiar with using ASP.NET.
>There is no trivial introductory material or useless .NET
>hype and the presentation of the namespaces, in an easy-to use
>alphabetical order ensures a user-friendly reference format.
>We provide in-depth coverage of all the major ASP.NET classes,
>giving you those real-world tips that the documentation doesn't
>offer, and demonstrating complex techniques with simple
>examples.
>
>---