MS Access project with SQL Server - SQL Server as a backend and logging in

Author

SQL Server as a backend and logging in

rdemyan via AccessMonster.com

2006-03-06, 7:30 pm

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 webservertalk.com
http://www.webservertalk.com/Uwe/Fo...server/200603/1

aaron.kempf@gmail.com

2006-03-06, 7:30 pm

use SQL authentication when you're doing this without a domain

-aaron

rdemyan via AccessMonster.com

2006-03-06, 7:30 pm

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@gmail.com wrote:
>use SQL authentication when you're doing this without a domain
>
>-aaron

--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...server/200603/1

Sponsored Links