تبلیغات
گروه کمک درسی دانشجویان غیاث الدین جمشید کاشانی (آبیک) - رفع خطای A network-related or instance-specific error
 
گروه کمک درسی دانشجویان غیاث الدین جمشید کاشانی (آبیک)
بسم رب شهدا و الصدیقین . . .
درباره وبلاگ


مهمترین اهدافی که این وبلاگ دنبال میکند کمک و راهنمایی تمام دانشجویان کارشناسی(خصوصآ کارشناسی ناپیوسته کامپیوتر -نرم افزار) است تا:
1-دوره کارشناسی خود را با رضایت قلبی و در حداقل تعداد ترم های مجاز و بدون مشکل پشت سر بگذارند
2-آماده سازی دانشجویان برای شرکت در آزمون کارشناسی ارشد می باشد

مدیر وبلاگ : سجاد یوسفی
نویسندگان
برچسبها

GO START -> ALL PROGRAMS -> SQL SERVER 2008/2005/2008 R2
->CONFIGURATION TOOLS->
->SELECT SQL SERVER CONFIGURATION MANAGER
->SELECT SQL SERVER NETWORK CONFIGURATION
->SELECT PROTOCOLS FOR MSSQLSERVER(YOUR INSTANT NAME)
->IN RIGHT TASK PANEL
->MAKE SURE MENTION BELOW:

DISABLE SHARED MEMORY AND VIA
ENABLE NAMED PIPE AND TCP/IP

—-MAKE SAME THING IN
->SQL NATIVE CLIENT 10.0(SERVER VERSION) CONFIGURATION – CLIENT PROTOCOLS

RESTART SQL SERVER(MSSQLSERVER [YOUR INSTANT NAME]) SERVICE


A network-related or instance-specific error

This is the common error when we are working with sql server.It will occur while establishing a connection to sqlserver.In this post i will explain how to resolve network and remote connection error.First we need to check the given data source name is correct or not in connection string.The TCP/IP protocol should be enable to made such type connection.The following steps will describe how to enable TCP/IP protocol in sql server configuration manager
Go To-->Configuration Tools folder which is in MS Sql Server 2008 folder in start menu

2.Select server Network configuration-->click on protocols for SQLEXPRESS.
Then we can see the protocols at Right side panel.By default the TCP/IP status is in disable mode.So we need to change status to enable






نوع مطلب : دنیای کامپیوتر و فناوری اطلاعات، 
برچسب ها :
لینک های مرتبط :
29 اردیبهشت 97 12:39 ب.ظ
you're in reality a excellent webmaster. The website loading velocity is amazing.
It kind of feels that you are doing any unique trick. Also, The contents are masterpiece.
you've performed a wonderful activity in this matter!
27 شهریور 96 05:55 ق.ظ
Good day! I could have sworn I've been to your blog before but after looking at
a few of the posts I realized it's new to me. Anyhow,
I'm certainly delighted I stumbled upon it and I'll be book-marking it and checking back regularly!
30 مرداد 96 02:02 ب.ظ
This is really interesting, You are a very skilled blogger.
I have joined your rss feed and look forward to seeking
more of your magnificent post. Also, I've shared
your website in my social networks!
14 مرداد 96 02:02 ق.ظ
Just want to say your article is as surprising. The clearness to your post is simply excellent and
that i could suppose you are knowledgeable in this subject.

Well with your permission allow me to seize your RSS feed to keep up to date with forthcoming post.

Thank you 1,000,000 and please keep up the gratifying work.
9 مرداد 96 09:15 ق.ظ
Heya i'm for the first time here. I found this board and I find It truly
useful & it helped me out a lot. I hope to give something back and
help others like you aided me.
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر


آمار وبلاگ
  • کل بازدید :
  • بازدید امروز :
  • بازدید دیروز :
  • بازدید این ماه :
  • بازدید ماه قبل :
  • تعداد نویسندگان :
  • تعداد کل پست ها :
  • آخرین بازدید :
  • آخرین بروز رسانی :