SQL Server Xpress remote connections

Hot Topic

Why Mining Structure can only use one dimension from a cube?
How to combine to boolean collumns ?
SQL Server Management Studio Express - cannot find SQLEditors.DLL
dynamically created dataset
Daylight Savings Time changes coming in 2007
Error using UnaryOperatorColumn on a Many-to-Many linked dimension
Sql server Sp1 error messages questions
append current date to file name
Web Site Admin Tool problem in VS2005
Foreach loop with XML Source failure

SQL Server

alternating row color
Microsoft report builder is a very BAD product
Business Intelligence Projects
Sum measures
Installation Problems - need help..
past and future date
comments
How do I add an ODBC connection data source as a Data Flow Source
Delete record from table over 5000 count.
SQL stored procs

SQL Server Xpress remote connections

Hello

I've installed the SQL Server 2005 Xpress Edition on a server. On other machine I've got the SQL Server 2005 Enterprise Edition. From this, I'm trying to connect to the SQL server witch has the SQL Server Xpress Edition but gives me the follow error:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

I've already enable the TCP/IP and Pipe connections and SQL allows remote users!

Anyone could help me with this problem

Thanks

Answer this question

SQL Server Xpress remote connections

  • Reza Bemanian

    Did you restart the service after enabling the remote connections Make sure that the SQL Server Browser is started on the SQL Server Express, it will redirect client request to the appropiate port as no static port is used by default. The default is top grab a dynamic port for listening to the network.

    HTH, Jens K. Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
  • SQL Server Xpress remote connections
Answer this question