May 1, 2015 at 4:05 am
Hi everyone,
I am a complete noob in SQL but not in programming. I am trying to teach myself to be proficient in SQL but I find that the configuration part is hard to get past before the actual lessons.
I just installed MS SQL Server 2008 Management Studio Express from here https://www.microsoft.com/en-ph/download/details.aspx?id=7593. Opening the Management Studio I get the Connect to Server window. Choosing Server type: Database Engine with the Server name default value "(local)" I can't get anywhere. I have tried the To connect to the Database Engine procedure with this link: https://msdn.microsoft.com/en-us/library/ms345332.aspx with no success. I think I might need to install something else.
I have resources detailing how to integrate a sample database (to begin learning to code) once I have connected to the actual database engine. Can anyone help me with this?
Sorry, if this seems elementary but I am pretty intent on learning SQL for work purposes and it looks like I am going to have a lot of questions like this. Thanks in advance.
May 1, 2015 at 4:49 am
Choosing Server type: Database Engine with the Server name default value "(local)" I can't get anywhere.
Don't worry about asking simple questions - we all ask questions at some point that we believe we should know the answers to.
When you try and connect, what error message do you see, or what response is there?
May 1, 2015 at 5:10 am
Thanks BrainDonor.
This is the reply:
Cannot connect to (local)
Additional info:
Property Login was not set. (Microsoft.SqlServer.ConnectionInfo)
May 1, 2015 at 5:47 am
SQL Server management studio is a developers tool to be able to connect to the sql engine, the installer you've downloaded does not include the engine itself. have you installed sql engine before installing management studio? if you have a named instance you have to use (local)\InstanceName to connect.
Download an installer from below link:
https://www.microsoft.com/en-us/download/details.aspx?id=30438
i would suggest downloading straight away the one with advanced services SQLEXPRADV so you have most of the things to start learning.
May 1, 2015 at 6:40 am
dick.vanderweed (5/1/2015)
Choosing Server type: Database Engine with the Server name default value "(local)"
If you performed a default install of express then the engine will be a named instance.
Open up the services.msc on your pc and post a screen shot of this.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
May 1, 2015 at 8:40 am
That error message suggest you've selected SQL Server Authentication and left the Login field blank. At least, that's the only time I've seen that error.
Cheers!
May 2, 2015 at 1:19 am
Thanks for the replies.
I have now downloaded and installed the actual database engine (SQLEXPRW) based on Kutang Pan's reply and attached AdventureworksDW as a sample database. I will now attempt to go with the actual tutorial in this link: https://msdn.microsoft.com/en-us/library/ms167593.aspx unless there is a better one.
One thing I noticed is that I can't open Database Diagrams for AdventureworksDW because the sample database "does not have a valid owner". Is this something to be concerned about?
May 5, 2015 at 9:59 pm
Am I right in assuming that installing SQLEXPRW does not allow me to have access to Database Diagram, but SQLEXPRADV does?
If that's the case should I uninstall SQLEXPRW first, or just install SQLEXPRADV directly? Thanks. 🙂
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply