Authentication, windows or custom

I have read most of the threads regarding form authentication as well as the suggested articles. Unfortunately I am not clear if I need to do custom security or stay with windows authentication

I would like to access a specific report using a URL so that all the features and funcionalty of the report is available to the user. There are to many users and reports to assign and maintain individual users and/or groups to a specific report.

Our users would access the report from either a windows or web application having already passed security. They would have a button to press to obtain the report. We would prefer to pass a specific userid to report services at this point that is authorized to view the report.

Can this be done without switching to custom security? To use form authentication must you switch to custom security? Would impersonation work?Hi,

If you go with Windows Authentication, then you can retrieve the Windows UserId from the Thread class - Thread.CurrentPrincipal.Identity.Name

Regards,
Vikram

attempts to attach db are locking up the server...

Hi,
I had a similar post before, and got some good
suggestions on this, but so far I'm still unable to
retrieve my database. Unfortunately, I made the mistake
of not detaching my database when I was having some
problems, and it got physically moved instead. I have
tried several different options to get it back, but they
either don't work or end up locking the system.
What would cause something to lock up like that? I've
tried to kill everything, so I don't see anything going
on there.
Any ideas on how I could get this db back, and why it
might be locking up when I try to attach it?
Thanks!
Rick
Hi,
What do you meant by Locking while attach? Are you getting any errors while
attaching ? See the SQL server error log for any errors.
Thanks
Hari
MCDBA
"Rick" <rmemmer@.carolina.rr.com> wrote in message
news:783701c48423$2fd35f80$a601280a@.phx.gbl...
> Hi,
> I had a similar post before, and got some good
> suggestions on this, but so far I'm still unable to
> retrieve my database. Unfortunately, I made the mistake
> of not detaching my database when I was having some
> problems, and it got physically moved instead. I have
> tried several different options to get it back, but they
> either don't work or end up locking the system.
> What would cause something to lock up like that? I've
> tried to kill everything, so I don't see anything going
> on there.
> Any ideas on how I could get this db back, and why it
> might be locking up when I try to attach it?
> Thanks!
>
> Rick
|||Hi,
Thanks for your reply. Actually, I had two different
timing out issues. One was happening due to an update
that needed an index in order to update millions of
rows. It would time out and just sit there racking up
memory resources, but after I put the index on the join
field... it worked just fine. The same thing was
happening to the database I was trying to attach, but it
looks as though there was no way this was ever going to
work. It needed to be repaired first, but I had not
found anything that would work (prior to my post).
Anyway, I found this article that you might be interested
in for future reference:
Search "experts exchange Q_21020424" in Google to get
this article... the link won't bring you directly in, so
that's why you need to search on it. I was able to run a
few procedures and then repair the database (which took
about 40 minutes for a very large file), and after that I
was ready to go.
So, I'm all fine now. Of course, I'm still not sure what
to do in order to kill a process that seemingly doesn't
want to be killed. It would be nice to find that out for
future reference, so that the memory doesn't climb to the
point where you have to shut it down.
Thanks for your help!
Rick

>--Original Message--
>Hi,
>What do you meant by Locking while attach? Are you
getting any errors while[vbcol=seagreen]
>attaching ? See the SQL server error log for any errors.
>Thanks
>Hari
>MCDBA
>"Rick" <rmemmer@.carolina.rr.com> wrote in message
>news:783701c48423$2fd35f80$a601280a@.phx.gbl...
mistake[vbcol=seagreen]
they
>
>.
>

attempts to attach db are locking up the server...

Hi,
I had a similar post before, and got some good
suggestions on this, but so far I'm still unable to
retrieve my database. Unfortunately, I made the mistake
of not detaching my database when I was having some
problems, and it got physically moved instead. I have
tried several different options to get it back, but they
either don't work or end up locking the system.
What would cause something to lock up like that? I've
tried to kill everything, so I don't see anything going
on there.
Any ideas on how I could get this db back, and why it
might be locking up when I try to attach it?
Thanks!
RickHi,
What do you meant by Locking while attach? Are you getting any errors while
attaching ? See the SQL server error log for any errors.
Thanks
Hari
MCDBA
"Rick" <rmemmer@.carolina.rr.com> wrote in message
news:783701c48423$2fd35f80$a601280a@.phx.gbl...
> Hi,
> I had a similar post before, and got some good
> suggestions on this, but so far I'm still unable to
> retrieve my database. Unfortunately, I made the mistake
> of not detaching my database when I was having some
> problems, and it got physically moved instead. I have
> tried several different options to get it back, but they
> either don't work or end up locking the system.
> What would cause something to lock up like that? I've
> tried to kill everything, so I don't see anything going
> on there.
> Any ideas on how I could get this db back, and why it
> might be locking up when I try to attach it?
> Thanks!
>
> Rick|||Hi,
Thanks for your reply. Actually, I had two different
timing out issues. One was happening due to an update
that needed an index in order to update millions of
rows. It would time out and just sit there racking up
memory resources, but after I put the index on the join
field... it worked just fine. The same thing was
happening to the database I was trying to attach, but it
looks as though there was no way this was ever going to
work. It needed to be repaired first, but I had not
found anything that would work (prior to my post).
Anyway, I found this article that you might be interested
in for future reference:
Search "experts exchange Q_21020424" in Google to get
this article... the link won't bring you directly in, so
that's why you need to search on it. I was able to run a
few procedures and then repair the database (which took
about 40 minutes for a very large file), and after that I
was ready to go.
So, I'm all fine now. Of course, I'm still not sure what
to do in order to kill a process that seemingly doesn't
want to be killed. It would be nice to find that out for
future reference, so that the memory doesn't climb to the
point where you have to shut it down.
Thanks for your help!
Rick

>--Original Message--
>Hi,
>What do you meant by Locking while attach? Are you
getting any errors while
>attaching ? See the SQL server error log for any errors.
>Thanks
>Hari
>MCDBA
>"Rick" <rmemmer@.carolina.rr.com> wrote in message
>news:783701c48423$2fd35f80$a601280a@.phx.gbl...
mistake[vbcol=seagreen]
they[vbcol=seagreen]
>
>.
>

Attaching a Database

Hi Friends
Can i attach a database without having its LOG file. Unfortunately all LOG
backups and original log files are deleted from the server. I've the MDF file
only.
Kindly guide me.
Amit
Check out sp_attach_single_file_db in the BOL.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
"Amit-SQL-DBA" <AmitSQLDBA@.discussions.microsoft.com> wrote in message
news:4281944D-1714-4A69-8664-BFFACEC4649B@.microsoft.com...
Hi Friends
Can i attach a database without having its LOG file. Unfortunately all LOG
backups and original log files are deleted from the server. I've the MDF
file
only.
Kindly guide me.
Amit
|||Try Tom's suggestion first but if that doesn't work you can have a look
here:
http://www.sqlservercentral.com/scri...p?scriptid=599
Andrew J. Kelly SQL MVP
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23%23J1x%23$7EHA.3708@.TK2MSFTNGP14.phx.gbl.. .
> Check out sp_attach_single_file_db in the BOL.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> .
> "Amit-SQL-DBA" <AmitSQLDBA@.discussions.microsoft.com> wrote in message
> news:4281944D-1714-4A69-8664-BFFACEC4649B@.microsoft.com...
> Hi Friends
> Can i attach a database without having its LOG file. Unfortunately all LOG
> backups and original log files are deleted from the server. I've the MDF
> file
> only.
> Kindly guide me.
> Amit
>

Attaching a Database

Hi Friends
Can i attach a database without having its LOG file. Unfortunately all LOG
backups and original log files are deleted from the server. I've the MDF fil
e
only.
Kindly guide me.
AmitCheck out sp_attach_single_file_db in the BOL.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Amit-SQL-DBA" <AmitSQLDBA@.discussions.microsoft.com> wrote in message
news:4281944D-1714-4A69-8664-BFFACEC4649B@.microsoft.com...
Hi Friends
Can i attach a database without having its LOG file. Unfortunately all LOG
backups and original log files are deleted from the server. I've the MDF
file
only.
Kindly guide me.
Amit|||Try Tom's suggestion first but if that doesn't work you can have a look
here:
http://www.sqlservercentral.com/scr...sp?scriptid=599
Andrew J. Kelly SQL MVP
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23%23J1x%23$7EHA.3708@.TK2MSFTNGP14.phx.gbl...
> Check out sp_attach_single_file_db in the BOL.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> .
> "Amit-SQL-DBA" <AmitSQLDBA@.discussions.microsoft.com> wrote in message
> news:4281944D-1714-4A69-8664-BFFACEC4649B@.microsoft.com...
> Hi Friends
> Can i attach a database without having its LOG file. Unfortunately all LOG
> backups and original log files are deleted from the server. I've the MDF
> file
> only.
> Kindly guide me.
> Amit
>

Attaching a Database

Hi Friends
Can i attach a database without having its LOG file. Unfortunately all LOG
backups and original log files are deleted from the server. I've the MDF file
only.
Kindly guide me.
AmitCheck out sp_attach_single_file_db in the BOL.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Amit-SQL-DBA" <AmitSQLDBA@.discussions.microsoft.com> wrote in message
news:4281944D-1714-4A69-8664-BFFACEC4649B@.microsoft.com...
Hi Friends
Can i attach a database without having its LOG file. Unfortunately all LOG
backups and original log files are deleted from the server. I've the MDF
file
only.
Kindly guide me.
Amit|||Try Tom's suggestion first but if that doesn't work you can have a look
here:
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
--
Andrew J. Kelly SQL MVP
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23%23J1x%23$7EHA.3708@.TK2MSFTNGP14.phx.gbl...
> Check out sp_attach_single_file_db in the BOL.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> .
> "Amit-SQL-DBA" <AmitSQLDBA@.discussions.microsoft.com> wrote in message
> news:4281944D-1714-4A69-8664-BFFACEC4649B@.microsoft.com...
> Hi Friends
> Can i attach a database without having its LOG file. Unfortunately all LOG
> backups and original log files are deleted from the server. I've the MDF
> file
> only.
> Kindly guide me.
> Amit
>