I have a sql 2008 express with advanced services running on a windows 7 box. I can get into reporting services through the browser on that box. I want to be able to access RS from other boxes as well. All the boxes (3 of them) are running windows 7 and all of them belong to the same workgroup. I've created the three logins used in a group on the SQL box and added each of those users to group. Then in RS i added that group as having access to the RS. I tried to mimic how i've done it before when there was a domian. Apparently i'm either missing something on you can't access RS from another box in a workgroup env. Wondering if anyone had any pointers. thanks

I have a sql 2008 express with advanced services running on a windows 7 box. I can get into reporting services through the browser on that box. I want to be able to access RS from other boxes as well. All the boxes (3 of them) are running windows 7 and all of them belong to the same workgroup. I've created the three logins used in a group on the SQL box and added each of those users to group. Then in RS i added that group as having access to the RS. I tried to mimic how i've done it before when there was a domian. Apparently i'm either missing something on you can't access RS from another box in a workgroup env. Wondering if anyone had any pointers. thanks

Hi jvcoach23, In a domain environment, the client's credential can be passed to the Domain Controller to be verified. However, in a workgroup, the credential is verified locally. We are unable to authorize a credential from remote computer. So, in general word, we are not able to impersonate a domain environment. However, there should have a workaround, that please create the user account in all boxes(4 boxes in this case) with the same username and password. This should pass throught the error you met. If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

Yes.. i tried that.. i created teh users that are used to log into the other computers are the RS box. It appears taht the pass through does not allow for authentication. Do i have any other options... it's a non profit org so i don't have any money to upgrade this to a domain. thanks shannon

Hi Shannon, In this case, I would suggest you using customized security extension instead of Windows Integrated authentication. For example, if we are using Forms Authentication, we can create users in a user system, and then use these users in the report server. Microsoft providers a Forms Authentication sample for SQL Server Reporting Services(SSRS), it can be found from: http://msftrsprodsamples.codeplex.com/ For your original question, it seems, in some cases, a local user won't be able to access the network resource. You can ask the network team to help on this. Thanks, Jin ChenJin Chen - MSFT

Hi Shannon, In this case, I would suggest you using customized security extension instead of Windows Integrated authentication. For example, if we are using Forms Authentication, we can create users in a user system, and then use these users in the report server. Microsoft providers a Forms Authentication sample for SQL Server Reporting Services(SSRS), it can be found from: http://msftrsprodsamples.codeplex.com/ For your original question, it seems, in some cases, a local user won't be able to access the network resource. You can ask the network team to help on this. Thanks, Jin ChenJin Chen - MSFT

ok.. i'll give that a shot. thanks for the help