Re: Can't connect to SQL (ASPNET account)

From: mm2 (jraahauge@yahoo.com)
Date: 07/09/02 

From: "mm2" <jraahauge@yahoo.com>
Date: Mon, 8 Jul 2002 15:23:28 -0700

See response below:
>-----Original Message-----
>Are you intending to use integrated security or a SQLS
login? you have
>connection strings which are unclear.

I used mixed authentication and have tried both integrated
security and SQL login without success

>Try something like the following
>for your connection string if you're using the SqlClient
provider:
>
>"Data Source=(local);Initial Catalog=DBName;Integrated
Security=SSPI;"

Didn't work.

It is almost like the ASPNET doesn't see my SQL Server at
all. I can put anything instead of local and get the
excact error message I am getting.

Relevant Pages

  • Re: Cant connect to SQL (ASPNET account)
    ... >>Are you intending to use integrated security or a SQLS ... >>connection strings which are unclear. ... >security and SQL login without success ... >It is almost like the ASPNET doesn't see my SQL Server at ...
    (microsoft.public.sqlserver.security)
  • Re: Using Integrated Security for Accessing SQL on Remote Server
    ... "Login Failed for NT Authority/System"? ... > I am currently trying to use integrated security to access the SQL ... IIS does not allow anonymous access on the site and is using Windows ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Permission question - another one
    ... If I add an Sql Login it does add the TRAVAC\ in front of the names, ... seems to be users that were setup to use SQL Server Authentication. ... RAPTOR is the Server that has SQL Server running on it. ... > " I could think I am taking permissions away from someone, ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL 2k5 SP2 Mirroring - SQL in Mixed mode.
    ... US\sqlservices (old SQLservice account) still member of built-in local admin ... Login: US\sqlservices ... How can I transfer the SQL logins to ... Here is SP_help_revlogin results from the Principal Server (NYSQL-3) ...
    (microsoft.public.sqlserver.clustering)
  • Re: Renamed Windows login not found in SQL Server 2000
    ... It's almost like SQL tuck some knowledge away in an area ... of memory that only gets released on Windows stop. ... > I am running SQL Server 2000 SP2 with Windows ... > login gets corrupted) I am unable to add the new login to ...
    (microsoft.public.sqlserver.security)