Looking for definition of "domain account"

[Larry Woods]

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

 

[Dave Patrick]

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.

:
| 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
|
|

 

[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]

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.

:
| 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

 

[Larry Woods]

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

 

[Larry Woods]

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