EDAMS Database Manager
Frequently Asked Questions
July 2010

• Restoring database from backup problem


• Connecting to my personal PC SQL server 2005 instance from another PC

---

   

Restoring database from backup problem

When trying to restore database from backup we get the following error. What does it mean?

You are trying to restore a backup of a MS sql 2005 server database to a previous version of MS sql server.

Back to Top

---

      

Connecting to my personal PC SQL server 2005 instance from another PC

If you have an instance of MS SQL 2005 running on your personal PC and require other users to access it remotely, you need to enable the following.

1. Start Menu\Programs\Microsoft SQL Server 2005\Configuration Tools\SQL Server Surface Area Configuration\  

Select configuration for connections and enable Local and remote connections as shown on screenshot below.

2. If your firewall is enabled you need to also open the following ports.

Run the following commands at the Command Prompt:
Netsh firewall set portopening tcp 445 SQLNP ENABLE ALL 
Netsh firewall set portopening tcp 1433 SQL_PORT_1433 ENABLE ALL 

Netsh firewall set portopening udp 1434 SQLBrowser enable ALL 

Back to Top