• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 86
  • Last Modified:

How to open sql server management studio by using sql server authenticaion by using vba

Hi Experts,

I am using below code to open ssms by using windows authenticion. But how can i open ssms by using sql server authenticaion via vba. Please anyone tell me the solution.

 Sub Open_ModScript()
    Dim rc
       rc = Shell("ssms.exe -S CHNMCT123456D -d sample -E ")
End Sub

Thanks
0
venkatesh ks
Asked:
venkatesh ks
  • 8
  • 6
  • 2
2 Solutions
 
Rgonzo1971Commented:
Hi,

Maybe
 
Sub Open_ModScript()
     Dim rc
        rc = Shell("ssms.exe -S CHNMCT123456D -d sample -U theUser -P thePW")
 End Sub

Open in new window

Regards
0
 
venkatesh ksAuthor Commented:
Hi,

That code is not working.  I replaced theuser as username, the PW as password. But ssms show dialog box which contain usage.
0
 
Rgonzo1971Commented:
and with
-noSplash
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
venkatesh ksAuthor Commented:
it shows

ssms.exe [-S servername[\instance_name]][-d database][-U user] [-p password] [-E] [-nosplash] [file_name[,file_name]*][-log [file_name]?][?]


and gives meaning from -s to.....[?]
0
 
venkatesh ksAuthor Commented:
HI Rgonzo1971,

I am new for this VB macros. If you give code , i will check it.
0
 
Rgonzo1971Commented:
Didn't quite understand
0
 
Rgonzo1971Commented:
Sub Open_ModScript()
     Dim rc
        rc = Shell("ssms.exe -S CHNMCT123456D -d sample -U theUser -P thePW -nosplash" )
 End Sub

Open in new window

0
 
QlemoC++ DeveloperCommented:
The syntax description shows a lower case -p for the password parameter.
Sub Open_ModScript()
     Dim rc
        rc = Shell("ssms.exe -S CHNMCT123456D -d sample -U theUser -p thePW -nosplash" )
 End Sub

Open in new window

0
 
venkatesh ksAuthor Commented:
in the above code i replaced my server name, database name, userid and password of the server. But it should not work. Sql server management studio shows a dialog box of usage. The usage box contain below code as,

"ssms.exe [-S servername[\instance_name]][-d database][-U user] [-p password] [-E] [-nosplash] [file_name[,file_name]*][-log [file_name]?][?]

[-S the name of the sql server instance to connect to]
...............
..............
[?] displays this usage information"

But the SSMS is not opening automatically by run this vb
0
 
Rgonzo1971Commented:
Sorry can't help further
0
 
venkatesh ksAuthor Commented:
Hello Rgonzo1971,

Do you know how to import xlcsv file into sql server by using VB?
0
 
Rgonzo1971Commented:
Nope
0
 
venkatesh ksAuthor Commented:
Ok
0
 
venkatesh ksAuthor Commented:
Thank You
0
 
QlemoC++ DeveloperCommented:
Just tested with SSMS 2016 from the cmdline, and it works for me as expected. Even if the DB is wrong (does not exist), SSMS opens up with a connected query window.
0
 
venkatesh ksAuthor Commented:
Hi Qlemo,

How to upload xlcsv file in SSMS by using VB?
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 8
  • 6
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now