Enabling Remote SQL Express 2008 Network Connections on Vista

a-foton » Enabling Remote SQL Express 2008 Network Connections on Vista

a-foton » Enabling Remote SQL Express 2008 Network Connections on Vista — Thu, 18 Sep 2008 05:39:47 GMT

PingBack from http://blog.a-foton.ru/2008/09/enabling-remote-sql-express-2008-network-connections-on-vista/

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Logan — Thu, 18 Sep 2008 12:34:17 GMT

Hi Beth

Just wondering, you mention SQL Server Express 2005, saying that it locks out remote connections, will these steps work to enable remote connections when using SQL Server Express 2005?

Regards,

Logan

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Beth Massi — Thu, 25 Sep 2008 19:19:10 GMT

Hi Logan,

Yep I think this is the same thing you need to do for SQL 2005 Express on Vista.

-B

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Logan — Mon, 29 Sep 2008 11:24:33 GMT

Hi Beth,

You beauty thank you :) I keep getting these errors saying "default settings don't allow remote connections" or something... although, not so much now I've watched the windows forms over data video series and know how to do it right lol

Thanks again, and keep shelling out these awesome tips will ya.

Logan

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Andy Hinds — Fri, 10 Oct 2008 16:52:55 GMT

I just want tosay thanks for writing this. I'm a novice and was searching all the wrong things until I found your post. So, thanks!

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Tim De Coen — Tue, 14 Oct 2008 01:08:25 GMT

Thank you very much. This is just what i need. I've been trying a lot of things but they never worked.

TDC

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Mary Fran — Wed, 15 Oct 2008 18:36:40 GMT

You're a life-saver! I was banging my head against the wall and you've stopped the headache!!!!

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Muni Kumar — Thu, 20 Nov 2008 14:35:09 GMT

Hi Beth,

I read you blog and several other hundred trying to figure out how to set up sql server on a small LAn(like a home network). You should use Mixed Mode Authentication. If you use windows Authentication(Integrated Security=True; in the connection string),unless you mirror each user on the network on the server computer, that user will not be able to login. A shortcut is to give the Guest account in every windows installation login rights to SQLSERVER. That is because every network log on is presented in windows authentication mode as Guest to the SQLSERVER. The SQL books Online recommends using WIndows Authentication mode as more secur. I cannot see how!

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Carl — Mon, 05 Jan 2009 00:58:43 GMT

Does this work on Workgroups on a Local Network?

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Jure Žove — Mon, 05 Jan 2009 02:11:49 GMT

Hello Beth,

I have an odd problem but i dont know if its the right topic :-) I have an VB application that connects to SQL Server Express 2008 on my computer. It works fine when i run it on my machine but when i run it on any other, it returns Network Instance 26 error. I enabled remote connections and if i type in the global IP (im behind a router) in the connection string (VB), it also works fine. If someone in local network tries to run the app, it crashes. I followed this manual but it didnt work :( (btw, i followed your How Do I videos when creating a database..)

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Jure Å½ove — Tue, 06 Jan 2009 04:08:58 GMT

Fixed it -> the connection string on the DataSet was invalid :-) now it works perfectly! Again, your How Do I videos are great!

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Beth Massi — Wed, 07 Jan 2009 21:20:26 GMT

Hi Carl,

It should. That's what I have here when I tested it.

Cheers,

-B

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Tue, 13 Jan 2009 22:32:05 GMT

just another thank you from another fellow programmer who's on his way now thanks to this article

thanx!

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Willem — Tue, 03 Feb 2009 18:17:16 GMT

Hi Beth. Great and helpful blog!

Can I add after having seen people experience difficulties: I will simply add on to your writing:

Beth:3. Enable TCP/IP by right-clicking and selecting Enable, then OK.

Willem: Double click the TCP/IP and click on the IP-adress tab. Go straight to "IPALL" - at bottom. Ensure Dynamic Ports contains a BLANK and add a port like 1433 to IP Port. If you have a named Instance leave the 1433 for some default and use 49172 (up to 65000)

Now you are ready to restart your instance's service again

"Beth:10. Configure the connection string. "

With the advent of the VS express editions, only WEB DEVELOPER can connect to a database engine as such. Use the following example to sort out your connection string.

e.g:

tcp:myMachine\MydbInstance,49172 - this if you want to use TCP/IP.

Hope this will complete Beth's very welcome blog a little.

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Ferdinand — Fri, 27 Feb 2009 12:28:11 GMT

Thanks, this saved me a lot of time!

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Jeremy — Wed, 18 Mar 2009 05:59:31 GMT

Great article. I got it working in about 2 minutes. Thanks.

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Dan — Fri, 20 Mar 2009 19:20:28 GMT

I found this article MOST helpful! You're a peach!

re: Enabling Remote SQL Express 2008 Network Connections on Vista

delta dirac — Sat, 04 Apr 2009 16:27:06 GMT

do you beleive what you're telling? ("it works for me")

no it doesn't work for no body there are much more to do please tell people completely or don'tell anything.people are spending days and days oh it works for her so am i an ideot???

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Beth Massi — Sat, 04 Apr 2009 18:11:25 GMT

Hi Delta Dirac,

Well it seems to have worked for many people here acoording to the other comments. It's kind of hard to help you if you don't explain what steps you tried or what error you are getting.

-B

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Delta Dirac — Sat, 04 Apr 2009 23:17:24 GMT

ofcourse i know you don't have to solve any personel difficulties met when programming,at least you don't have time for that Just wanna say,this sql networking thing is not so simple,i passed many many obstacles,first 'the remote connection settings and allowing named pipes and tcp/ip ' then 'user guest doesn't allowed in something',than i made logins on server,i made everything and everything,i gace roles i gave permissions but no way at the and of the fourth day i 've got a "User does not have permission to perform this action" what permisson i gave all te roles all the permissions, you know what something wrong with me or with these procedures,anyway thanks for your interest to my rude and angry comment(but i am still angry this is tha fact :))

re: Enabling Remote SQL Express 2008 Network Connections on Vista

jose — Tue, 21 Apr 2009 07:20:29 GMT

When they say "Firewall" ... it's not just windows firewall, but ANTIVIRUS FIREWALL too!!!!

That was the key for me... may be a little kork-head (cabeza'e termo para latinos), don´t care. That was it. 11:30 pm, at client site... Ramon, you saved my day!!!

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Matt — Fri, 26 Jun 2009 17:06:21 GMT

Awesome tip! Love the detail and step by step approach. Worked like a charm!

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Gary — Tue, 07 Jul 2009 17:18:23 GMT

Thanks for the straightforward post and step by step instructions.

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Kevin — Fri, 17 Jul 2009 05:42:03 GMT

THANK YOU!

I had been wrestling with this for two Evenings!!

(Even though the Error Message was Very Descriptive and Telling me what was wrong!!)

Thanks Again!

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Itsu — Thu, 23 Jul 2009 05:00:34 GMT

Very helpful post.

Willem,

your pointing out the need to disable the dynamic port was a life saver.

Thanks.

re: Enabling Remote SQL Express 2008 Network Connections on Vista

cj — Fri, 31 Jul 2009 20:31:59 GMT

Beth (and Willem!)...

Thanks a lot for all this info! It really helped us.

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Klaus Lozie — Sat, 05 Sep 2009 17:16:59 GMT

Thank you for your explanation.

Again a step further.

Best regards

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Rob — Tue, 22 Sep 2009 09:51:20 GMT

Thanks Beth!

You've helped get my project another step forward (again!)

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Kadilac — Tue, 22 Sep 2009 16:30:39 GMT

v been listen to ur CBTs neva knw u r that pretty , well thanks for the post that has really helped me alot.

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Raphael — Wed, 04 Nov 2009 10:28:05 GMT

Hii,

I was wondering if there's a good tutorial for connecting a Visual basic 2008 database app to the SQL 2008 database trough the network and what do do for it.. cause i made a dbase in SQL server Managment Studio, via tutorial, but i dont know for far how to connect it..

I'm creating a app on the laptop, en the sql server 2008 & managment database are on my local pc.

THnx in advanced!

Btw.. Your tutorials are very good.

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Beth Massi — Wed, 04 Nov 2009 21:15:57 GMT

Hi Raphael,

Take a look here:

http://msdn.microsoft.com/en-us/library/ms171886.aspx

You can connect to a remote database in Visual Studio and it will save that in the app.config file so that if you need to change the database location you don't have to recompile your application.

HTH,

-B

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Fred Zarguna — Tue, 10 Nov 2009 08:24:16 GMT

On x64 bit systems, the SQL Browser.exe will be in "c:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe"

SQLServer.exe will still be in the same place as above

re: Enabling Remote SQL Express 2008 Network Connections on Vista

Michael M. Bangoy — Thu, 03 Dec 2009 01:13:56 GMT

Great Article...I've tested it in windows 7...it works just fine...now i'm able to connect to my database installed in a Windows 7...tnx...