Friday, March 23, 2012

Promt for Uname and Pass while opening Databas through QuiryAnalis

How to make SQL Server 2000 to promt for Uname and Pass while opening user
defined database from QuiryAnaliser.Ramcy (Ramcy@.discussions.microsoft.com) writes:
> How to make SQL Server 2000 to promt for Uname and Pass while opening user
> defined database from QuiryAnaliser.
SQL Server is a server program, and cannot interact with users and is
not able to prompt. Query Analyzer usually prompts you for username and
password when you log in, or open a new query window. Once connected
to the server, there is no further authentication.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

No comments:

Post a Comment