We have a VB.NET application which uses SQL Server Express 2008. This application could have any number of users. One user will be the server, so there won't be any problem in connecting (.\SQlExpress). But other users have to access the database through LAN, where I couldn't connect. I have given \SQLExpress (should I try with the IP address of server?). I get an error. Why?

We are not giving them SSMS, only SQL Server Express.

Code used to connect is VB.NET.

migrated from stackoverflow.com Nov 6 '11 at 19:18

This question came from our site for professional and enthusiast programmers.

  • Welcome, prabal! I've voted to close because this is a question regarding setting up SQL Server, not software development. I have, however, posted an answer. – Adam Robinson Nov 6 '11 at 17:25
  • Hi, I've also voted to close as the question's not quite right for SO - If you have more questions like this in future, try Server Fault. That said, welcome! – Basic Nov 6 '11 at 17:45

By default, SQL Server express is not configured to allow for connections from other computers. In order to do this, you'll need to access the SQL Server configuration snap-in and enable TCP/IP connections. You'll also need to ensure that the firewall on that computer is configured to allow connections to SQL Server.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy