I have a server with MSDE running on it because of Backup Exec. Now I am trying to install the full blown version of SQL 2005 on this server because another piece of software that we use requires that we have the full blown SQL so that I can select an instance with just the server name. Everytime I try to install SQL on this server, I get the error messages attached. I know almost nothing about SQL other than it's a database system needed for some programs to work and I am not sure what options I should pic when installing it.
This is what I am doing at the different steps of the installation:
The first page asks what components you want to install. The only thing I am selecting is "SQL Server Database Services." there are 5 other options to install other things, but I didn't think they were necessary.
Then it gets to a page that asks me if I want to do Default Instance or Named Instance. So I pick Named Instance and I make up a name like "DA7" because if I try to pick default instance it gives another error (see attached "Default Instance.jpg").
Then it gets to a page that asks me if I want to use the built-in System account or the domain user account. I select Domain user account and put in the administrator username and password along with the domain name.
Then it asks if I want to use Windows Authentication Mode or Mixed Mode. I select Windows Authentication mode.
Then it asks something about Collation designator and sort order. I just leave this as how it is as I have no idea what they are talking about. The default is "SQL collations: Dictionary order,case-insensitive, for use with 1252 Character Set"
I click next then click install and then here's where all my frustration begins.
I hope this is enough information. Can somebody please shed some light on the situation.