Recently, I had helped install a new instance of Sql server 2008 on a windows 2008 server.
The install went fine. However, I noticed that the sa account is disabled by default. This is a new feature in sql server 2008.
You will have to login to the server as an administrator not as user with administrator rights, but as an administrator to make any changes to the sql server configuration. Once the necessary changes are made, any users with administrative rights can login and make other changes.
By default, all the ports are closed. So, you will have to go to windows firewall, add a new role to open the port for 1433. Name the rule as sql server port. Once the port is enabled, remote clients can make connections to the sql server 2008.
Port 1433 is not opened by default, even if an active instance of sql server 2008 is running on the server, it has to be manually opened via the firewall.
Thats my tip for the day.
No comments:
Post a Comment