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

Raghuraman (raghuraman_ace (AT) rediffmail (DOT) com) writes:
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, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

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 ***

Raghu Raman (raghuraman_ace (AT) rediffmail (DOT) com) writes:
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, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp