SQL Server Login Error During Setup

J

John Caruthers

Error: SQL Server login is invalid or does not have security administrator
permission.

User is a domain account that has securityadmin permission on the
SQL Server Instance that I created for Groove.

I have heard that Groove must be installed on the Default SQL Server
Instance. Is this true? Is there any way around it?

Thanks in advance.

- John.
 
B

Bob Weiner

I am having the same problem. I am installing on Win03R2 with SQL 05
(having failed with Win08 and SQL08/05). My account is also a local admin
as well as a securityadmin on the SQL server.

The log file following the failure gives:

---Snip---
A SqlException was thrown. Failed to execute the sql command: EXEC
Gdb_Administrator_Create 'ecs_grv_mgr_Ems',
'f667c257_ecca_4c4c_8940_bdc07a3c5d2f_Ems', 1
An exception of type System.Data.SqlClient.SqlException was thrown.
Additional exception information: User does not have permission to perform
this action.
-----------

On the SQL server, the gmsDb exists, contains an account 'ecs_grv_mgr_Ems'
which is a member of the EMSAdministrator role. Neither the role nor the
account however, have permissions to execute the stored procedure
dbo.Gdb_Administrator_Create.

To workaround, I
granted exec permission to EMSAdministrator for the stored procedure,
uninstalled Groove Mgr,
rebooted the server, and
re-ran setup.exe

When pressing Next on the Groove Manager Database Configuration, I get an
error that says:
"Database gmsDb is not a valid Groove Server Manager database. Select a
valid Groove Server Manager database or specify a new database name."

I could delete the database but then I'm back at square 1.

Also, on a side note, it seems strange that the database contains schemas,
ecs_grv_mgr_Ems and EMSAdministrator, but doesn't actually used them (at
least I found no associated objects).


Please send help - people are waiting...
 
B

Bob Weiner

The solution is to do the install using the SQL server SA account rather
than a domain account. You can disable the account after the installation
completes.

My groove manager is running fine now.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top