Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can not see the database
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Sécurité
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01300594
Message ID:
01300628
Vues:
11
This message has been marked as a message which has helped to the initial question of the thread.
>>If you have MSSQL.1-4 that you have 4 instances of SQL Server installed. Just try to connect to each one and see where the data is.
>
>Can you specify for dummies how to connect to each instance from SSMS?
>
>Looks like I'm connecting to the 4th instance instead of 1.

When you get Login dialog just open Server name combo. There you should have all instances of your server + all servers SSMS found.
Also if you open SQL Server Configuration Manager there you could see what services you have. On my office computer i have:
SQL Server (MSSQLSERVER)
SQL Server (SQLSERVEREXPRESS) (or something like that)

Right click on every instance and see all properties for it.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform