Re: can't connect to sql server with domain users? Help....

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Martin Marinov (memmarinov_at_mecrossroad.bg)
Date: 06/04/04 

Date: Fri, 4 Jun 2004 16:38:26 +0300

Have you tried to connect with sql query analizer with your username and
password
if you don't have query analizer try this:

osql -U yourusername -P password -S servername -d database

if this is failed to than you don't have sql authentication to your server

Regards
Martin

"Reza" <anonymous@discussions.microsoft.com> wrote in message
news:ADFEE77D-2ADD-4ED9-AF72-4E6ACB7CD423@microsoft.com...
> Yes, I tried both of these, but no luck. I tried with domain name and
without. Tried the trusted connection, Integrated Security=True, but still
the same problem - Login failed for user 'username'!
>
> ----- Martin Marinov wrote: -----
>
> are you sure that in the connection string the user is
DOMAINNAME\USERNAME ?
> have you tried by connection like this:
>
> server=servername;database=databasename;Integrated Security=True
>
> Regards,
> Martin
>
>
> "Reza" <uwhockey@hotmail.com> wrote in message
> news:B692F699-0808-4276-987D-CD866271C3E5@microsoft.com...
> > Hello,
> >> The project was working, where I had a domain user registered in
the
> database as a user, and I used that user to connect the datebase.
Everything
> was fine and it was working, then when I moved the project to the
production
> servers - database server and web server. Following that all the
users are
> failing to connct to database, getting this message:
> > "login failed for user 'username'"
> >> I am getting the user with property identity and it is registered
> identically in the database user list.
> >> I am pretty much stuck and ran out of ideas to try. So a
resolution will
> be greatly apreciated.
> >> Thanks in advance,
> >> Reza
>
>
>

Relevant Pages

  • RE: C++ Validating SQL user credentials
    ... All I want to do is take SQL credentials: server, database, username, ... CString connectionString = GetConnectionString(authenticationType, server, ...
    (microsoft.public.data.odbc)
  • C++ Validating SQL user credentials
    ... All I want to do is take SQL credentials: server, database, username, ... CString connectionString = GetConnectionString(authenticationType, server, ...
    (microsoft.public.data.odbc)
  • Re: Design question
    ... username and password on the App Server and Database server and synchronize ... recommend using the stored procedure for security and performance reasons. ...
    (microsoft.public.dotnet.framework.remoting)
  • Re: Login issues
    ... Depending on the computer or username, ... There is not way to enter to the database using ... If I enter as usual from my computer, the FM server automatically ... Perhaps someone changed your script, or the user name on your computer, or the default account in File Options. ...
    (comp.databases.filemaker)
  • Re: Securing a SQL Server Database
    ... you cannot block out the server administrator. ... SQL Server, even the SA User, should not be able to access the database. ... my Access database looks for a secret built in UserName and ...
    (microsoft.public.sqlserver.security)