September 5, 2012 at 12:22 pm
L' Eomot Inversé (9/5/2012)
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.
You know, I wondered if we were talking Mangement Objects, but I'm used to seeing that listed as SMO, not SSMO.
September 5, 2012 at 2:00 pm
Brandie Tarvin (9/5/2012)
You know, I wondered if we were talking Mangement Objects, but I'm used to seeing that listed as SMO, not SSMO.
On social.msdn.microsoft.com there are a lot of people apparently using SSMO to mean SSMS (but people post there because they have a problem, so it's no surprise that some of them are confused) so maybe that's what it meant in this thread. But MS clearly means SMO when it writes SSMO (the most obvious demonstration of that is that the Installing SMO MSDN page says that you use the Shared Management Objects .msi in the SQL Server Feature Pack to install Sql Server Management Objects.
Tom
September 5, 2012 at 4:13 pm
It looks like I have miss-quoted and have caused an awful lot of trouble to those trying to help me. I am sorry that I have done this. I mean SSMS, SQL Management Studio. On the second install this item used to reside in my Start Menu and I could click on it and it would bring up a window but it showed that I was NOT connected to a database. I was never able to connect to a database and then with further installs that SSMO was no longer in my start menu. I believe everything including the Client support is already on my PC. I just do not know how to get to it to use it. JRichards54
September 5, 2012 at 4:42 pm
SQL Server Management Studio is SSMS, not SSMO (where does the O come from?)
What you describe (SSMS starting and asking you to connect to a server) is completely correct and expected behaviour, not a broken installation. SQL Server is a server application, not a file-based database like MS Access, so when you start the client tool, you have to tell it which server (which SQL Server instance on which computer) is the one you want to connect to.
Now, did you do what Brandie asked?
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 5, 2012 at 4:45 pm
jrichards54 (9/5/2012)
It looks like I have miss-quoted and have caused an awful lot of trouble to those trying to help me. I am sorry that I have done this. I mean SSMO, SQL Management Studio. On the second install this item used to reside in my Start Menu and I could click on it and it would bring up a window but it showed that I was NOT connected to a database. I was never able to connect to a database and then with further installs that SSMO was no longer in my start menu. I believe everything including the Client support is already on my PC. I just do not know how to get to it to use it. JRichards54
You could start by referring to Management Studio as SSMS, not SSMO. You can call it being nitpicky.
The first thing I would do in your position is uninstall SQL Server, all of it. Then I would install it again from scratch.
September 5, 2012 at 4:45 pm
Jeffery Williams. You posted: 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.
I am unable to do either of these as in Windows 7 Home Premium, in Control Panel, in Remove programs, I do not have an add programs feature. Just Delete, Modify, or Change.
When I navagate to C:\Program Files (X86)\Microsoft... there is no Microsoft SQL Server there. JRichards54
September 5, 2012 at 4:50 pm
I just ran a search for "SqlWb.exe" in the C:\Program Files (X86)\Microsoft and there were no results. JRichards54
September 5, 2012 at 4:50 pm
jrichards54 (9/5/2012)
I am unable to do either of these as in Windows 7 Home Premium, in Control Panel, in Remove programs, I do not have an add programs feature. Just Delete, Modify, or Change.
Modify. Then add features from the installer that launches.
Or just remove the whole lot and reinstall (following that link that Brandie posted) from scratch.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 6, 2012 at 5:42 am
GilaMonster (9/5/2012)
SQL Server Management Studio is SSMS, not SSMO (where does the O come from?)What you describe (SSMS starting and asking you to connect to a server) is completely correct and expected behaviour, not a broken installation. SQL Server is a server application, not a file-based database like MS Access, so when you start the client tool, you have to tell it which server (which SQL Server instance on which computer) is the one you want to connect to.
Now, did you do what Brandie asked?
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.
And this is why I think you may have lost track of either the server or the instance name when you were doing the install. You need to note what these are when do the installation so that you can then connect to them later.
"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 6, 2012 at 6:02 am
I don't remember what the default environment is set up on 2k5. I use Empty Environment so that I can connect to whatever I want. But when SSMS is opened up, here are 3 things that you may be seeing.
The first picture is Empty Environment (no connection dialogue box, no summary window).
The second picture is what SSMS looks like if it's opened with Object Explorer chosen as the environment. It may not have "local" in the DB name (I put it there because local is what is commonly used for default instances).
The third picture is what you get when you cancel out of that connect box on most of the other environment setups.
After you are done reinstalling (and writing down what you installed), look at these three pictures. Tell us which one is closest to what you saw when you said you weren't connected to the database.
BTW, when you reinstall, you MUST make sure to install the client tools. That is an option. If you forget it, you won't see SSMS available under the menu.
September 6, 2012 at 1:39 pm
I just ran the DOS Command with the > in it and got "Access Denied". Then I went into Control Panel and deleted every thing "SQL Server". Now I assume that everything is deleted that has to do with SQL Server so I start the install and get to a window that says "Installation is blocked. All the features that you indicate that you want are already installed on this machine." How can this be when I just deleted (un-installed) everything using the "Control Panel". Seems to me that we cannot fix it, I evidently cannot delete it, and I am unable to install it. I believe it is time to re-format the C: hard drive, re-install the OS, Virus Portection, and try again to install SQL Server 2005 Developer Edition. Does anyone have any suggestions as this is an awful lot of work and will take me several days to accomplish. When I re-format I always loose a few Apps because I am unable to locate the license for them. JRichards54
September 6, 2012 at 1:44 pm
Do you mean that you used the uninstall process for software through the Control Panel? If so, you should be ready to go for a clean install. If you did something other than that... I'm not sure what state your system is in.
"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 6, 2012 at 1:45 pm
If you're not willing to give details (such as what and how you 'deleted' stuff from Control Panel), what installer you ran, what options you selected, the exact dialog and the exact point in the installation that it came up, etc, it's unlikely anyone's going to be able to give you help. We can't see your machine.
I get the impression you're fairly new to Windows as a whole. May I suggest getting someone in who's more familiar with the OS.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 6, 2012 at 2:34 pm
Another suggestion. Get a copy of virtualbox. It's free. You can install your OS to a virtual machine and get it set, then make a copy. Try installing SQL Server to that. If it fails, throw it away, copy the original OS again, and then try again with SQL Server. You'll save yourself tons and tons of headaches if you start working that way, especially when you're just getting started learning how this stuff works.
"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 6, 2012 at 3:05 pm
jrichards54 (9/6/2012)
I just ran the DOS Command with the > in it and got "Access Denied". Then I went into Control Panel and deleted every thing "SQL Server". Now I assume that everything is deleted that has to do with SQL Server so I start the install and get to a window that says "Installation is blocked. All the features that you indicate that you want are already installed on this machine." How can this be when I just deleted (un-installed) everything using the "Control Panel". Seems to me that we cannot fix it, I evidently cannot delete it, and I am unable to install it. I believe it is time to re-format the C: hard drive, re-install the OS, Virus Portection, and try again to install SQL Server 2005 Developer Edition. Does anyone have any suggestions as this is an awful lot of work and will take me several days to accomplish. When I re-format I always loose a few Apps because I am unable to locate the license for them. JRichards54
Sounds like you may be encountering issues with UAC (user account control) in Windows 7. You may want to google that.
Second item. If using Home premium, I would seriously rethink that strategy. Home Premium has some limitations that can cause some issues with SQL Server (like paging to disk frequently) in my experience. This will require more tuning and troubleshooting but it can be made to work. Grant made an excellent recommendation on that front. Download and use virtual box. I think it will significantly improve your experience.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 15 posts - 31 through 45 (of 81 total)
You must be logged in to reply to this topic. Login to reply