Re: Connect via workgroup
- From: Sue Hoegemeier <Sue_H@xxxxxxxxxxxxx>
- Date: Fri, 03 Nov 2006 22:36:22 -0700
You don't mention the editions of the operating systems
involved. With XP home, authentication is done using the
guest account as simple file sharing is always enabled on XP
Home. You could hit the issue with XP Pro if simple file
sharing is used. How you address the issue depends somewhat
on what specific operating systems are involved. Refer to
the following for more info:
SQL Server clients are authenticated as guests if Simple
File Sharing is enabled
http://support.microsoft.com/?id=831133
That's one of the issues....
For a connection string, you supply the user and password if
you are using SQL authentication. You use Integrated
Security=SSPI if you want to connect using Windows
Authentication. That's the purpose of switching those
around.
Then...if you want to use Windows Authentication, you aren't
in a domain so credentials aren't passed. You need to have
the same windows accounts with the same passwords on both
boxes.
-Sue
On Fri, 3 Nov 2006 13:16:38 -0700, ".netnew"
<vbopen@xxxxxxxxx> wrote:
I am trying to connect to an SQL Server using a vb.net program. It works if
I put it on the SQL Server computer, but will not connect over my local
network that is set up as a workgroup. I get the following message:
Login failed for user 'DELL4100\Guest'
DELL4100 is the computer name where the sql server is on.
The connection string is:
Data Source=dell4100;Database=dbname;User ID=dbn;Password=password;
I have also tried Integrated Security=SSPI; instead of the User ID &
Password.
I do not know why it is using Guest instead of the User ID that I specified.
So, I created a Login name in the SQL Server called Guest with no password.
I also activated the Guest account in XP for both machines. Still the same
message.
I created accounts for dbn on both computers and gave them the same
password. I logged in under dsn and ran the program, but I still get the
same error.
I turned off the Windows firewall on both computers. I can share files and
printers between computers, just not access the SQL Server.
Can anyone help?
Thanks
Tim
.
- Follow-Ups:
- Re: Connect via workgroup
- From: .netnew
- Re: Connect via workgroup
- References:
- Connect via workgroup
- From: .netnew
- Connect via workgroup
- Prev by Date: Re: Cannot connect to SQL Express on 2003 Machine from XP machine
- Next by Date: Re: sqlserver connection
- Previous by thread: Connect via workgroup
- Next by thread: Re: Connect via workgroup
- Index(es):
Relevant Pages
|
|
