Installing SQL 7 SP4 is a Domain are domain accounts required

When installing SQL 7 (non clustered) on a server is it neccessary to use
domain accounts.
e.g. We have a web server that is part of the workgroup "workgroup" this web
server is to access via the application on it the SQL database that resides
on a separate server (also in "workgroup") is it neccessary to create a
domain and have both these servers as members?
Thank youThere is no domain account for a workgroup topology. You will want to use
sql login for your authentication.
-oj
http://www.rac4sql.net
"Bruce Gilbert" <bruce.gilbert@.cgi.com> wrote in message
news:%23GsIqzCDEHA.2424@.TK2MSFTNGP09.phx.gbl...
> When installing SQL 7 (non clustered) on a server is it neccessary to use
> domain accounts.
> e.g. We have a web server that is part of the workgroup "workgroup" this
web
> server is to access via the application on it the SQL database that
resides
> on a separate server (also in "workgroup") is it neccessary to create a
> domain and have both these servers as members?
> Thank you
>|||To answer you question specifically. You do not need a domain. However, all
connectivity to the SQL Server machine will either have to be done with SQL
authentication or passthrough authentication (the same NT user and password
on both the client and SQL Server machine)
Rand
This posting is provided "as is" with no warranties and confers no rights.