Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 343
  • Last Modified:

Installing MS SQL Server - no services

I just installed MS SQL 2005 Server and having problem connecting to an instant.  According to the error, "no sql server 2005 components were found on the specified computer. Either no components are installed or you are not an administrator on this computer."

Solution thus far:
-Admin checked my profile and yes I do have an administration authentication
-I tried to enable TCP/IP, but get error - no services to restart
-Follow most of Microsoft solutions, but none work.

Unease:
I am still concern about my user authentication - I don't know if that is a problem.


0
ChrisCorea
Asked:
ChrisCorea
  • 5
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you installed eventually only the client components?
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Hello ChrisCorea,

it seems like you just installed the Client components
check this
http://sequelserver.blogspot.com/2007/06/20070703sql-server-2005-installation.html


Regards,

aneeshattingal
0
 
ChrisCoreaAuthor Commented:
aneeshattingal,
It is highly likely that I only installed the client - let me go through the installation process again.

Thank you,
0
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

 
ChrisCoreaAuthor Commented:
We finally got the full version and here is what I got in the installation process:
"SQL Server failed to obtain system account information for the ASPNET account.  To process, reinstall the .net framework, and then run SQL server setup again".
0
 
ChrisCoreaAuthor Commented:
Update
I finally almost got through the installation process when I suddenly came across this error:
"Error message when you install SQL Server 2005: "There was an unexpected failure during the setup wizard"
Here is what Microsoft wants me to do:
To copy the files from the SQL Server 2005 installation CDs to a location and then install SQL Server 2005 from that location, follow these steps:

Note In this example, the D:\SQLServer2005 folder is the location to which you want to copy the files from the SQL Server 2005 installation CDs.
In the D:\SQLServer2005 folder, create the following two subfolders:
Servers
Tools
Copy all the files from the SQL Server 2005 installation CD that is named Servers to the D:\SQLServer2005\Servers folder.
Copy all the files from the SQL Server 2005 installation CD that is named Tools to the D:\SQLServer2005\Tools folder.
Open the D:\SQLServer2005\Servers folder, and then double-click Setup.exe to start the SQL Server 2005 Setup program.
Similarly, if you downloaded SQL Server 2005 Developer Community Technology Preview (CTP) from the MSDN download site, the full product is split into two separate downloads. To perform a complete installation of SQL Server 2005, you must download both the Servers and Tools files to folders that are named Servers and Tools. Additionally, keep these folders under the same level of a folder or the root folder of a drive before you start the installation.

Unfortunately, the installation CD does not have the two folders (Servers & Tools) on the CD as stated.
Now what?
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
are you sure, you just got one CD ?
0
 
ChrisCoreaAuthor Commented:
I am not sure, but we are investigating.
0
 
ChrisCoreaAuthor Commented:
Resolved
Yes we needed the server part of the CD. Problem solved and thank you to all, expecially aneeshattingal.
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now