Unanswered: Connecting to SQL Server on the Server
Hi guys we finally got the Server setup and SQL server is on it, now I am on the developers computer trying to connect to the SQL Server on our server but its not connecting. And I do have sql server on the pc I am developing from. We also have AD setup on the server but I am wondering do we need to setup pc's on the server so the server can connect to the Pc's. I dont know allot about AD, any help would be great thanks
Make sure your develpers can ping to the SQL server. If they can't ping means developers machine can't see the SQL server.
Once you can ping then you can use SQL authentication or windows authentication to connect to SQL server but you have to grant the access to developers before connecting to sql server.
i did that and they can not ping the server. It timed out
Either you have pings blocked by a firewall in which case the ping test tells you nothing
Your developer machines just cannot see that server on the network and you have a networking issue to investigate, not a database issue.