| Author |
Topic |
|
datasphere
Starting Member
6 Posts |
 Posted - 2011-01-11 : 20:56:26
|
| Hi, I encountered a problem with my user ID when I login to GP after every year end, this is the 2nd time it happened. Now I have 2 IDs with this problem. When I click on Purchase Order Entry during the first working day of the year, an error will appear. "You are not authorized to enter Purchase Orders at this time" Is it something to do with some date settings? Any experts here please advise? Thanks a million! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-01-12 : 10:41:07
|
| i think when you create userID it has an expiration date attached to it which its defaulting to end of year. just check for that property and disable and select userid never expires option instead.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
datasphere
Starting Member
6 Posts |
Posted - 2011-01-26 : 02:30:00
|
| Hi visakh16,Thank you very much for your advice.We tried to look thru the user ID setup in GP and compare with other user ID and there is no difference.Do you know where can we find the setting to set the expiry date? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-26 : 09:15:48
|
| In Management Studio, expand the server, drill down to the Security/Logins node. Right click the login in question, click properties. In the General tab, see if "Enforce Password Policy" and "Enforce Password Expiration" are ticked. |
|
|
|
datasphere
Starting Member
6 Posts |
Posted - 2011-01-26 : 20:19:12
|
| Hi Russell,Thank you for your kind advice. We are using SQL server 2000, guessed there is no management studio.Any other ways to find the settings? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-27 : 11:42:20
|
| pretty much the same steps in Enterprise Manager |
|
|
|
datasphere
Starting Member
6 Posts |
Posted - 2011-01-27 : 20:30:25
|
From the enterprise manager, I expanded our SQL Server --> security ---> Logins but I cant seem to find any general tab available. When i right click a particular user and click on properies, on the general there is no option for me to untick "Enforce password policy". |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-27 : 21:39:19
|
| Sorry, I was wrong. Not available in SQL 2000.Is DSS checked in the database access tab? |
|
|
|
datasphere
Starting Member
6 Posts |
Posted - 2011-01-28 : 00:04:27
|
| Yes it is checked, I have compared the settings with other users and I can't seem to find any difference. |
|
|
|
|
User ID Issue in Great Plains