What sup on 00971-556053318 for the best ID Card Printers in the Middle East, Gulf, Saudi, Kuwait, Bahrain, Qatar, Oman, Egypt, Iraq, Nigeria, Somalia, Sudan, Tanzania, Uganda, Somalia, Africa
Tuesday, February 17, 2009
Enable the SQL Server Browser service
Enable the SQL Server Browser service
If we are running sql server 2005 by using instance name and we are not using specific port number in connction string we need to enable sql server browser service to allow remote connctions. For example if you are using computername\sqlexpress you need to enable sql server browser service.
One important thing while doing enabling sql server browser service is it is increasing security risk and making the computer or network to more vulnerable to attacks by malicious programs or malicious users such as viruses. I recommended you to follow this only if you really requires this.
Steps to enable the SQL Server Browser service
1. Click start->programs->microsoft sql server 2005-> configuration tools->
sql server surface area connection.
2. In sql server surface area configuration page click Surface Area Configuration for Services and Connections.
3.In Surface Area Configuration for Services and Connections change sql server browser startup type to automatic. click apply
4. Click start-OK
TACS LLC Dubai
Building Maintanance Dubai
Access Control System
Gate Barrier
HRMS Solutions
EID Reader Software
EID Reader
Building Maintanance
UHF Reader
Time Attendance Dubai
Eanble remote connections on the instance of sql server.
Eanble remote connections on the instance of sql server express or sql server developer edition.
To enable remote connections on the instance of sql server express or sql server developer edition you need to follow the following steps
Click on start->programs->microsoft sql server 2005->Configuration tools->sql server surface area connction
CAME GARD GT4
BFT MOOVI30
CAME G4000
SLIDING GATES
Then the following window will open. In this click on surface area configuration for services and connections.
When clicking on surface area configuration for services and connections.
In the window when selecting remote connectins you can see whether remoteconnctions have enabled in your system. If not enable by selecting the radio button. Then a message box will show as changes will take effect only when restarting. Then restart your computer.
Time Attendance Dubai
TACS LLC Dubai
Time Attendance Dubai
Access Control System
Gate Barrier
HRMS Solutions
EID Reader Software
EID Reader
Building Maintanance
UHF Reader
Web based printing
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that u
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
When you try to connect to the sql server 2005 remotely the above error may occur. One reason for this eroor is your sql server 2005 configuration is not accepting remote connection. By default sql server express edition and sql server 2005 developer edition do not allow remote connections. To configure sql server 2005 to allow remote connections, complete the following steps.
Induction Loop detectors
1. Eanble remote connections on the instance of sql server.
2. Turn on the sql server browser service.
3. Do firewall configuration to allow network trafic related to sql server and browser service.
Time Attendance Dubai
TACS LLC Dubai
Time Attendance Dubai
Access Control System
Gate Barrier
HRMS Solutions
EID Reader Software
EID Reader
Building Maintanance
UHF Reader
Subscribe to:
Posts (Atom)