LocalDB and Scripts folder

begaspnet · July 5th, 2014, 09:26 AM

Hello,

I downloaded this file:
ENU\x86\SQLEXPRWT_x86_ENU.exe
for the SQL Server Management Studio, but I cannot connect to the localDB as described in the try it out on page 411. Instead the only option that I was getting is the following: my pc id\SQLEXPRESS. The LocalDB 11.1 is actually installed on the computer, but the management studio can't connect to it. I am now stuck and can't make any progress. Any suggestions?

Also, in chapter 11 page 395, on section 3 of the try it out, the system is rejecting the drag because both files are located within the Scripts folder.

Thank you!

Imar · July 7th, 2014, 08:18 AM

Hi there,

Local DB may not appear in the list automatically. Did you try typing it in manually as suggested in step 3 on page 411? It should read as (LocalDB)\v11.0

>> the system is rejecting the drag because both files are located within the Scripts folder.

The text says not to drag it in the Scripts folder, but to drag the file *onto* the open references files in the text editor.

Cheers,

Imar

begaspnet · July 7th, 2014, 09:33 AM

Hi Imar,

I typed it manually as suggested by the text. Is there any other alternative, because I noticed that the rest of the material depends on this particular step.
Did I download the correct express version anyways?

Thank you!

Imar · July 7th, 2014, 09:44 AM

>> I typed it manually as suggested by the text.

And did that work?

If not, check under Programs and Features in Windows and search for local. You should see something like Microsoft SQL Server 2012 Express LocalDB. If you don't see it, it's not installed and you may need to reinstall it.

You don't *have* to use LocalDB, and a regular Express instance would work too, but LocalDB is typically simpler to work with.

Cheers,

Imar

begaspnet · July 7th, 2014, 11:16 AM

When I typed it manually it did not work. I typed it exactly as suggested by the book. Microsoft SQL Server 2012 Express LocalDB is installed on my computer and the version is 11.1. I typed this version as well as the version suggested(11.0) by the book. Both did not work.

This is what I installed for the express: ENU\x86\SQLEXPRWT_x86_ENU.exe
Is it the right thing?

Thanks again!

Imar · July 7th, 2014, 11:30 AM

>> This is what I installed for the express: ENU\x86\SQLEXPRWT_x86_ENU.exe

Hard to say as the file name doesn't reveal the version. But this should give you SQL Express, not necessarily Local DB.

Have you tried (re)installing Local DB? http://www.microsoft.com/en-us/downl....aspx?id=29062

Also, can you post the *exact* instance name you're entering when trying to log in to local DB?

Imar

begaspnet · July 7th, 2014, 02:24 PM

Hi Imar,

I reinstalled it and it worked. The one that was previously installed was a higher version which was not compatible.

Thanks for the help!