Can't connect using management studio while using remote desktop connection on lan.

I get the error message:

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.

I am not able to find this setting. Could someone please inform me of where to look and maybe what to do?

Thanks in advance.

Start/Programs/Microsoft SQL Server 2005/Configuration Tools/SQL Server Surface Area Configuration Manager/
Click Surface Area Configuration for Services and Connections
Click Database Engines / Remote connections
Select Local and Remote connections and one of the 3 choices below

also make sure the Allow Remote Connection to This Server option is checked on the
Server Properties/Connections page

|||

lkh wrote:

Start/Programs/Microsoft SQL Server 2005/Configuration Tools/SQL Server Surface Area Configuration Manager/
Click Surface Area Configuration for Services and Connections
Click Database Engines / Remote connections
Select Local and Remote connections and one of the 3 choices below

also make sure the Allow Remote Connection to This Server option is checked on the
Server Properties/Connections page

I have found the settings within the configuration tools up to the part where you mention the 3 choices below with success.

The part:
also make sure the Allow Remote Connection to This Server option is checked on the
Server Properties/Connections page

Is that from within the same configuration area or elsewhere?
Thanks so much.|||In Object Explorer in SQL Server Management Studio (SSMS) right click the server, click properties.|||

lkh wrote:

In Object Explorer in SQL Server Management Studio (SSMS) right click the server, click properties.

I'm sorry, there is nothing listed under object explorer pane. I see a default server under database engine in the registered servers pane.

Maybe because I haven't been able to connect yet? I'm not sure where else to look. I'm prolly goofed atm.

Maybe I'll have to do this the normal way and actually connect locally on that computer, then set that setting you mention.

I was hoping I could avoid having to do that, but I will if I have to.|||

right-click the default server, then click Connect/Object Explorer

SQL Server service also has to be started

|||Thanks so much for the help, the second part is already set to allow remote connections.
Turns out the problem I was having was due to my logging in as the second admin account on that pc. I could swear I installed it from that user account but it's acting like I can only connect to SQL via the original account on the pc.
Can't put my finger on it as it's been too long since the install.

Thanks for the help, all's good for now.|||Are you connecting with server\instance?

Can't connect to the sql server

I have machine A hosting SQL Server XXX, and B tries to access XXX. XXX
use mixed authentication mode. A and B are in the same LAN and
workgroup.
B use Sql Server username and passoword to access the XXX sql server.
In ADO.Net and Visual Studio .Net, if I first register the Server A on
Visual Studio .Net IDE, then I can connect to XXX by the pre-set sql
server username and password, otherwise it failed.
Or, if I first connect to Server A by visiting network connections to
give A's windows username and password, then I can connect to XXX by
the pre-set sql server username and password.
However, if I don't first gain access A, then I can't connect XXX by
the pre-set sql server username and password.
What's the problem here?
Thanks;Can you describe your installation more fully? Which edition of SQL
Server 2005 (I assume it's SQL Server 2005) are you using? Which CTP?
Thanks
Andrew Watt
MVP - InfoPath
On 9 Oct 2005 11:55:29 -0700, zhenghong04@.yahoo.com wrote:

>I have machine A hosting SQL Server XXX, and B tries to access XXX. XXX
>use mixed authentication mode. A and B are in the same LAN and
>workgroup.
>B use Sql Server username and passoword to access the XXX sql server.
>In ADO.Net and Visual Studio .Net, if I first register the Server A on
>Visual Studio .Net IDE, then I can connect to XXX by the pre-set sql
>server username and password, otherwise it failed.
>Or, if I first connect to Server A by visiting network connections to
>give A's windows username and password, then I can connect to XXX by
>the pre-set sql server username and password.
>However, if I don't first gain access A, then I can't connect XXX by
>the pre-set sql server username and password.
>What's the problem here?
>Thanks;

Can't connect to the sql server

I have machine A hosting SQL Server XXX, and B tries to access XXX. XXX
use mixed authentication mode. A and B are in the same LAN and
workgroup.
B use Sql Server username and passoword to access the XXX sql server.
In ADO.Net and Visual Studio .Net, if I first register the Server A on
Visual Studio .Net IDE, then I can connect to XXX by the pre-set sql
server username and password, otherwise it failed.
Or, if I first connect to Server A by visiting network connections to
give A's windows username and password, then I can connect to XXX by
the pre-set sql server username and password.
However, if I don't first gain access A, then I can't connect XXX by
the pre-set sql server username and password.
What's the problem here?
Thanks;
Can you describe your installation more fully? Which edition of SQL
Server 2005 (I assume it's SQL Server 2005) are you using? Which CTP?
Thanks
Andrew Watt
MVP - InfoPath
On 9 Oct 2005 11:55:29 -0700, zhenghong04@.yahoo.com wrote:

>I have machine A hosting SQL Server XXX, and B tries to access XXX. XXX
>use mixed authentication mode. A and B are in the same LAN and
>workgroup.
>B use Sql Server username and passoword to access the XXX sql server.
>In ADO.Net and Visual Studio .Net, if I first register the Server A on
>Visual Studio .Net IDE, then I can connect to XXX by the pre-set sql
>server username and password, otherwise it failed.
>Or, if I first connect to Server A by visiting network connections to
>give A's windows username and password, then I can connect to XXX by
>the pre-set sql server username and password.
>However, if I don't first gain access A, then I can't connect XXX by
>the pre-set sql server username and password.
>What's the problem here?
>Thanks;

Can't connect to SQL server

Hi,
I'm having trouble connecting to the SQL server in a LAN. I can't even
telnet to the port 1433 of the server. Does anyone have any idea how to fix
this problem?
Shafiee.
Are you able to ping the SQL Server? What error are you getting when you try
connecting to the server using Query Analyzer?
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"shafiee" <mohamed.shafee@.gmail.com> wrote in message
news:Ov0k0dSrFHA.304@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I'm having trouble connecting to the SQL server in a LAN. I can't even
> telnet to the port 1433 of the server. Does anyone have any idea how to
fix
> this problem?
> Shafiee.
>
|||Hi Narayana,
Yes I am able to ping to the server. The server isn't listening to client
requests. The version of SQL server installed is SQL 2000. Any ideas?
Shafiee.
"Narayana Vyas Kondreddi" wrote:

> Are you able to ping the SQL Server? What error are you getting when you try
> connecting to the server using Query Analyzer?
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "shafiee" <mohamed.shafee@.gmail.com> wrote in message
> news:Ov0k0dSrFHA.304@.TK2MSFTNGP11.phx.gbl...
> fix
>
>
|||If SQL Server is running and you can ping the server, one
possibility is that the server is listening on shared memory
only which means only local connections will be allowed. Use
the server network utility on the SQL Server box to make
sure you have protocols enabled. You can also check the SQL
Server error log from when the instance started to see what
protocols, ports SQL Server is listening on. If it's only
Shared Memory, enable TCP/IP on the server using the server
network utility.
-Sue
On Tue, 30 Aug 2005 19:59:04 -0700, "Shafiee"
<Shafiee@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Narayana,
>Yes I am able to ping to the server. The server isn't listening to client
>requests. The version of SQL server installed is SQL 2000. Any ideas?
>Shafiee.
>"Narayana Vyas Kondreddi" wrote:

Can't connect to SQL server

Hi,
I'm having trouble connecting to the SQL server in a LAN. I can't even
telnet to the port 1433 of the server. Does anyone have any idea how to fix
this problem?
Shafiee.Are you able to ping the SQL Server? What error are you getting when you try
connecting to the server using Query Analyzer?
--
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"shafiee" <mohamed.shafee@.gmail.com> wrote in message
news:Ov0k0dSrFHA.304@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I'm having trouble connecting to the SQL server in a LAN. I can't even
> telnet to the port 1433 of the server. Does anyone have any idea how to
fix
> this problem?
> Shafiee.
>|||Hi Narayana,
Yes I am able to ping to the server. The server isn't listening to client
requests. The version of SQL server installed is SQL 2000. Any ideas?
Shafiee.
"Narayana Vyas Kondreddi" wrote:

> Are you able to ping the SQL Server? What error are you getting when you t
ry
> connecting to the server using Query Analyzer?
> --
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "shafiee" <mohamed.shafee@.gmail.com> wrote in message
> news:Ov0k0dSrFHA.304@.TK2MSFTNGP11.phx.gbl...
> fix
>
>|||If SQL Server is running and you can ping the server, one
possibility is that the server is listening on shared memory
only which means only local connections will be allowed. Use
the server network utility on the SQL Server box to make
sure you have protocols enabled. You can also check the SQL
Server error log from when the instance started to see what
protocols, ports SQL Server is listening on. If it's only
Shared Memory, enable TCP/IP on the server using the server
network utility.
-Sue
On Tue, 30 Aug 2005 19:59:04 -0700, "Shafiee"
<Shafiee@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Hi Narayana,
>Yes I am able to ping to the server. The server isn't listening to client
>requests. The version of SQL server installed is SQL 2000. Any ideas?
>Shafiee.
>"Narayana Vyas Kondreddi" wrote:
>

cant connect to my databse in lan

Hi all!

I am using MSSQL 2005 and asp.net .I have made a web application that needs to be run in LAN.The authentication used is windows authentication.The problem is that when in LAN I cannot connect to the database The sqlexception error shows that the connection is closed.Is there any thing that i am missing?Any configurations i need to make??Is this the issue of remote connections?? Please help!!I am new and dont knw much abt it .Thanks!!

Quote:

Originally Posted by dotnetgal

Hi all!

I am using MSSQL 2005 and asp.net .I have made a web application that needs to be run in LAN.The authentication used is windows authentication.The problem is that when in LAN I cannot connect to the database The sqlexception error shows that the connection is closed.Is there any thing that i am missing?Any configurations i need to make??Is this the issue of remote connections?? Please help!!I am new and dont knw much abt it .Thanks!!

yes you have to setup the Security of SQL Server to accept Mix Authentication|||

Quote:

Originally Posted by ck9663

yes you have to setup the Security of SQL Server to accept Mix Authentication

hello !!

Thanks for the reply.But how am i to set it up to accept Mix Authentication?|||

Quote:

Originally Posted by dotnetgal

hello !!

Thanks for the reply.But how am i to set it up to accept Mix Authentication?

open enterprise manager. right click on your server. choose properties. a dialog box will appear. choose Securtiy. on Server Authentication, choose SQL Server and Windows authentication mode|||

Quote:

Originally Posted by ck9663

open enterprise manager. right click on your server. choose properties. a dialog box will appear. choose Securtiy. on Server Authentication, choose SQL Server and Windows authentication mode

thanks!!I did it but dtill the problem persists!!Any idea?

Can't connect from remote computer

I can't connect to a sql server express server who is in another computer in
the same lan.
In the server I went to the configuration manager and I enabled the TCP/IP
protocol but it still doesn't work.
What else can I do?
Thank youAlberto,
please have a look here for details on enabling remote connections:
http://support.microsoft.com/kb/914277
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Hello,
Using Surface Area configuration toll see:-
1. The SQL Server is configured for Local and Remote connections
2. SQL Server Browse service is started.
If not, do both chnages and try connecting.
Thanks
Hari
"Alberto" <alberto@.nospam.es> wrote in message
news:%23LM3c23SHHA.412@.TK2MSFTNGP02.phx.gbl...
>I can't connect to a sql server express server who is in another computer
>in the same lan.
> In the server I went to the configuration manager and I enabled the TCP/IP
> protocol but it still doesn't work.
> What else can I do?
> Thank you
>
>|||In the surface area confgurarion tool I've got what you say and it still
doesn't work.
I don't know why.
"Hari Prasad" <hari_prasad_k@.hotmail.com> escribió en el mensaje
news:OQlRzI4SHHA.1212@.TK2MSFTNGP03.phx.gbl...
> Hello,
> Using Surface Area configuration toll see:-
> 1. The SQL Server is configured for Local and Remote connections
> 2. SQL Server Browse service is started.
> If not, do both chnages and try connecting.
> Thanks
> Hari
>
>
> "Alberto" <alberto@.nospam.es> wrote in message
> news:%23LM3c23SHHA.412@.TK2MSFTNGP02.phx.gbl...
>>I can't connect to a sql server express server who is in another computer
>>in the same lan.
>> In the server I went to the configuration manager and I enabled the
>> TCP/IP protocol but it still doesn't work.
>> What else can I do?
>> Thank you
>>
>

Can't connect from remote computer

I can't connect to a sql server express server who is in another computer in
the same lan.
In the server I went to the configuration manager and I enabled the TCP/IP
protocol but it still doesn't work.
What else can I do?
Thank youAlberto,
please have a look here for details on enabling remote connections:
http://support.microsoft.com/kb/914277
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com|||Hello,
Using Surface Area configuration toll see:-
1. The SQL Server is configured for Local and Remote connections
2. SQL Server Browse service is started.
If not, do both chnages and try connecting.
Thanks
Hari
"Alberto" <alberto@.nospam.es> wrote in message
news:%23LM3c23SHHA.412@.TK2MSFTNGP02.phx.gbl...
>I can't connect to a sql server express server who is in another computer
>in the same lan.
> In the server I went to the configuration manager and I enabled the TCP/IP
> protocol but it still doesn't work.
> What else can I do?
> Thank you
>
>|||In the surface area confgurarion tool I've got what you say and it still
doesn't work.
I don't know why.
"Hari Prasad" <hari_prasad_k@.hotmail.com> escribi en el mensaje
news:OQlRzI4SHHA.1212@.TK2MSFTNGP03.phx.gbl...
> Hello,
> Using Surface Area configuration toll see:-
> 1. The SQL Server is configured for Local and Remote connections
> 2. SQL Server Browse service is started.
> If not, do both chnages and try connecting.
> Thanks
> Hari
>
>
> "Alberto" <alberto@.nospam.es> wrote in message
> news:%23LM3c23SHHA.412@.TK2MSFTNGP02.phx.gbl...
>