Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 2008 Express Security Question

Author  Topic 

sinjin67
Yak Posting Veteran

53 Posts

Posted - 2010-04-30 : 16:49:26
I am trying the SQLEPRESS 2008 and I am bit lost on the security side of things. After readin the help file I did not find an answer.

My question is when setting up an install or after install, how or where do you change the security so it will not prompt you for user name and password before loading. In the 2005 Express you could do this thru IIS, but I dont see where you can with this new version.

Any pointers would be great.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-04-30 : 16:54:24
Do you mean inside Management Studio? If so, then just connect with Windows authentication.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

sinjin67
Yak Posting Veteran

53 Posts

Posted - 2010-04-30 : 17:23:43
Im sorry, I meant to specify with the reporting service.
before it loads it prompts for username and password.

I found the url reference in the report server manger, but cant find
where to adjust this anywhere else..

again sorry for not being more specific.

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-04-30 : 17:55:30
I'll move this to the RS forum then.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -