June 6, 2015 at 8:30 am
I have a laptop (PC2) and a desktop (PC1) in a workgroup (Windows 7). PC1 is running SQL Server 2014 Developer and PC2 is running SQL Server Express 2014. Using SSMS, I have tried many different ways to connect to PC1 SQL Server, but always get error 18456.
I'm obviously new to SQL Server administration. The servers on both PCs are configured for both Windows and SQL Server Authentication. SQL Server browser service is running and enabled. The error log on ASUS-JHS-CM6850 (PC1, desktop) shows
"06/05/2015 14:42:25,Logon,Unknown,Login failed for user 'ASUS-JHS-CM6850\Guest'. Reason: Could not find a login matching the name provided. [CLIENT: 192.168.1.15] 06/05/2015 14:42:25,Logon,Unknown,Error: 18456 Severity: 14 State: 5."
I'm pretty sure I need to add logins or users to one or both servers, but I've been struggling with this for days now. I also don't know why it's logging in as Guest, nor have I found a way to change that. (I am always in the same admin accounts on both machines)
June 7, 2015 at 4:42 am
For example PC1 is logged on with user "sql_dba_dev" and PC2 is logged on with "sql_dba_exp"
Now if you try to logon with SSMS from PC2 to PC1 the SSMS tries to logon with user PC2\sql_dba_exp onto PC1...
Does the user PC2\sql_dba_exp exists on PC1 and is it granted access to sql server on PC1?
If not it might be a "failback" to guest-account to give you public access rights in order to connect to sql server.
It is much easier to use sql server auth in such enviroments...
There are more possibilities ... for example UAC is enabled or you have to run SSMS with administrator rights
June 7, 2015 at 6:11 am
I got the answer on experts-exchange. It turns out I needed to use SQL Authentication, not Windows Authentication. Everything is working now. Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply