Accessing SQL Server over Workgroup

Question

I have two machines:

A: Win 2008 server B: Windows 7

They are on the same workgroup, and I enabled network discovery. So on the server, I have SQL Server installed with a SQL Server account (mixed mode is enabled). I'm trying to connect to this server from the win 7 machine in the workgroup, but no go. Do I have to reference the server by something else than machine name? How do I successfully establish that relation? I am a n00b to this type of thing...

Thanks.

Solution 1

Windows Server 2008 comes with the firewall blocking most stuff. Have you checked the server firewall to see if SQL is allowed? Ports 1433 and 1434 by default. You'll need 1434 on if you are using SQL Express and want to find it by browsing. Also check the SQL Server Configuration tool and see if TCP/IP is turned on.

Solution 2

Use tcpview to get the port of sql express. Than, use "ip\instancename,port" to connect to the server. Verify firewall, but, it should work if both are in LAN. HTH

Comments

[johnie]

This was helpful: This was helpful: support.microsoft.com/kb/968872

[johnie]

Got the name right, but no go... I don't think it's that.

[johnie]

OK, that's probably it, will double-check that. Thanks.

[Chris W]

In that case check for firewalls blocking access and also check with the SQL Surface Area Config wizard to make sure remote connections are actually allowed to the server.

[Bratch]

Also, from the SQL Server Configuration Manager, SQL Server Network Configuration, Protocols for SERVERNAME, TCP/IP, Properties, IP Addresses tab, IP#, TCP Port (TCP Dynamic Ports if SQLEE). This config manager is also where you enable/disable protocols.

[Bratch]

You can also turn off the firewall to see if you can connect, to determine that is the problem, but be sure to turn it back on as soon as you are done testing.