Hello! I just wanted to put up a post to explain what’s going on here…
I’ve had the domain name Cpugeni.com since 2001, the name came about from a friend who created me an AOL AIM account, he chose Cpugeni. It means CPU (central processing unit) genious. I guess because whilst we were at school I was known to be stuck to my computer. Anyway, its a kind of interesting name, and I’ve thought about thinking up a new name, but never have, partly because I use it as an alias whenever I’m signing up to various websites, a Google Search reveals that!
So back to the topic: The Blog – As an experiment I downloaded Community Server 2008 Express Edition and set it up on my test server (more about that in a later post) to see what it was all about. I like it, so much so I thought I would deploy it to my website and actually have a blog. Previously I’ve thought there’d be no point in me having a blog, but really, I think it’d be quite useful, so here it is.
I plan on getting into some customisation and funking it up a bit inline with my plans for the overall website – so watch this space!
The Website – As I said, I’ve had the domain since 2001, and for the first four years or so I made use of it, not much, but better than nothing, like the last 3 years or so :-/ So this is my push to do something with the website, to demonstrate what I’m capable of, to demonstrate some of the possibilities today's web technologies offer us, and of course to practice new things, which no doubt will greatly help for when I finally do the Microsoft exams to gain myself MCTS/MCPD status (more about this, again, in a later post!).
I will eventually get the main website “up”, I actually have a design (and implemented!) too so there's not much else to do… Just get it online!
I came across a problem when using Microsoft SQL Server Management Studio 2008 to connect and manage a database which is housed on my shared host’s SQL Server 2005, the problem was that I couldn’t actually access my database, as I clicked the “Database” node within “Object Explorer” I received the message:
The server principal “username” is not able to access the database “databasename” under the current security context. (Microsoft SQL Server, Error: 916)
Anyway, after an hour, I decided that I would try and access my database within Microsoft Visual Studio 2008, using the “Server Explorer”. I set myself up with a connection to the database server, and hooray, I could connect and access everything. That left me wondering why it wasn’t working in the Management Studio, so I spent some more time trawling the net for an answer (since I’m hardly a SQL Server guru!). I eventually found something to help me out…
When I clicked on the “Databases” node within SQL Server Management Studio, the software would (in the background) execute an T-SQL query to retrieve a list of databases along with additional information about those databases, one of those pieces of information is collation, which I didn’t have permission to do for every database, only my own.
Fix:
-
In Object Explorer, click Databases
-
Display “Object Explorer Details” (F7) or “View –> Object Explorer Details”
-
Right click the column headers and deselect “collation”
-
Refresh Databases, and hopefully bingo!
Hopefully that helps anyone who finds themselves in the same situation! :)