SQL Server as a backend and logging in "rdemyan via AccessMonster.com" <u6836[ at ]uwe> 04.03.2006 03:49:26 I'm playing around with SQL Server as a backend. I've upsized the tables and have been able to get my app linked to SQL Server when both SQL Server and my app are on the same machine. I hope I can ask this probably basic SQL Server question here, but, how do I connect to SQL Server from another machine running my app. I'm getting the following message on the second machine: Connection failed: .. .. .. Login failed for user 'COMPAQM2005\Guest So I went into the Enterprise Manager and tried to create a new user, which user would be a user from the second machine. The machine running SQL Server is the COMPAQM2005, the first machine. However, the domain for the 2nd machine does not appear in the list for creating a user even though both machines are connected via a home network. Both machines are running Windows XP Home Edition. Is the only way to get in to SQL Server by using the Guest account on the machine that has SQL Server. Thanks in advance. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-adp-sqlserver/200603/1

Re: SQL Server as a backend and logging in "aaron.kempf[ at ]gmail.com" <aaron.kempf[ at ]gmail.com> 04.03.2006 17:43:09 use SQL authentication when you're doing this without a domain -aaron

Re: SQL Server as a backend and logging in "rdemyan via AccessMonster.com" <u6836[ at ]uwe> 04.03.2006 20:05:57 Aaron: Thanks for the reply. Yes, I was beginning to think that the problem might be with the domain. XP home edition doesn't have domains, correct? But if I had XP Professional, then I would have seen the domain of the 2nd computer when I was trying to setup a User ID/PWD for a user on the remote machine. aaron.kempf[ at ]gmail.com wrote: [Quoted Text] >use SQL authentication when you're doing this without a domain > >-aaron -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-adp-sqlserver/200603/1