Click here to Skip to main content
15,915,513 members
Home / Discussions / Database
   

Database

 
GeneralRe: DELETE FROM ... not affecting the table? Pin
David Wulff10-Feb-02 8:00
David Wulff10-Feb-02 8:00 
GeneralRe: DELETE FROM ... not affecting the table? Pin
Andrew Peace10-Feb-02 8:45
Andrew Peace10-Feb-02 8:45 
GeneralRe: DELETE FROM ... not affecting the table? Pin
David Wulff10-Feb-02 8:56
David Wulff10-Feb-02 8:56 
GeneralRe: DELETE FROM ... not affecting the table? Pin
Andrew Peace10-Feb-02 9:11
Andrew Peace10-Feb-02 9:11 
GeneralRe: DELETE FROM ... not affecting the table? Pin
David Wulff10-Feb-02 10:49
David Wulff10-Feb-02 10:49 
AnswerRe: DELETE FROM ... not affecting the table? Pin
Matt Gullett10-Feb-02 9:04
Matt Gullett10-Feb-02 9:04 
GeneralRe: DELETE FROM ... not affecting the table? Pin
David Wulff10-Feb-02 10:00
David Wulff10-Feb-02 10:00 
GeneralSQL Authentication Pin
Mike Osbahr28-Jan-02 4:32
Mike Osbahr28-Jan-02 4:32 
In 'SQL Server' security the group login 'DOMAIN/Domain Users' is permitted to use my target database. On Friday (1/18) I was logged into my SQL NT server as 'DOMAIN/Administrator' and the app under development was testing well. When I returned to work on Monday (1/21) the same app withouting any code changes would not execute any SQL queries.

After testing, I discovered that logged in as '(local)/Administrator' the app would work. Logged in as '(local)/Mike' the app would work or logged in as 'DOMAIN/Mike' the app would work. However, logged in with a domain account name other than 'Administrator' that does not exist on the SQL NT server the app fails. So, I know that 'SQL Server' is doing NT Authentication of a sort. It just appears that between Friday and Monday it stopped using the domain controller for authentication.

I have tested to be sure that the DC still considers the SQL NT server to be a part of the domain. I have shutdown and restarted the SQL NT server twice.
I can run the SQL Server Enterprise Manager from other workstations logged into the domain with domain-only user names.

Any suggestions of what to try or what may have changed between Friday and Monday are appreciated.

>>>-----> MikeO
Generalset Request Value option on the field ! Pin
Hadi Rezaee27-Jan-02 10:15
Hadi Rezaee27-Jan-02 10:15 
GeneralOLE-DB connection Pin
User 988527-Jan-02 7:01
User 988527-Jan-02 7:01 
QuestionCan you show me about SQL Server 7.0 Pin
25-Jan-02 7:39
suss25-Jan-02 7:39 
AnswerRe: Can you show me about SQL Server 7.0 Pin
Carlos Antollini25-Jan-02 7:51
Carlos Antollini25-Jan-02 7:51 
GeneralSpecifying a connection should use TCP/IP Pin
James T. Johnson24-Jan-02 12:23
James T. Johnson24-Jan-02 12:23 
GeneralRe: Specifying a connection should use TCP/IP Pin
AndyG26-Jan-02 8:22
AndyG26-Jan-02 8:22 
GeneralRe: Specifying a connection should use TCP/IP Pin
James T. Johnson26-Jan-02 19:44
James T. Johnson26-Jan-02 19:44 
GeneralCHAR, adVarWChar, CString Pin
David Pokluda22-Jan-02 21:12
David Pokluda22-Jan-02 21:12 
GeneralADO Data Control Pin
22-Jan-02 20:37
suss22-Jan-02 20:37 
Questionwhich data type responding to DBTYPE_DBTIMESTAMP? Pin
Aaron K.B. Huang18-Jan-02 2:17
Aaron K.B. Huang18-Jan-02 2:17 
AnswerRe: which data type responding to DBTYPE_DBTIMESTAMP? Pin
Konstantin Vasserman18-Jan-02 2:30
Konstantin Vasserman18-Jan-02 2:30 
GeneralRe: which data type responding to DBTYPE_DBTIMESTAMP? Pin
Aaron K.B. Huang18-Jan-02 21:56
Aaron K.B. Huang18-Jan-02 21:56 
GeneralMemory leak when connecting to an Excel data source usin ODBC Pin
Martin Fridegren15-Jan-02 3:33
Martin Fridegren15-Jan-02 3:33 
GeneralAbout Provider's memeory manager Pin
Jeason Zhao14-Jan-02 23:13
Jeason Zhao14-Jan-02 23:13 
Generalexecution speed... Pin
l a u r e n14-Jan-02 6:20
l a u r e n14-Jan-02 6:20 
GeneralRe: execution speed... Pin
Konstantin Vasserman14-Jan-02 7:18
Konstantin Vasserman14-Jan-02 7:18 
GeneralRe: execution speed... Pin
Daniel Turini14-Jan-02 8:35
Daniel Turini14-Jan-02 8:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.