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
venkatesh ksAsked:
Who is Participating?
 
QlemoConnect With a Mentor Batchelor, Developer and EE Topic AdvisorCommented:
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
 
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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Rgonzo1971Commented:
and with
-noSplash
0
 
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
 
Rgonzo1971Connect With a Mentor Commented:
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
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.