I have installed SQL Server 2012 on Windows Server 2008. This system is configured to be part of a Workgroup and all the users in our organisation are part of a domain. I am trying to use the reporting services that is part of SQL Server.
I was trying to give "System User" permission to a user who is part of the domain through the "New System Role Assignment" page of the "Report Manager". It keeps throwing the error "user name or group name is not recognized.(rsUnknownUserName)"
Is it because the server is in a workgroup or is there any other reason?
Best Answer
Well according to MSDN here:
I would take that to mean you will not be able to do what you are wanting. A work around I would try is to create a local group, adding the domain group/user to it, and try to add that local group to the new system role. It has been a while since I have supported a mixed environment so I am not sure if you can add domain accounts to a workgroup computer. You might have to check with your AD admin for assistance on that.