Showing posts with label http. Show all posts
Showing posts with label http. Show all posts

Sunday, March 25, 2012

cant get any event from FormsAuthentication Sample in the report server ?

Hi i have used

http://msdn2.microsoft.com/en-gb/library/ms160724.aspx

to enable custom security in the report server,now custom security sample is working fine with my report server,

So bigger problem is my Software manager ask me to redesighn

UILogon.aspx page ?

Now the bigger problem is when redesign the UILogon.aspx page

I am having lot of problems in the sample ,thing is i cant get any button event from the

code behind it self ?

Error is saying that

"cannot handle Event 'Public Event Click(sender As Object, e As System.Web.UI.ImageClickEventArgs)' because they do not have the same signature."

Whats is the wrong with this ?

regards

sujithf ?

The only requirement for the method that handles the event is that it must have the same signature (parameters) as the delegate that is defined as the event handler for the event...If we put the Handles clause on a method whose signature does not match the delegate, then the compiler will give us a build error saying, "Method Car_Start cannot handle Event 'Start' because they do not have the same signature."

http://www.knowdotnet.com/articles/creatingevents3.html

http://msdn2.microsoft.com/en-us/library/00wh89xa.aspx


|||

Thank you very much for the help,

now its working with the help of u r answer,,........realy helped me lot

regards

sujithf

sql

Tuesday, March 20, 2012

Can't extract key with rskeymgmt

I'm trying to move my RS from one machine to another. Following the MS
instructions found on
http://support.microsoft.com/?kbid=842425, it says to extract the
encryption key. When I try that, i get
C:>rskeymgmt.exe -e -f c:\rskey.txt -p thepassword
Are you sure you want to extract the key from the report server (Y/N)?
y
The local NT Service is disabled 0x80090005
What service would that be? I've seen similar posts with no
resolution. thanks in advance,
steveIhave the same problem
windows 2003 with SP1 and RS 2000 with SP2
any advice?
"sfp" wrote:
> I'm trying to move my RS from one machine to another. Following the MS
> instructions found on
> http://support.microsoft.com/?kbid=842425, it says to extract the
> encryption key. When I try that, i get
> C:>rskeymgmt.exe -e -f c:\rskey.txt -p thepassword
> Are you sure you want to extract the key from the report server (Y/N)?
> y
> The local NT Service is disabled 0x80090005
> What service would that be? I've seen similar posts with no
> resolution. thanks in advance,
> steve
>|||Unfortunately, no. I could not find a solution so I gave up. I
recreated manually. I'd be interested to hear if you find a solution
tho!
Cheers,
Steve
Josky wrote:
> Ihave the same problem
> windows 2003 with SP1 and RS 2000 with SP2
> any advice?
> "sfp" wrote:
> > I'm trying to move my RS from one machine to another. Following the MS
> > instructions found on
> > http://support.microsoft.com/?kbid=842425, it says to extract the
> > encryption key. When I try that, i get
> >
> > C:>rskeymgmt.exe -e -f c:\rskey.txt -p thepassword
> > Are you sure you want to extract the key from the report server (Y/N)?
> > y
> >
> > The local NT Service is disabled 0x80090005
> >
> > What service would that be? I've seen similar posts with no
> > resolution. thanks in advance,
> >
> > steve
> >
> >|||Switch the Account of the Rport Server Service to "NETWORK SERVICE" before
you backup the Key.sql

Can''t drop trigger assembly

Created an assembly based on this article...

http://sqljunkies.com/Article/4CD01686-5178-490C-A90A-5AEEF5E35915.scuk

Now I want to make changes and redeploy the assembly but when I try to drop I get this.

IF EXISTS (SELECT * FROM sys.assemblies asms WHERE asms.name = N'AuditCommon')

DROP ASSEMBLY [AuditCommon]

Msg 6590, Level 16, State 1, Line 3

DROP ASSEMBLY failed because 'AuditCommon' is referenced by object 'clr_trigger'.

Any ideas?

Figured it out. clr_trigger was a trigger that I created somewhere along the way which was dependent upon the assembly. It didn't appear anywhere in SQL Manager Studio so I thought that it was some sort of system object.|||A late reply,

using show dependencies, list out those need to removed. Remove the listed first and then drop the assembly.

Can't drop trigger assembly

Created an assembly based on this article...

http://sqljunkies.com/Article/4CD01686-5178-490C-A90A-5AEEF5E35915.scuk

Now I want to make changes and redeploy the assembly but when I try to drop I get this.

IF EXISTS (SELECT * FROM sys.assemblies asms WHERE asms.name = N'AuditCommon')

DROP ASSEMBLY [AuditCommon]

Msg 6590, Level 16, State 1, Line 3

DROP ASSEMBLY failed because 'AuditCommon' is referenced by object 'clr_trigger'.

Any ideas?

Figured it out. clr_trigger was a trigger that I created somewhere along the way which was dependent upon the assembly. It didn't appear anywhere in SQL Manager Studio so I thought that it was some sort of system object.|||A late reply,

using show dependencies, list out those need to removed. Remove the listed first and then drop the assembly.

Wednesday, March 7, 2012

Can't create http endpoint - don't have permission

I am trying to install an application that have following code in SQL Server
installation script
CREATE ENDPOINT RequirementsAuthoring
STATE = STARTED
AS HTTP (
SITE = '*',
PATH = '/sql/RequirementsAuthoring',
AUTHENTICATION = (INTEGRATED),
PORTS=(CLEAR)
)
FOR SOAP (...
I get following error
The user 'SIATA\Shimon' does not have permission to register endpoint
'RequirementsAuthoring' on the specified URL. Please ensure the URL refers
to a namespace that is reserved for listening by SQL.
I logged as computer admin on Windows XP with IIS installed.
I tried to run
sp_reserve_http_namespace N'http://Siata:80/sql/RequirementsAuthoring'
That runs just fine. But I still get the same error when I run first script.
Any suggestions?
Thanks,
ShimonHello Shimon,
Although you are logged into Windows as an Admin, that doesn't automatically
make you a member of SA role. Can you do this:
use master
go
grant create endpoint to [your-domain\your-account]
Thanks,
Kent Tegels, DevelopMentor
http://staff.develop.com/ktegels/|||Thanks for fast replay.
No, I can't do it I got this
Cannot find the login 'Siata\Shimon', because it does not exist or you do
not have permission.
I don't get this but. When I am using Management Studio I get this ID as
logged in ID.
I am probably the member of BUILDIN/Administrators
Any solution?
Thanks
"Kent Tegels" <ktegels@.develop.com> wrote in message
news:b87ad741b7c58c89f11cfb03360@.news.microsoft.com...
> Hello Shimon,
> Although you are logged into Windows as an Admin, that doesn't
> automatically make you a member of SA role. Can you do this:
> use master
> go
> grant create endpoint to [your-domain\your-account]
> Thanks,
> Kent Tegels, DevelopMentor
> http://staff.develop.com/ktegels/
>|||Well I created the log in and run your script. It worked. I still have the
same error with original script.
How can I confirm that the namespace 'is reserved for listening by SQL.'
Thanks
"Kent Tegels" <ktegels@.develop.com> wrote in message
news:b87ad741b7c58c89f11cfb03360@.news.microsoft.com...
> Hello Shimon,
> Although you are logged into Windows as an Admin, that doesn't
> automatically make you a member of SA role. Can you do this:
> use master
> go
> grant create endpoint to [your-domain\your-account]
> Thanks,
> Kent Tegels, DevelopMentor
> http://staff.develop.com/ktegels/
>|||Hello Shimon,
I believe HTTPCFG.EXE can do this, but I don't have it locally to work with.
You can download it from the MS website. See the following URL
http://www.microsoft.com/downloads/...&displaylang=en
(watch for wrapping, of course)
Thanks,
Kent Tegels, DevelopMentor
http://staff.develop.com/ktegels/|||Thanks.
Will Try
Shimon
"Kent Tegels" <ktegels@.develop.com> wrote in message
news:b87ad741b88e8c89f1e021134b0@.news.microsoft.com...
> Hello Shimon,
> I believe HTTPCFG.EXE can do this, but I don't have it locally to work
> with. You can download it from the MS website. See the following URL
> http://www.microsoft.com/downloads/...&displaylang=en
> (watch for wrapping, of course)
> Thanks,
> Kent Tegels, DevelopMentor
> http://staff.develop.com/ktegels/
>|||Yes, I checked the namespace is reserved.
But I still keep getting this message
An error occurred while attempting to register the endpoint
'RequirementsAuthoring'. One or more of the ports specified in the CREATE
ENDPOINT statement may be bound to another process. Attempt the statement
again with a different port or use netstat to find the application currently
using the port and resolve the conflict.
I tried to run netstat but can't find anything listening to port 80 or 1433.
Thanks
"Kent Tegels" <ktegels@.develop.com> wrote in message
news:b87ad741b88e8c89f1e021134b0@.news.microsoft.com...
> Hello Shimon,
> I believe HTTPCFG.EXE can do this, but I don't have it locally to work
> with. You can download it from the MS website. See the following URL
> http://www.microsoft.com/downloads/...&displaylang=en
> (watch for wrapping, of course)
> Thanks,
> Kent Tegels, DevelopMentor
> http://staff.develop.com/ktegels/
>

Can't create http endpoint - don't have permission

I am trying to install an application that have following code in SQL Server
installation script
CREATE ENDPOINT RequirementsAuthoring
STATE = STARTED
AS HTTP (
SITE = '*',
PATH = '/sql/RequirementsAuthoring',
AUTHENTICATION = (INTEGRATED),
PORTS=(CLEAR)
)
FOR SOAP (...
I get following error
The user 'SIATA\Shimon' does not have permission to register endpoint
'RequirementsAuthoring' on the specified URL. Please ensure the URL refers
to a namespace that is reserved for listening by SQL.
I logged as computer admin on Windows XP with IIS installed.
I tried to run
sp_reserve_http_namespace N'http://Siata:80/sql/RequirementsAuthoring'
That runs just fine. But I still get the same error when I run first script.
Any suggestions?
Thanks,
ShimonHello Shimon,
Although you are logged into Windows as an Admin, that doesn't automatically
make you a member of SA role. Can you do this:
use master
go
grant create endpoint to [your-domain\your-account]
Thanks,
Kent Tegels, DevelopMentor
http://staff.develop.com/ktegels/|||Thanks for fast replay.
No, I can't do it I got this
Cannot find the login 'Siata\Shimon', because it does not exist or you do
not have permission.
I don't get this but. When I am using Management Studio I get this ID as
logged in ID.
I am probably the member of BUILDIN/Administrators
Any solution?
Thanks
"Kent Tegels" <ktegels@.develop.com> wrote in message
news:b87ad741b7c58c89f11cfb03360@.news.microsoft.com...
> Hello Shimon,
> Although you are logged into Windows as an Admin, that doesn't
> automatically make you a member of SA role. Can you do this:
> use master
> go
> grant create endpoint to [your-domain\your-account]
> Thanks,
> Kent Tegels, DevelopMentor
> http://staff.develop.com/ktegels/
>|||Well I created the log in and run your script. It worked. I still have the
same error with original script.
How can I confirm that the namespace 'is reserved for listening by SQL.'
Thanks
"Kent Tegels" <ktegels@.develop.com> wrote in message
news:b87ad741b7c58c89f11cfb03360@.news.microsoft.com...
> Hello Shimon,
> Although you are logged into Windows as an Admin, that doesn't
> automatically make you a member of SA role. Can you do this:
> use master
> go
> grant create endpoint to [your-domain\your-account]
> Thanks,
> Kent Tegels, DevelopMentor
> http://staff.develop.com/ktegels/
>

Friday, February 24, 2012

Can't connect via HTTP remotely...

Hello-

I've just set up HTTP Access to SSAS and can connect locally, but when trying to connect remotely, as the same domain user, I receive the message:

The connection either timed out or was lost

Unable to connect to the remote server

No connection could be made because the target machine actively refused it

I can connect remotely if I connect using just the servername (rather than http://...)

Anyone else runinto this one?

Hi Tristan,

For troubleshooting connectivity problems, one great resource is Edward's blog at: http://www.sqljunkies.com/WebLog/edwardm/.

If you still have connectivity issues after following the guidelines described in this blog, please let us know and give more details.

Hope this helps,

Artur

Sunday, February 19, 2012

Can't connect to SQL Server 2005 Reporting Services

Hi all, for some reason I can't connect to SQL Server 2005 reporting services. When I try to log in I get "the request failed with HTTP status 404:Not Found".

When I installed SQL Server, port 80 was not available as I am also running Apache, so SQL Server Report Server runs at http://localhost:81/ReportServer/ .. this work fine, I have build a report, deployed it successfully and can view it.

In SSMS I see two 2 databases, ReportServer and ReportServerTempDB.

Everything looks OK in the Report Server Configuration Manager, however in the Surface Area Configuration when I click on "
Windows Integrated Security" under the Reporting Services node it also comes back as "the request failed with HTTP status 404:Not Found"

Does anyone have any ideas how I can fix this, does it look like it is looking for Reporting Services on the wrong port? 80 instead of 81 ?

Thanks for any advice

Hello, I have had a similar problem and posted a thread on it at: http://tinyurl.com/zke4g

I've been running IIS 5.1 on port 200 just for security as hackers go straight for 80 if they are trying anything. While my problem is similar to yours, I have seen nothing that says the port is the problem especially given it persists when I switch IIS to port 80. A common move with Apach is to go into the config file and set apache to :8080, I've done that though it's been years and the details of how to are fuzzy.

Good luck. - Greg