I have two computers that are on a LAN, both with Windows 2000 server, but
NOT defined in any sort of "official" domain; just "peers." Can I set up a
"domain account" between these two computers and, if so, how? Reason: I
need to execute SQL Server stored procedures between computers and I need to
be running under a "domain account" to do this.

TIA,

Larry Woods

Domain accounts will only exist in a domain model network. Doubtful that
this is an issue. Without details it's hard to know what you're wanting to
do. Better to post (with specific details) in sqlserver.server

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft MVP [Windows NT/2000 Operating Systems]
http://www.microsoft.com/protect.

"Larry Woods" wrote:
| I have two computers that are on a LAN, both with Windows 2000 server, but
| NOT defined in any sort of "official" domain; just "peers." Can I set up
a
| "domain account" between these two computers and, if so, how? Reason: I
| need to execute SQL Server stored procedures between computers and I need
to
| be running under a "domain account" to do this.
|
| TIA,
|
| Larry Woods
|
|

Thanks. I will post to sqlserver. I am trying to copy a database from one
server to another. SQL Server needs a "domain account" so that it can
communicate between computers.

Larry

"Dave Patrick" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Domain accounts will only exist in a domain model network. Doubtful that
> this is an issue. Without details it's hard to know what you're wanting to
> do. Better to post (with specific details) in sqlserver.server
>
> --
> Regards,
>
> Dave Patrick ....Please no email replies - reply in newsgroup.
> Microsoft MVP [Windows NT/2000 Operating Systems]
> http://www.microsoft.com/protect.
>
> "Larry Woods" wrote:
> | I have two computers that are on a LAN, both with Windows 2000 server,
but
> | NOT defined in any sort of "official" domain; just "peers." Can I set
up
> a
> | "domain account" between these two computers and, if so, how? Reason:
I
> | need to execute SQL Server stored procedures between computers and I
need
> to
> | be running under a "domain account" to do this.
> |
> | TIA,
> |
> | Larry Woods
> |
> |
>
>

You'll need to create an account that exist on both pc's with the same
username and password that has local administrative rights. Then you'll need
to set the MSSQLSERVER service and possibly the SQLSERVERAGENT service to
logon with this account. See booksonline for more info on this.

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft MVP [Windows NT/2000 Operating Systems]
http://www.microsoft.com/protect.

"Larry Woods" wrote:
| Thanks. I will post to sqlserver. I am trying to copy a database from
one
| server to another. SQL Server needs a "domain account" so that it can
| communicate between computers.
|
| Larry

Thanks, Dave....

I will set up another account but in my case I have my "Adminstrator" user
defined with the same password on both servers. And, I "thought" that I had
tried setting up SQL Server and SQL Agent with these names. But, maybe I
missed something. I'll try it again.

Larry

"Dave Patrick" <(E-Mail Removed)> wrote in message
news:Oiw$(E-Mail Removed)...
> You'll need to create an account that exist on both pc's with the same
> username and password that has local administrative rights. Then you'll
need
> to set the MSSQLSERVER service and possibly the SQLSERVERAGENT service to
> logon with this account. See booksonline for more info on this.
>
> --
> Regards,
>
> Dave Patrick ....Please no email replies - reply in newsgroup.
> Microsoft MVP [Windows NT/2000 Operating Systems]
> http://www.microsoft.com/protect.
>
> "Larry Woods" wrote:
> | Thanks. I will post to sqlserver. I am trying to copy a database from
> one
> | server to another. SQL Server needs a "domain account" so that it can
> | communicate between computers.
> |
> | Larry
>
>

Dave,

I don't know if I missed something, but I set up an account as you
suggested, gave it Administrative group permissions, but it still didn't
work.

Larry

"Dave Patrick" <(E-Mail Removed)> wrote in message
news:Oiw$(E-Mail Removed)...
> You'll need to create an account that exist on both pc's with the same
> username and password that has local administrative rights. Then you'll
need
> to set the MSSQLSERVER service and possibly the SQLSERVERAGENT service to
> logon with this account. See booksonline for more info on this.
>
> --
> Regards,
>
> Dave Patrick ....Please no email replies - reply in newsgroup.
> Microsoft MVP [Windows NT/2000 Operating Systems]
> http://www.microsoft.com/protect.
>
> "Larry Woods" wrote:
> | Thanks. I will post to sqlserver. I am trying to copy a database from
> one
> | server to another. SQL Server needs a "domain account" so that it can
> | communicate between computers.
> |
> | Larry
>
>