Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
polskash
Starting Member
4 Posts |
 Posted - 2009-02-17 : 18:07:05
|
| Here's my setup:SQL Server Express 2008 is running on my desktop which is on a LAN. I am trying to log in to the server with Management Studio on my laptop which is not on the LAN. For the server, I have it set to Mixed Mode (by right clicking the server name in the object explorer and going to properties->security). Also, in the Configuration Manager, I have TCP/IP enabled and have restarted the services. Also, for the TCP/IP properties, I have TCP port 1433 specified and TCP Dynamic Ports set to empty.However, I am not able to log in to the server when not on a LAN. On a LAN, for the server name I put "192.168.1.100\SQLEXPRESS" and it works fine. I have forwarded the appropriate ports to the machine with the server.What's the deal? Am I supposed to do something different? Any help is appreciated! Thanks! |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-02-17 : 23:18:51
|
| How could your laptop connect to your desktop if the laptop is not connected to the LAN?CODO ERGO SUM |
 |
|
|
polskash
Starting Member
4 Posts |
Posted - 2009-02-18 : 00:02:34
|
| By specifying the IP address of the desktop computer like so?"XXXX.XXXX.XXXX.XXXX\SQLEXPRESS" |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-02-18 : 00:05:52
|
| If the laptop has no physical connection to the LAN, what physical path would information travel from the laptop to the desktop computer?CODO ERGO SUM |
|
|
|
polskash
Starting Member
4 Posts |
Posted - 2009-02-18 : 01:06:40
|
| Oh sorry, I'm at a university and my laptop is connected to the school's wireless network while the laptop is hardwired into the wall. |
|
|
|
|
|
|
SQL login & TCP enabled, doesn't work over non-LAN