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

[Reza]

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

[Reza]

----- Reza wrote: ----

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

Rez
-------------
Just to clarify, I have updated the server and database name in the connection string.

[Martin Marinov]

are you sure that in the connection string the user is DOMAINNAME\USER NAME ?
have you tried by connection like this:

server=serverna me;database=dat abasename;Integ rated Security=True

Regards,
Martin
"Reza" <uw******@hotma il.com> wrote in message
news:B6******** *************** ***********@mic rosoft.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

[Martin Marinov]

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" <an*******@disc ussions.microso ft.com> wrote in message
news:AD******** *************** ***********@mic rosoft.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\USER NAME ? have you tried by connection like this:

server=serverna me;database=dat abasename;Integ rated Security=True

Regards,
Martin
"Reza" <uw******@hotma il.com> wrote in message
news:B6******** *************** ***********@mic rosoft.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

[Reza]

Martin

I get the same message when I tried your suggestion. Looks like it is complaining that there is not a secure connection. How do I do this? I changed the authenticaion to both, SQL and windows, but still the same thing

Any idea

thanks
rez

----- Martin Marinov wrote: ----

Have you tried to connect with sql query analizer with your username an
passwor
if you don't have query analizer try this

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

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

Regard
Marti

"Reza" <an*******@disc ussions.microso ft.com> wrote in messag
news:AD******** *************** ***********@mic rosoft.com..

Yes, I tried both of these, but no luck. I tried with domain name an without. Tried the trusted connection, Integrated Security=True, but stil
the same problem - Login failed for user 'username'

----- Martin Marinov wrote: ----
are you sure that in the connection string the user i DOMAINNAME\USER NAME have you tried by connection like this

server=serverna me;database=dat abasename;Integ rated Security=Tru
Regards Marti "Reza" <uw******@hotma il.com> wrote in messag news:B6******** *************** ***********@mic rosoft.com..

Hello

The project was working, where I had a domain user registered i

th database as a user, and I used that user to connect the datebase Everythin was fine and it was working, then when I moved the project to th productio servers - database server and web server. Following that all th users ar failing to connct to database, getting this message

"login failed for user 'username'

I am getting the user with property identity and it is registere

identically in the database user list I am pretty much stuck and ran out of ideas to try. So

resolution wil be greatly apreciated Thanks in advance
Rez

[Martin Marinov]

Now when you change it to sql and windows authentication you have to add the
aspnet user to the database and use Integrated Security=True

Regards
Martin

"Reza" <an*******@disc ussions.microso ft.com> wrote in message
news:EE******** *************** ***********@mic rosoft.com...

Martin,

I get the same message when I tried your suggestion. Looks like it is complaining that there is not a secure connection. How do I do this? I
changed the authenticaion to both, SQL and windows, but still the same
thing!
Any idea?

thanks,
reza

----- Martin Marinov wrote: -----

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" <an*******@disc ussions.microso ft.com> wrote in message
news:AD******** *************** ***********@mic rosoft.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\USER NAME ?

> have you tried by connection like this:

>> server=serverna me;database=dat abasename;Integ rated Security=True >> Regards,

> Martin

>>> "Reza" <uw******@hotma il.com> wrote in message

> news:B6******** *************** ***********@mic rosoft.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
>>>

[Reza]

Well I thought I had resolved this, but looks like this company's policy not allows sql authentication for the users, so I am back to step one.
It works for aspnet user, however, there is a fix list of people that will be able to access it, which they belong to a domain.
and looks like I get the same message, login failed for user 'username'
----- Martin Marinov wrote: ----

Now when you change it to sql and windows authentication you have to add th
aspnet user to the database and use Integrated Security=Tru

Regard
Marti

"Reza" <an*******@disc ussions.microso ft.com> wrote in messag
news:EE******** *************** ***********@mic rosoft.com..

Martin

I get the same message when I tried your suggestion. Looks like it i complaining that there is not a secure connection. How do I do this?
changed the authenticaion to both, SQL and windows, but still the sam
thing

Any idea
thanks rez

----- Martin Marinov wrote: ----
Have you tried to connect with sql query analizer with your usernam an passwor
if you don't have query analizer try this

osql -U yourusername -P password -S servername -d databas
if this is failed to than you don't have sql authentication to you

serve Regard

Marti

"Reza" <an*******@disc ussions.microso ft.com> wrote in messag

news:AD******** *************** ***********@mic rosoft.com..

Yes, I tried both of these, but no luck. I tried with domain nam

an without. Tried the trusted connection, Integrated Security=True, bu stil the same problem - Login failed for user 'username' ----- Martin Marinov wrote: ----
are you sure that in the connection string the user i

DOMAINNAME\USER NAME

have you tried by connection like this

server=serverna me;database=dat abasename;Integ rate Security=Tru Regards

Marti

"Reza" <uw******@hotma il.com> wrote in messag

news:B6******** *************** ***********@mic rosoft.com..

Hello
The project was working, where I had a domain user registered i

th

database as a user, and I used that user to connect th

datebase Everythin

was fine and it was working, then when I moved the project t

th productio

servers - database server and web server. Following that al

th users ar

failing to connct to database, getting this message

"login failed for user 'username'
I am getting the user with property identity and it is registere

identically in the database user list

I am pretty much stuck and ran out of ideas to try. So

resolution wil

be greatly apreciated

Thanks in advance
Rez

[Martin Marinov]

If you can add these domain users to a domain group and then add rights for
this group and set the quthentication to be windows authentication

check if the group Domain Users has not been added with deny rights

Regards
Martin Mrinov

"Reza" <uw******@hotma il.com> wrote in message
news:F3******** *************** ***********@mic rosoft.com...

Well I thought I had resolved this, but looks like this company's policy not allows sql authentication for the users, so I am back to step one. It works for aspnet user, however, there is a fix list of people that will be able to access it, which they belong to a domain. and looks like I get the same message, login failed for user 'username'?

----- Martin Marinov wrote: -----

Now when you change it to sql and windows authentication you have to add the aspnet user to the database and use Integrated Security=True

Regards
Martin

"Reza" <an*******@disc ussions.microso ft.com> wrote in message
news:EE******** *************** ***********@mic rosoft.com...

> Martin,

>> I get the same message when I tried your suggestion. Looks like it is

complaining that there is not a secure connection. How do I do this? I changed the authenticaion to both, SQL and windows, but still the same thing!

>> Any idea?
>> thanks, > reza

>> ----- Martin Marinov wrote: -----
>> 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" <an*******@disc ussions.microso ft.com> wrote in message

> news:AD******** *************** ***********@mic rosoft.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\USER NAME ?

>> have you tried by connection like this:
>>> server=serverna me;database=dat abasename;Integ rated

Security=True >>> Regards,
>> Martin
>>>> "Reza" <uw******@hotma il.com> wrote in message
>> news:B6******** *************** ***********@mic rosoft.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
>>>>