It could be that you can't login any longer to an old server, because you don't have access to it or the files and user has been removed from the server.
In that case you can delete the old server and add a new one.
Delete "old" server:
1) Go in Microsoft SSMS to "View - Registered Servers"
2) Click on "Database Engine - Local Server Groups"
3) Delete the specific server
Add a new server:
1) Go in Microsoft SSMS to "View - Registered Servers"
2) Click on "Database Engine - Local Server Groups"
3) Click with the right mouse button on "Local Server Groups" and choose the option "New Server Registration..."
4) Give the new server a name and type for Authentication the default sysadmin user name (e.g. default Windows login)
After that it should be possible to work again with SSMS en the new server
How to delete an existing SQL Server
Allerlei tweaks voor een SQL Server
Moderator: Theet
Jump to
- Boeken & Tijdschriften
- Tweaks IT
- ↳ Office 2003
- ↳ Server
- ↳ Office 2010
- ↳ Apache
- ↳ php
- ↳ MySQL
- ↳ FTP
- ↳ WDS (Windows Deployment Services)
- ↳ Maginon IP-Camera
- ↳ E2000 Linksys
- ↳ Joomla
- ↳ CapaInstaller
- ↳ VMware
- ↳ Exchange
- ↳ Autodesk
- ↳ CMD
- ↳ TV
- ↳ Office 2013
- ↳ SQL Server
- ↳ Printers
- ↳ Office 365
- ↳ Excel 365
- Synology
- ↳ Mailstation
- ↳ phpBB3
- ↳ IPKG
- ↳ Raspberry Pi
- ↳ XPEnology
- ↳ Home Assistant
- Satelliet tv
- ↳ Strong SRT8000
- ↳ Dreambox 600PVR-S
- Huishoudelijke apparaten
- ↳ Senseo
- ↳ Vaatwasser
- KPN
- Computers/Laptops
- Operating Systems
- ↳ Windows XP
- ↳ Windows 7
- ↳ Windows 8
- ↳ Windows 10
- ↳ OpenELEC
- Mobile devices
- ↳ Samsung Galaxy S2
- ↳ iPhone
- ↳ OnePlus One
- ↳ SABnzbd
- ↳ NZBget
- ↳ Dreambox 500S
- Netwerk
- ↳ Cisco
- ↳ Filter voor kinderen