Re: Can't connect to remote sql server from asp.net buk ok from Enterprise Manager
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
"karim" <email@example.com> wrote in message
> 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
> 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?
|All times are GMT. The time now is 04:28 AM.|
Powered by vBulletin®. Copyright ©2000 - 2013, vBulletin Solutions, Inc.
SEO by vBSEO ©2010, Crawlability, Inc.