July 31, 2008 at 3:17 pm
Hi all,
I have a SSRS report where I can take in the user ID as a parameter using custom code that does a real simple call to WScript.Network to get the user id. Unfortunately, while this works fine from within Visual Studio in terms of proper report execution and display, once I deploy the report to the reporting server, accessing the report provides the following error:
Error during processing of ‘UserName’ report parameter. (rsReportParameterProcessingError)
Here's my custom code:
Public Function GETUSER()
Dim objNet As Object
objNet = CreateObject("WScript.Network")
GETUSER = UCase(objNet.UserName)
objNet = Nothing
End Function
I have no idea why. Do I perhaps need a reference to an assembly that would provide the necessary dll when run through the reporting server? Is there some other factor I need to know? Thanks!
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
August 1, 2008 at 8:47 am
Well, no responses so far... dang... So, I'm now trying to use SERVER_LOGIN within the stored procedure, and it produces results just fine within Visual Studio, and I can run the report just fine there, however, I've deployed this to the web server, and on the web server I'm now getting an error about not being able to connect to the data source. I'm using Windows Integrated Security for this data source, and I'm not sure why this doesn't work. It's possible to configure SQL Server to not allow that to operate, but BOL indicates you'd get an error message that tells you it's not allowed. I've already found the following post from 2005:
http://www.sqlservercentral.com/Forums/Topic154669-150-1.aspx
And I added the Integrated Security parameter to the connection string, but to no avail. I've deleted all my reports and my data source from the web server and completely redployed them, also to no avail. Any ideas folks?
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply