SQL 2005 Login

I am very frusted.. I have a vb.net app that used to work fine with SQL
2000.
I installed a new server with SQL 2005, and the new vb.net app fails login
from any workstation. Every username I create in SQL fails login from vb.net
app, EXCEPT sa. I guess the app is OK since just replacing the username and
password in the connection string with sa clears the problem up. What do I
have to do to make a single user work. I have 2 diff DB servers and the same
happens on both. Here's what I've done so far, is this wrong? What else do I
need to do?
TRIED THIS:
Created a user 'testuser' in the management console under databases >
security >logins
( I even made the user a sysadmin, if that makes any difference)
Went under the TESTDB > SECURITY >LOGINS , made sure he was there and made
him under the general tab a db_owner.
All I get is login failed for user 'testuser' from my vb.net app, of course
replacing the user/pass with the sa account connects fine. I would rather
not use the sa account credentials from my remote app.

TRIED THIS:
I then tried this did the same stuff above with a new user called
'testuser1' but made hime a local windows user on the standalaone DB
server. No effect, same error...

Ideas are appreciated.. This is driving me nuts..
Thanks BUC



.

Relevant Pages

  • Re: version & instances
    ... SQL 2000 SP3a for Antivirus app ... that same server, to avoid breaking any of those apps. ... MSDE has a limited database size ...
    (microsoft.public.sqlserver.msde)
  • Re: Accessing SQL Server w/ Forms on Intranet
    ... on to the SQL server." ... launched the application from a shared drive really shouldn't affect SQL ... Sam Santiago ... > which Forms process information much better then an ASP app communicating ...
    (microsoft.public.dotnet.distributed_apps)
  • ?? unable to access SQL Server w/ sa account unless user is Administrator on local machine
    ... can tell it to pickup our SQL server using SQL ... app and SQL Server. ... >user belongs to the local Administrators group, ...
    (microsoft.public.sqlserver.security)
  • Re: Invalid Seek Offset continued...
    ... Well shifting to MS SQL will be a very very big step. ... > As Aashish mentioned, network cards drivers may be causing this problem, I ... > also see this error a lot at one customer where the server RAID Controller ... >>> We are deploying a VFP8 app to several beta sites to replace an FPW ...
    (microsoft.public.fox.programmer.exchange)
  • Re: SQl Data Provider Performance Issues
    ... Can you provide a complete sample app ... selects with a single inner join perforn OK. ... When I run the query from SQL ...
    (microsoft.public.dotnet.languages.csharp)