One or more connection strings in your UTIL.DBC are invalid, or user does not have appropriate SQL permissions

[Michele]

I have 4 desktops and 2 started giving me this error!

I have run CreateDBC with no errors. But I still get the error on the 2 desktops.
Any help would be appreciated.
Thanks,
Michele

[Keller,Rod]

You might try running a Windows System Restore to a date prior to the time you started having the issue.

 

Rod Keller

 

 

---

From: lam2m...@googlegroups.com [mailto:lam2m...@googlegroups.com] On Behalf Of Michele
Sent: Tuesday, June 26, 2012 3:14 PM
To: lam2m...@googlegroups.com
Subject: [lam2musers] One or more connection strings in your UTIL.DBC are invalid, or user does not have appropriate SQL permissions

--
You received this message because you are subscribed to the Google Groups "Los Angeles Area Made2Manage User Group" group.
To view this discussion on the web visit https://groups.google.com/d/msg/lam2musers/-/Wf13yOqCyywJ.
To post to this group, send email to lam2m...@googlegroups.com.
To unsubscribe from this group, send email to lam2musers+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/lam2musers?hl=en.

[Walia, Rajesh]

Hi Michelle.

You have a corrupt user table. Actually the fpt table. This has happened to me before.

M2m has a routine you can follow to clear it. Basically you copy the user table to a tmp, delete the usdr table, copy the blank tables from Data00 folder, then repopulate the users.

All users need to be out whilst this goes on.

Or, just give those corrupted users new M2M logins until its a good time to shut the system down to perform the steps.

All the Best!
Raj

Rajesh Walia
Logistics and Systems Admin
Diamond B, Inc., a HILTI Group Company
Phone 714-230-7435
Email Raj....@Hilti.com

[Michele]

Hi Raj,

 

Thank you for your reply.

 

The screen comes up before the 2 users even get into M2M, but I will try anything.

 

I am a little unclear on where to find the tables.

 

Do you have a written procedure, if not can you write it for me when you have a chance.

 

Thanks,

 

Michele.

To unsubscribe from this group, send email to lam2musers+unsubscribe@googlegroups.com.

[Michele]

Hi Rod,

 

I tried the system restore, no luck.....

 

Any other ideas....

 

Thanks,

 

Michele

 

On Tuesday, June 26, 2012 3:25:01 PM UTC-7, Rod Keller wrote:

You might try running a Windows System Restore to a date prior to the time you started having the issue.

 

Rod Keller

 

 

---

From: lam2m...@googlegroups.com [mailto:lam2musers@googlegroups.com] On Behalf Of Michele

Sent: Tuesday, June 26, 2012 3:14 PM
To: lam2m...@googlegroups.com
Subject: [lam2musers] One or more connection strings in your UTIL.DBC are invalid, or user does not have appropriate SQL permissions

I have 4 desktops and 2 started giving me this error!

I have run CreateDBC with no errors. But I still get the error on the 2 desktops.
Any help would be appreciated.
Thanks,
Michele

--
You received this message because you are subscribed to the Google Groups "Los Angeles Area Made2Manage User Group" group.
To view this discussion on the web visit https://groups.google.com/d/msg/lam2musers/-/Wf13yOqCyywJ.
To post to this group, send email to lam2m...@googlegroups.com.

To unsubscribe from this group, send email to lam2musers+unsubscribe@googlegroups.com.

[Walia, Rajesh]

Hi Michele.

 

Its not a system restore, it's grabbing the user tables from your backup of x:/m2mdata/util.  They're

 

utuser.dbf,

utuser.fpt,

utuser.cdx

 

Remove these files from the Util folder and replace them from the last backup of this folder where the users were not having issues.

 

I don't remember if you have to do the CreateDBC or anything but I don't think so.

 

Hope this helps!
Raj

Rajesh K. Walia
Diamond B, Inc.
A HILTI Group Company
P 714-230-7435 I F 918-459-3627 | E raj....@hilti.com
www.us.hilti.com

 

---

From: lam2m...@googlegroups.com [mailto:lam2m...@googlegroups.com] On Behalf Of Michele
Sent: Tuesday, June 26, 2012 4:38 PM
To: lam2m...@googlegroups.com
Subject: Re: [lam2musers] One or more connection strings in your UTIL.DBC are invalid, or user does not have appropriate SQL permissions

To view this discussion on the web visit https://groups.google.com/d/msg/lam2musers/-/oiCJe4dk_7YJ.

To post to this group, send email to lam2m...@googlegroups.com.

To unsubscribe from this group, send email to lam2musers+...@googlegroups.com.

[Anthony Agpaoa]

ACtually I've received this msg on numerous occasion, almost always on a Windows 7 PC.  IF this is not  systemwide and just specific to certain machines, then try these steps that have worked for me in the past.

1) Unistall M2M and  SQL server native client on the PC's.  Delete M2Mwin.ini too

2) Run setup.exe from the \m2m\srvpck\  directoryand isntall client from there.

I it may help to download LAtest sclncli.mis or sqlncli_x64.msi from micrsofot for SQL server native client.

3) MAke sure you are logged in with admin priveledges on the local pc's and give Explicit  RW access to Windows system directory and M2M program file directories.  For some  reason these are not granted as a default.

[Ray Collazo]

Hello all!

  We have purchased 10 Win7 (64-bit) machines as part of my facilities overall Systems upgrade, and I'm curious as to everyone elses experieces in running M2M6.01 under it.

 

-Ray

 

[Bill Greganti]

Ray,

The only thing I can think of right off the bat is that we disabled UAC via group policy. W7 UAC could not decide if M2M wanted elevated privileges or not. One day it would prompt the user, and the next it would not.

Not W7 specific, but I always add RW permissions for Domain Users to the M2M program folder and M2MWin.ini.

Bill Greganti

Owner

The I.T. Department

(714) 491-3886 Office

(714) 491-3887 Fax

(714) 746-3356 Mobile/Text

Sent from my iPhone.

--

You received this message because you are subscribed to the Google Groups "Los Angeles Area Made2Manage User Group" group.

[Brent Marcus]

Hi Ray;

 

We use mostly Windows 7 workstations.  64 bit Windows 7 runs M2M 6.01 significantly better  than XP. I think this is because of more available RAM.  Also, the SQL Native client is optimized for 64 bit environments, and is more efficient with queries. It’s difficult to judge what speed increase is attributable to Windows 7, since the newer OS is always on newer machines with faster processors. Still, the improvements are noticeable.

 

Regards;

 

Brent A. Marcus

Director of Information Technologies

Reinhold Industries, Inc.

(562) 321-6666 Direct (949) 232-4216 Cell

 

 

 

From: lam2m...@googlegroups.com [mailto:lam2m...@googlegroups.com] On Behalf Of Ray Collazo

Sent: Wednesday, June 27, 2012 4:39 PM
To: lam2m...@googlegroups.com

Subject: [lam2musers] Windows 7...

Reinhold Proprietary Information Statement:
The information contained herein and/or attached is Reinhold Industries Proprietary Information and is disclosed in confidence. This information shall not be used, disclosed to others or reproduced without the express written consent of Reinhold Industries, Incorporated.

Reinhold Export Control Statement:
The information contained herein and/or attached may contain technical data within the definition of the International Traffic in Arms Regulations, and are subject U.S. export control laws. Unauthorized export or re-export and/or transfer of this information by any means to a foreign person, whether in the U.S. or abroad, is prohibited without an export license or other approval from the U.S. Department of State.

--
You received this message because you are subscribed to the Google Groups "Los Angeles Area Made2Manage User Group" group.
To post to this group, send email to lam2m...@googlegroups.com.
To unsubscribe from this group, send email to lam2musers+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/lam2musers?hl=en.

Reinhold Proprietary Information Statement:
The information contained herein and/or attached is Reinhold Industries Proprietary Information and is disclosed in confidence. This information shall not be used, disclosed to others or reproduced without the express written consent of Reinhold Industries, Incorporated.

Reinhold Export Control Statement:
The information contained herein and/or attached may contain technical data within the definition of the International Traffic in Arms Regulations, and are subject U.S. export control laws. Unauthorized export or re-export and/or transfer of this information by any means to a foreign person, whether in the U.S. or abroad, is prohibited without an export license or other approval from the U.S. Department of State.

[Michele]

Hi all,

 

Thank you for all your responses!

Now its happend to all 4 desktops!  Not quite sure what is going on, I have tried everything that everyone has suggested!

 

Now when I try to run Creatdbc from the desktops I get the following error:

 

M2M DBC maintenance utility
Unable to connect to SQL using the curent users login. Either the login does not exist, lacks sufficient permissions, the specified SQL server name is invalid, or the specified SQL database name is invalid.

all is correct, I dont know why its not picking it up.

 

Any help would be appreciated.

 

Thanks,

Michele

[Bill Greganti]

Michele,

I would begin to suspect the network or server at this point. There are so many possibilities, so I'll just start throwing ideas out.

Can the workstations ping the server by name? Can you telnet to port 1433 on the server? Do you have the SQL management tools on any workstations to test connections? Can you open M2M on the server?  Ran any diagnostics on the SQL databases?  Any related errors in the event viewer on the server or workstations?

Bill Greganti

Owner

The I.T. Department

(714) 491-3886 Office

(714) 491-3887 Fax

(714) 746-3356 Mobile/Text

Sent from my iPhone.

--

You received this message because you are subscribed to the Google Groups "Los Angeles Area Made2Manage User Group" group.

To view this discussion on the web visit https://groups.google.com/d/msg/lam2musers/-/z5B2U_s2oiYJ.

[Thomas D. Erb]

Could this be a problem with your domain security ?

 

 

From: lam2m...@googlegroups.com [mailto:lam2m...@googlegroups.com] On Behalf Of Bill Greganti

Sent: Friday, June 29, 2012 12:22 AM
To: <lam2m...@googlegroups.com>

Subject: Re: [lam2musers] Re: One or more connection strings in your UTIL.DBC are invalid, or user does not have appropriate SQL permissions

Michele,

 

I would begin to suspect the network or server at this point. There are so many possibilities, so I'll just start throwing ideas out.

 

Can the workstations ping the server by name? Can you telnet to port 1433 on the server? Do you have the SQL management tools on any workstations to test connections? Can you open M2M on the server?  Ran any diagnostics on the SQL databases?  Any related errors in the event viewer on the server or workstations?

 

 

Bill Greganti

Owner

The I.T. Department

(714) 491-3886 Office

(714) 491-3887 Fax

(714) 746-3356 Mobile/Text

 

Sent from my iPhone.

 

On Jun 28, 2012, at 5:42 PM, "Michele" <mic...@damarplastics.com> wrote:

--

You received this message because you are subscribed to the Google Groups "Los Angeles Area Made2Manage User Group" group.
To view this discussion on the web visit https://groups.google.com/d/msg/lam2musers/-/z5B2U_s2oiYJ.
To post to this group, send email to lam2m...@googlegroups.com.
To unsubscribe from this group, send email to lam2musers+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/lam2musers?hl=en.

[Brent Marcus]

Hi All;

 

Has anyone used an epayables system with M2M? We are evaluating Bank of America’s E-Pay system and wondered if anyone else has any experience with integrating this into M2M? Basically, this looks for a pay file to be created instead of a check run, and disperses actual payment through the cloud.

 

Thanks;

 

Brent A. Marcus

Director of Information Technologies

Reinhold Industries, Inc.

(562) 321-6666 Direct (949) 232-4216 Cell

 

 

[Thomas D. Erb]

Interesting idea – I wouldn’t  trust BofA  with my change dish though

--