Solved

sql server 2008 install

Posted on 2009-07-14
3
270 Views
Last Modified: 2012-05-07
Hi, i was install sql erver 2008, but i dont see the menu SQL Server Surface Area Configuration.
menuSlqserv2008.JPG
0
Comment
Question by:nolberta
  • 2
3 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24848370
In 2008, SQL Server Surface Area Configuration was deprecated and hence it wont be available.
Those features are integrated as part of your SQL Server Configuration Manager and your SSMS itself.

Hope this helps
0
 

Author Comment

by:nolberta
ID: 24849311
ok, in which option I see remote connection? (view file)
remoteConnection.JPG
0
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 250 total points
ID: 24849973
In SQL Server 2008, this will be in

1. Open SQL Server Configuration Manager --> SQL Server Network Configuration --> Protocols for MSSQLSERVER
2. If TCP/ IP is enabled, then it corresponds to the one which you saw in the above configuration of 2005.
3. If Named Pipes is enabled, then it corresponds to option 2 in snapshot.
4. If both are enabled, then it corresponds to option 3 in snapshot

Kindly revert if I need to explain more.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Writing SQL Select Query result to a text file 12 56
SSRS 2013 - Creating a summarized report 19 49
Help Required 3 108
Master DB with Masterkey 1 34
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question