I have installed an XP virtual machine on a Linux host. Everything seems to work OK except I cannot connect to the database from clients elsewhere on the LAN. I am using port 1433. I *can* telnet to this port, so that tells me the SQL Server is listening to this port on the VM, but when I try to connect I get the error:
Status: 4064 Cannot open user default database. Login failed. ClientConnectionId:d5cd574
connection string is:
I can still successfully connect to the original, physical XP host. Its connection string is:
I've checked SQL Configuration Manager > Protocols ... > TCP/IP, and that looks OK - Any ideas where I might look?
so, check login/username and set the default db
are you giving the databasename to connect to?