I'm using integrated security and trying to access the SQ database in dot net. my OS is XP and i've SQL Server 2000 Developer Edition installed. If write following connection string, it works
"Persist Security Info=False;Integrated Security=SSPI;database=DBName;data source=(local);"
But if i use the same using name or IP Address of the server it gives an error stating
"SQL Server does not exist or access denied."
Same happens if access it from some other machine. because in that case also either i'm using ip address of my machine or the name of the machine as server.
It works well through query analyzer.
What could be the reason. pls. help
Thanks and regards,