Can't connect to remote sql server from asp.net buk ok from Enterprise Manager

[Mamcx]

Remove now aspnet user from admin group! (no matter is a test server, is a
bad practique). You server is win2003? I don't can connect to Sql Server
using NT authentication but with Sql Server authentication is fine. Create
user group with the rigth permision on the database, create a user (like
WebUser) with strong password and connect with it...

[karim]

On Thu, 17 Jul 2003 17:53:16 -0500, Mamcx wrote:

> Remove now aspnet user from admin group! (no matter is a test server, is a
> bad practique). You server is win2003? I don't can connect to Sql Server
> using NT authentication but with Sql Server authentication is fine. Create
> user group with the rigth permision on the database, create a user (like
> WebUser) with strong password and connect with it...

aspnet has more rights that it should. I know and certainly this is not the
cause of the problem.

Rmember I said the app connects fine from my development machine. This
means the user and password on the database work fine.

Karim

[bruce barker]

you must use tcp/ip and standard security for your configuration to work.
named pipes requires an authenticated connection and is subject to the one
hop rule. turn off named pipe support on your sqlserver and see if you can
still connect.

-- bruce

"karim" <karim3411@11yahoo11.com> wrote in message
news:c857bbdd7527f5c6ec0c2021dbef6ed4@free.teranew s.com...

>
> I have an asp.net app that can connect from my development box to a
> database server.
>
> However the same app, when put on a web server box, can't connect to that
> database server. Enterprise Manager and Query Analyzer on the web server
> can connect just fine. I am using SQL Server authentication. aspnet user

is

> a member of the admin group. All 3 machines are part of the same domain.
>
> Both web server and database have tcp/ip and named pipes enabled.
> One weird thing I noticed on the development box is that I can't telnet to
> port 1433 of the database server even though my app connects fine.
>
> What am I missing?
>
> Karim