Connect to Sql Server[vbcol=seagreen]
Connect using:
[ ] Window authentication
[ ] Sql Server authentication
Login Name : [____________]
Password : [____________]
----
--
I want to get the above senario for sql server name and connect using
different authentication from dos mode using Visual dialog script or winbatc
h
program.
Is there any way to get the following from dos prompt or using sql command
or using registry key --
* server name
* connect using >>>
*-- Window authentication
*-- Sql Server authentication
if Sql Server authentication
then check for user and password
--
Makes Yor Life Easy,MicrosoftHey i got it guys .,.,take it easy .,i found the way in osql
in command prompt type the following steps
if you want the connection in window authentication
c:\>osql -E -i *.txt -o *.txt -n -dmaster
if you want the connection in sql authentication
c:\>osql -U username
password :
> select * from master
>exit
Or
c:\>osql -Uusername -Ppassword -i *.txt -o *.txt -n -h-1 -dmaster
Makes Yor Life Easy,Microsoft
"MrRAO" wrote:
> Connect to Sql Server
> Connect using:
> [ ] Window authentication
> [ ] Sql Server authentication
> Login Name : [____________]
> Password : [____________]
> ----
--
> I want to get the above senario for sql server name and connect using
> different authentication from dos mode using Visual dialog script or winba
tch
> program.
> Is there any way to get the following from dos prompt or using sql command
> or using registry key --
> * server name
> * connect using >>>
> *-- Window authentication
> *-- Sql Server authentication
> if Sql Server authentication
> then check for user and password
> --
> Makes Yor Life Easy,Microsoft
Monday, March 19, 2012
need assistance on connecting to sql server
Labels:
assistance,
authentication91,
authenticationlogin,
connect,
connecting,
database,
microsoft,
mysql,
oracle,
server,
servervbcolseagreen,
sql,
using91,
window
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment