Login / Signup

SQL Server minimum access right (non sysadmin)

 
Archive Data mgt
Last Post by f.martin 6 years ago
19 Posts
6 Users
0 Likes
155 Views
RSS
 m.nau@ypsys.com
(@m.nau@ypsys.com)
Posts: 0
New Member Guest
 

I don't have permission to read this article.

" You are not authorized to access the requested resource

You do not have permission to view this directory or page using the credentials you supplied."

Is it normal?
Manu

 
Posted : 23/06/2017 11:59 am
g.montmartin
 g.montmartin
(@g-montmartinarcinfo-com)
Posts: 20
Member Moderator
 

Hi,
The article is now public

 
Posted : 23/06/2017 12:00 pm
f.cubattoli
 f.cubattoli
(@f-cubattoliarcinfo-com)
Posts: 167
Reputable Member
 

Hello, I made some tests with PcVue 12 Update 15 and SQL Server 2017. Using the raccomandation provided in KB 869 I have this error during HDS startup:

4704=738-99b4f77132bdba867c28b1181bd8ca5f
2020/07/03,17:29:06.235,VMW10MOB1,dev,HDS,E,0,0,smoReportException __ SmoError Source : 'mscorlib' Description : 'Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index'

This error disappears if I grant "sysadmin" privileges to the SQL Server user set in PcVue to connect the database. Any idea? I tried with SQL Server profiler to locate the failed query but I'm not able to determine what happens.

KB869 : https://staging.pcvue.com//sql-server-2012-user-right/

This post was modified 2 years ago by LM
 
Posted : 03/07/2020 11:04 pm
f.martin
 f.martin
(@f-martinarcinfo-com)
Posts: 148
Member Admin
 

Hi Filippo,

You can check SPR 67484.
Kevin fixed this issue in version 15.0 last month.At startup the HDS was always trying to set the maximum size of the database, which requires the dbcreator role. Now this is done only at the db creation.

BR,
Florent

 
Posted : 10/07/2020 2:27 pm
Forum Jump:
  Previous Topic
Next Topic