Click here to Skip to main content
15,887,135 members
Home / Discussions / C#
   

C#

 
GeneralRe: C# and local SQL server connection Pin
Pete O'Hanlon22-Mar-11 0:04
mvePete O'Hanlon22-Mar-11 0:04 
GeneralRe: C# and local SQL server connection Pin
JoplinsSlave22-Mar-11 0:32
JoplinsSlave22-Mar-11 0:32 
GeneralRe: C# and local SQL server connection Pin
Pete O'Hanlon22-Mar-11 0:42
mvePete O'Hanlon22-Mar-11 0:42 
AnswerRe: C# and local SQL server connection Pin
Geoff Williams21-Mar-11 23:42
Geoff Williams21-Mar-11 23:42 
GeneralRe: C# and local SQL server connection Pin
JoplinsSlave21-Mar-11 23:57
JoplinsSlave21-Mar-11 23:57 
AnswerRe: C# and local SQL server connection Pin
Ravi Sant21-Mar-11 23:51
Ravi Sant21-Mar-11 23:51 
GeneralRe: C# and local SQL server connection Pin
JoplinsSlave22-Mar-11 0:04
JoplinsSlave22-Mar-11 0:04 
AnswerRe: C# and local SQL server connection Pin
Rob Philpott22-Mar-11 0:33
Rob Philpott22-Mar-11 0:33 
No specific answers I'm afraid, but a few things which spring to mind.

Firstly http://www.connectionstrings.com is the thing I always use because I can't remember connection strings. I've checked that and what you have looks OK. I don't believe there's any case-sensitivity in them, but as one poster pointed out, get rid of the 'yes' and replace with 'true'.

In terms of username and password, SQL Server can run in two modes - SQL Server Authentication which has a username and password or Windows Authentication which uses your domain identity. The latter is preferred as you don't have to expose authentication details in config etc.

The only thing I can suggest is check that you have the relevant protocols switched on, particularly named pipes as this is what I believe local connections use by preference. Go to the SQL Server Configuration tool->SQL Server Network Configuration->Protocols and set them all on. I've been stung by that before...
Regards,
Rob Philpott.

GeneralRe: C# and local SQL server connection Pin
Rob Philpott22-Mar-11 0:35
Rob Philpott22-Mar-11 0:35 
GeneralRe: C# and local SQL server connection Pin
Ravi Sant22-Mar-11 0:52
Ravi Sant22-Mar-11 0:52 
Questiondatagridview problems! Pin
King Boy21-Mar-11 19:54
King Boy21-Mar-11 19:54 
Questioncalling a web service at runtime Pin
Marcus Spitzmiller21-Mar-11 13:45
Marcus Spitzmiller21-Mar-11 13:45 
AnswerRe: calling a web service at runtime Pin
Pete O'Hanlon21-Mar-11 22:57
mvePete O'Hanlon21-Mar-11 22:57 
Questionproblem to connect to Oracle from my C# WinForm program Pin
Gali197821-Mar-11 10:12
Gali197821-Mar-11 10:12 
AnswerRe: problem to connect to Oracle from my C# WinForm program Pin
Wendelius21-Mar-11 10:26
mentorWendelius21-Mar-11 10:26 
AnswerRe: problem to connect to Oracle from my C# WinForm program Pin
Ian Shlasko21-Mar-11 10:30
Ian Shlasko21-Mar-11 10:30 
QuestionWindows service stable APPCRASH in clr.dll after 3.5 to 4.0 .NET platform change Pin
Chesnokov Yuriy21-Mar-11 1:26
professionalChesnokov Yuriy21-Mar-11 1:26 
AnswerRe: Windows service stable APPCRASH in clr.dll after 3.5 to 4.0 .NET platform change Pin
Pete O'Hanlon21-Mar-11 3:10
mvePete O'Hanlon21-Mar-11 3:10 
QuestionRe: Windows service stable APPCRASH in clr.dll after 3.5 to 4.0 .NET platform change Pin
Chesnokov Yuriy21-Mar-11 7:18
professionalChesnokov Yuriy21-Mar-11 7:18 
AnswerRe: Windows service stable APPCRASH in clr.dll after 3.5 to 4.0 .NET platform change Pin
Pete O'Hanlon21-Mar-11 8:23
mvePete O'Hanlon21-Mar-11 8:23 
QuestionRe: Windows service stable APPCRASH in clr.dll after 3.5 to 4.0 .NET platform change Pin
Chesnokov Yuriy21-Mar-11 10:06
professionalChesnokov Yuriy21-Mar-11 10:06 
AnswerRe: Windows service stable APPCRASH in clr.dll after 3.5 to 4.0 .NET platform change Pin
Pete O'Hanlon21-Mar-11 10:42
mvePete O'Hanlon21-Mar-11 10:42 
AnswerRe: Windows service stable APPCRASH in clr.dll after 3.5 to 4.0 .NET platform change Pin
Chesnokov Yuriy22-Mar-11 0:36
professionalChesnokov Yuriy22-Mar-11 0:36 
GeneralRe: Windows service stable APPCRASH in clr.dll after 3.5 to 4.0 .NET platform change Pin
Pete O'Hanlon22-Mar-11 0:38
mvePete O'Hanlon22-Mar-11 0:38 
GeneralRe: Windows service stable APPCRASH in clr.dll after 3.5 to 4.0 .NET platform change Pin
Chesnokov Yuriy22-Mar-11 21:52
professionalChesnokov Yuriy22-Mar-11 21:52 

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.