My Sellerdeck Account | Free Trial

Sellerdeck Community & Knowledge Base

Old 01-Jun-2011, 04:15 PM
G.W.Green G.W.Green is offline
Join Date: Sep 2005
Full Name: G.W.Green
Posts: 485
Thanks: 0
Thanked 68 Times in 43 Posts
SQL Server Configuration Manager settings

Once SQL Server has been initially installed, there are a few settings to check or edit if necessary.
  1. Open MS SQL Server Configuration Manager:
    “Start | All Programs | Microsoft SQL Server | Configuration Tools”
  2. Click on ‘SQL Server Services’ from the tree on the left
  3. From the list on the right, Check that the SQL Server service is running
  4. Expand ‘SQL Server Network Configuration’ from the tree on the left
  5. Click on ‘Protocols for [SQL SERVER INSTANCE NAME]
  6. Double click ‘TCP/IP’ (or right click and choose properties)
  7. In the ‘Protocol’ tab, ensure ‘Enabled’ is set to yes
  8. Switch to the ‘IP Addresses’ tab
  9. Change the TCP Port to the port you are using for SQL Server. The default port is 1433
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

All times are GMT. The time now is 07:23 PM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.