September 11, 2012 at 9:58 am
I have completed the fifth install of SQL Server 2005 Developer Edition but it is getting worse, not better. So I have uninstalled everything in the Control Panel that has to do with SQL Server but noticed that the Analysis, Reporting, and Integration Services were not listed in Control Panel so I started the Uninstall Troubleshooter that was previously recommended and it Uninstalled those other three services.
Now I am ready for the sixth install but I would like to install only the Database Service and since I am using Visual Studio 2005 I believe that I will also need the Integration Service. Is this correct?
My SQL Server 2012 arrived yesterday so if this sixth install of SQL Server 2005 (with the bare minimum) does not work this time, I wash my hands of that Server (give up on it and will gladly give it to anyone who wants it) and will try the 2012 version. I cannot have any worse luck, I don't believe. But then that statement fails to take into account Murphie's Law which states: "If anything CAN go wrong, it WILL!! Getting more furstrated which does not do my 84 year old heart any good. JRichards54
September 11, 2012 at 11:56 am
jrichards54 (9/11/2012)
Now I am ready for the sixth install but I would like to install only the Database Service and since I am using Visual Studio 2005 I believe that I will also need the Integration Service. Is this correct?
Yes and no.
Visual Studio is it's own stand alone program. However, if you install Integration Services, SQL will install a crippled copy of VS that only works with SQL related items.
Do you need the full capabilities of Visual Studio? Or Business Intelligence Development Studio / BIDS (renamed and different for SQL 2012)?
If the later, then yes, you need to install the Database Engine, the Client Tools (This is a MUST), and Integration Services. I also advise installing the documentation, the tutorials and (if available) the sample databases.
My SQL Server 2012 arrived yesterday so if this sixth install of SQL Server 2005 (with the bare minimum) does not work this time, I wash my hands of that Server (give up on it and will gladly give it to anyone who wants it) and will try the 2012 version. I cannot have any worse luck, I don't believe. But then that statement fails to take into account Murphie's Law which states: "If anything CAN go wrong, it WILL!! Getting more furstrated which does not do my 84 year old heart any good. JRichards54
Take a deep breath. Walk away from the computer. Have a drink. Enjoy the sunset.
When you are relaxed, come back in. Turn on the computer. Open up the installation instructions, and take your time with the installation. Don't rush, read everything, write down every choice you make.
September 11, 2012 at 12:15 pm
Brandie Tarvin (9/11/2012)
jrichards54 (9/11/2012)
Now I am ready for the sixth install but I would like to install only the Database Service and since I am using Visual Studio 2005 I believe that I will also need the Integration Service. Is this correct?Yes and no.
Visual Studio is it's own stand alone program. However, if you install Integration Services, SQL will install a crippled copy of VS that only works with SQL related items.
Do you need the full capabilities of Visual Studio? Or Business Intelligence Development Studio / BIDS (renamed and different for SQL 2012)?
If the later, then yes, you need to install the Database Engine, the Client Tools (This is a MUST), and Integration Services. I also advise installing the documentation, the tutorials and (if available) the sample databases.
My SQL Server 2012 arrived yesterday so if this sixth install of SQL Server 2005 (with the bare minimum) does not work this time, I wash my hands of that Server (give up on it and will gladly give it to anyone who wants it) and will try the 2012 version. I cannot have any worse luck, I don't believe. But then that statement fails to take into account Murphie's Law which states: "If anything CAN go wrong, it WILL!! Getting more furstrated which does not do my 84 year old heart any good. JRichards54
Take a deep breath. Walk away from the computer. Have a drink. Enjoy the sunset.
When you are relaxed, come back in. Turn on the computer. Open up the installation instructions, and take your time with the installation. Don't rush, read everything, write down every choice you make.
Thank you for your very good advice.
No, I do not need the full capabilities of VS 2005. Also, I do not need to install the Integration Services as I have a full blown VS 2005 Standard Edition with MS License Product Key on my machine..
I have printed the "How to: Install SQL Server 2005 (Setup) and I tried to follow those instructions step by step on the fifth install but I must of done something wrong. This SQL Server is by far the most difficult app that I have ever tried to install. But with your help and incouragement I believe that I am going to succeed.
I am taking a deep breath, walking away from my PC, going to give it two full days for me to collect my thoughts and composure and then, when I am relaxed, I will follow your advice and make that sixth install attempt, and I will write down every choice I make and my reason for making that choice. Thanks again for the excellent advice. Have a good day. JRichards54 🙂
September 12, 2012 at 7:22 am
I do need some more advice though before I attempt that sixth install.
When I run the install I very shortly get a window that says: "There are known compatibility issues between this software and the OS I am using. Do you want to check the internet for a possible fix"? I click "Yes" and Microsoft finds Service Pack 3, I download it and try to install it but I get another window which says: "Cannot install Service Pack 3 as some files on your machine are newer than the files in this SP".
I believe these newer files are from SP4 which I have previously downloaded and installed. But I cannot find any entry in Control Panel about SP4 so I am unable to uninstall it(them) there and I start the Windows Troubleshooter and after it loads I cannot find any entry about SP4 listed there for me to try to uninstall. How am I going to be able to install SP3 under these conditions? Thanks, JRichards54
September 12, 2012 at 8:01 am
jrichards54 (9/12/2012)
I do need some more advice though before I attempt that sixth install.When I run the install I very shortly get a window that says: "There are known compatibility issues between this software and the OS I am using. Do you want to check the internet for a possible fix"? I click "Yes" and Microsoft finds Service Pack 3, I download it and try to install it but I get another window which says: "Cannot install Service Pack 3 as some files on your machine are newer than the files in this SP".
I don't remember what OS you said you were using. Could you tell us again, please?
September 12, 2012 at 8:07 am
You don't need to worry about SP3 - just download and install SP4. They are cumulative so you will be fine with that.
The reason you are getting the notice is that on Windows 7 there are known issues with SQL Server 2005 which have been addressed in later service packs.
Like I said - skip SP3 and just go straight to SP4.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 14, 2012 at 12:25 pm
I have just made two more attempts at installing SQL Server 2005 but was unable to even get SP4 installed successfully. All the steps that I took are recorded in the first attachment. Since this attempt failed, I tried a second time, made some changes that are recorded in the second attachment, but got virtually the same results. Where do I go from here, please? JRichards54
September 14, 2012 at 12:30 pm
jrichards54 (9/14/2012)
I have just made two more attempts at installing SQL Server 2005 but was unable to even get SP4 installed successfully. All the steps that I took are recorded in the first attachment. Since this attempt failed, I tried a second time, made some changes that are recorded in the second attachment, but got virtually the same results. Where do I go from here, please? JRichards54
JRichards,
You cannot install SQL Server Service Packs until SQL Server itself is installed. I believe what you were supposed to be downloading and installing were OS service packs.
Just to verify, are you on Windows 7 (your operating system aka OS)?
EDIT: I just realized your error mentions Vista. Take it from someone who also runs a Vista OS (Vista Business), Vista is a pain in the butt to install & run SQL on.
Which version of Vista are you running? Home, Premium, Business, Ultimate?
September 14, 2012 at 1:23 pm
Okay - you need to install SQL Server first. When you get the compatibility warning - continue the install. Once that has finished, then you can apply the service pack.
Once that is finished, then validate that you have Visual Studio 2005 SP1 installed. If not, download and install that as it is required for SQL Server 2005 on Vista and above.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 14, 2012 at 3:24 pm
Brandie Tarvin (9/14/2012)
jrichards54 (9/14/2012)
I have just made two more attempts at installing SQL Server 2005 but was unable to even get SP4 installed successfully. All the steps that I took are recorded in the first attachment. Since this attempt failed, I tried a second time, made some changes that are recorded in the second attachment, but got virtually the same results. Where do I go from here, please? JRichards54JRichards,
You cannot install SQL Server Service Packs until SQL Server itself is installed. I believe what you were supposed to be downloading and installing were OS service packs.
Just to verify, are you on Windows 7 (your operating system aka OS)?
EDIT: I just realized your error mentions Vista. Take it from someone who also runs a Vista OS (Vista Business), Vista is a pain in the butt to install & run SQL on.
Which version of Vista are you running? Home, Premium, Business, Ultimate?
You wrote: "You cannot install SQL Server Service Packs until SQL Server itself is installed." and I ask then why did the Install ask for the SP3 to be downloaded and installed BEFORE the Server was installed?
I am running Windows 7 Home Premium. I simply quoted what the install program displayed. If it displayed "Vista" then I quoted it, not because I am using it. Surely MS knows what OS I am using so why do they say anything about "Vista"? Seems like more confusion to me.
You wrote: "I believe what you were supposed to be downloading and installing were OS service packs." Then why did the install go to the internet, supposedly found an answer to the incompatibility problem, and ask me to download the SP3? Still more confusion.
But, dispite everything said above, I will try again and this time I will ignore the suggestion that the Install Program check the Internet for a solution, go ahead and run the Install Program to the finish, and then run SP4. JRichards54
September 14, 2012 at 4:15 pm
jrichards54 (9/14/2012)
You wrote: "You cannot install SQL Server Service Packs until SQL Server itself is installed." and I ask then why did the Install ask for the SP3 to be downloaded and installed BEFORE the Server was installed?I am running Windows 7 Home Premium. I simply quoted what the install program displayed. If it displayed "Vista" then I quoted it, not because I am using it. Surely MS knows what OS I am using so why do they say anything about "Vista"? Seems like more confusion to me.
You wrote: "I believe what you were supposed to be downloading and installing were OS service packs." Then why did the install go to the internet, supposedly found an answer to the incompatibility problem, and ask me to download the SP3? Still more confusion.
But, dispite everything said above, I will try again and this time I will ignore the suggestion that the Install Program check the Internet for a solution, go ahead and run the Install Program to the finish, and then run SP4. JRichards54
The install package was built at or around the same time as Vista being released. At that time, there were known compatibility issues with the Vista OS and SQL Server 2005. That is why it states Vista...
On Windows Vista and Windows 7 - they added functionality to the OS that checks for compatibility issues. When it finds that you are trying to install something that is on their known issues list - it generates that message and prompts you to go to the internet to find a solution.
It directs you to the solution to the problem - and when it directed you to SP3 that is all it was doing. It was not stating that this had to be installed prior to SQL Server, just that SP3 will resolve the compatibility issue.
Confusing...somewhat...maybe...
Again, bypass that warning - install SQL Server then apply SP4. And, if you have not already installed Visual Studio 2005 SP1 - be prepared with that installation. I believe you should already have that though.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 15, 2012 at 1:00 pm
Your right. I already have VS 2005 SP1 downloaded and installed and I am running Windows 7 Home Premium.
I did what you suggested and bypassed the offer to find a solution on the Internet and completed the install of the Server. The steps I took are recorded in the first attachment.
Everything seemed to have installed successfully except that there were two intries for the "Client Components" and the first one was successful and the second one was a failure. I might have cause the double entries because somewhere, on my desktop, the original window for the install process appeared and I thought it wanted me to install the Client Components so I clicked on it. See attachment three.
I now have SSMS in my start menu as shown in attachment two.
But when I click on the SSMS I get what is in attachment five. And when I try to connect to a Database I get what's in attachment four.
Is there anymore help for a fumbler (someone who doesn't know how to install Server)? JRichards54
September 15, 2012 at 1:09 pm
I can't see all the configuration, but it looks like you have an instance name of MSSQLSERVER, but the connection is trying to connect to SSSQLSERVER. Possibly change that S to an M and see what happens then. Also, in case you installed a default instance try using the server name as (local), just like that in parens. Or try it as a dot . . A period, but not in parens.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
September 15, 2012 at 1:17 pm
In addition to what Grant stated - there is a utility called SQL Server Configuration Manager. Open that and you can see all of the services available for SQL Server. You can use that to verify whether or not the services are running.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 15, 2012 at 3:50 pm
Thank you both. I will try to do what you both have suggested and I will report the results, probably tomorrow. JRichards54 🙂
Viewing 15 posts - 61 through 75 (of 81 total)
You must be logged in to reply to this topic. Login to reply