Click here to Skip to main content
15,560,351 members
Home / Discussions / Database
   

Database

 
AnswerRe: MS SQL Server Multiple Roles per User Pin
Ashfield8-Jul-08 23:03
Ashfield8-Jul-08 23:03 
QuestionCommunicating via Windows Service object Pin
Richard Blythe8-Jul-08 6:07
Richard Blythe8-Jul-08 6:07 
AnswerRe: Communicating via Windows Service object Pin
Pete O'Hanlon8-Jul-08 9:56
mvaPete O'Hanlon8-Jul-08 9:56 
AnswerRe: Communicating via Windows Service object Pin
Mycroft Holmes9-Jul-08 18:47
professionalMycroft Holmes9-Jul-08 18:47 
QuestionDB2 Query Validation in C# Pin
Member 19917268-Jul-08 3:03
Member 19917268-Jul-08 3:03 
AnswerRe: DB2 Query Validation in C# Pin
Ashfield8-Jul-08 5:46
Ashfield8-Jul-08 5:46 
AnswerRe: DB2 Query Validation in C# Pin
Kschuler8-Jul-08 12:33
Kschuler8-Jul-08 12:33 
QuestionSQL Server 2005 Express, Windows Authentication mode, domain/non-domain users Pin
Gary Wheeler8-Jul-08 2:39
Gary Wheeler8-Jul-08 2:39 
I'm using SQL Server 2005 Express, running on a machine on our domain. The ODBC connection string for my application normally looks like this:
Driver={SQL Server}; Server=HostSys\SQLEXPRESS; Trusted_Connection=yes; Database=VersamarkCPT;
<small>(spaces inserted for readability)</small>
I would like non-domain users to be able to access this data base as well. The only way I've been able to do that is to set SQL Server to "Mixed Authentication" mode, and use a connection string like this:
Driver={SQL Server}; Server=123.123.123.123\SQLEXPRESS; Database=VersamarkCPT; Uid=username; Pwd=passwrd;
I would rather use Windows Authentication if possible. I would also like to use a machine name instead of its IP address.

Is there some other connection string syntax I should be using? I've read through the SQL Server Books Online, MSDN, and articles here at CP, and haven't had a lot of luck deciphering what's going on. I'm a complete noob at DB programming, so please be kind.

Software Zen: delete this;

AnswerRe: SQL Server 2005 Express, Windows Authentication mode, domain/non-domain users Pin
Ashfield8-Jul-08 3:11
Ashfield8-Jul-08 3:11 
GeneralRe: SQL Server 2005 Express, Windows Authentication mode, domain/non-domain users Pin
Gary Wheeler8-Jul-08 3:46
Gary Wheeler8-Jul-08 3:46 
GeneralRe: SQL Server 2005 Express, Windows Authentication mode, domain/non-domain users Pin
Ashfield8-Jul-08 5:58
Ashfield8-Jul-08 5:58 
GeneralRe: SQL Server 2005 Express, Windows Authentication mode, domain/non-domain users Pin
Gary Wheeler8-Jul-08 6:20
Gary Wheeler8-Jul-08 6:20 
QuestionWhile using ADDNEW in MySQL it is creating huge Temp files Pin
pallaka8-Jul-08 2:37
pallaka8-Jul-08 2:37 
AnswerRe: While using ADDNEW in MySQL it is creating huge Temp files Pin
pallaka8-Jul-08 23:20
pallaka8-Jul-08 23:20 
QuestionReporting Services Pin
Rashmi Deshpande8-Jul-08 2:26
Rashmi Deshpande8-Jul-08 2:26 
QuestionHow to comare two database,and find out difference? Pin
dingoishere7-Jul-08 18:08
dingoishere7-Jul-08 18:08 
AnswerRe: How to comare two database,and find out difference? Pin
TheFM2347-Jul-08 18:41
TheFM2347-Jul-08 18:41 
GeneralRe: How to comare two database,and find out difference? Pin
dingoishere8-Jul-08 16:16
dingoishere8-Jul-08 16:16 
QuestionHow to find the location of an update Pin
Brady Kelly7-Jul-08 5:21
Brady Kelly7-Jul-08 5:21 
AnswerRe: How to find the location of an update Pin
scottgp7-Jul-08 5:26
professionalscottgp7-Jul-08 5:26 
GeneralRe: How to find the location of an update Pin
Brady Kelly7-Jul-08 5:42
Brady Kelly7-Jul-08 5:42 
GeneralRe: How to find the location of an update Pin
scottgp7-Jul-08 5:49
professionalscottgp7-Jul-08 5:49 
GeneralRe: How to find the location of an update Pin
Brady Kelly7-Jul-08 6:39
Brady Kelly7-Jul-08 6:39 
GeneralRe: How to find the location of an update Pin
SimulationofSai7-Jul-08 7:28
SimulationofSai7-Jul-08 7:28 
GeneralRe: How to find the location of an update Pin
Brady Kelly7-Jul-08 8:29
Brady Kelly7-Jul-08 8:29 

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.