Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fabianus76
Posting Yak Master
191 Posts |
 Posted - 2007-04-23 : 12:23:00
|
| Hello !I am trying to connect to a SQLExpress installed on Vista through the network. I did enable all protocolls and in the Surface Area Configuration I activated Remote Connections ("using both TCP/IP and named pipes"). But still I get the following error: "An error has occured while establishing a connection to the serveR. When connection to SQL Server 2005, this failure may be caused by the fact that uder the default settings SQL Server does not allow remote connections. (provider: SQL Network Interface, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)"Thanks a lot for any help!Regards, Fabianusmy favorit hoster is ASPnix : www.aspnix.com ! |
|
|
fabianus76
Posting Yak Master
191 Posts |
Posted - 2007-04-23 : 12:29:47
|
| I just figured out that it is due to the Vista firewall. Does anybody know how to configure it to make it work?Thanks a lot for any feedback!Regards, Fabianusmy favorit hoster is ASPnix : www.aspnix.com ! |
 |
|
|
fabianus76
Posting Yak Master
191 Posts |
Posted - 2007-04-23 : 12:39:56
|
| OK, found the answer to my last post here : http://support.microsoft.com/default.aspx?scid=kb;en-us;914277Create an exception for SQL Server 2005 in Windows Firewall1. In Windows Firewall, click the Exceptions tab, and then click Add Program. 2. In the Add a Program window, click Browse. 3. Click the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe executable program, click Open, and then click OK. Note The path may be different depending on where SQL Server 2005 is installed. MSSQL.1 is a placeholder for the instance ID that you obtained in step 3 of the previous procedure. 4. Repeat steps 1 through 3 for each instance of SQL Server 2005 that needs an exception. Create an exception for the SQL Server Browser service in Windows FirewallTo create an exception for the SQL Server Browser service in Windows Firewall, follow these steps:1. In Windows Firewall, click the Exceptions tab, and then click Add Program. 2. In the Add a Program window, click Browse. 3. Click the C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe executable program, click Open, and then click OK.That's it. See you, Fabianus my favorit hoster is ASPnix : www.aspnix.com ! |
|
|
|
JLibertor
Starting Member
3 Posts |
Posted - 2007-04-23 : 18:28:25
|
| Thanks this may help me soon. I will have to do this on my machine in a few days. I appreciate you responding with your resolution. |
|
|
|
|
|
|
|
|
trying to connect to SQLExpress on Vista