| Author |
Topic |
|
quozr
Starting Member
5 Posts |
 Posted - 2015-04-10 : 03:13:26
|
| Hi guys,So, I have 2 laptops, both with standalone SQL Server 2012 Management Studio.laptop 1 can connect to my remote server on xxx.xxx.xxx.xxx,1433laptop 2 cannot connect through management studio - but can connect directly from the development website on this machine.I get error 18456, cannot connect to server and login failed for 'user'Firewall on or off has no effect.Any ideas please?Cheers,Jack |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-04-10 : 08:33:54
|
| same Windows logon id used on both laptops? |
 |
|
|
quozr
Starting Member
5 Posts |
Posted - 2015-04-10 : 09:41:04
|
| Thanks, well both administrators...on laptop 2 I can connect to the same web host but to a database on port 2433. It must be a port setting in management studio, no?Cheers, Jack |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-04-10 : 10:47:22
|
| Well, what port is SQL Server listening on (one port per instance, see SQL Server Configuration Manager, 1433 is default)?Do both Windows logons have matching login ids in SQL Server? If not, are the members of a Domain group that *does* have a matching login id in Sql Server? |
|
|
|
quozr
Starting Member
5 Posts |
Posted - 2015-04-10 : 11:28:54
|
| I should have explained more... both laptops have SQL Server 2008 Full developer edition but my remote DB is 2012, so I am using the free stand alone management studio (express) on its own to connect to the remote 2012. I am using the exact same credentials on both but on laptop 2 it will not allow the login. Strangely it does allow a direct connection from my web connection string using those very same credentials. I'm simply logging in direct with:-xxx.xxx.xxx.xxx,1433usernamepasswordCheers. |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-04-10 : 12:12:11
|
| Is laptop 2 a member of the same domain as laptop 1? |
|
|
|
quozr
Starting Member
5 Posts |
Posted - 2015-04-10 : 12:18:51
|
| They are not on a domain. Cheers. |
|
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-04-10 : 13:00:43
|
| OK, so what authentication are you using for the login to SQL? Not Windows, obviously, So, SQL Server authentication?Could it be that SQL server is running on a WIndows Server machine where the firewall is configured to only allow certain ips to connect to SQL? Not the firewall on your laptop(s) |
|
|
|
quozr
Starting Member
5 Posts |
Posted - 2015-04-11 : 08:09:44
|
| Sorry, yes SQL Authentication. From the laptop with the problem I can connect to this remote server from Visual Studio, from my web connection string and another database utility. I've reinstalled SQL 2012 management Studio but it just will not allow a connection to the server. I've looked through all the setting on both the machines and they appear the same. Most odd?Thanks for your help so far... |
|
|
|
|
Connect through Port 1433