September 2, 2012 at 8:47 am
Hi to all. This is my first post.
I currently have SQL SERVER 2005 Developer Edition installed on my PC but have not been able to use it at all. I have reinstalledit three additional times but this has not helped. It is still unusable. So I purchased SQL SERVER 2012 Developer Edition from Amazon but it has not arrived yet. I am using Windows 7 Home Premium with dual core 2.5 GHzCPU's, with 4 GB Memory and about 700 GB hard drive ( I have three hard drives on my PC). My question is: Do I install SQL SERVER 2012 on top of the previous installation, or should I go into "Control Panel" and delete everything that has to do with the 2005 version, or do I have to reformat my C hard drive and reinstall my OS and all of my Aps as well as the 2012 Edition of SQL Server? 🙂
September 2, 2012 at 10:10 am
You'll have to clarify what you mean by "you can't use it".
You can upgrade 2005 installations to 2012 or you can uninstall them if you like. Either way works.
September 2, 2012 at 12:55 pm
Thank you Steve Jones. I have given up on SQL Server 2005 Developer Edition because after 4 installs it does not work and I was unable to get help on this 2005 Edition in another Forum. I have already spent my money on SQL SERVER 2012 Developer Edition and am just waiting for it to be delivered. You have answered my question in that you advised either way I install it (on top of the previous install or remove the previous install using Control Panel) that it will work. I will have to wait until I see it work right to believe it. Thanks again for your help. jrichards54 🙂
September 2, 2012 at 7:55 pm
jrichards54 (9/2/2012)
Thank you Steve Jones. I have given up on SQL Server 2005 Developer Edition because after 4 installs it does not work and I was unable to get help on this 2005 Edition in another Forum. I have already spent my money on SQL SERVER 2012 Developer Edition and am just waiting for it to be delivered. You have answered my question in that you advised either way I install it (on top of the previous install or remove the previous install using Control Panel) that it will work. I will have to wait until I see it work right to believe it. Thanks again for your help. jrichards54 🙂
You can uninstall the previous edition, upgrade it or install side-by-side (a new instance). I would recommend installing a new instance and keeping the 2005 instance around just in case you need to use it.
If we know what 'it does not work' actually means we could probably help you. I would hate for you to go through the time and effort (and money) of purchasing 2012, installing it - and then having the same problems as the 2005 instance.
When I installed 2012 of this laptop - I had absolutely no issues. I then installed on my desktop - and it installed with no issues but I couldn't launch SSMS without errors. It took me several days of digging around, but I finally found out that a third-party utility was causing all of the problems. It turned out that third-party utility had a registry entry that was jacking up SSMS. Removed the old registry entry and everything worked.
I have 2005, 2008 R2 and 2012 on that system - and all are working as expected.
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 3, 2012 at 1:47 am
Jeffrey Williams 3188 (9/2/2012)
If we know what 'it does not work' actually means we could probably help you. I would hate for you to go through the time and effort (and money) of purchasing 2012, installing it - and then having the same problems as the 2005 instance.
+1
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 3, 2012 at 11:20 am
Thank you Jeffery for your comments. I appreciate you going over your experience with installing SQL Server. I have never had a Laptop but I have built 7 PCs one component at a time. I start with an empty case, then the Power Supply, MB, Memory, and the drives, then the OS and all the Apps.
I am going to take your suggestion and install 2012 side by side. I have Visual Studio 2003 and I just recently installed Visual Studio 2005. I am glad that I have both as I cannot get to MS Access Databases with the 2005 but can get to them and use them in the 2003 version. And since I cannot get the SQL Server to work I certainly cannot access the SQL Databases. I am pretty familiar with Access as I was the Assistant Instructor for two different Access Database Classes on Smart Planet. I am trying to learn Database Programming but the MS ADO.NET 2.0 book that I have uses the SQL Server Databases.
I thank you for your offer to help me with the 2005 Version. On the second install I had the SSMO in my start menu and when I clicked on it it said I was not connected to a database. I was never able to connect to a database. Then on the third and forth installs I lost that SSMO in my start menu and now I cannot even find the Server.exe file to be able to start it. But I will gladly go back and try to get it working with your guidance and help. Without help, I have found that it is worthless for me to try to get it to work. By the way, it was installed per the instructions in MCTS 70-431 Microsoft SQL SERVER 2005 Implementation and Maintenance. Have a good day. Jim 😛
September 3, 2012 at 1:28 pm
You are right Perry Whittle BUT I have already broken ALL the eggs in the omelette. I do not quit easily. I would never have learned to program Windows Programs if I had givin up early. I tried and retired to install that SQL Server 2005 but it is now in worse condition than after my second install. At least then I could click on the SSMO and it would start the Server. I just was not connected to a database. I cannot even start the SQL Server now, let alone use the databases (Northwind) in SQL. But maybe the gentleman in the next post can help me. I surely hope so. JRichards54 Have a good day. 🙂
September 3, 2012 at 3:26 pm
It sounds like you were expecting SQL Server to work the same as Access. It does not - there isn't a file you click on to open a database.
SQL Server runs as a service - and when you open SSMS (I assume that is what you are referring to as SSMO) it prompts for you to connect to a server. In that dialog box, you put the server name which is dependent on how you installed that instance.
SQL Server can have multiple instances on a system. Each instance is a separate service with its own name. The default instance would be accessed just by using the server (or PC in this case) name. You can only have one default instance - all others would be named instances and would be referenced using the server/pc name and instance name.
Okay - with all that said I would recommend the following:
1) Open Services applet and find all SQL Server related services. Verify whether or not those services are running. You only need (for now) the database engine running which will be something like: SQL Server (MSSQLSERVER).
2) Go to Add/Remove Programs and select SQL Server. This will prompt to either add components, remove components or uninstall. You want to add components and make sure you add the workstation components. Make sure you include the tools for Integration Services (I don't recall if that is separate or not).
3) Once you have verified the above and made sure the workstation tools are installed - open SQL Server Management Studio and connect to the instance identified in step one.
If you have any issues - post back and we can work through them.
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 3, 2012 at 3:28 pm
Note: SQL Server 2005 needs to be patched before it will work on Windows 7. Find SQL Server 2005 SP4, download it and apply it once you have performed the other steps.
You will also need Visual Studio 2005 SP1 to be installed - which it sounds like you already have.
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 3, 2012 at 6:47 pm
Thank you Sir. I will try to do what you have outlined although I am unfamiliar with many of the terms and proceedures. Wish me luck in trying. JRichards54 🙂
September 4, 2012 at 8:02 am
Thank you. I have SP 4 installed on SQL Server 2005 and SP 1 is installed on Visual Studio 2005. JRichards54 🙂
September 4, 2012 at 8:14 am
If you post more information about what you did or what didn't seem to be working, we can probably help you. Likely SQL Server has been running or working find on your system and you haven't been able to access it.
September 4, 2012 at 8:17 am
Jeffery Williams said: If you have any other isssues post back and we will work through them.
I have checked the Services and there are 4 or 5 with SQL Server entries and three of them show the MSSQLSERVER.
When I installed this app I always checked all of the components to install and then checkec "Advanced and added "Entire feature will be installed on local hard drive.
I am unable to locate "SQL MANAGEMENT STUDIO". Can't find it in the Start Menu or on the C: hardrive under programs (both versions). I had it in my Start Menu on the second install but it is gone now. JRichards54
September 4, 2012 at 8:21 am
Shouldn't this who thread be deleted here under SQL Server 2012 General and re-posted in SQL Server 2005? Others my find something helpful in your excellent comments and advice but they would not likely find it here the 2012 version. JRichards54
September 4, 2012 at 8:27 am
jrichards54 (9/4/2012)
4 or 5 with SQL Server entries and three of them show the MSSQLSERVER.
you probably have a default installation of SSRS and SSAS too as well as the database engine, that's why you'll see 3 services as MSSQLServer.
Can you post a screenshot of the services.msc console showing the sql services or post the output from this when run from a command prompt
net start > c:\services.txt
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 15 posts - 1 through 15 (of 81 total)
You must be logged in to reply to this topic. Login to reply