Friday, March 9, 2012
Passed SQL Exam
Now on to 70-229 Microsoft SQL Server 2000 Database Design and Implementation for the MCDBA
For my preparation , i used HotCerts.com Guides & transcenders . HotCerts had questions which were very close to the real exams . They are highly recommended . Now iam off to 070-229 . Good luck future aspriantsCan I get into the MCDBA course online? take the exam online? earn the certificate online?
Just wondering!|||I gave up on mcdba. It's like trying to shoot a moving target. I had all the sql exams taken except for 1 elective when 6.5 was around and 7.0 just came out. 3 months later they retired 6.5 stuff and I had to re-take everything all over.|||I'm hesitating to start with the complete mcdba certification. On the one hand it's a proof of knowledge (if you didn't just read books), but on the other hand I don't like the structure. I don't get why only 2 of the 4 exams are about sql server. I agree that you have to have some knowledge on the operating system, but if I wanted to be a windows guru I would take the mcse certification.|||>> On the one hand it's a proof of knowledge
Unfortunately it's not.
See http://www.sqlmag.com/Articles/Index.cfm?ArticleID=39941
But it does get MicroSoft a lot of money to continue development :).
Congratulations on passing though.|||Anyone else notice that that was sqlman's first post?
Maybe I'm just cynical, but it looks like a shameless and deceptive plug for a website he is probably associated with. I don't see much difference between that and SPAM, so Hotcerts.com is one site I WON'T be recommending.
blindman
Wednesday, March 7, 2012
Pass through Authentication
We have Reporting Services 2000 standard edition installed and everything works fine. You can log in and run reports and the Reporting Services security rolls work. The problem is when a user goes to the url of reporting services web server it prompts them for a login. They enter their Windows domain login and they get in. Is there a way to configure Reporting Services to use the user's Windows Domain login credentials (pass through) and not prompt for them, similar toSharePoint.Here is our configuration:
We have a NT Domain (not active directory) all servers and client machine’s are in the same domain.
IIS for Reporting Services is set to authenticate users by Integrated Windows authentication, Enable anonymous is unchecked.
Server is running Windows Server 2003 Web Edition
Database security utilizes sql server login and is storedin the data source.
We are also planning to move the access to Reporting Services through SharePoint.Don’t know if that will complicate this login issue
Thanks
Enable anonymous access should be checked. Username and password credentials should be given, uncheck Integrated Windows authentication|||I have a DotNetNuke portal running Reports from Reporting Services. I am having a problem because each time I access my ReportServer on a browser I am asked to authenticate myself. I am currently hosting my database on a hosting services company and I only have access to the Report Manager. Where should I define the access properties in the report manager for my report server?
The user I must use to authenticate is the main user which has full access to reports so this is not a viable solution.
Thanks for your help.