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