Solved

sql server 2008 install

Posted on 2009-07-14
3
254 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

863 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

27 Experts available now in Live!

Get 1:1 Help Now