By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,846 Members | 1,631 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,846 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 18 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a


----- 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.
Nov 18 '05 #2

P: n/a
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" <uw******@hotmail.com> wrote in message
news:B6**********************************@microsof t.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

Nov 18 '05 #3

P: n/a
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*******@discussions.microsoft.com> wrote in message
news:AD**********************************@microsof t.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" <uw******@hotmail.com> wrote in message
news:B6**********************************@microsof t.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


Nov 18 '05 #4

P: n/a
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*******@discussions.microsoft.com> wrote in messag
news:AD**********************************@microsof t.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\USERNAME have you tried by connection like this
server=servername;database=databasename;Integrated Security=Tru
Regards Marti "Reza" <uw******@hotmail.com> wrote in messag news:B6**********************************@microsof t.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

Nov 18 '05 #5

P: n/a
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*******@discussions.microsoft.com> wrote in message
news:EE**********************************@microsof t.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*******@discussions.microsoft.com> wrote in message
news:AD**********************************@microsof t.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" <uw******@hotmail.com> wrote in message

> news:B6**********************************@microsof t.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
>>>

Nov 18 '05 #6

P: n/a
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*******@discussions.microsoft.com> wrote in messag
news:EE**********************************@microsof t.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*******@discussions.microsoft.com> wrote in messag

news:AD**********************************@microsof t.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\USERNAME
have you tried by connection like this
server=servername;database=databasename;Integrate Security=Tru Regards

Marti
"Reza" <uw******@hotmail.com> wrote in messag

news:B6**********************************@microsof t.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

Nov 18 '05 #7

P: n/a
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******@hotmail.com> wrote in message
news:F3**********************************@microsof t.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*******@discussions.microsoft.com> wrote in message
news:EE**********************************@microsof t.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*******@discussions.microsoft.com> wrote in message

> news:AD**********************************@microsof t.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" <uw******@hotmail.com> wrote in message
>> news:B6**********************************@microsof t.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
>>>>

Nov 18 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.