Last post Jun 28, 2017 05:44 PM by PatriceSc
Jun 28, 2017 04:53 PM|anupamabr|LINK
Jun 28, 2017 05:01 PM|PatriceSc|LINK
Unclear. Do you mean that SQL Management Studio is installed but that you can't access or connect to a datatabase ? You don't know which SQL Server information to enter in the connect dialog ? Do you have SQL Server installed somewhere? (SSMS is just the
management tool, you still need to have the SQL Server dbengine installed somewhere).
By default VS shoudl install localdb. Try
https://docs.microsoft.com/en-us/sql/tools/sqllocaldb-utility to see if it is installed and to get information on installed instances. SSMS allows also to connect to SQL Local DB.
If you meant using SQL Server Management Studio to connect to an Access database you can't. This tool allows to manage SQL Server.
Jun 28, 2017 05:15 PM|anupamabr|LINK
Jun 28, 2017 05:44 PM|PatriceSc|LINK
It doesn't really make sense. SQL Management Studio is a management tool for "SQL Server" (not any SQL based server, "SQL Server" is the name of a Microsoft, enterprise level, database engine).
- at best you would rather connect SQL Management Studio to Microsoft Access rather than the other way round
- but anyway you can't as it is dedicated to managing the SQL Server database engine and only this particular database engine
I gave this a try and you have limited support for Access in Visual Studio (you can connect to an existing accdb file, browse existing tables and columns and run queries by using the "Data Sources" window). Is this enough for you?