[dba-SQLServer] Login to sql server

Gary Kjos garykjos at gmail.com
Thu Jun 10 15:48:13 CDT 2010


Glad we could help. ;-)

GK

On Thu, Jun 10, 2010 at 2:23 PM, jwcolby <jwcolby at colbyconsulting.com> wrote:
> The "default database" was the key.  Discovered it about 15 oh-no-seconds after pressing send.
>
> I'm good on this one.
>
> John W. Colby
> www.ColbyConsulting.com
>
>
> jwcolby wrote:
>> 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.
>>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>



-- 
Gary Kjos
garykjos at gmail.com




More information about the dba-SQLServer mailing list