Server Man Studio Express Connect error on server but works locally . help??

Hot Topic

SQL Server 2005 and RDO compatibility
problem with microsoft xp....help please
ADO Connection Pooling Error: "The client was unable to reuse a session with ..."
Backup and Restore Databases Through XML in SQL Express 2005
The connection manager 'OLEDB' is not properly installed on this computer
REceiving notification in windows application
SSIS Fuzzy Matching
SQL Server Express fails to install
UDM Information
Teradata data extension question

SQL Server

Bug in the OLE DB command?
Error locating server/instance specified
SQL server 2005 reportmanager not accessable, reportserver is working fine ??
Problem getting execution status of a SQL Agent Job
SQL Server 2005 and SharePoint Portal Server 2003
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance
Can't Deploy AdventureWorks Database
DB Mirroring VS. Clustered Failover Questions
Data Source View and Report Model
BDE admin connecting problem, How do I connect via IP address.

Server Man Studio Express Connect error on server but works locally . help??

Hi there,

Can anybody help me

I installed Server Management Studio Express and it works great on my local server but when trying to connect to a server i have on the lan it gives me a connect error.

I use the correct format i.e.  machine_name\SQLEXPRESS

I have also enabled Protocols, via, tcpip, and named pipes... and restarted sql server express on the server.

I do have a standard Windows 2003 firewall installed maybe I have to open a port.. Can anyone advise

Thanks in advance

Ian

Answer this question

Server Man Studio Express Connect error on server but works locally . help??

  • Namialus Dauf

    Hi Ian,



    Yes, you will need to add an Exception to your firewall to allow SQL Express to communicate through. You may also need to create an Exception for SQL Browser if you have that enabled. Just add the programs to the Exception list. Be sure to add the correct SQL executable to the list, each instance of SQL Express has a separate executable; you need to create an exception for each instance you want to be accessed remotely. Browser is a shared component, so you only need a single Exception for that.



    Regards,

    Mike

  • Salva

    Please note that by default all versions of SQL Server 2005 will only talk to local machine.  The idea is to have the default install in a locked down state.  You must change the configuration to support the TCP/IP protocol.  I'm not sure how to change it in EXPRESS, but in all the other editions you can use the SQL Server Configuration Manager.  Do you have anything like this

  • Server Man Studio Express Connect error on server but works locally . help??
Answer this question