Categories

Billing
12
DotBlock Private Cloud
16
FAQ
50
Security
11
Tech Support
62
VPS Installation
2

  Categories

  Tag Cloud

.asp .net abuse access account account access account creation acpi addons administration administrator advertisement affiliate antivirus apache apache modules audio avs backup data backups bandwidth bare-metal restore basic billing billing address block block countries block country boot boot issues boot order branding canceled cancellation cancelled cd CDN centos certificate change os clamav cleanup client vpn compromised connection console cores country code cpanel cpanel migration cpanel transfer cpu credit card credit card failure csf csf country code csf firewall csr database datacenters deceased dedicated server desktop died disk size disk space dispute DNS dns amplification dns attack dns recursion domains easyapache email error fcrdns fedora fedora control panel fedora login file management file manager filtering firewall firewall block forgot password fraud ftp GD google pagespeed grub gui hacked hard drive hardware failure hardware replacement hosting hostname how to backup how to cancel http to https https identity ie IIS initramfs innodb install internet explorer invoice IP ipmi iso java license linux load location login mail malware malware scan managed server management migration mod deflate mod_pagespeed mysql nameserver network open resolvers openvpn operating system optimize order overdue ownership packages pagespeed panel password payment paypal performance phone php phpmyadmin port power pricing private cloud PTR r1soft ram rDNS RDP re-activate re-direct reactivate reboot recover recovery redirect registry key reimage reinstall remote console remote desktop reset password resize resources restore reverse DNS root rootkit sales scan security self-signed server administration server express server hardening server manager shutdown signup smtp speed sql SRV SRV Record ssh ssl ssl redirect storage stream streaming support terminated ticket traffic transfer tweak settings ubuntu unmanaged unmetered upgrade upload verification verify video virtual dedicated virtualmin virus virus scan vnc vpn vps warnings webuzo whm windows Windows Server wine wordpress

  Support

My Support Tickets
Announcements
Knowledgebase
Downloads
Network Status
Open Ticket

How to Enable Remote SQL connections with SQL Server Express? Print

  • windows, sql, server express
  • 1

To enable remote SQL connections with SQL Server Express please use the following steps:

Click Start => Programs => Microsoft SQL Server 2005/2008 => SQL Server Configuration Manager.

Select SQL Server Network Configuration

Double click on Protocols for SQLEXPRESS

Right click TCP/IP and select Properties

Click on the IP Address tab, and then under IP2 IP Address, enter your IP Address

Scroll down to IPAll make sure TCP Dynamic Ports is blank and that TCP Port is set to your custom port

Click OK
Make sure that your custom port is enabled on your firewall and that mixed mode authentication is enabled for remote connections

When using SQL Express you will also need to open UDP port 1434

You may also find the following documentation helpful:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277

Was this answer helpful?

Related Articles

How do I disable Internet Explorer Enhanced Security Configuration? How to disable Internet Explorer Enhanced Security Configuration (IE ESC) in Windows Server 2012... How do I manually add a second IP address to my Windows installation? If you have purchased a second ip address for your Windows installation and need to add the new... How to Open A Custom Port in Windows Server 2008 We recommend using the extensive support documentation from Microsoft:... How do I secure my Windows Server? There are numerous ways to help improve security on your Windows server. Starting with the... How do I enable audio over Remote Desktop? There are two basic steps which need to be taken to ensure audio is enabled on your Windows VPS....
« Back

  Tag Cloud

.asp .net abuse access account account access account creation acpi addons administration administrator advertisement affiliate antivirus apache apache modules audio avs backup data backups bandwidth bare-metal restore basic billing billing address block block countries block country boot boot issues boot order branding canceled cancellation cancelled cd CDN centos certificate change os clamav cleanup client vpn compromised connection console cores country code cpanel cpanel migration cpanel transfer cpu credit card credit card failure csf csf country code csf firewall csr database datacenters deceased dedicated server desktop died disk size disk space dispute DNS dns amplification dns attack dns recursion domains easyapache email error fcrdns fedora fedora control panel fedora login file management file manager filtering firewall firewall block forgot password fraud ftp GD google pagespeed grub gui hacked hard drive hardware failure hardware replacement hosting hostname how to backup how to cancel http to https https identity ie IIS initramfs innodb install internet explorer invoice IP ipmi iso java license linux load location login mail malware malware scan managed server management migration mod deflate mod_pagespeed mysql nameserver network open resolvers openvpn operating system optimize order overdue ownership packages pagespeed panel password payment paypal performance phone php phpmyadmin port power pricing private cloud PTR r1soft ram rDNS RDP re-activate re-direct reactivate reboot recover recovery redirect registry key reimage reinstall remote console remote desktop reset password resize resources restore reverse DNS root rootkit sales scan security self-signed server administration server express server hardening server manager shutdown signup smtp speed sql SRV SRV Record ssh ssl ssl redirect storage stream streaming support terminated ticket traffic transfer tweak settings ubuntu unmanaged unmetered upgrade upload verification verify video virtual dedicated virtualmin virus virus scan vnc vpn vps warnings webuzo whm windows Windows Server wine wordpress

  Support

My Support Tickets
Announcements
Knowledgebase
Downloads
Network Status
Open Ticket