Click here to Skip to main content
15,844,364 members
Home / Discussions / Database
   

Database

 
GeneralRe: Connection Pooling Pin
anju21-Jun-05 10:11
anju21-Jun-05 10:11 
GeneralRe: Connection Pooling Pin
Colin Angus Mackay21-Jun-05 10:18
Colin Angus Mackay21-Jun-05 10:18 
GeneralRe: Connection Pooling Pin
anju21-Jun-05 10:23
anju21-Jun-05 10:23 
GeneralRe: Connection Pooling Pin
Colin Angus Mackay21-Jun-05 11:04
Colin Angus Mackay21-Jun-05 11:04 
GeneralRe: Connection Pooling Pin
anju21-Jun-05 11:14
anju21-Jun-05 11:14 
GeneralRe: Connection Pooling Pin
Luis Alonso Ramos21-Jun-05 17:58
Luis Alonso Ramos21-Jun-05 17:58 
GeneralRe: Connection Pooling Pin
Colin Angus Mackay21-Jun-05 21:25
Colin Angus Mackay21-Jun-05 21:25 
GeneralRe: Connection Pooling Pin
Mike Dimmick22-Jun-05 3:43
Mike Dimmick22-Jun-05 3:43 
I'd agree with that in general, but there are times that it's not practical, for example if you have a service that's running as SYSTEM with the database on another machine. Yes, I know that it's bad practice to have a service running as SYSTEM unless absolutely necessary - unfortunately this is a legacy service with UI and therefore has to run as an interactive service, hence it has to run as SYSTEM.

It's useful to note that you don't need a domain to set this up, but if you don't have one, you'll need to create user accounts for the appropriate users on the server hosting SQL Server, and add them to SQL Server's logins. You then need to synchronize the passwords for those user accounts between the machine that the client runs on and the server hosting SQL.

One thing you can do with Windows Authentication that you can't with SQL Server Authentication is to set up groups of users with particular permissions.

Stability. What an interesting concept. -- Chris Maunder
GeneralRe: Connection Pooling Pin
Colin Angus Mackay22-Jun-05 3:58
Colin Angus Mackay22-Jun-05 3:58 
GeneralRe: Connection Pooling Pin
Luis Alonso Ramos22-Jun-05 15:21
Luis Alonso Ramos22-Jun-05 15:21 
GeneralUsing Zip component to Zip files Pin
Wilbur J. Pereira21-Jun-05 3:56
Wilbur J. Pereira21-Jun-05 3:56 
GeneralRe: Using Zip component to Zip files Pin
Eduard Keilholz21-Jun-05 23:46
Eduard Keilholz21-Jun-05 23:46 
GeneralExecuting DTS packages Pin
AetherS21-Jun-05 3:16
AetherS21-Jun-05 3:16 
GeneralIn Depth Knowledge - Edit Almost Anything in a datagrid -Declan Brennan Pin
21-Jun-05 2:15
suss21-Jun-05 2:15 
GeneralDisplay data in tree view. Pin
Anonymous21-Jun-05 0:46
Anonymous21-Jun-05 0:46 
GeneralSave DataTable to dbf Pin
kost8120-Jun-05 23:31
kost8120-Jun-05 23:31 
GeneralRe: Save DataTable to dbf Pin
Marek Konieczny20-Jun-05 23:51
Marek Konieczny20-Jun-05 23:51 
GeneralRe: Save DataTable to dbf Pin
kost8122-Jun-05 4:33
kost8122-Jun-05 4:33 
QuestionCreating Tables at runtime? Pin
kbalias20-Jun-05 22:29
kbalias20-Jun-05 22:29 
AnswerRe: Creating Tables at runtime? Pin
Colin Angus Mackay21-Jun-05 0:01
Colin Angus Mackay21-Jun-05 0:01 
GeneralSearch Record Pin
ADY00720-Jun-05 9:45
ADY00720-Jun-05 9:45 
GeneralRe: Search Record Pin
Yulianto.20-Jun-05 16:43
Yulianto.20-Jun-05 16:43 
GeneralRe: Search Record Pin
Luis Alonso Ramos20-Jun-05 19:06
Luis Alonso Ramos20-Jun-05 19:06 
Generalread and display single record Pin
gharryh20-Jun-05 8:37
gharryh20-Jun-05 8:37 
GeneralRe: read and display single record Pin
Colin Angus Mackay20-Jun-05 11:44
Colin Angus Mackay20-Jun-05 11:44 

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.