provider: SQL Network Interfaces, error: 26

UDO_67 · March 13th, 2013, 12:50 AM

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.

Imar · March 13th, 2013, 08:59 AM

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

UDO_67 · March 13th, 2013, 10:25 AM

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.

Imar · March 13th, 2013, 10:46 AM

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

UDO_67 · March 13th, 2013, 10:56 AM

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.

Imar · March 13th, 2013, 11:01 AM

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

UDO_67 · March 13th, 2013, 11:08 AM

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.

Imar · March 13th, 2013, 11:19 AM

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

UDO_67 · March 13th, 2013, 11:48 PM

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.

Imar · March 14th, 2013, 09:55 AM

>> 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