User access denied

Our SA is trying to give one of our users access to one of our companies and 
as soon as the checkbox is clicked next to the company name, the following 
message appears, "The user could not be added to one or more databases".

In this case the user already has access to nine of the companies.  The same 
message appears when we try to un-check the company box for another user.  
It's a test company - not that it should matter.

Appreciate any help
0
Utf
12/22/2009 9:10:01 PM
greatplains 29623 articles. 6 followers. Follow

2 Replies
1664 Views

Similar Articles

[PageSpeed] 34

Hi Merle,

I suppose you restore a database backup from one of your live companies to 
the test company database?  The error message is caused by already present 
sql (object) logins in the test company database for the user you're 
attempting to grant access company within GP.  Drop the user login the in the 
test company database in SQL and try to grant the user company access again 
in GP.

The scenario and troubleshooting steps above is only one variations of this 
incident.

Let us know how you go!

Cheers,

Dennis Araullo, MACS
Microsoft Certified Technology Specialist GP,CRM,AX
MCITP Installation and Configuration AX 2009
MCITP Database Administrator SQL 2008
Citrix Certified Enterprise Administrator



"Merle Schwickerath" wrote:

> Our SA is trying to give one of our users access to one of our companies and 
> as soon as the checkbox is clicked next to the company name, the following 
> message appears, "The user could not be added to one or more databases".
> 
> In this case the user already has access to nine of the companies.  The same 
> message appears when we try to un-check the company box for another user.  
> It's a test company - not that it should matter.
> 
> Appreciate any help
0
Utf
12/22/2009 9:47:01 PM
Hey thanks.  We figured this one out yesterday, but you hit the answer on the 
head.  Happy Holidays

"Dencio" wrote:

> Hi Merle,
> 
> I suppose you restore a database backup from one of your live companies to 
> the test company database?  The error message is caused by already present 
> sql (object) logins in the test company database for the user you're 
> attempting to grant access company within GP.  Drop the user login the in the 
> test company database in SQL and try to grant the user company access again 
> in GP.
> 
> The scenario and troubleshooting steps above is only one variations of this 
> incident.
> 
> Let us know how you go!
> 
> Cheers,
> 
> Dennis Araullo, MACS
> Microsoft Certified Technology Specialist GP,CRM,AX
> MCITP Installation and Configuration AX 2009
> MCITP Database Administrator SQL 2008
> Citrix Certified Enterprise Administrator
> 
> 
> 
> "Merle Schwickerath" wrote:
> 
> > Our SA is trying to give one of our users access to one of our companies and 
> > as soon as the checkbox is clicked next to the company name, the following 
> > message appears, "The user could not be added to one or more databases".
> > 
> > In this case the user already has access to nine of the companies.  The same 
> > message appears when we try to un-check the company box for another user.  
> > It's a test company - not that it should matter.
> > 
> > Appreciate any help
0
Utf
12/24/2009 6:48:01 PM
Reply:

Similar Artilces:

Access to VB tools
Hi, Does anyone know of any freeware tool that might help in this? I have looked at a couple commercial access to vb conversion tools but they are pretty expensive so I am wondering if anyone knows of a freeware or open source tool that we could use to save us some time and effort..... Thanks, Malakie Tony Toews lists a few tools at http://www.granite.ab.ca/access/accesstovb.htm: I'm not aware whether any of them are free. The general consensus is that conversion tools do an incomplete job at best. There are simply too many differences between the controls available for ...

populating an Access table from a text file
A text file has data in a format like the below: Title1 Cell 1 data Title 2 Cell 2 data Title 3 Cell 3 data .. .. .. Title 10 Cell 10 data Title 11 Cell 11 data .. .. .. Title 15 Cell 15 data .. .. .. Title N Cell N data I guess I can read this using some VBA code posted at http://www.mvps.org/access/modules/mdl0057.htm and http://www.granite.ab.ca/access/readtextfile.htm, add an Instr function to it so that when I read the text file, I know when to insert the data properly in the table. 1. Is there another way I can directly import the data into an Access 2...

Two domains and two users
(1) I have domain A and domain B (2) I have user A in domain A and user A in domain B (basically same user name but created at different time - different SIDS) (3) I want to remove domain A but copy user A SID info into user A of domain B - basically merge the SID of two accounts into domain B Question: ======= (1) How do I merge two accounts together into one account - merge SIDS of two accounts into one account? I HAVE NO Option such as delete destination account and recreate so PLEASE do not provide me that alternative or explanation - even if it is the easiest. Thank you k...

Lost original message when using outlook web access
I often use web access when travelling to get my work emails. When forwrdign and replying to emails, I always have the orginal email in tact and as part of the reply. However, when accessing from home on the internet, I lose the orginal email so that when I reply or forward there's nothing there. I also can't paste or copy into or from the message body. Is this problem easily fixed. Jim Assuming Outlook 2000 - though something like this will probably work for every version ... it just might not be in the same menu location. Go to Tools - Options - Preferences - Email option...

how do import the outlook express address book to mutipule users .
I just got a new system with Outlook,my wife and I have been using Express for mail.I imported the address book to my log in but can't figure out how to get it to hers.Any help is appreciated doates <doates@discussions.microsoft.com> wrote: > I just got a new system with Outlook,my wife and I have been using > Express for mail.I imported the address book to my log in but can't > figure out how to get it to hers.Any help is appreciated Exactly the same way. -- Brian Tillman ...

How to set up multiple users with same email account
I currently have the following set up on my XP Home SP3 using Outlook Express 2 user accounts on XP (mine and my wife's) 3 email accounts - all from one ISP (pop3) - (one for me only, one for my wife only, one for both of us) The address book is shared out to all email accounts. As Outlook Express is not supported in Windows 7 and I am not too keen on Windows Live Mail, I was thinking of moving over to Outlook 2003 (which I also have). Is it possible to set up the same construct I have with OE using Outlook 2003 and how is such a thing possible. I have seen articles ...

Excel/Access Delimma
I have inherited an Excel workbook with several worksheets containing charts that get their source data via MSQuery from an Access database. The users require that this stay in Excel so I have to find a way to make it work. The problem I am having is that whenever the user opens the workbook they are prompted to tell it whether or not to allow updates. The sad part of this is that we cannot rely on the numerous users to not accidently push the wrong button and allow it to update, and thus destroy the current data. I have to find a way that the user can open the workbook, let it update, sav...

Run a query based on user input to a text box
I am creating a database to manage Auction Bids for a live radio station phone auction weekend. I have a form where the user is entering names as the bidders call in. I want to be able to have entry into a text box cause a query to run and populate a list box so that if a caller has been entered before, the user can click on an existing name. So for example, if the first keystroke is A , then the list box will be populated with all names beginning with A. If the next keystroke is l to give Al then the list box will be repopulated with only names beginning with Al (e.g. Alice, Aliso...

Outlook Web Access 2K3
Hi, I am using OWA of the newly installed Exchange 2K3. When I use the premium mode and try to reply messages, the OWA keeps ask me to install the components. Why is it so? is there any pre-requisite to use the OWA premuim version. Thank MWGP Try posting this in an Exchange group for your version of Exchange as OWA is a function of Exchange, not Outlook. --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After searching go...

Public folder access problem #2
Hello, Don't know if this is an Exchange or Outlook problem, sorry for posting in both groups :-) Exchange Enterprise Edition 2003 SP2, Outlook 2003 SP2 in Windows XP SP2, 1.000 users and public folders. Until yesterday a user was able to access a public folder; tree is : \Public folders\All Public Folders\Department\Incoming Mail \Public folders\All Public Folders\Department\Outgoing Mail Then suddenly this user does not see the content of the Department folder nor the subfolders. When you click on the Department folder properties, summary tab, you see this user has the Reviewer role. ...

Read-only mailbox access, how to?
Exchange 5.5 on NT4 I want to set up a Support mailbox which all can read but only some can send-as. When I created it I associated it with the Domain Admin. I then added the Search role to Domain Users. But if I connect via a POP3 or IMAP client and authenticate as a domain user I am denied access. Ditto if I use an Outlook 2000 client connected to another mailbox, and try File->Open-> Other User's Folder. What permissions do I need for read-only access? The Help on the dialog in Exchange Admin doesn't even list the Search right! jim -- Jim Hatfield On Wed, 24 Aug 2005 14:...

Excel error: Permission to use object denied
I have some new computers setup with Windows XP and Office 97. When go into Excel and open a spreadsheet, I get a Microsoft Visual Basi error:Permission to use object denied. The spreadsheet will not open. The error happens with every spreadsheet I try to open on tha computer. If I copy the spreadsheet to another computer, it open without complaint. The other computer is also running XP and Excel 97 but was installed a few months ago. Any ideas -- Message posted from http://www.ExcelForum.com The following article may be of some help, althought your problem is slightly different. h...

Problem with user that sending out mail to 1000/users external
Hello I have 600/users on out Exchange 2000 server and some of them is sending out mail to 1000/user (external) and when they do that our mail server is working to hard and the other user is complaining. Is their anyway of stopping then from doing the mass mail during the day and then let them sending their mail at night?? Can I create some group (set some settings for max outgoing mamil) that handling this user or must I write some script?? Regards, Kenneth In Outlook, when creating new message click File\Properties\Send Options\MSExchange\Send this item in ... P.S. Sending message to 1000...

How to prevent users changing details in Contacts List
Hi All, After entering the contact details in the contact form, How to preven users from changing the details through the Conacts List ?? We have customised the contact form for not entering the non-codepag 1252 characters into the form. But, there is a possibility that use may do the trick by entering the non-codepage 1252 characters into th contact details through contacts list by clicking on a particula record with the help of a mouse and directly editing there. As per our requirement, the contact details shall be synchronised t Siebel through Exchange Server. Please suggest me how to av...

mass of cases/tasks/emails assigned to user
hello, I have just hada really strange thing happen in CRM 4.0. one user has just been assigned over 90 tasks/cases/emails. Has anyone ever had such a problem? Thanks Ian ...

Virtual user supports in exchange server (a email account without actually creating a email account)
I want to provide email service to my customer, but I don't want to create real user account and email account for each one. for example, I want to assign email like xyz123@mycompany.com to my customer, but I don't really have a email account named "xyz123" setup for it. Still, I want to be able to look at all the new email in the exchange server and extract those emails and doing somework accordingly. Does anyone know if Exchange server support this feature? If not, any other window based email server support it? Thank you so much for the help.. --Xin Chen In news:...

Can one access newsgroups from Outlook?
thanks In a way, yes. It calls for Outlook Express for this action. see: Outlookhelp - Support for Microsoft Office Outlook http://www.howto-outlook.com/Faq/news.htm "d p" <dp25@access-4-free.com> wrote in message news:%23ZttKlS9EHA.2196@TK2MSFTNGP14.phx.gbl... > thanks > > Thanks so much Walt ... a life saver. "Walt Basil" <see_signature@for_address.com> wrote in message news:#WV4VzS9EHA.2676@TK2MSFTNGP12.phx.gbl... > In a way, yes. It calls for Outlook Express for this action. > > see: > Outlookhelp - Support for Microsoft Offic...

Access database link
Am not a Visio user, am an Access person - - - the user makes Visio drawings is not technical. On the drawing are values. These values do not change the shape or size of the image of the drawing - they are just data surrounding the image. This data is already in an Access database and is used for reports and such. User needs Access Table - record 1 data to appear in drawing 1 record 2 data to appear in drawing 2 If he opens drawing 2 - the current data would populate (from record 2 of Table). So if the values in the record changed/updated in the ...

VB Code for button for Access 2003
I have a form called "Quote Entry" displaying data from a table called "Quote" with a field "CustomerID", on this form there is a button called "Customers". This opens a form called "Customer Display" which is a Continuous list of customers, from the current selected customer record. I need some code for a button on the "Customer Display" form to save the current CustomerID back the Quote Entry form and add it to the Quote Table -- thank you for your help "Meaty" <Meaty@discussions.microsoft.com> wrote in messa...

Allow access to item properties when Adding Items to purchase orde
Allowing access to item properties when adding items to a purchase order would assist in updating information like aliases, etc. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx...

How to create and access (add/delete mails) .PST file at runtime?
Hi, I need to store selected mails into some different .pst file at runtime. Also want to access those mails in .pst at runtime. I can import and export mails into .MSG file. But it is hard to maintain mails as .msg files. My queries are, 1. How to create/open .PST file at runtime ? 2. How to add/delete (import/export) mails (any format like .MSG, ..EML, etc.,) into .PST at runtime ? Is there any way to handle this kind of situation thru Outlook object model or CDO or Extended MAPI or Redemption or any other way? Thanks in advance with best regards, Kumar 1. Use Namespace.AddStore/Re...

Locking the User In
Does anyone have any suggestions on locking the user into an application so that they only go where you want them to (more or less, they do have some choices!) Is there a way to map it out on paper? Whats the easiest way to do this without getting lost or confused as I'm doing this. Any suggestions welcomed! Thanks DS What you are talking about is a Modal Application and the industry pretty mush left those behind when we left DOS. Object Oriented Event Driven software (such as Access) is very non modal and IMHO much easier for the user to learn. What is happening in your applicat...

Mail not received when certain user is on the To: or CC: list
Hi, I am using Exchange Server 2003 SP 1 (I believe) with XP clients running Outlook. Basically we have a problem sending email to a specific user when another specific user is in the cc or to field. IE. We have 5 employees If anyone in the company sends a message to Employee number 1 and employee number 5 is also in the message (either TO: or CC; field) then employees Number 2,3,4 and 5 will get it but not employee number 1. However employees number 1 can receive mail from all employees as long as employee number 5 is not in either the TO: or CC: field. Any help??? Thanks Check ...

Exchange 2003 OWA shared calendar access
Hi We are using Exchange 2003 with both OWA and outlook 2003 clients. I have set the permissions on everyones calendar so everybody has reviewer access to each other calendars. All calendars can be opened when using Outlook 2003. However when using OWA only some calendars can be opened and others are stating "You are not authorized to view this page" when trying to open them even though the permissions have been set to access them. I am trying to access them by typing http://servername/exchange/username/calendar Any ideas would be greatfully received Colin ...

Charts change by user
I have a set of charts to track daily data. On my PC with my resolution they look perfect. But when other users look at them with their lower resolutions they look different. The legend and other items move and do not fit the chart anymore. Is there a way to make the charts look the same no matter who looks at them and no matter what their resolution is? Thanks! Tim - I suppose you could export them as GIF files, and report them in a web page. Then everyone has the same low resolution. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index...