[dba-VB] Login to sql server

Try making Paul an administrator on the workstation?

Perry
----- Original Message ----- 
From: "jwcolby" <jwcolby at colbyconsulting.com>
To: "Sqlserver-Dba" <dba-sqlserver at databaseadvisors.com>; "VBA" 
<dba-vb at databaseadvisors.com>
Sent: Thursday, June 10, 2010 3:18 PM
Subject: [dba-VB] Login to sql server


>I have a network at my home office which uses Windows for Workgroups 
>networking.
>
> I have two SQL Servers.  I am having issues getting an employee able to 
> log in to the AZUL SQL
> Server instance (running on the AZUL server machine) FROM a desktop 
> machine.  He is able to remote
> desktop in to the AZUL server, to his own user, and through that is able 
> to open SQL Server
> Management Studio and do stuff, and is able to use the C# program we are 
> writing to do stuff.
>
> From his workstation, I AM able to log in as my own user, then open SSMS 
> and log in to AZUL SQL
> server instance.
>
> Paul is unable to log in to the AZUL SS instance through SSMS.  He gets an 
> error:
>
> Cannot connect to Azul.
>
> Cannot open user default database.  Login Failed.
>
> Login failed for Azul\Paul.  SQL Server error 4064
>
> This seems to imply that it has something to do with his user on the 
> workstation, since he can log
> in if he remote desktops in.  However the user name and password on the 
> workstation is exactly the
> same as the username on AZUL.
>
> I don't know where to go next in troubleshooting this.
>
> -- 
> John W. Colby
> www.ColbyConsulting.com
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
>
>