Friday, March 23, 2012

Promting for UNAME and PASS While opening DATABASE through QuiryAn

How to make SQL Server Promting for UNAME and PASS While opening userdefined
DATABASE through QuiryAnaliser.
In Busness Envirnment.Ramcy (Ramcy@.discussions.microsoft.com) writes:
> How to make SQL Server Promting for UNAME and PASS While opening
> userdefined DATABASE through QuiryAnaliser.
You asked the same question yesterday, and I repeat my answer, in case
you did not see it:
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