Ok, I tried the Mixed Mode, adn it failed. The error is:
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=MAROIS1;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.
driver={sql server};server=MAROIS1;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.
driver={sql server};server=MAROIS1;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.
SQL Server configuration failed.
I'v got no idea what's going on. Your help is greatly appreciated.
Kevin
>Kevin,
>
>See in-line
>
>>I'm on WinXp Home. Is there even an Administrator acount?. I set up
>>the users on this PC, with me as admin.
>
>I've no idea.
>
>>I used Windows authentication when I installed SQL Server. This should
>>allow SQL to login using the Windows logon info, correct?
>
>Yes it should.
>
>
>>In the SQL Server Service Manager, there are 2 servers; one named
>>after the PC name (MAROIS1) and another with the instance name I gave
>>it MAROIS\SQLSERVER1.
>>
>>MAROIS1 is running, but when I try to start the other, I get the mesage
>>'The service did not start due to a logon error'
>
>Did you install two instanes?
>
>>
>>Should I have used Sql Server authentication? If so, what do I need to
>>do set it that way?
>
>It's good idea to have dev. SQL Server set up for Mixed mode authentication so you can troubleshoot login problems.
>
>I would uninstall SQL Server and start over. This time install default instance only and apply SP3. After you get comfortable with SQL Server, you can play with instances.
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people