Re: unable to connect to sql db

well, I'm not going to show my actualy Id and pwd, but yeah I have the id
and password on my sql server, and I gave it dbowner permission for the
database I need to access with the id and pwd and no luck

"Mark Rae [MVP]" <mark@xxxxxxxxxxxxxxxxx> wrote in message
news:%23y%23C76Y6HHA.2208@xxxxxxxxxxxxxxxxxxxxxxx
"Steve" <Steve@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:ezy5zeY6HHA.5316@xxxxxxxxxxxxxxxxxxxxxxx

The error i'm getting is

'login failed for user 'username'

I have this as my connection string

<add key="dbConnection"
value="Server=DBServerTest;Database=SalesForTheYear;User
ID=username;Password=password;Trusted_Connection=False;"/>

now, this same connection string works on DBServerDev fine with the same
ID and pwd

You've actually created a SQL login called 'username' and given it a
password of 'password'...?

On the assumption that you have, does that login exist on the DBServerTest
box and, if so, does it have the necessary permissions to access the
SalesForTheYear database...?


--
Mark Rae
ASP.NET MVP
http://www.markrae.net


.

Relevant Pages

  • Interdev not creating project (authenticate failure)
    ... SQL Server Enterprise SP2 ... Username: Administrator ... Password: pwd ...
    (microsoft.public.inetserver.iis.security)
  • Interdev not creating project (authenticate failure)
    ... SQL Server Enterprise SP2 ... Username: Administrator ... Password: pwd ...
    (microsoft.public.win2000.security)
  • Re: root password issue
    ... couldn't start YasT, the pwd was always wrong, but I could su without ... pb, so I had t open console, su, then start YasT and it was OK. ... nor because of any special chars ... try with the password belonging to <login name> ...
    (alt.os.linux.suse)
  • Re: #1045 - Access denied for user root@localhost (using password: NO)
    ... Yes, even if I change, config.inc.php login from auth to http and get ... prompted for a pwd it does not accept it. ... understanding is that the pwd should be the same for mySql as for linux ... Rob uttered these immortal words: ...
    (comp.os.linux.setup)
  • Re: Database security (non-existent?)
    ... I run sqlcmd without specifying any username or pwd, ... *HUGE* security flaw - unless, ... BTW, based on this and your other post, I would highly recommend you pick ... done correctly SQL Server 2005 is pretty much as secure as ...
    (comp.databases.ms-sqlserver)