SharePoint stsadm addsolution - fails with permission based error (object ref)

Question

Attempting to deploy a MOSS solution to a UAT server from dev server for the first time. On executing this command

stsadm -o addsolution -filename xxx

I get a "Object reference not set to an instance of an object" Based on these links: (and others):

[http://social.msdn.microsoft.com/forums/en-US/sharepointdevelopment/thread/63f0f95d-1215-4041-be6d-64ae63bda276/][1]

[http://www.telerik.com/community/forums/thread/b311D-bachea.aspx I made sure of the following:][1]

1. I am a member of the farm admin group on the MOSS server
2. I am member of the WSS_RESTRICTED_WPG on the server
3. I was already in the WSS_ADMIN_WPG group on the server

I checked the event log and found exceptions saying that the login to my Site Services DB failed.

If I attempt to add myself via SQL Server Mgt Studio I do not have access to set access to that DB such as this:

Reason: Cannot open database "SharedServices1_DB" requested by the login. The login failed. Login failed for user 'XXXXX\Administrator'.

So, what am I missing? Any obvious things I need to do? Any helpful suggestions are welcome.

Thanks

[1]: http://MSDN forum thread

[1]: http://Telerik support thread

Answer 1

I think the obvious thing you are missing is that the user account doesn't have the required permission to use the sharepoint database - just as it says in your post ;)