469,625 Members | 1,077 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,625 developers. It's quick & easy.

Sql server authentication not set

Hi ,

am new to sqlserver 2000.I want to connect to my sqlserver which is a
remote machine.I want to connect to sqlserver by sqlserver
authentication.Even though i added the available sqlserver in my
client as it shows, it is connected only by windows[nt)
authentication.Why it is showing so ?.

* But it is connected via Query analyzer in sqlauthentication.
I want to connect this sqlserver to my asp.net .

Is the connection string as follows is right ,if no pls correct me,
---------
Persist Security Info=False;Integrated
Security=SSPI;database=NORTHWIND;server=IISSERVER; User id=sa"
---------

It shows the error .

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

I ve'nt mentioned any authentication mechanisym in my query string
..From the error it defaultly accepts the NT authentication.How can i
over ride this to sql authentication.

Pls tell me the procedures should be made to connect to sqlserver in
sql authentication.

Thx & Regards
Raghu
Jul 23 '05 #1
3 1105
Raghuraman (ra************@rediffmail.com) writes:
am new to sqlserver 2000.I want to connect to my sqlserver which is a
remote machine.I want to connect to sqlserver by sqlserver
authentication.Even though i added the available sqlserver in my
client as it shows, it is connected only by windows[nt)
authentication.Why it is showing so ?.

* But it is connected via Query analyzer in sqlauthentication.
I want to connect this sqlserver to my asp.net .

Is the connection string as follows is right ,if no pls correct me,
---------
Persist Security Info=False;Integrated
Security=SSPI;database=NORTHWIND;server=IISSERVER; User id=sa"
---------

It shows the error .

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

I ve'nt mentioned any authentication mechanisym in my query string


You've mentioned twice: Integrated Security and User id. Of which the
first takes precendence, so rip that out of the connection string.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2
Dear Erland Sommarskog,

Thx 4 that.Though i 've eliminated, the user id from my connection
string since , it has the integrated security,It again tells the same
error that the sql server does not exist.

pls tell me what to do.

Regards
Raghu


*** Sent via Developersdex http://www.developersdex.com ***
Jul 23 '05 #3
Raghu Raman (ra************@rediffmail.com) writes:
Thx 4 that.Though i 've eliminated, the user id from my connection
string since , it has the integrated security,It again tells the same
error that the sql server does not exist.


The error message you posted was "Login failed for user 'NT
AUTHORITY\ANONYMOUS LOGON'". If you are now getting "SQL Server does not
exist or access denied", you are further from your goals than before,
because you are not even reaching the server. In this case, the first
thing to do is make sure that SQL Server is running.

These sort of problems are very difficult to diagnose from a distance,
and with terse information, it's even more difficult.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by dale zhang | last post: by
2 posts views Thread by Lior Amar | last post: by
2 posts views Thread by news.microsoft.com | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.