How do I connect to MSSQL. I am very new at this and I am trying to get started on my first session. I have a standard Windows 10 installation and need to connect to a database that is in Microsoft sql server/MSSQL 10.50/MSSQL. When I try to start a new session it asks for my network type. I have tried all of the drop downs, and none of them worked. What do I need to do to get started?
getting started on Windows 10
I can connect to my local MS SQL Express installation with the following settings:
- Network type: SQL Server (named pipe)
- Hostname: [mycomputername]\SQLExpress
- Windows authentication activated
But I recall I had to activate the named pipe protocol in the MS SQL configuration settings, somewhere.
Please login to leave a reply, or register at first.