Help.

Bаne · 02/12/2011, 07:35

Everytime i try to install MMSQL 2005 Express editon (i had to reinstall my test server)I get a odd error....

TITLE: Microsoft SQL Server Setup
------------------------------

None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine. To continue, click Back and then select features to install. To exit SQL Server Setup, click Cancel.

For help, click:

------------------------------
BUTTONS:

OK
------------------------------

I have tried everything. Removing SQL from control pannel. Removing it from C program files.
C program data
C User app data
Windows systyem32

Everything i try get's the same error on instlation...even running the program as admin..i even tried using admin acc..nothing works..

Some help would be appriceated.

-Bane!

c0matose · 02/12/2011, 17:12

see if this helps Bane

Bаne · 02/12/2011, 17:49

no como...i al;ready tried something like that.............

c0matose · 02/12/2011, 18:07

see if you can find a Tools directory & rename it...I'm still searching

Bаne · 02/12/2011, 18:14

Already did that too lol..

c0matose · 02/12/2011, 18:29

hmmm - you don't have more than one node do you? Can you install just the tools, then try the install of sql server?

Bаne · 02/12/2011, 18:37

ZOMG ok through alot ofuninstlation i got the 1 error fixed...

but nowwhen installing SQL 2005 express....i don't get the option to use mixed mode..

Ok, i need a teamviewer helper...i installed 2005 dev studios..and get this error on it.

TITLE: Connect to Server
------------------------------

Cannot connect to CHRIS-PC\SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click:

------------------------------
BUTTONS:

OK
------------------------------

No matter what i do i run into a error lol,,

AriezOMG · 02/12/2011, 18:58

Make sure you configure everything in the Surface Area Configuration Manager and try to connect to your server using username: sa and ur password you put for it, put your address as 127.0.0.1 (this being your localhost) and you should be able to connect properly, awaiting feedback.

Bаne · 02/13/2011, 04:43

After i get instlation to work...

ERROR AFTER ERROR Q.Q

~~Xx.LaMin.xX~~ · 02/13/2011, 14:05

Its becoz you dont have IIS Installed. Click here to find out how to install it:

Best Regards
LaMin aka (Angel)

zargon05 · 02/13/2011, 14:49

You dont need IIS to use MSSQL. Did you properly enable TCP/IP and Namepipes protocol in MSSQL?

ProfNerwosol · 02/13/2011, 17:06

Bane, are you trying to use ZeroSignal's files or any of its versions, because it looks like it. First: check protocol configuration for MSSQL, enable all VIA, Named Pipes, TCP/IP, set static port to 1433 (this is how you go around named instance). Second: throw out any *.bat files and Attach every single database manually. Last: just run a query to add GM, Linked Servers, etc.

Bаne · 02/13/2011, 17:21

I'm using Omegas files Pronerwosol.

2. everything besides attaching all DB manualy has been done.

~~Xx.LaMin.xX~~ · 02/13/2011, 18:33

Yes you need iis to install MSSQL. If you dont have it you will get error while you installing. I got this problem before alot of times when i installed it on vps/dedicated servers.

Best Regards
LaMin

ProfNerwosol · 02/13/2011, 22:34

ISS and MSSQL are completely different programs. I don't understand why you suggest to install it. You don't need IIS. You need NET framework and Power Shell and sometimes Windows Installer to install MSSQL. At least that's what is needed for MSSQL 2008. I don't recall 2005 requirements, but they were similar.