Monday, March 15, 2004 - Posts
Karl wrote a long comment in my "All I needed to know..." piece. I really liked his comments: they resonated enough with me that I wanted to share my response with the community. While we may not agree, neither of us are wrong, I think, we're just looking at things differently.
Read On...
Sidney Johnson posted the following in my Reporting Services blog (which I need to update again)
No you aren't the only one that finds it strange. Take a close look at your data connection options you will find a few other choices once a person is logged into the server. Unfortunately even if you set the report to be SQL name/password you still have the problem that we have 2 layers, 1 for the server and 1 for the report. Short of custom security implemented by Enterprise server we appear to be stuck with windows authentication on the server. Now thats just well lame. Why support 7 options of security in the data connection(setup a new data connection and you should see the combinations of 7 different security choices) to the report but only 1 to the server. Does it make sense to force everyone to Enterprise just to offer people internet access. GIVE US A BREAK. I would love to see a breakdown of enterprise/std server as backend to internet websites. I bet a large majority of businesses with internets and mixed user environments will have SQL standard. Puting custom security extentions into Enterprise just seems inconsistant when one can see all these options for security at the report level with standard and not for the server. Why do we have one set of procedures for the server and another for the data source for the report. I would like to see the same set of options for the server a I see for the data connection with SQL standard.
I don't find it strange myself, Chris McKenzie did. That said...
appear to be stuck with windows authentication on the server. Now thats just well lame.
I'm getting the sense that you don't want to spin up Domain accounts for your users. While I agree that having some other choices would be nice (like what you can with ASP.NET natively,) is this a show stopper or just painful for you?
Why support 7 options of security in the data connection(setup a new data connection and you should see the combinations of 7 different security choices)
I guess because different database products and networks have different needs.
Does it make sense to force everyone to Enterprise just to offer people internet access
You don't have to do that. Put the RS-IIS box in your DMZ and spin up the domain account there. Then use SQL Logins to access the meta data and data bases over ports 1433 (but, please, use a different port and think really hard about using SSL or IPSec on that channel.
I would like to see the same set of options for the server a I see for the data connection with SQL standard.
In one sense, you do, since if you can get the stars to align right, you can use Windows Authentication through-and-through. That's not recommended because aligning the stars is an utter pain. I agree with you that it would be nice to have the standard edition have user provisioning and management as part of it's meta data. I wouldn't be surprised to see that in a future version. That said, I think we got these bits when we did because it works pretty well in the Intranet scenario which is where MS wants to push hardest right now.
Taken Out Tonight: ZZ Top
The counts: Blogging: 5; Development: 12; Other: 22; SQL: 4; WILY: 8
Line of the night: This is one reason why I lost a lot of interest in OSS. They want so badly for everybody to be using their software, but then they drive you away buy spouting crap arguments and stopping just short of calling you evil and stupid for using MS products.
Post of the night: Products You Might Be Interested In
Kent: What are you listening too?
Janell: Jay-Z's "H to the Izzo."
What's he saying?
Can't you understand it?
Uh, no. You?
She just smiles at me.
Google the lyrics for me?
A few moments later, toast pops up. E-mail from Janell. I read the lyrics.
Kent: I can't make sense of all of this.
Janell: just shows that you ARE NOT black. :-)
Puts Paul Simon's Graceland in the CD-ROM, "Word. I'm so not down."
The pairings are up. Here's my initial brackets.
The Saloon: Look for 90-Shilling and Alaskan Smoked to progress, Alaskan to advance. Snow Cap will take on Redhook IPA and beat that. Alaskan Smoked wins this division. Sad. Both Abbey and 90-shilling are great beers.
The Pub: Blond bock to face St. Arnold's brown, pick 'em. Barney Flats beats them all. Look for Celebration to take on Eye of the Hawk: I wouldn't be surprised to see Mendocino win. In my heart of hearts, I want Eye of the Hawk to go the distance, but it won't. It'll be either Pliny or Celebration.
The Bistro: There's just a lot of beer in this group that I've not had and probably won't care for. It would be nice to see Magic Hat and Brooklyn Black Chocolate make it out. They won't, Dogfish 90-minute IPA is a shoe-in.
The Tavern: too bad Summit drew GLB's porter. Although I think Summit is better, most people likely won't. Creamy dark might progress. Capital should win, as should Bell's. Folks will freak out too much about New Glarus's entry being a fruit beer to see it go far which is a real shame. Goose Island, Sweetwater and Zon should do ok. It'll come down to Goose Island vs. GLB porter and GLB should win.
GLB will lose handly to Dogfish 90-minute, Alaskan will squeak by Pliny, and in the end, Dogfish 90-minute wins.
I've always been of the opinion that AB had his head screwed on tight. At the first read, I thought maybe he lost it. But, really he's right. We can just applaud people for being themselves when they do things we like because we want to encourage non-conformity. Nope, when he praises Martha for being Martha like this, you've got to give both of them Kudos... however uncomfortable that may be.
I just want you to know a couple of things. Men don't like you because you've made it clear you don't need a stinkin' one of us and that makes...
[Via Alton Brown]
Snowing again today,
Wet and Accumulating.
Spring starts Saturday.