subtext blog, issues setting up on database

hi,

Am having a few problem setting up a subtext blog for my site www.siprojects.net, I have attempted to install the blog on a number of occassion so far with no success.

I have attempted to execute the query in two ways, firstly I tried executing the query by installing subtext via the Microsoft Web Platform Installer into which you enter the details of the database of you want execute the blog to these details include Database Username, Database Password, Database Server and Database Name when I attempt to install this way an error is thrown.

The second way I have attempted to install is manually by accessing the database through SQL Server Management Studio for Microsoft SQL Server 2008, when I execute the query I am again presented with an error message.

I have attached two jpg images of the screenshots of each of the errors one from the web platform installer ans the other from SQL Server Management Studio.

As a note in order to login to SQL Server Management studio I used the same Username and Password that I have been entering into the web platform installer and they work fine I also checked in the security setting for SQL Server Management Studio for that specific role and it does exist.

Please could you resolve my issue?

 

Hi,
I've used it on DASP servers the manual install way and it was no problem.
Haven't tried the Web Installer but from what you posted it appears the objects weren't created.
There are Install notes for it here:
http://www.subtextproject.com/docs/installation.aspx

If you get stuck and want me to look into it let me know.
All the best,
Mark