From the Groove 2k7 Manager guide -
"Have on-hand the SQL server host name, and, if SQL authentication is chosen,
your SQL server login name and password. The Groove Manager uses this
information
to establish a connection to the database server on which the Groove Manager
depends for data storage. Make sure that the login name and password have
sufficient permissions to allow you to create a database on this server"
I don't use Windows Authentication on my server but from the above ("if SQL
authentication is chosen"), it appears that it may be possible to use WA.
Check if your WA account also has the right permissions (to create dbs, etc
- perhaps as a dbo) on the server.
SBC
-------------------
Microsoft MVP - Groove
weblog:
http://weblogs.asp.net/sbchatterjee
sbc111 at gmaildotcom
Pickup Groove Developer workspaces:
http://www.ctdotnet.org
Ken Ng said:
Do you know if there is anyway to install Groove Manager with SQL server set
to Integrated Windows authentication?
SBC said:
Windows authentication on SQL Server is considered to be more secure
(especially if all clients are in the same domain). A reason to do "mixed
mode" (SQL authentication) is for backward compatibility of applications.
The SQL Server being used by the Groove Manager may be used for other
purposes.
SBC
-------------------
Microsoft MVP - Groove
weblog:
http://weblogs.asp.net/sbchatterjee
sbc111 at gmaildotcom
Pickup Groove Developer workspaces:
http://www.ctdotnet.org
Ken Ng said:
Is there a way to work around the "Mixed Mode" authentication requirement for
the SQL server? With Window Authentication set for SQL, Groove Manager
installation fail with the error "Login failed for user '[SEVERNAME]_Ems'.
The user is not associated with a trusted SQL Server connection"
I can't imagine that Microsoft call for using Window Authentication for
secure environment but Groove can only work with SQL authentication.
