getting started on Windows 10

[expired user #9931]'s profile image [expired user #9931] posted 8 years ago in Installation Permalink

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?

ansgar's profile image ansgar posted 8 years ago Permalink

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.

[expired user #9931]'s profile image [expired user #9931] posted 8 years ago Permalink

Where does it ask for the host name?

ansgar's profile image ansgar posted 8 years ago Permalink

Well, it's the second box from the top, quite obviously, isn't it?

1 attachment(s):
  • sql-server-hostname

Please login to leave a reply, or register at first.