Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Newbie Question
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Installation
Titre:
Divers
Thread ID:
00947367
Message ID:
00947798
Vues:
23
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform