Bonjour,

je récupére un projet en cours ou les BDD sont déjà créées. Je développe en .net 2.0avec du vb, mais ca n'a pas trop d'importance.

J'utilise SQLServer 2005. Voila déjà j'ai du mal à comprendre la notion d'authentification sql serveur et celle de l'authentification windows.

Comment créer des comtpes SQLserver? Est ce tout simplement le paramétrage des comptes windows pour qu'il ai les droits pour sql?


je vous transfère mon fichier de LOG car franchement je bloque deçu:
2008-12-08 22:46:09.47 Serveur Dedicated administrator connection support was not started because it is not available on this edition of SQL Server. This is an informational message only. No user action is required.
2008-12-08 22:46:09.47 Serveur SQL Server is now ready for client connections. This is an informational message; no user action is required.
2008-12-08 22:46:09.73 spid8s Clearing tempdb database.
2008-12-08 22:46:11.02 spid8s Starting up database 'tempdb'.
2008-12-08 22:46:11.15 spid4s Recovery is complete. This is an informational message only. No user action is required.
2008-12-08 22:46:11.16 spid11s The Service Broker protocol transport is disabled or not configured.
2008-12-08 22:46:11.16 spid11s The Database Mirroring protocol transport is disabled or not configured.
2008-12-08 22:46:11.21 spid11s Service Broker manager has started.
2008-12-08 22:47:01.95 Login succeeded for user 'PC-de-Babass\Babass'. Connection: trusted. [CLIENT*: <local machine>]
2008-12-08 22:47:01.97 spid51 Starting up database 'Clicparticulier'.
2008-12-08 22:47:02.18 spid51 Recovery is writing a checkpoint in database 'Clicparticulier' (6). This is an informational message only. No user action is required.
2008-12-08 22:47:07.71 Erreur*: 18456, Gravité*: 14, État*: 6.
2008-12-08 22:47:07.71 Login failed for user 'PC-DE-BABASS\BABASS'. [CLIENT*: <local machine>]
2008-12-08 23:02:52.11 Serveur Server resumed execution after being idle 30 seconds: user activity awakened the server. This is an informational message only. No user action is required.
2008-12-08 23:02:52.17 Login succeeded for user 'PC-de-Babass\Babass'. Connection: trusted. [CLIENT*: <local machine>]
2008-12-08 23:02:52.17 spid51 Starting up database 'Clicparticulier'.
2008-12-08 23:02:55.40 spid51 Starting up database 'Clicparticulier'.
2008-12-08 23:03:05.50 spid51 Starting up database 'Clicparticulier'.
2008-12-08 23:03:16.25 Login succeeded for user 'PC-de-Babass\Babass'. Connection: trusted. [CLIENT*: <local machine>]
2008-12-08 23:03:16.25 spid52 Starting up database 'Clicparticulier'.
2008-12-08 23:04:09.81 Login succeeded for user 'PC-de-Babass\Babass'. Connection: trusted. [CLIENT*: <local machine>]
2008-12-08 23:04:09.81 spid52 Starting up database 'Clicparticulier'.
2008-12-08 23:04:41.75 Login succeeded for user 'PC-de-Babass\Babass'. Connection: trusted. [CLIENT*: <local machine>]
2008-12-08 23:04:41.75 spid52 Starting up database 'Clicparticulier'.
2008-12-08 23:05:28.25 Login succeeded for user 'PC-de-Babass\Babass'. Connection: trusted. [CLIENT*: <local machine>]
2008-12-08 23:05:31.62 Erreur*: 18456, Gravité*: 14, État*: 6.
2008-12-08 23:05:31.62 Login failed for user 'PC-DE-BABASS\BABASS'. [CLIENT*: <local machine>]
Je pense que ca vient du fait que je ne suis pas le créateur des bdd et je ne suis pas expert en administration. Si vous pouviez me filer un coup de main, ca m'arrangerait bien.

voila merci d'avance.