August 7, 2013 at 6:48 pm
I have done a lot w/ Excel Databases, but needed to expand to more power. I have installed SQL Server 2012, but I don't have a clue how to start this thing. No Icon was placed on my desktop.
The Sql Server 2012 folders created don't make much sense to me. I only have a book that tells me to choose Management Studio from the main menu. Know idea how to even get to a main menu.
Can anyone help me get started:hehe:
thx
f
August 7, 2013 at 10:39 pm
Start->All programs->SSMS
August 7, 2013 at 11:55 pm
Start->All programs->Microsoft SQL Server 2012-> SQL Server Management Studio
or
Start-> run-> SSMS
give sa and its password or through windows authentication if you have configured .
Regards
Durai Nagarajan
August 8, 2013 at 12:02 am
When you get SSMS (SQL Server Management Studio) started, you need to fill in the servername. The easiest way to do this is to just put a dot .
This means you are taking the default instance on your localhost (which is your own computer).
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 12, 2013 at 4:48 pm
thx everyone:-)
f
August 12, 2013 at 4:56 pm
One important point is that SQL Server runs as a service. That service is managed through the SQL Server Configuration Manager. You may have to start the configuration manager and use it to start the SQL Server service before you can use SSMS to connect to it and manage the running SQL Server databases and users. Configuration Manager will allow you to configure the types of connections allowed (TCP, Named Pipes, Shared Memory), and other features of the SQL Server service.
Books Online (BOL) is your friend.
August 12, 2013 at 4:56 pm
thx Durai,
unfortunately I am on Win 8, and I don't have a Start button and the Desktop Explorer shows Sql Server was installed in a Folder 'Microsoft SQL Server' which appears in both the /Program files/ directory and also the /program Files x86/ directory.
Exploring those folders, I can find no relevant application icon.
Also in Win 8 Tablet View mode, I can see the various Sql 'Apps', including Manegement Studio. Selecting them runs everything fine,
but i just wanted a way to get it on my desktop view and can see no options for the in the Win 8 tablet view mode.
????
thx
f
August 12, 2013 at 4:59 pm
ok gee,
i checked out the 'Config Tools' folder on my desktop, and that displayed the relevant shortcuts for the desktop:-)
thanks for pointing out that folder!
f
August 12, 2013 at 5:08 pm
oh wait again,
Management Studio icon still not on the Desktop,
I thought I had it but only have configuration shortcut,
???
August 12, 2013 at 6:36 pm
got it finally,
Pulled Up Tablet View (Management Studio displays), right-clicked and clicked option 'open in folder', then I was able to see the program in a folder (which was not available from the desktop view), then right-clicked 'Create a Shortcut' - like normal from there,
whew!
thx
August 13, 2013 at 12:04 am
fgrubercpa (8/12/2013)
got it finally,Pulled Up Tablet View (Management Studio displays), right-clicked and clicked option 'open in folder', then I was able to see the program in a folder (which was not available from the desktop view), then right-clicked 'Create a Shortcut' - like normal from there,
whew!
thx
Windows 8, it is quite the adventure 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 13, 2013 at 12:12 am
fgrubercpa (8/12/2013)
got it finally,Pulled Up Tablet View (Management Studio displays), right-clicked and clicked option 'open in folder', then I was able to see the program in a folder (which was not available from the desktop view), then right-clicked 'Create a Shortcut' - like normal from there,
whew!
thx
Congratualtion 😛
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply