Re: SQL security

From: Gary X (SQLGuy_at_EarthLink.Net)
Date: 07/02/03

  • Next message: Gary X: "Re: Changed Domain for SQL Server Logins using NT Authentication" 
    Date: Wed, 2 Jul 2003 02:45:21 -0700

    Make sure set the default DB, either in SQL for the group or in DSN for the
    connection, or specify it at your connection string. If you leave all of
    those to default, you are trying to connection master database.

    Gary

    "Amy Wang" <amywang@bankofny.com> wrote in message
    news:38ff01c34012$da36cf80$a401280a@phx.gbl...
    > SQL 2000, windows 2000
    >
    > I am using window NT authentication. In SQL Server, I give
    > permission to NT group GROUP1. My NT login USER1 is the
    > member of GROUP1.
    >
    > Get error when set up ODBC : Connection failed, sQL state
    > 42000, SQl server error 4064. Can not open user default
    > database. login failed.
    >
    >
    >
    > If I give permission to USER1 directly, It works.
    > all SQL server login works.
    >
    > By the way, it worked before and not work after I restore
    > last night backup data. No change with user or any NT
    > permissions
    >
    > Thanks

  • Next message: Gary X: "Re: Changed Domain for SQL Server Logins using NT Authentication"

    Relevant Pages

    • Re: Concurrent database access in SQL 2005 Mobile
      ... Please stick to having an "dummy" connection in Open State. ... SQL CE/Mobile has a background thread that flushes the changes ... they run for long hours and we have not seen memory leaks so far. ... then opens his work forms and it's in ...
      (microsoft.public.sqlserver.ce)
    • Re: Concurrent database access in SQL 2005 Mobile
      ... Please stick to having an "dummy" connection in Open State. ... So it is a kind of asynchronous commit which happens every 10 ... I am not sure of this claim as we have many applications built on SQL CE ... then opens his work forms and it's in ...
      (microsoft.public.sqlserver.ce)
    • Access 2003 adp/proxy security - A substitute for SYSTEM_USER()
      ... We need a way for SQL to know the nt username that initiated the proxy ... Many stored procedures and views use a UDF that also depends on ... SyUserLogin and use HostIDand HostName() to find the right row. ... We've played with the Connection dialog settings, ...
      (microsoft.public.access.security)
    • RE: Logging in in background
      ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
      (microsoft.public.access.modulesdaovba)
    • Access 2003 adp/proxy security - A substitute for SYSTEM_USER()
      ... We need a way for SQL to know the nt username that initiated the proxy ... Many stored procedures and views use a UDF that also depends on ... SyUserLogin and use HostIDand HostName() to find the right row. ... We've played with the Connection dialog settings, ...
      (microsoft.public.sqlserver.connect)
    • Quantcast