I'm not sure if your question is rhetorical, or if it's directed at me, since I was the one who asked why the thread has 300,000 views, and I also have written a book.
First, don't buy my book. Please.
Next, why do you believe that web development should be easy?
Having trouble following the book and online stuff can be a challenge, particularly the first time through. You might want to take a class or find a tutor and get some in-person assistance from someone who has been through it before. After you've been through
it once, and after you get everything set up, things tend to go pretty smoothly.
Wow! Thanks for responding. And I agree what I need is somebody to sit next to me and answer my stupid questions. Do you know such a person in Southern NH who freelances? Barring that, do you know a book that explains the concepts I need? Is yours the one?
It looks more like a book on optimizing code than on debugging SQL Server installations.
And I was playing the dumb blonde... I have actually worked as a software engineer for 17 years, spend every day writing MFC code and C++ (STL) that reads and writes to a SQL Server that I installed on the network myself and that I maintain. I also for some
occasions use Access or mySQL.
Years ago when I learned that technology, I had people in the office that I could ask about why some error popped up, and who actually knew the answer and AND WERE WILLING TO explain it. Like you said, I got over the hump in a week or two. I haven't met
an error message in MFC or C++ that stopped me for more than a few minutes in years. I let some senior programmers with no knowledge of SQL Server or ASP take my laptop and spend a couple hours trying to figure out why I'm getting this error message without
success. There are a couple people in the England office who know ASP, but they didn't know what to suggest.
So I'm not an idiot, and neither were they. And I maintain that some aspects of Web development should be easy. Yes. This happens with every new technology and some people have more patience with it than others. But this is precisely the sort of thing that
doesn't take any deep insight or programming magnificence to get. You need to know a few conventions, and you need to be TOLD them. You can't guess that if you're running SQL Server Express, your connection string should say SQLEXPRESS and not SQLSERVEREXPR.
300,000 hits means that Microsoft has failed (temporarily) in some way to communicate a very common issue. Because no. This shouldn't be hard.
The Server wasn't found it says. Okay, why not? It's installed. It says SQL Sever may not be configured to accept remote connections? How do I check? There's no SQL Server app. It's a limited version, and there's no DB Manager to open up, no dialog box with
a check box saying 'Accept remote connections'. Why? These issues should be anticipated and addressed immediately. I've paid good money for a full version and I deserve to know without too much ado.
A miracle! A SQL Server guru friend of my brother's was here for dinner -- a Muslim guy from India. He fixed my machine. It took him almost 8 minutes. I asked him if I needed to know what was wrong, and he said he didn't think it would repeat itself, so
I'm blissfully ignorant, and inclined to remain so. It was some Vista user registration issue, I think. I sure am glad I spent 6 days on that.....................
Never mind, it's broken the same as before, and Minouj is clueless. :-)
Sorry, I don't know any freelancers in NH. If you can't find someone locally, you might look on a site like liverperson.com to see if there's someone who could help you on a remote basis via chat. If you're having trouble getting a fully licensed SQL Server
to work at all, then another option is to open a support ticket at Microsoft. Their support folks are surprisingly good, and will stick with you until the issue is fixed, no matter how long it takes. Or, you could post a question at serverfault.com; the
folks over there are pretty helpful.
My book covers how to build an ASP.NET / SQL Server-based website that's fast and scalable, but doesn't include beginner stuff about installation and how to get a basic site running. There are a million tutorials and videos online which cover that area in
detail.
Oh, and FWIW, I suspect that the high view count on this thread isn't from disgruntled users. Rather, it's more likely from spiders or auto-refreshes, or something like that.
Well it turns out that I have extended the membership provider but forgot to extend the role provider. So even though the membership provider was quite happy looking at my connectionstring the default Role Provider was searching for an SQLExpress install.
Oh well hope someone learns from my mistakes :)
Cheers
I think this is the problem I have, however I dont know how to go about fixing it. Can someone give me explicit instructions has to how to go about doing as the above has mentioned? I'd be extremely grateful. This problem is greatly frustrating to say the
least.
Many Thanks
Dan
SQLasp.net 3.5Connectionn Error
I haven't failed. I've just found 10,000 ways that don't work.
The problem has been resolved. There must be a compatibility issue between VS2005 C++ and VS2008, because we've tried it now on 9 machines. On the 7 running VS2005, it won't let us access SQL Server from within 2008, and on the 2 which aren't running VS2005,
everything works fine.
Thanks! We sort of gave up for now, and uninstalled it on all the development machines. I'm just borrowing a different machine for this purpose which isn't reunning VS2005. But if it ever comes up again, I'll give it a try.
RickNZ
Contributor
5233 Points
880 Posts
Re: A network-related or instance-specific error occurred while establishing a connection to SQL ...
Dec 17, 2009 12:04 AM|LINK
I'm not sure if your question is rhetorical, or if it's directed at me, since I was the one who asked why the thread has 300,000 views, and I also have written a book.
First, don't buy my book. Please.
Next, why do you believe that web development should be easy?
Having trouble following the book and online stuff can be a challenge, particularly the first time through. You might want to take a class or find a tutor and get some in-person assistance from someone who has been through it before. After you've been through it once, and after you get everything set up, things tend to go pretty smoothly.
Ultra-Fast ASP.NET: Build Ultra-Fast and Ultra-Scalable web sites using ASP.NET and SQL Server
My blog: http://www.12knowmore.com
hvete
Member
20 Points
10 Posts
Re: A network-related or instance-specific error occurred while establishing a connection to SQL ...
Dec 18, 2009 08:05 PM|LINK
Wow! Thanks for responding. And I agree what I need is somebody to sit next to me and answer my stupid questions. Do you know such a person in Southern NH who freelances? Barring that, do you know a book that explains the concepts I need? Is yours the one? It looks more like a book on optimizing code than on debugging SQL Server installations.
And I was playing the dumb blonde... I have actually worked as a software engineer for 17 years, spend every day writing MFC code and C++ (STL) that reads and writes to a SQL Server that I installed on the network myself and that I maintain. I also for some occasions use Access or mySQL.
Years ago when I learned that technology, I had people in the office that I could ask about why some error popped up, and who actually knew the answer and AND WERE WILLING TO explain it. Like you said, I got over the hump in a week or two. I haven't met an error message in MFC or C++ that stopped me for more than a few minutes in years. I let some senior programmers with no knowledge of SQL Server or ASP take my laptop and spend a couple hours trying to figure out why I'm getting this error message without success. There are a couple people in the England office who know ASP, but they didn't know what to suggest.
So I'm not an idiot, and neither were they. And I maintain that some aspects of Web development should be easy. Yes. This happens with every new technology and some people have more patience with it than others. But this is precisely the sort of thing that doesn't take any deep insight or programming magnificence to get. You need to know a few conventions, and you need to be TOLD them. You can't guess that if you're running SQL Server Express, your connection string should say SQLEXPRESS and not SQLSERVEREXPR. 300,000 hits means that Microsoft has failed (temporarily) in some way to communicate a very common issue. Because no. This shouldn't be hard.
The Server wasn't found it says. Okay, why not? It's installed. It says SQL Sever may not be configured to accept remote connections? How do I check? There's no SQL Server app. It's a limited version, and there's no DB Manager to open up, no dialog box with a check box saying 'Accept remote connections'. Why? These issues should be anticipated and addressed immediately. I've paid good money for a full version and I deserve to know without too much ado.
So there. ;-)
hvete
Member
20 Points
10 Posts
Re: A network-related or instance-specific error occurred while establishing a connection to SQL ...
Dec 18, 2009 09:53 PM|LINK
A miracle! A SQL Server guru friend of my brother's was here for dinner -- a Muslim guy from India. He fixed my machine. It took him almost 8 minutes. I asked him if I needed to know what was wrong, and he said he didn't think it would repeat itself, so I'm blissfully ignorant, and inclined to remain so. It was some Vista user registration issue, I think. I sure am glad I spent 6 days on that.....................
Never mind, it's broken the same as before, and Minouj is clueless. :-)
RickNZ
Contributor
5233 Points
880 Posts
Re: A network-related or instance-specific error occurred while establishing a connection to SQL ...
Dec 19, 2009 04:18 AM|LINK
Sorry, I don't know any freelancers in NH. If you can't find someone locally, you might look on a site like liverperson.com to see if there's someone who could help you on a remote basis via chat. If you're having trouble getting a fully licensed SQL Server to work at all, then another option is to open a support ticket at Microsoft. Their support folks are surprisingly good, and will stick with you until the issue is fixed, no matter how long it takes. Or, you could post a question at serverfault.com; the folks over there are pretty helpful.
My book covers how to build an ASP.NET / SQL Server-based website that's fast and scalable, but doesn't include beginner stuff about installation and how to get a basic site running. There are a million tutorials and videos online which cover that area in detail.
Oh, and FWIW, I suspect that the high view count on this thread isn't from disgruntled users. Rather, it's more likely from spiders or auto-refreshes, or something like that.
Ultra-Fast ASP.NET: Build Ultra-Fast and Ultra-Scalable web sites using ASP.NET and SQL Server
My blog: http://www.12knowmore.com
shijobaby500
Member
54 Points
28 Posts
Re: A network-related or instance-specific error occurred while establishing a connection to SQL ...
Dec 19, 2009 08:54 AM|LINK
http://sqlerrormessages.blogspot.com/2009/12/specified-sql-server-not-found-or-error.html
dt86uk
Member
107 Points
132 Posts
Re: A network-related or instance-specific error occurred while establishing a connection to SQL ...
Jan 02, 2010 01:02 AM|LINK
I think this is the problem I have, however I dont know how to go about fixing it. Can someone give me explicit instructions has to how to go about doing as the above has mentioned? I'd be extremely grateful. This problem is greatly frustrating to say the least.
Many Thanks
Dan
SQL asp.net 3.5 Connectionn Error
athelli_redd...
Member
8 Points
57 Posts
Re: A network-related or instance-specific error occurred while establishing a connection to SQL ...
Mar 05, 2010 04:49 AM|LINK
I also got this message when I am trying on connect open solution in Visual studio 2008 and visual studio 2010.
hvete
Member
20 Points
10 Posts
Re: A network-related or instance-specific error occurred while establishing a connection to SQL ...
Mar 05, 2010 12:07 PM|LINK
The problem has been resolved. There must be a compatibility issue between VS2005 C++ and VS2008, because we've tried it now on 9 machines. On the 7 running VS2005, it won't let us access SQL Server from within 2008, and on the 2 which aren't running VS2005, everything works fine.
hitrobinho
Member
2 Points
1 Post
Re: A network-related or instance-specific error occurred while establishing a connection to SQL ...
Mar 11, 2010 08:46 AM|LINK
try it：
change “Data Source=(local);”to “Data Source=(local\SqlExpress);”
may it will work
hvete
Member
20 Points
10 Posts
Re: A network-related or instance-specific error occurred while establishing a connection to SQL ...
Mar 11, 2010 10:42 AM|LINK
Thanks! We sort of gave up for now, and uninstalled it on all the development machines. I'm just borrowing a different machine for this purpose which isn't reunning VS2005. But if it ever comes up again, I'll give it a try.