Connect via workgroup

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







.

Relevant Pages

  • Re: Guest Account
    ... This comes from the book, "Professional SQL Server 2000 Programming", WROX ... "The guest account provides a way of having default access. ... >> Master, MSDB, Temp, Northwind, Pubs, and all other User databases. ...
    (microsoft.public.sqlserver.security)
  • Re: Connect via workgroup
    ... Try using SQL authentication instead. ... enable the guest account which isn't a good idea. ... The SQL Server is on XP pro and the workstation is XP Home. ... guest account as simple file sharing is always enabled on XP ...
    (microsoft.public.sqlserver.connect)
  • Re: Very basic login question
    ... In order to use Windows Authentication the two computers have to be members of the same domain or trusted domains. ... you should have a login at the SQL Server on the XP Pro workstation. ...
    (microsoft.public.sqlserver.security)
  • Re: Very basic login question
    ... Both computers are NOT members of a domain. ... In order to use Windows Authentication the two computers have to be ... you should have a login at the SQL Server on the XP Pro ...
    (microsoft.public.sqlserver.security)
  • Re: Connect via workgroup
    ... The SQL Server is on XP pro and the workstation is XP Home. ... authentication is done using the ... guest account as simple file sharing is always enabled on XP ... I turned off the Windows firewall on both computers. ...
    (microsoft.public.sqlserver.connect)