Re: C# connection string using Windows NT Authentication

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I'd like to add a bit to the previous poster's response.

Unless I misunderstand your issue, you indicate that you are using Windows
authentication to connect to SQL Server 2000 and the connection is working
fine on your computer but not on a remote server. What you do not indicate
is:
1.) If you are connecting to a local instance of SQL Server on your
computer.
2.) If the SQL Server instance that you are connecting to on your computer
is the same as the one you'll be connecting to from the remote server.
3.) How the site is configured on your computer.

>From what you have described, it sounds much less like a connection string
coding problem than a configuration issue. The account that the ASP.NET
worker process runs under must have access to the database for integrated
security to work unless impersonation is used in which case the
impersonation account must have access to the database. In the event that
you are unable to have access granted for a particular Windows account,
you'll need to resort to SQL Authentication.

HTH
----------------
Dave Fancher
http://davefancher.blogspot.com

"Maziar Aflatoun" <maz00@xxxxxxxxxx> wrote in message
news:Gq2dnSSITtm9Ze_fRVn-sw@xxxxxxxxxxxxx
> Hi guys,
>
> I'm using Windows authentication to connect to SQL Server 2000. On my
> computer the connection is fine. Now if I move it to a remote server, how
> to I hard code my Username/Password in my connection string (using Windows
> NT authentication and not SQL Server authentication)?
>
> Thank you
> Maz.
>
>


.

Relevant Pages

  • Getting to the bottom of MSDE network connection problems ...
    ... but other than that it is MSDE 2000 with sp3a already applied. ... I've finally figured out the connection problems associated with this, ... and it seems the problems are due to Windows XP and not MSDE. ... the enterprise/standard versions of SQL server won't install ...
    (microsoft.public.sqlserver.msde)
  • Re: Windows Authentication in asp.net 2005 to SQL Server?
    ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: Changing passwords / Blocking SA login attempts
    ... I went into the Server Config properties and changed to Windows ... My login for Start and Run SQL server was in this format. ... I am supposing this was an SQL authentication, ...
    (microsoft.public.sqlserver.security)
  • Re: Bizzare SQL Network Error
    ... The bizzare thing is that, the same connection string, the same code to ... In a windows APP it works fine, in a Web APP I get ... >>I am trying to connect to a default instance of SQL Server 2000 Enterprise ...
    (microsoft.public.dotnet.framework.adonet)