Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 4.5 > BOOK: Beginning ASP.NET 4.5 : in C# and VB
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Beginning ASP.NET 4.5 : in C# and VB
This is the forum to discuss the Wrox book Beginning ASP.NET 4.5: in C# and VB by Imar Spaanjaars; ISBN: 978-1-118-31180-6
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning ASP.NET 4.5 : in C# and VB section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old March 13th, 2013, 01:50 AM
Authorized User
Points: 71, Level: 1
Points: 71, Level: 1 Points: 71, Level: 1 Points: 71, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2013
Posts: 16
Thanks: 3
Thanked 0 Times in 0 Posts
Default provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specifie

Hi everyone. I have been trying for a couple of days now to log in to the SQL Server LocalDB instance. (on page 425 - step 3).

I keep getting the error message I posted on my thread title.

I download this SSMS --> http://care.dlservice.microsoft.com/...qldenexppost32

(SQLEXPRWT_x64_ENU.exe)

I also went to the appendix B in the Enabling Remote Connections in SQL Server section, and followed the direction.

I am still getting that error message. I cannot seem to figure out what is the problem.

I also did many search in Google and still cannot figure out what I am doing wrong.

It would be really helpful if we could have detailed step by step on how to proceed and sticky this somewhere.

I really hope someone can help me on this one.

Thank you.
Reply With Quote
  #2 (permalink)  
Old March 13th, 2013, 09:59 AM
Imar's Avatar
Wrox Author
Points: 70,811, Level: 100
Points: 70,811, Level: 100 Points: 70,811, Level: 100 Points: 70,811, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 16,891
Thanks: 79
Thanked 1,545 Times in 1,522 Posts
Default

Hi there,

Two questions:

1. What's the exact SQL Server instance name you're entering?

2. Are you sure Local DB is installed correctly? Do you see it appear in your Programs and Features list under Windows?

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
The Following User Says Thank You to Imar For This Useful Post:
UDO_67 (March 13th, 2013)
  #3 (permalink)  
Old March 13th, 2013, 11:25 AM
Authorized User
Points: 71, Level: 1
Points: 71, Level: 1 Points: 71, Level: 1 Points: 71, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2013
Posts: 16
Thanks: 3
Thanked 0 Times in 0 Posts
Default

Hi Imar,

I am at work and do not have access to my PC right now but to Answer your questions:

1) SQLEXPRESS is the name of server instance.

2) I am not sure if localdb is installed correctly but I did see it in control panel last night under the uninstall programs folder or what ever it is called.

In your book in Chapter 12 you specify that it is tricky and that was the first time in the whole book that you mentioned to come and get help here. I was surprise that I am one of the only one struggling with this. :-(

I have many years experience developing in non Microsoft product. I will not lie I struggle a bit with installing and dealing admin/db stuff.

If we cannot resolve this together do you happen to know if there is someplace I can go and have someone log on to my PC. I am that frustrated!!!

Again, I really appreciate you taking the time to help me.

I will follow up on this thread because I have a feeling someone might get stuck one day. This might help them too.

Thank you Imar.
Reply With Quote
  #4 (permalink)  
Old March 13th, 2013, 11:46 AM
Imar's Avatar
Wrox Author
Points: 70,811, Level: 100
Points: 70,811, Level: 100 Points: 70,811, Level: 100 Points: 70,811, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 16,891
Thanks: 79
Thanked 1,545 Times in 1,522 Posts
Default

Hi there,

1. SQLExpress is not the same as Local DB. Local DB gets installed with Visual Studio 2012, so it should be there already. Try logging into (localdb)\v11.0

2. The link you initially posted is a deep link so I can't really tell which product it is without downloading it. Your description seems to indicate you only downloaded SSMS, not the Express database engine.
If you still want to install SQL Server Express, try this page instead: http://www.microsoft.com/en-us/downl....aspx?id=29062 and choose something like SQLEXPRWT_x64_ENU.exe or
SQLEXPRWT_x86_ENU.exe as that's the Express Engine with the tools.

Hope this helps,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
  #5 (permalink)  
Old March 13th, 2013, 11:56 AM
Authorized User
Points: 71, Level: 1
Points: 71, Level: 1 Points: 71, Level: 1 Points: 71, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2013
Posts: 16
Thanks: 3
Thanked 0 Times in 0 Posts
Default

Imar,

That is what I downloaded. If you look at my original post, after the url link I put the name of the file in parenthesis, so that people could see what I was downloading. I also tried loging in with (localdb)\v11.0 and that is when I got the error message I posted in my title thread.
Reply With Quote
  #6 (permalink)  
Old March 13th, 2013, 12:01 PM
Imar's Avatar
Wrox Author
Points: 70,811, Level: 100
Points: 70,811, Level: 100 Points: 70,811, Level: 100 Points: 70,811, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 16,891
Thanks: 79
Thanked 1,545 Times in 1,522 Posts
Default

Sorry, I missed that. What do you get when you run that installer?

Also, try downloading the Local DB from my last link and run that installer again.

And once more: what *exactly* do you enter in the Server Name box of the "Connect to Server" dialog when using SSMS to log in to SQL Server?

Finally: check Programs and Features and the Services panel to see if Express and Local DB are installed and up and running.

If it keeps failing, please post more information about your version of Windows, installed software and so on.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
  #7 (permalink)  
Old March 13th, 2013, 12:08 PM
Authorized User
Points: 71, Level: 1
Points: 71, Level: 1 Points: 71, Level: 1 Points: 71, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2013
Posts: 16
Thanks: 3
Thanked 0 Times in 0 Posts
Default

Ok, I will try your suggestions and answer your questions tonight when I get home from work.

One last question for you today, if you do not mind. I would really like to have this working but do I need this in order to do all chapters in the book? Do i need to have this installed to complete the project or is it just for the exercise in Appendix B?

Thank you.
Reply With Quote
  #8 (permalink)  
Old March 13th, 2013, 12:19 PM
Imar's Avatar
Wrox Author
Points: 70,811, Level: 100
Points: 70,811, Level: 100 Points: 70,811, Level: 100 Points: 70,811, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 16,891
Thanks: 79
Thanked 1,545 Times in 1,522 Posts
Default

Yes, you do need a working database (Express or Local DB) for all the database related chapters. It's slight difficult to show you how database work and how to use them in ASP.NET without actually having one..... ;-)

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
  #9 (permalink)  
Old March 14th, 2013, 12:48 AM
Authorized User
Points: 71, Level: 1
Points: 71, Level: 1 Points: 71, Level: 1 Points: 71, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Feb 2013
Posts: 16
Thanks: 3
Thanked 0 Times in 0 Posts
Default

In the server name box I enter what the book told me too: (localdb)\v11.0

I noticed that by default it put my Computer name\SQLEXPRESS in the server name box. When I click the connect button, it seems to work now. I was able to resume the exercises and create a db. Hopefully I am in good shape now.

Thank you.
Reply With Quote
  #10 (permalink)  
Old March 14th, 2013, 10:55 AM
Imar's Avatar
Wrox Author
Points: 70,811, Level: 100
Points: 70,811, Level: 100 Points: 70,811, Level: 100 Points: 70,811, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 16,891
Thanks: 79
Thanked 1,545 Times in 1,522 Posts
Default

>> it seems to work now

Excellent.

Quote:
I noticed that by default it put my Computer name\SQLEXPRESS in the server name box.
Yes, that should work. Another common way to access that same instance is using .\SqlExpress The dot (.) represents the local machine.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified soufya BOOK: Beginning ASP.NET 4 : in C# and VB 7 September 14th, 2011 09:08 AM
Chapter 15. "Sign Up for new account" gets error: 26 - Error Locating Server/Instance Tanya Roslyakova BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 3 March 8th, 2011 10:34 AM
Microsoft OLE DB Provider for SQL Server error '80004005' ldp Classic ASP Databases 5 August 17th, 2009 10:13 PM
[newbie]A network-related or instance-specific error... jon80 BOOK: Professional ASP.NET 3.5 : in C# and VB ISBN: 978-0-470-18757-9 0 March 14th, 2009 08:43 AM
SQL Error Locating Server/Instance Specified cole C# 2005 0 September 18th, 2006 01:38 PM



All times are GMT -4. The time now is 08:34 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.