---
# System prepended metadata

title: Réinstaller SQL Server manuellement

---

# Réinstaller SQL Server manuellement

## ilucca login

https://github.com/LuccaSA/IT/blob/cc3e4cb4cf2bc0d20c8a5f77d59eb34a8c2a4a63/Documentation/Conf_Dev.md

Jouer les 3 commandes ci-dessous en powershell :
```
Invoke-Sqlcmd -Query " CREATE LOGIN [ilucca] WITH PASSWORD = N'&1Azertdgdsjfhdsfisfuyfuygfyuzg';EXEC master..sp_addsrvrolemember @loginame = N'ilucca', @rolename = N'sysadmin'"
Invoke-Sqlcmd -Query "ALTER LOGIN [ilucca] WITH PASSWORD = N'ilucca', CHECK_EXPIRATION = OFF, CHECK_POLICY = OFF"
Invoke-Sqlcmd -Query "if exists( select * from fn_my_permissions(NULL, 'SERVER') where permission_name = 'CONTROL SERVER') print 'You are a sysadmin.'"
```

## Sql Server configuration Manager

- Ouvrir Sql Server configuration Manager (rechercher dans windows)
- aller sur `SQL Server Network Configuration`
- mettre TCP/IP en enabled

![](https://i.imgur.com/Yg0FJV2.png)