Click here to Skip to main content
15,904,828 members
Home / Discussions / C#
   

C#

 
GeneralRe: switch on computer Pin
Garth J Lancaster26-Jan-09 11:25
professionalGarth J Lancaster26-Jan-09 11:25 
AnswerRe: switch on computer Pin
Garth J Lancaster26-Jan-09 11:22
professionalGarth J Lancaster26-Jan-09 11:22 
GeneralRe: switch on computer Pin
Mark Churchill26-Jan-09 12:57
Mark Churchill26-Jan-09 12:57 
AnswerRe: switch on computer Pin
Drew Stainton26-Jan-09 15:42
Drew Stainton26-Jan-09 15:42 
GeneralRe: switch on computer Pin
PIEBALDconsult26-Jan-09 18:06
mvePIEBALDconsult26-Jan-09 18:06 
GeneralRe: switch on computer Pin
Drew Stainton26-Jan-09 18:14
Drew Stainton26-Jan-09 18:14 
QuestionC# and SQL Part 2: Attack of the "Login Failed For (thiscomputer)/Guest"! Pin
Michael Fritzius26-Jan-09 10:57
professionalMichael Fritzius26-Jan-09 10:57 
AnswerRe: C# and SQL Part 2: Attack of the "Login Failed For (thiscomputer)/Guest"! [modified] Pin
Wendelius26-Jan-09 11:16
mentorWendelius26-Jan-09 11:16 
Michael Fritzius wrote:
I posted earlier today about this but didn't get a response. Didn't know if CP sends notifications to everybody in the thread if anything at all is added to the thread, hence why I'm posting here.


If you post a reply to yourself, the others who have replied won't get a notice, but if you reply to someone elses post, he/she will get an email.

To your question.

If you want to use SQL Server authentication, you must create a login for yourself (or use an existing one). When you installed the SQL Server instance you were prompted if you want to use Mixed mode authentication. If you selected it, the installation prompted for the password for user SA. You can use that login to connect to the SQL Server. SA is like Administrator in Windows. It has all the privileges in SQL Server. After logging into the SQL Server, you can create additional logins and grant rights to them.

The easiest way to create a login is to use Management Studio. Select from the Object explorer Security/Logins, right click and select New Login. This opens a dialog where you can specify what kind of login you want to create and then grant privileges to the login.

Addition:

Michael Fritzius wrote:
the next part after this will be to log into the server via the internet, using an IP address


Basically this is exactly the same as you would connect to your local server. You can define server as ip-address and port, like: 127.0.0.1,1433. You just need to check the port SQL Server is listening using for example Configuration Manager and make sure that you have secure connection over the internet so that the port can be opened for you.

The need to optimize rises from a bad design.My articles[^]

modified on Monday, January 26, 2009 5:53 PM

GeneralRe: C# and SQL Part 2: Attack of the "Login Failed For (thiscomputer)/Guest"! Pin
Michael Fritzius26-Jan-09 12:29
professionalMichael Fritzius26-Jan-09 12:29 
GeneralRe: C# and SQL Part 2: Attack of the "Login Failed For (thiscomputer)/Guest"! Pin
Wendelius26-Jan-09 18:24
mentorWendelius26-Jan-09 18:24 
GeneralRe: C# and SQL Part 2: Attack of the "Login Failed For (thiscomputer)/Guest"! Pin
Michael Fritzius1-Feb-09 12:41
professionalMichael Fritzius1-Feb-09 12:41 
GeneralRe: C# and SQL Part 2: Attack of the "Login Failed For (thiscomputer)/Guest"! Pin
Wendelius2-Feb-09 6:25
mentorWendelius2-Feb-09 6:25 
GeneralRe: C# and SQL Part 2: Attack of the "Login Failed For (thiscomputer)/Guest"! Pin
Michael Fritzius2-Feb-09 15:30
professionalMichael Fritzius2-Feb-09 15:30 
QuestionMessengerAPI Pin
shopi3026-Jan-09 10:12
shopi3026-Jan-09 10:12 
AnswerRe: MessengerAPI Pin
Xmen Real 26-Jan-09 13:58
professional Xmen Real 26-Jan-09 13:58 
Questionapplicationsecurityinfo class Pin
bolly-8126-Jan-09 9:53
bolly-8126-Jan-09 9:53 
AnswerRe: applicationsecurityinfo class Pin
vaghelabhavesh26-Jan-09 10:19
vaghelabhavesh26-Jan-09 10:19 
QuestionImpersonation With Md5 Pin
asafbs200426-Jan-09 9:25
asafbs200426-Jan-09 9:25 
AnswerRe: Impersonation With Md5 Pin
0x3c026-Jan-09 10:00
0x3c026-Jan-09 10:00 
AnswerRe: Impersonation With Md5 Pin
Dave Kreskowiak26-Jan-09 16:09
mveDave Kreskowiak26-Jan-09 16:09 
Questionthe result of DefragAnalysis method in c# Pin
SAKRA26-Jan-09 7:06
SAKRA26-Jan-09 7:06 
AnswerRe: the result of DefragAnalysis method in c# Pin
musefan26-Jan-09 7:25
musefan26-Jan-09 7:25 
AnswerRe: the result of DefragAnalysis method in c# Pin
ChunkyStool28-Jan-09 19:00
ChunkyStool28-Jan-09 19:00 
QuestionC# Threading help!! cant seem to get going.... Pin
alexleslie26-Jan-09 6:07
alexleslie26-Jan-09 6:07 
AnswerRe: C# Threading help!! cant seem to get going.... Pin
EliottA26-Jan-09 6:23
EliottA26-Jan-09 6:23 

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.