Oletown
Rookie

How to enable remote Connection sql server 2008?


As we know that SQL Server 2008 express is out in the market and I am trying to install it but not able to do so as it doesn’t allow remote connection by default installation as on SQL Server 2005 express. So I want to ask you that do I have to facilitate it manually or there is any other method….share with me.
6 months ago
Respond to this discussion
Harshil Darji | Oct 29 2011

Hello, to see if I can help because I'm already agobiadisimo. I have made ​​a visual basic application that accesses a database sql server 2008. In local mode this works correctly but the problem is in wanting another pc also access data from the first. How I can configure the main sql served for the Visual Basic application on the remote computer to access data also without problems. ThaWhere you need to change depends on two things: The type of authentication and how to connect.

If authentication is via windows authentication, then computers must authenticate to the same place is implemented database. If a domain, both must belong to the same domain and with users accessing their computers to be registered in the domain.
If authentication is via sql server, then there is nothing to move you to the server, rather than ensuring that the user exists and has privileges at the database and associated tables, procedures, etc.. Where you have to move is in the application, particularly in the connection string. If this server is identified as 'local' or 'localhost' is why you can not connect from the remote entity. The server must have the name of the computer (server) which is implemented database.

Thank you very much in advance, I assume you do not have problems with SQL authentication mode in such a way so as nannies utenticacion the installation in windows mode or that topic sql conoses guess the other side when you install an instance of SQL Server 2008 by default is configured to not allow remote connections to another computer on your network to connect to sql server you have to enable in sql 2008 to accept remote connections, but nobody is going to connect to the server database in sql 2005 this option is set in the "surface area configuration "in sql 2008 is no longer that option now you will have to enable remote connections (for other pc to connect to the database) from another option called faces or facets that is located in, when you open the management studio and give click right in the instance of the Server and select the option faces or facets you opened a sales and choose the option Depue remote connections and then look for the option to enable remote connections (ie to other pcs on the network can connect to sql) and put it in true or true Depue restart sql Serbs and ready.

© 2012, Instamedia. Some rights reserved. Powered by Instapress and Instacheckin.