New
#1
Remote Access to SQL Server Express 2008 Windows 7
Hello,
I have installed SQL Server Express 2008 on my desktop and am attempting to connect to it from my lap top. I have enabled remote connections for SQL Server and opened up a port on my desktop. When I attempt to connect to the server instance from my laptop via ipaddress\sqlserver with the Windows 7 firewall turned on and the port open, the attempt fails. However, if I turn off the firewall and attempt to connect via my laptop the connection is successfull.
I followed the steps to open up the port:
- To enable port 1433 on Windows 7
- On the Start menu, click Control Panel.
- Click System and Security.
- Click Windows Firewall.
- Click Advanced Settings.
- In the Windows Firewall with Advanced Security on Local Computer dialog, click Inbound Rules.
- In the Actions panel, click New Rule….
- In the New Inbound Rule Wizard, click Port, and then click Next.
- In the Specific local ports: box type 1433. Ensure that the (default) TCP radio button is selected and then click Next.
- Ensure that the (default) Allow the Connection radio button is selected and then click Next.
- Clear or select the Domain, Private, and Public checkboxes as appropriate, and then click Next.
- In the Name box, type an appropriate name, such as SQL Server Port, and then click Finish.
Can anyone offer up any suggestion on why I can connect with the firewall turned off, but not when it is on?
Any suggestions are greatly appreciated!
Win7Newb