Showing posts with label login. Show all posts
Showing posts with label login. Show all posts

Friday, March 30, 2012

If I log out will SQL Server still run?

Runnning 2005. I want to log out (not reboot) of Windows Server 2003, log
in as another user, and then log out and back in as the original user. Will
doing this cause the SQL Server to stop running (taking requests from
applications)?No, assuming it is running as a service.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"HB" <replywithingroup@.notreal.com> wrote in message
news:Lws7g.6122$yM.3355@.tornado.socal.rr.com...
> Runnning 2005. I want to log out (not reboot) of Windows Server 2003, log
> in as another user, and then log out and back in as the original user.
> Will doing this cause the SQL Server to stop running (taking requests from
> applications)?
>

Friday, March 23, 2012

IE 7

Hi all,
I've installed IE 7 today and I don't why but I'm locked out of RS. I can
login but I can't see any report even if I'm admin on the machine ( laptop
with XP pro and SQL 2005 sp 1).
Anyone experienced this?
If anyone can help, it would be appriciated
FredYes,
Add your report server to your INTRANET zone (NOT THE TRUSTED ZONE).
If you add it to your trusted zone (or must) - you will need to make a
change - Open up Internet Properties (Control Panel) Then click the Advanced
Tab. Scroll down to security (at bottom) and make sure "Enabled Integrated
Windows Authentication" is checked.
Note: If you put your site in the INTRANET zone you do NOT need to do the
following steps)
Next, go to the security tab. Click the "Trusted Sites" icon - then click
the "Custom level..." button. Scroll down too the bottom and under the
section "User Authentication->Logon" make sure the bullet is set to what you
want - if you want automatic authentication select "Automatic logon with
current user name and password". If you wish to be prompted, choose "Prompt
for user name and password."
After making your changes, I suggest you restart.
Cheers!
=-Chris
"Fred" <Fred@.discussions.microsoft.com> wrote in message
news:3A2757B7-8736-4698-8192-A5A80C408594@.microsoft.com...
> Hi all,
> I've installed IE 7 today and I don't why but I'm locked out of RS. I can
> login but I can't see any report even if I'm admin on the machine (
> laptop
> with XP pro and SQL 2005 sp 1).
> Anyone experienced this?
> If anyone can help, it would be appriciated
> Fredsql