Re: unable to connect to sql db

"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

  • Re: Delph7 + ADO conenction to advantage & oracle
    ... >connect to a database and then login to the program based on matching the ... >supplied username & password with a username and password stored in a table ... You connect to and OleDb connection using a connection string. ... your next step is to find the username and password the user provides on login ...
    (borland.public.delphi.database.ado)
  • Please Help! Access 2003, login to SQL Sever
    ... I use a connection string (with username and the password) in my Access ... module to login to the SQL Server database. ...
    (microsoft.public.access.security)
  • Re: Prompt user for connection string
    ... to be able to enter a username and password on a login page which I want to ... and then just use the String.Replacemethod on the existing connection string. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: EXEC master..xp_cmdshell Prevention
    ... > I found that my web application did use a connection string in a file ... > stored procedures for every SQL statement would be impractical. ... I have created a new login account ...
    (microsoft.public.sqlserver.security)
  • Problem handling Login control Authenticate event
    ... login process. ... required for login… they have a username, password, and another “location ... and when the extra input field is submitted ... for the users where this concatenation of the two input field ...
    (microsoft.public.dotnet.framework.aspnet)