September 4, 2012 at 10:52 am
What I did four times was to install SQL Server 2005 Developer Edition exactly as outlined in Microsoft
September 4, 2012 at 11:00 am
jrichards54 (9/4/2012)
What I did four times was to install SQL Server 2005 Developer Edition exactly as outlined in Microsoft
"outlined in Microsoft" doesn't tell us anything. Outlined where? What specific procedure or URL did you use?
Also, your screenshot shows lots of missing items, so depending on what you checked in setup, you may or may not get the other tools you need.
September 4, 2012 at 11:52 am
Here are three screenshots of information that you request me to make. JRichards54 🙂
September 4, 2012 at 2:05 pm
jrichards54 (9/3/2012)
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 😛
It sounds like during the install you may have either not chosen the correct services or didn't note what instance name you gave the server, or possibly didn't get the security settings correct. If you've never installed SQL Server before in your life, it's much, much trickier than most other installs. I would strongly suggest tracking down some step-by-step instructions and understanding them thoroughly before you try the install. The 2012 install process is not radically different from the 2012 install process. This means that whatever went wrong on you before, could do so again.
"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 4, 2012 at 2:42 pm
Thank you all for trying to help me. Based on the last post I believe that you all are at the end of your rope and have no other suggestion/advice to give me. This leaves me exactly where I was when I asked for help, out $172.00 and with an SQL Server 2005 that is worthless. Maybe I will have better luck when the 2012 version arrives but the posts indicate that I will probably have the same trouble. JRichards54 🙂
September 4, 2012 at 2:53 pm
The problem we have, at least from my point of view, is that we still don't know what you mean by things aren't working. It appears that you have all the services installed and running based on some of the screen shots posted. Our problem is we can't see what you see when you say it is broken.
September 4, 2012 at 4:20 pm
Grant Fritchey (9/4/2012)
The 2012 install process is not radically different from the 2012 install process.
The install process between 2005 and 2012 is radically different.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 4, 2012 at 5:09 pm
I have mentioned that I cannot start the SQL Server as I have no SSMO in my Start Menu. It was there on the second install but has dissappeared since then. I don't know what else to say or do. But I thank all who have tried to help me. JRichards54 🙂
September 4, 2012 at 6:05 pm
The second item I wanted you to do is to go to Programs & Features (Add/Remove), select SQL Server 2005 and the option to add features.
From here - you should be able to see what features are available to be added.
If you cannot add the workstation components, then they are already installed - or at least the system thinks they are installed. If that is the case, then you can go to C:\Program Files (x86)\Microsoft SQL Server\...90\binn folder and look for the SqlWb.exe file.
If you find that file - you have found SSMS for 2005.
If you don't find that file, then the workstation components were uninstalled and you should be able to install them again from the Add Features.
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 4, 2012 at 10:09 pm
jrichards54 (9/4/2012)
I have mentioned that I cannot start the SQL Server as I have no SSMO in my Start Menu. It was there on the second install but has dissappeared since then. I don't know what else to say or do. But I thank all who have tried to help me. JRichards54 🙂
First of all, what is SSMO? I know what SSMS is, it is SQL Server Management Studio.
Second, looking at the screen print you posted of the services, SQL Server is already running, so again, I'm not surte what you are talking about when you say you can't start it.
September 5, 2012 at 5:36 am
jrichards54 (9/4/2012)
Thank you all for trying to help me. Based on the last post I believe that you all are at the end of your rope and have no other suggestion/advice to give me. This leaves me exactly where I was when I asked for help, out $172.00 and with an SQL Server 2005 that is worthless. Maybe I will have better luck when the 2012 version arrives but the posts indicate that I will probably have the same trouble. JRichards54 🙂
JRichards,
Calm down a little. FYI: Your wording above sounds both frustrated and insultingly rude. The smiley just makes it worse, not better. Remember, this is a text environment. We can't see your body language or hear your tone of voice. So please be careful about how you word things.
You're making a huge assumption about ropes and ends and such. These people are trying to help you, but the terminology you are using is completely different from the terminology we understand.
Let's start from the beginning.
1) What is SSMO? Please define the acronym.
2) Please post the link to the instructions you used to install SQL Server Dev edition. If you did not look at a link or instructions, but just followed the prompts on the DVD, please let us know that too.
3) Go to Start -> Programs -> Microsoft SQL Server 2005. At minimum under this menu, you should see SQL Server Management Studio. If you do not, then you did not correctly install the client tools.
Do you remember what choices you made when it asked you to install SQL? Did you just install the engine? Did you install the documentation and tutorials? Did you in fact ask it to install the client tools?
SQL Server cannot be accessed on your desktop without these client tools. As others said, this is not like installing Microsoft Access.
Here is a link to the installation process tutorial for MS SQL Server 2005. Please click through it and verify where what you did was different from what this tutorial mentions: http://msdn.microsoft.com/en-us/library/ms143516(v=SQL.90).aspx.
September 5, 2012 at 6:17 am
jrichards54 (9/4/2012)
Here are three screenshots of information that you request me to make. JRichards54 🙂
For the first one, you appear to have typed
"net start c:\services.txt" instead of
"net start > c:\services.txt"
What was wanted was the c:\services.txt file that would be created by the command if the ">" character was included.
Tom
September 5, 2012 at 9:58 am
Your wording above sounds both frustrated and insultingly rude. The smiley just makes it worse, not better.
I assure you that I did not intend to be insultingly rude or even insulting or even rude. I appoligize if I sounded this way. The smiley was to show that even though I am exceedingly fustrated, that I still have a smile on my face.
I have copied the instructions in the link on how to install SQL Server 2005 and will re-install it again following those instructions.
Again I appoligize. JRichards54
September 5, 2012 at 10:58 am
So I tried to search for a definition of SSMO and here's what I found:
SSMO Sisters of St. Mary of Oregon (religious order)
SSMO Sudanese Standards and Metrology Organization
SSMO Summary of Synoptic Meteorological Observations
SSMO Ship Safety Management Office (UK)
SSMO State Surface Maintenance Office
SSMO Sewer System Maintenance and Operation Department (Northeast Ohio Regional Sewer District; Cleveland, OH)
I don't think the internet likes my google-fu today.
September 5, 2012 at 11:51 am
Brandie Tarvin (9/5/2012)
So I tried to search for a definition of SSMO and here's what I found:SSMO Sisters of St. Mary of Oregon (religious order)
SSMO Sudanese Standards and Metrology Organization
SSMO Summary of Synoptic Meteorological Observations
SSMO Ship Safety Management Office (UK)
SSMO State Surface Maintenance Office
SSMO Sewer System Maintenance and Operation Department (Northeast Ohio Regional Sewer District; Cleveland, OH)
I don't think the internet likes my google-fu today.
That looks like extremely broken google-fu - it omits the (South African) SARS Service Monitoring Office, the (Canadian) Service Spécialisé de Main-d'Oeuvre, the (Chilean) Servicio de Salud Metropolitano Oriente, the (Belizean ) Seal Solutions and Maritime Operations, and the (Scottish) Shetlands Shellfish Management Organisation as well as many more.
But of course all those are irrelevant, because SSMO in a Microsoft context stands for Sql Shared Management Objects. Googling the search string "SSMO site:microsoft.com" delivers fewer than 1000 hits - so clearly it is not a much used acronym.
Tom
Viewing 15 posts - 16 through 30 (of 81 total)
You must be logged in to reply to this topic. Login to reply