downsouth

Saturday, July 22, 2006

HOW TO CHANGE THE MICROSOFT SQL SERVER 2000 PORT ON THE SERVER

Open the Microsoft SQL Server Enterprise Manager.
Right-click on your server instance (you may have to expand the server groups).
Choose Properties.
Under the General tab, click the button labeled "Network Configuration". The SQL Server Network Utility will be displayed.
On the right, under the Enabled Protocols, you should see TCP/IP. Select it and hit the Properties button.
The Network Protocol Default Value Setup dialog will ask for the Default Port for SQL Server (it will most likely be 1433). Changing this entry will change the port that SQL Server listens on. Make the change and hit OK to close the dialog.
Hit Apply on the SQL Server Network Utility screen, then OK.
The system will tell you that the changes are saved, but that they will not take effect until you stop and restart the SQL Server service. Hit OK.
Hit OK to close the Properties dialog.
Right-click on your server instance again, and choose to stop the SQL Server service.
Once it has stopped, right-click and choose to start the SQL Server service. Restarting it will now use the new port.

HOW TO CHANGE THE MICROSOFT SQL SERVER 2000 PORT ON THE CLIENT

Close the Client and any Administrative tools (Customization Manager, User Manager, etc.).
On each Client machine, go to the Client program group and open the Client Network Utility under the Networking folder.
On the right, under the Enabled Protocols, you should see TCP/IP. Select it and hit the Properties button.
The Network Protocol Default Value Setup dialog will ask for the Default Port for SQL Server (it will most likely be 1433). Changing this entry will change the port that Client connects to on the Server_Name/SQL Server.
Change the entry and hit OK to close.
Hit OK to close and save the changes.

Sunday, April 10, 2005

MOVIE:Review "finding Neverland"

Its always a pleasure to rate or review a fine movie ; with added star value such a Johnny Depp it makes a rewarding way to spend time . The movie is a tale of fantasy & magic inspired by the life of James Barrie

The performance of the lead character played by depp is charming , and proves himself to be much more than a natural talent & more or less a star who is immortal.

The only down side to the movie is it lacks inspiration to the viewer, but what seperates it from other movies is that the story is unfolded gently and simply without excess sendimentality.

I did like the movie and do recommend it all Johnny depp Fan's and people in particular who liked the TITANIC, not because Kate winslet also star's in this film .