Establishing a remote connection..! (Again)

Hi,

I am trying to connect via the Management Studio Express. I share a LAN with the server. In Netowrk connections I can see the server and I can even access the "Shared" folders. However,when I try to connect I get an error that says the error may be caused by the server not allowing remote connections. I have already done the following:

With the Surface Area Configuration facility I have set the server to allow remote connections I have selected TCP/IP as the preferred mode of connection. I have selected Windows authentification as mode of authorisation

What else can I do?

Please help.

Derekprinsloo

Verify that there is no local firewall blocking.

These resources should help you.

Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

Configuration -Connect to SQL Express and ‘Stay Connected’
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html

Establishing a remote connection..!

How can I establish a remote connection for using remote database in SQL Server 2K5?

Thanks.

Take a look at this link:

http://msdn2.microsoft.com/en-us/library(d=robot)/ms188721.aspx

Is this what you are looking for? If not, please provide additional information on the scenario you want to enable.

Thanks
Laurentiu

|||

my scenario :

my computer is into a LAN. I want to connect from my PC to a database on another computer in this LAN. I have username and password for logging in to the another computer in SQL Server Authentication mode.

please help me!

|||

How did you try to connect so far?

Normally, you would need to specify the server name, and the user name and password. But you should check that the server accepts remote connections and that you're not blocked by a firewall. Also check to see that the type of connection that you make is enabled on the server (if you use TCP, check that TCP is enabled).

Thanks
Laurentiu

sql

Error: Unable to connect to the remote server.

I have been running RS for a month and it was working fine. However, now it is giving me the following error:

The underlying connection was closed: Unable to connect to the remote server.

Any ideas? Thanks

Is this both remotely and from the local server? And of course some of the basice questions:

Have you installed any new software?

Have you made any changes to your IIS?

Have there been any firewall changes?

Is this from all machines?

|||

Yes, this is both remotely and from the server. SQL is intalled on the remote server. The error is from all machines. The only new software installed on the IIS (where RS is intalled) is Cold Fusion. This might be the cause, but I don't understand how? No firewall changes have been made.

Thanks

|||

I don't know if this is an option, but have you tried to reinstall report services? or removing Cold Fusion. Also you may want to call the makers of Cold Fusion and see if they have heard anything like this.

To be honest I am taking stabs in the dark on this one, sorry.

Error: Unable to connect to the remote server

I'm getting an error message:
The underlying connection was closed: Unable to connect to the remote
server.
Any suggestions why this error is occurring?
Thanks.
danIt looks like your server connection string got corrupted.
Use the RSConfig utitlity to reset it and that should take of it.
"Dan Slaby" <dslaby@.evergreeninfo.biz> wrote in message
news:%23umiDgcSFHA.248@.TK2MSFTNGP15.phx.gbl...
> I'm getting an error message:
> The underlying connection was closed: Unable to connect to the remote
> server.
> Any suggestions why this error is occurring?
> Thanks.
> dan
>