When playing around with Windows Server 2008 I discovered how good Linux is. Even that I have to use Terminal (which I like anyway), dealing with Linux configuration is easier than dealing with Windows.
My primary area of interest is the Internet and all about it (web sites, databases, programming, servers). I really like open source (from operating system to programming languages), but occasionally I also check on the alternatives (Microsoft’s world, to be precise).
And in the previous week I checked a bit of how stuff works in Windows (DNS, IIS, MS SQL, ASP.Net). On the first look, it seemed a lot easier to work with it because of the GUI, but it soon became clear that I was terribly wrong.
Internet Information Server … great thing, a lot of options and dialogs but there are still stuff that needs to be configured manually. After setting up a few test web sites, I ran into few problems. The biggest was about caching static content on visitor’s computers. I partially configured it by Googling about it.
MS SQL
Again, everything seemed very easy. Creating a database takes few clicks, creating a user takes another few clicks and we have everything we want. Tables can be migrated from MySQL by using ODBC and that’s it. Until…I wanted to access this data from a web application.
Only thing I can get from my web application (just a simple thing for testing some of the MS SQL features and comparing performance to MySQL) was a simple error, that selected user cannot access selected database.
I was confused at first, but then I opened another instance of MS SQL Management Studio, connected to the server using this user, and I was not allowed to access anything. I guessed MS SQL has a unique way of managing rights and so I googled for tutorials and help. As I found out, there is a lot less Internet literature on this topic (MS SQL) than on alternatives.
After reading 30 articles, 400 clicks on buttons, 100 closed dialogs and 2 hours of work, I finally found a solution for this problem.
Recent Comments