Re: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005

Hi

Check that the login you are using from your ASP page has a login to SQL
Server, has rights in the Db you want to access, and has permissions to the
objects in the DB.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@xxxxxxxxxxxx

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

"sudip" <sudip@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2BBB35A2-5D9D-4A2B-8BE9-AEB0DBB29FD2@xxxxxxxxxxxxxxxx
> My logincheck.asp Page were working well in SQL 7 but ,
> When I try to run my logincheck.asp page after installing SQL 2000
> I get the follwing error .
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Access denied.
> /pts/logincheck.asp, line 32
>
> If anyone could let me know what i need to do or point me in the right
> direction i would appreciate it.
>
>


.

Relevant Pages

  • Re: SQL User SID format?
    ... When you move databases to another server, you can remap users to logins ... capability to remap a user to a login with new ALTER USER syntax - I ... The new ALTER USER syntax works for remapping both SQL and Windows ... this means you already have access to a SID from the syslogins catalog; ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server on XP Home Network
    ... The sa account is the system administrator "God" account witihin SQL ... This account is a SQL-Server login. ... You might be able to use Enterprise Manager to go in and create a new SQL ... Select the "SQL Server Authentication" ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2000 Replication Agents Credentials
    ... the snapshot agent IS using sql login to connect to the ... The pull distribution agent IS using sql ... Do you know where SQL Server 2000 saves the sql ...
    (microsoft.public.sqlserver.replication)
  • Re: Can you update/process AS2005 cube with AMO and SQL authentica
    ... We have cases where the AS server and the Data Source server reside on 2 ... The data source is properly secured using SQL Server ... login and no serious client will accept the login with no password. ...
    (microsoft.public.sqlserver.olap)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
Loading