Showing posts with label accessible. Show all posts
Showing posts with label accessible. Show all posts

Sunday, February 12, 2012

Are web services methods accessible with forms authentication?

Hi,
When I use the render method on a server using windows authentication the
method works like a charm.
When I use the render method on a server using forms authentication i get an
error: Object moved to <a
href='/ReportServer/logon.aspx?ReturnUrl=%2fReportServer%2fReportService.asmx'>
When using forms authentication are there special steps to accomplish in
order to get a web service method to work ? (like render)
thxYou could use a generic principal (System.Security.Principal) or the
System.Net.NetworkCredential and set the username and password to your
validated textbox values.
"Eric" <Eric@.discussions.microsoft.com> wrote in message
news:8D30F671-1600-45CC-9F62-05FB6E1AC6E6@.microsoft.com...
> Hi,
> When I use the render method on a server using windows authentication the
> method works like a charm.
> When I use the render method on a server using forms authentication i get
> an
> error: Object moved to <a
> href='/ReportServer/logon.aspx?ReturnUrl=%2fReportServer%2fReportService.asmx'>
> When using forms authentication are there special steps to accomplish in
> order to get a web service method to work ? (like render)
> thx|||No that didnt work either ... I tried almost every type of credentials
without success.
There must be an authentication step im missing...|||The Username/Password that connects to RS must be an authorized user on RS.
You could do this with a common Windows account (i.e. RSRenderer). This
way, your users access your site with forms auth (UserA, UserB, etc), but
they access the report server as RSRenderer.
If your users need to authenticate explicitly to RS (and you don't want to
use Windows accounts), you will probably have to go down the path
demonstrated in the following:
http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3
"Eric" <Eric@.discussions.microsoft.com> wrote in message
news:74FE7DA9-63EC-42CF-BD3B-203F21ED8880@.microsoft.com...
> No that didnt work either ... I tried almost every type of credentials
> without success.
> There must be an authentication step im missing...
>

Thursday, February 9, 2012

Are the databases created within VWD Express accessible by aspnet_regsql.exe or Management

Hi,

When I attempt to add the membership functionality to a database created within VWD Express, by using the aspnet_regsql.exe application (connecting to ./SQLEXPRESS using Windows authentication), the database I've created within VWD Express doesn't appear within the list of accessible databases. I have the same problem when attempting to access the same database within Management Studio Express.

Does this mean that databases created from within VWD Express don't use the same storage mechanism or paradigm as those already available within Management Studio Express? Or perhaps I need to somehow register the database using Management Studio Express? As a side note, I'm not sure if the "File/Open File" menu option within Management Studio Express holds the answer to my problems, but rather bizarrely, it crashes Management Studio Express when I select it.

Apologies for the rambling - in essence my question is "How can I make databases created within VWD Express appear within aspnet_regsql.exe and/or Management Studio Express?"

Many thanks,

Jon

Hey,

You can attach them. However, I had problems with any database in my documents showing up. But attaching is the process that makes it work. So you will want to attach database from the list of options, and then navigate to the database.

|||

http://forums.asp.net/thread/1456464.aspx

Step 1 to 6 will do what the previous poster said :)

|||

Thanks for your help folks.

So the only problem I have remaining is that (as stated in the referenced post) Management Studio can't see the database in order to attach it unless I move it out of my home directory (presumably a file permissions problem). Ideally I need both VWD and Management Studio to be able to access the database without moving it between two different locations. Which leaves me with two options:

1) Change the permissions on my home directory such that Management Studio can see the MDB/LDB and therefore attach it. However, I'm not sure what permissions I'd need to change.

2) Move the MDB and LDB out of my home directory and to a place where Management Studio can see them (e.g. the standard database directory for SQL Server 2005 Express) and update the path of the database within VWD. However, VWD doesn't appear to allow me to change the path of the database within the database properties in Solution Explorer.

Can anybody advise on how to do either of the above, and/or which approach is preferable?

Many thanks.

|||If you want both to be able to see it, your best bet is to put the database files in the SQL Server directory (where all the other databases are), attach it, and then change your connection string in your project to access the database by IP address instead.

The MDF-in-APP_DATA approach is when you're going to use VWD exclusively to deal with it. Otherwise, go the "good old fashionned way", which is to let SQL Server handle the database fully.|||

Yep, that's what I ended up doing anyway - thanks for the confirmation.

Not sure why they don't just put the MDB/LDB in the SQL Server data directory in the first place...

|||Because if you only use VWD, and your host supports sql server 2005 with attach, you can do XCOPY deployement, while if they put the mdf in the sql server directory, you need to export the database :)