Solved

sql server 2008 install

Posted on 2009-07-14
3
240 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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Suggested Solutions

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

771 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now