How do I configure the SQL Server Client connection protocol?

To connect to a remote MS SQL Server over the Internet using SQL clients (Enterprise Manager, Query Analyser,etc), you will need to use TCP/IP as you network library.  To enable TCP/IP as the connection protocol, follow the below steps :

  1. Open the Client Network Utility Configuration  (Start -> Programs -> Microsoft SQL Server -> Client Network Utility)
  2. Select the General Tab
  3. Make sure TCP/IP is on top of the list in the 'Enabled Protocols by order' box
  4. Click OK

?האם התשובה שקיבלתם הייתה מועילה

 הדפסת המאמר

קראו גם

Can I have more logins for my MS SQL database?

No, we only provide a single database user login.

How do I find my MS SQL Server or Host Address?

Please follow these steps below to obtain that information : Login to your DotNetPanel :...

How to transfer SQL database from My Database Server to your Database Server

From the Start Menu, select Programs -> Microsoft SQL Server -> Import and...

How to restore my mssql database?

Old control panel -    Upload the backup file in .zip extension onto your root...

Can I use mssql 2008 if I built my database using mssql 2005?

Yes you can use the mssql 2008 although you build your db using mssql 2005. The database can be...