Last week, I have encountered a problem in connecting SQL Server 2005 from a remote machine, to a Server, in which Windows Vista Business Edition was the operating system.
After installing the SQL Server 2005 with SP2 in the Vista Business Machine, I started checking the SQL Server. It is working fine in local server. When I am trying to connect the same server from an Application (developed in VB.NET), I was unable to connect that.
My basic principle in diagnosing the problem is, always starting with zero. So I started ping the server IP and also the name of the Server. It was working fine.
Second I checked the Application, that the Server Name (and instance name in the correct format, ‘\’ should be used with instance name not the ‘/’) specified there is correct or not!? It was right!
Then I checked Server’s Surface area Configuration, whether the server is allowing remote connection or not! It is allowing! Then checked that the Protocols for Remote Connections are properly configured or not! That was also done! (As I knew the purpose of that Server earlier, after installing the SP2, I configured all these things earlier! Still I checked everything again!)
So everything is fine, and where lies the block!?
Then I started digging with error numbers in SQL Server Books Online and a lot of SQL Server related websites.
Most of the times I got the error was “Named Pipes Provider, error: 40 - Could not open a connection to SQL Server” . Best answer I have got on searching with this error is in SQLProtcols blogs. A must read blog for the every DBAs.( The last article published in that blog was July 2007)
Then I found that, SQL Browser Service was stopped and disabled! So I started with the following commands!( I typed in Command Prompt!)
sc config sqlbrowser start= auto
net start sqlbrowser
After starting the SQLBrowser, I was getting the Error (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
This error number is related to Firewall! Then I got that. I have to open the port ( the default port for my situation is the default port of SQL Server 1433) in firewall! The following link helped me! Step by step is explained there.
http://msdn2.microsoft.com/en-us/library/ms175043.aspx
Now it is working fine! Thank you MSDN!
18 comments:
I can't help but believe that the market for products with photos imprinted on them, now made accessible by the Internet, represents a truly enormous opportunity. Every day many new websites are coming on the internet, which can be used for all sort of access to stuff that can make you smile. if you want to get these amazing and funny gifs animated images, then what are you waiting for.
my web-site http://www.discutii.eu/GuspyieSi
What a funny blog! I in fact loved watching this comic video with my family unit as well as
along with my friends.
Feel free to visit my blog - bakersfieldbug.com/groups/battling-to-comply-with-a-specialist-health-software-attempt-these-strategies-in-its-place/
So just like others, if a person has interest in the fresh news updates, he can surely give a preference to online medium for getting
familiarity with these topics. A person needs to have an active internet connection to be able to access all the headlines and information on internet.
Due to the recent horrifying terror attacks and other such couple of events people want to be aware and alerted of the whereabouts of the nation.
Visit my web page Latest Daily News
Well, as we know world is changing day by day and its every single move in politics, business or even entertainment world affects our
lives a lot. Indeed, internet is the best source of because it is easily
accessible and fast. ' They always intend to take public view on variousu topics.
Here is my web blog ... just click the following webpage
People talk themselves out of exercising so easily, and the opposite can be
so easy. We know because they have done so for millions of other people.
The decisive factor is that men would want
to show themselves as hot and rock solid before the fashionable ladies as ever.
Also visit my webpage ... women fitness tips abs
One can find plenty of funny pictures and videos by a single click on any search engine
like Yahoo or Google. I can also would suggest taking a few minutes to successfully snicker not to mention grin available at funny
pictures ( imagenes de humor ) and then funny videos ( videos divertidos ) to assist you
in the quest with cheer in addition to stress reliever. While wasting your time watching
something marginally funny may actually frustrate you, watching truly hilarious movies
and shows is an easy way to get laughter into your life whenever you need it.
my page ... funny pictures about love
What's up, I just want to mention, you're wrong.
Your own blog doesn't make any sense.
My webpage ... Click That Link
You need to flex those muscles regularly to keep them
strong and resilient. It is important that you realise that
if you do miss one of your exercise sessions it is not the end of the world.
I am aware this seems enjoy ridiculous advice - Get real if you may possibly just flip a switch and enjoy exercise
you would certainly, right.
Also visit my blog post; fitness tips and motivation
Hi there mates, its enormous paragraph about
cultureand entirely defined, keep it up all the time.
Here is my homepage - web log analysis software
Internet is the biggest server of fun with a lot of variety.
This trend brings more enthusiast people to
upload the beautiful funny videos to share with others
and get their precious feedback. If you cannot get over something that went wrong in your life, remember this quote, 'Do not blame yourself for past errors.
Here is my web-site helpful hints
Far too many children become the victims of abuse, neglect, or abandonment and then sadly, often they become wards of the court who
will eventually determine their fate. Both the content and presentation of news are drastically different
from what it used to be. Committee on Gulf War and Health: Health
Effects of Serving in the Gulf War, Update 2009.
Feel free to visit my page: Latest Daily News
Can you please send an e-mail to me the code for this script or please let know me in
detail concerning this script?
My web page: please click the next internet page
Hi there to every , for the reason that I am in fact eager of reading this web siteís post to be updated
on a regular basis. It carries pleasant information.
Feel free to visit my blog: fitness tips of the day
Or maybe you look at it from a monetary standpoint
and decide that Guy Ritchie and Madonna divorce was worse because they were married
so long and have children and there is a lot of money involved.
But unlike their blank counterparts, custom lanyards also can
proclaim a marketing or motivational message to customers and employees.
She married singer Mark Anthony in2005 and released her
next album called Rebirth.
Feel free to surf to my web site - texasveteransforcongress.org
Here again you want to find or even create
an angle or slant in which you can take headline news and 'incorporate' it into a
post you are composing. Also, find one that has includes videos explaining the latest news because that is sometimes the best way to
see it. However, today, the wedding photographers capture photographs of moments that are precious
and that you would cherish all your life; and, when
you least expects the wedding photographer to capture
you.
Feel free to visit my homepage http://demo.socialengineexpress.com
Νoгmаllу, ωhat we comprehend if ωe 1st hear Ciаlіs іѕ the fact thаt this is thе
Alsо vіsit my web site ... viagra
I was pretty pleased to find this site. I wanted to thank you for your time due to this wonderful read!
! I definitely savored every part of it and I have you book marked to check out new things in your web site.
my homepage: Biomedical Companies
After exploring a number of the blog articles
on your website, I honestly appreciate your way of blogging.
I added it to my bookmark site list and will be checking back in the near future.
Take a look at my web site as well and tell me your opinion.
Here is my blog ... news of the day
Post a Comment