remote connection to SQL server problems

[VR]

While developing an ASP.NET with a SQL server running
locally, I didn't have any problems using the following
connection string (where ATP is the local server's name)

"Server=ATP;uid=AppAdmin;pwd=pass;Database=DB1 ";

When I try to connect to a remote SQL server named DTP,
using connection string:

"Server=DTP;uid=AppAdmin;pwd=pass;Database=DB1 ";

I am getting an exception "SQL Server doesn't exist or
access denied".

I wrote a Windows Forms apps in .NET and successfully
connected to DTP server with exaclty the same connection
string as used in ASP.NET. So, I figured my problem had
something to do with accounts under which both apps run.

I tried the following:

1. added to connection string "Network Library =dbmssocn"
per MS article Q315159

2. tried using impersonation:

<identity
impersonate="true"
userName="user"
password="pass"
/>

where user is the user name for an administrator on my
machine

Still, no luck.

Any suggestions are greatly appreciated.

Thanks,
VR

[Jacob Yang [MSFT]]

Hi Victor,

There are a lot of possible reasons for the error:

"SQL Server does not exist or access denied"

Based on my reserch and experience, the following Knowledge Base article is
useful to you. Please refer to it carefully.

INF: Potential Causes of the "SQL Server Does Not Exist or Access Denied"
Error Message
[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;328306[/url]

I hope it helps.

Best regards,

Jacob Yang
Microsoft Online Partner Support
<MCSD>
Get Secure! ¨C [url]www.microsoft.com/security[/url]
This posting is provided "as is" with no warranties and confers no rights.

[VR]

Thanks Jacob.

I will sure read the article.

Also, while on the subject, what is the customary way for
allowing ASP.NET applications to access a remote SQL
server? Is adding ASPNET account on the SQL server
appropriate or should I impersonate an existing user with
my ASP.NET app?

Thanks again.
VR

>-----Original Message-----
>Hi Victor,
>
>There are a lot of possible reasons for the error:
>
>"SQL Server does not exist or access denied"
>
>Based on my reserch and experience, the following

Knowledge Base article is

>useful to you. Please refer to it carefully.
>
>INF: Potential Causes of the "SQL Server Does Not Exist

or Access Denied"

>Error Message
>[url]http://support.microsoft.com/default.aspx?scid=kb;en-[/url]

us;328306

>
>I hope it helps.
>
>Best regards,
>
>Jacob Yang
>Microsoft Online Partner Support
><MCSD>
>Get Secure! ¨C [url]www.microsoft.com/security[/url]
>This posting is provided "as is" with no warranties and

confers no rights.

>
>.
>

[Jacob Yang [MSFT]]

Hi Victor,

Your new question is a big topic. Based on my research and experience, the
following URLs are useful for your new question. Please refer to it
carefully.

Building Secure ASP.NET Applications: Authentication, Authorization, and
Secure Communication - Data Access Security
[url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/ht[/url]
ml/SecNetch12.asp
"...This chapter presents recommendations and guidance that will help you
develop a secure data access strategy..."

HOW TO: Configure SQL Server Security for .NET Applications
[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;815154[/url]

I hope it helps.

Best regards,

Jacob Yang
Microsoft Online Partner Support
<MCSD>
Get Secure! ¨C [url]www.microsoft.com/security[/url]
This posting is provided "as is" with no warranties and confers no rights.