Screen of Logon of SQL SERVER 7.0 and 2000 
Author Message
 Screen of Logon of SQL SERVER 7.0 and 2000

How do I do so that the screen of LOGON of SQL SERVER doesn't appear to type
password, when I am using QUERY ANALIZER??



Sat, 11 Jun 2005 00:40:01 GMT
 Screen of Logon of SQL SERVER 7.0 and 2000

Unless you use Windows authentication you have no way of disabling
the login dialog box, if you are using SQL Analyzer by itself. It
is a entirely different tool which requires normal login & password
like any other client tool. One option is to use Enterprise Manager,
connect to the Server/database and try using the QA from the EM MMC
menu.

--
- Anith
(Please respond only to newsgroups)



Sat, 11 Jun 2005 01:47:22 GMT
 Screen of Logon of SQL SERVER 7.0 and 2000
You can use the command line options to pass the login name and password in
your shortcut to ISQL.
This is definately not recommended at all!  But it's possible.

How to log in to the default instance of SQL Server (Command Prompt)
To log in to the default instance of SQL Server

From a command prompt, enter either:
osql /U [login_id] /P [password] /S [servername]

-or-

isql/U [login_id]/P [password] /S [servername]


Quote:

> How do I do so that the screen of LOGON of SQL SERVER doesn't appear to
type
> password, when I am using QUERY ANALIZER??



Sat, 11 Jun 2005 02:44:23 GMT
 Screen of Logon of SQL SERVER 7.0 and 2000
From Command prompt
use isqlw -E  if you have windows authentication
otherwise
isqlw -U -P -S

as like your isql/osql command.

Naras


Quote:

> How do I do so that the screen of LOGON of SQL SERVER doesn't appear to
type
> password, when I am using QUERY ANALIZER??



Mon, 13 Jun 2005 07:31:05 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Update NT4.0 and SQL Server 7.0 to Windows 2000 and SQL Server 2000

2. SQL Server 2000 license overriding SQL Server 7.0 license on separate server

3. Installing SQL server 7.0 on a server with SQL server 2000

4. SQL Server 2000 and SAMBA 2.2.x unified logon

5. Eval Copy on XP: Cannot logon or Connect to Eval SQL Server 2000

6. Help: Can't logon to SQL server 2000

7. db_owner Role (SQL Server 7.0 v/s SQL Server 2000)

8. Migrating an SQL Server 7.0 database to an SQL Server 2000

9. SQL Server 7.0 and SQL Server 2000

10. Linking SQL Server version 7.0 to SQL Server 2000

11. SQL SERVER 7.0 TO SQL SERVER 2000

12. Downgrading from SQL Server 2000 to SQL Server 7.0


 
Powered by phpBB® Forum Software