 | |
Using SQLCMD to test Connection
microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients
 |
| | Thread Tools | Display Modes |
#41
 
| |||
| |||
|
Re: Using SQLCMD to test Connection -
03-03-2008
, 10:22 AM
|
Thanks all, but I still must be doing something wrong. I've switched SSMS into SQLCMD mode and tried running all of the following. .... Each of these generate the following error message: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'S'. |
SQLCMD is not a SQL command, it is an EXE file. Run it from a bat file.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Rubens" <rubensrose (AT) hotmail (DOT) com> wrote
Quote:
|
Thanks all, but I still must be doing something wrong. I've switched SSMS into SQLCMD mode and tried running all of the following. SQLCMD -Stcp:MIS-RROSE1 -E SQLCMD -S tcp:MIS-RROSE1 -E SQLCMD -S tcp:{MIS-RROSE1} -E SQLCMD -S tcp:[MIS-RROSE1] -E SQLCMD -SMIS-RROSE1 -E SQLCMD -S MIS-RROSE1 -E SQLCMD -S {MIS-RROSE1} -E SQLCMD -S [MIS-RROSE1] -E Each of these generate the following error message: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'S'. Any idea? FYI... the reason I had initially tested forcing tcp on port 1433 is I'd like to verify connectivity using this specific connection. And going forward, I'd like to be able to test this way if we change the default port. Thank-you, Rubens "Hans" <hansxlion (AT) hotmail (DOT) com> wrote in message news:2CD4AE4A-33C1-4341-A197-56AF30B930D9 (AT) microsoft (DOT) com... Hi, It should be like this: SQLCMD -S tcp:ServerName -E "Rubens" <Rubens (AT) discussions (DOT) microsoft.com> 写入消息 news:7C95C60D-3331-4481-9392-B9900CAB60C2 (AT) microsoft (DOT) com... I am using the following comand to test a SQL 2005 connection, but I seem to have the syntax incorrect. SQLCMD -Stcp:ServerName,1433 -E What am I doing wrong? Thanks, Rubens |
#42
| |||
| |||
|
|
Thanks all, but I still must be doing something wrong. I've switched SSMS into SQLCMD mode and tried running all of the following. ... Each of these generate the following error message: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'S'. Above is because you are connected to SQL Server from SSMS, and SQL Server expects a SQL command. SQLCMD is not a SQL command, it is an EXE file. Run it from a bat file. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Rubens" <rubensrose (AT) hotmail (DOT) com> wrote in message news:BEB5AF0C-B17A-4E4D-8DD7-1078827CE69A (AT) microsoft (DOT) com... Thanks all, but I still must be doing something wrong. I've switched SSMS into SQLCMD mode and tried running all of the following. SQLCMD -Stcp:MIS-RROSE1 -E SQLCMD -S tcp:MIS-RROSE1 -E SQLCMD -S tcp:{MIS-RROSE1} -E SQLCMD -S tcp:[MIS-RROSE1] -E SQLCMD -SMIS-RROSE1 -E SQLCMD -S MIS-RROSE1 -E SQLCMD -S {MIS-RROSE1} -E SQLCMD -S [MIS-RROSE1] -E Each of these generate the following error message: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'S'. Any idea? FYI... the reason I had initially tested forcing tcp on port 1433 is I'd like to verify connectivity using this specific connection. And going forward, I'd like to be able to test this way if we change the default port. Thank-you, Rubens "Hans" <hansxlion (AT) hotmail (DOT) com> wrote in message news:2CD4AE4A-33C1-4341-A197-56AF30B930D9 (AT) microsoft (DOT) com... Hi, It should be like this: SQLCMD -S tcp:ServerName -E "Rubens" <Rubens (AT) discussions (DOT) microsoft.com> 写入消息 news:7C95C60D-3331-4481-9392-B9900CAB60C2 (AT) microsoft (DOT) com... I am using the following comand to test a SQL 2005 connection, but I seem to have the syntax incorrect. SQLCMD -Stcp:ServerName,1433 -E What am I doing wrong? Thanks, Rubens |
#43
| |||
| |||
|
|
Thanks all, but I still must be doing something wrong. I've switched SSMS into SQLCMD mode and tried running all of the following. ... Each of these generate the following error message: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'S'. Above is because you are connected to SQL Server from SSMS, and SQL Server expects a SQL command. SQLCMD is not a SQL command, it is an EXE file. Run it from a bat file. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Rubens" <rubensrose (AT) hotmail (DOT) com> wrote in message news:BEB5AF0C-B17A-4E4D-8DD7-1078827CE69A (AT) microsoft (DOT) com... Thanks all, but I still must be doing something wrong. I've switched SSMS into SQLCMD mode and tried running all of the following. SQLCMD -Stcp:MIS-RROSE1 -E SQLCMD -S tcp:MIS-RROSE1 -E SQLCMD -S tcp:{MIS-RROSE1} -E SQLCMD -S tcp:[MIS-RROSE1] -E SQLCMD -SMIS-RROSE1 -E SQLCMD -S MIS-RROSE1 -E SQLCMD -S {MIS-RROSE1} -E SQLCMD -S [MIS-RROSE1] -E Each of these generate the following error message: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'S'. Any idea? FYI... the reason I had initially tested forcing tcp on port 1433 is I'd like to verify connectivity using this specific connection. And going forward, I'd like to be able to test this way if we change the default port. Thank-you, Rubens "Hans" <hansxlion (AT) hotmail (DOT) com> wrote in message news:2CD4AE4A-33C1-4341-A197-56AF30B930D9 (AT) microsoft (DOT) com... Hi, It should be like this: SQLCMD -S tcp:ServerName -E "Rubens" <Rubens (AT) discussions (DOT) microsoft.com> 写入消息 news:7C95C60D-3331-4481-9392-B9900CAB60C2 (AT) microsoft (DOT) com... I am using the following comand to test a SQL 2005 connection, but I seem to have the syntax incorrect. SQLCMD -Stcp:ServerName,1433 -E What am I doing wrong? Thanks, Rubens |
#44
| |||
| |||
|
|
Thanks all, but I still must be doing something wrong. I've switched SSMS into SQLCMD mode and tried running all of the following. ... Each of these generate the following error message: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'S'. Above is because you are connected to SQL Server from SSMS, and SQL Server expects a SQL command. SQLCMD is not a SQL command, it is an EXE file. Run it from a bat file. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Rubens" <rubensrose (AT) hotmail (DOT) com> wrote in message news:BEB5AF0C-B17A-4E4D-8DD7-1078827CE69A (AT) microsoft (DOT) com... Thanks all, but I still must be doing something wrong. I've switched SSMS into SQLCMD mode and tried running all of the following. SQLCMD -Stcp:MIS-RROSE1 -E SQLCMD -S tcp:MIS-RROSE1 -E SQLCMD -S tcp:{MIS-RROSE1} -E SQLCMD -S tcp:[MIS-RROSE1] -E SQLCMD -SMIS-RROSE1 -E SQLCMD -S MIS-RROSE1 -E SQLCMD -S {MIS-RROSE1} -E SQLCMD -S [MIS-RROSE1] -E Each of these generate the following error message: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'S'. Any idea? FYI... the reason I had initially tested forcing tcp on port 1433 is I'd like to verify connectivity using this specific connection. And going forward, I'd like to be able to test this way if we change the default port. Thank-you, Rubens "Hans" <hansxlion (AT) hotmail (DOT) com> wrote in message news:2CD4AE4A-33C1-4341-A197-56AF30B930D9 (AT) microsoft (DOT) com... Hi, It should be like this: SQLCMD -S tcp:ServerName -E "Rubens" <Rubens (AT) discussions (DOT) microsoft.com> 写入消息 news:7C95C60D-3331-4481-9392-B9900CAB60C2 (AT) microsoft (DOT) com... I am using the following comand to test a SQL 2005 connection, but I seem to have the syntax incorrect. SQLCMD -Stcp:ServerName,1433 -E What am I doing wrong? Thanks, Rubens |
#45
| |||
| |||
|
|
Thanks all, but I still must be doing something wrong. I've switched SSMS into SQLCMD mode and tried running all of the following. ... Each of these generate the following error message: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'S'. Above is because you are connected to SQL Server from SSMS, and SQL Server expects a SQL command. SQLCMD is not a SQL command, it is an EXE file. Run it from a bat file. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Rubens" <rubensrose (AT) hotmail (DOT) com> wrote in message news:BEB5AF0C-B17A-4E4D-8DD7-1078827CE69A (AT) microsoft (DOT) com... Thanks all, but I still must be doing something wrong. I've switched SSMS into SQLCMD mode and tried running all of the following. SQLCMD -Stcp:MIS-RROSE1 -E SQLCMD -S tcp:MIS-RROSE1 -E SQLCMD -S tcp:{MIS-RROSE1} -E SQLCMD -S tcp:[MIS-RROSE1] -E SQLCMD -SMIS-RROSE1 -E SQLCMD -S MIS-RROSE1 -E SQLCMD -S {MIS-RROSE1} -E SQLCMD -S [MIS-RROSE1] -E Each of these generate the following error message: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'S'. Any idea? FYI... the reason I had initially tested forcing tcp on port 1433 is I'd like to verify connectivity using this specific connection. And going forward, I'd like to be able to test this way if we change the default port. Thank-you, Rubens "Hans" <hansxlion (AT) hotmail (DOT) com> wrote in message news:2CD4AE4A-33C1-4341-A197-56AF30B930D9 (AT) microsoft (DOT) com... Hi, It should be like this: SQLCMD -S tcp:ServerName -E "Rubens" <Rubens (AT) discussions (DOT) microsoft.com> 写入消息 news:7C95C60D-3331-4481-9392-B9900CAB60C2 (AT) microsoft (DOT) com... I am using the following comand to test a SQL 2005 connection, but I seem to have the syntax incorrect. SQLCMD -Stcp:ServerName,1433 -E What am I doing wrong? Thanks, Rubens |
#46
| |||
| |||
|
|
Thanks all, but I still must be doing something wrong. I've switched SSMS into SQLCMD mode and tried running all of the following. ... Each of these generate the following error message: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'S'. Above is because you are connected to SQL Server from SSMS, and SQL Server expects a SQL command. SQLCMD is not a SQL command, it is an EXE file. Run it from a bat file. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Rubens" <rubensrose (AT) hotmail (DOT) com> wrote in message news:BEB5AF0C-B17A-4E4D-8DD7-1078827CE69A (AT) microsoft (DOT) com... Thanks all, but I still must be doing something wrong. I've switched SSMS into SQLCMD mode and tried running all of the following. SQLCMD -Stcp:MIS-RROSE1 -E SQLCMD -S tcp:MIS-RROSE1 -E SQLCMD -S tcp:{MIS-RROSE1} -E SQLCMD -S tcp:[MIS-RROSE1] -E SQLCMD -SMIS-RROSE1 -E SQLCMD -S MIS-RROSE1 -E SQLCMD -S {MIS-RROSE1} -E SQLCMD -S [MIS-RROSE1] -E Each of these generate the following error message: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'S'. Any idea? FYI... the reason I had initially tested forcing tcp on port 1433 is I'd like to verify connectivity using this specific connection. And going forward, I'd like to be able to test this way if we change the default port. Thank-you, Rubens "Hans" <hansxlion (AT) hotmail (DOT) com> wrote in message news:2CD4AE4A-33C1-4341-A197-56AF30B930D9 (AT) microsoft (DOT) com... Hi, It should be like this: SQLCMD -S tcp:ServerName -E "Rubens" <Rubens (AT) discussions (DOT) microsoft.com> 写入消息 news:7C95C60D-3331-4481-9392-B9900CAB60C2 (AT) microsoft (DOT) com... I am using the following comand to test a SQL 2005 connection, but I seem to have the syntax incorrect. SQLCMD -Stcp:ServerName,1433 -E What am I doing wrong? Thanks, Rubens |
#47
| |||
| |||
|
|
Thanks all, but I still must be doing something wrong. I've switched SSMS into SQLCMD mode and tried running all of the following. ... Each of these generate the following error message: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'S'. Above is because you are connected to SQL Server from SSMS, and SQL Server expects a SQL command. SQLCMD is not a SQL command, it is an EXE file. Run it from a bat file. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Rubens" <rubensrose (AT) hotmail (DOT) com> wrote in message news:BEB5AF0C-B17A-4E4D-8DD7-1078827CE69A (AT) microsoft (DOT) com... Thanks all, but I still must be doing something wrong. I've switched SSMS into SQLCMD mode and tried running all of the following. SQLCMD -Stcp:MIS-RROSE1 -E SQLCMD -S tcp:MIS-RROSE1 -E SQLCMD -S tcp:{MIS-RROSE1} -E SQLCMD -S tcp:[MIS-RROSE1] -E SQLCMD -SMIS-RROSE1 -E SQLCMD -S MIS-RROSE1 -E SQLCMD -S {MIS-RROSE1} -E SQLCMD -S [MIS-RROSE1] -E Each of these generate the following error message: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'S'. Any idea? FYI... the reason I had initially tested forcing tcp on port 1433 is I'd like to verify connectivity using this specific connection. And going forward, I'd like to be able to test this way if we change the default port. Thank-you, Rubens "Hans" <hansxlion (AT) hotmail (DOT) com> wrote in message news:2CD4AE4A-33C1-4341-A197-56AF30B930D9 (AT) microsoft (DOT) com... Hi, It should be like this: SQLCMD -S tcp:ServerName -E "Rubens" <Rubens (AT) discussions (DOT) microsoft.com> 写入消息 news:7C95C60D-3331-4481-9392-B9900CAB60C2 (AT) microsoft (DOT) com... I am using the following comand to test a SQL 2005 connection, but I seem to have the syntax incorrect. SQLCMD -Stcp:ServerName,1433 -E What am I doing wrong? Thanks, Rubens |
#48
| |||
| |||
|
|
Thanks all, but I still must be doing something wrong. I've switched SSMS into SQLCMD mode and tried running all of the following. ... Each of these generate the following error message: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'S'. Above is because you are connected to SQL Server from SSMS, and SQL Server expects a SQL command. SQLCMD is not a SQL command, it is an EXE file. Run it from a bat file. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Rubens" <rubensrose (AT) hotmail (DOT) com> wrote in message news:BEB5AF0C-B17A-4E4D-8DD7-1078827CE69A (AT) microsoft (DOT) com... Thanks all, but I still must be doing something wrong. I've switched SSMS into SQLCMD mode and tried running all of the following. SQLCMD -Stcp:MIS-RROSE1 -E SQLCMD -S tcp:MIS-RROSE1 -E SQLCMD -S tcp:{MIS-RROSE1} -E SQLCMD -S tcp:[MIS-RROSE1] -E SQLCMD -SMIS-RROSE1 -E SQLCMD -S MIS-RROSE1 -E SQLCMD -S {MIS-RROSE1} -E SQLCMD -S [MIS-RROSE1] -E Each of these generate the following error message: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'S'. Any idea? FYI... the reason I had initially tested forcing tcp on port 1433 is I'd like to verify connectivity using this specific connection. And going forward, I'd like to be able to test this way if we change the default port. Thank-you, Rubens "Hans" <hansxlion (AT) hotmail (DOT) com> wrote in message news:2CD4AE4A-33C1-4341-A197-56AF30B930D9 (AT) microsoft (DOT) com... Hi, It should be like this: SQLCMD -S tcp:ServerName -E "Rubens" <Rubens (AT) discussions (DOT) microsoft.com> 写入消息 news:7C95C60D-3331-4481-9392-B9900CAB60C2 (AT) microsoft (DOT) com... I am using the following comand to test a SQL 2005 connection, but I seem to have the syntax incorrect. SQLCMD -Stcp:ServerName,1433 -E What am I doing wrong? Thanks, Rubens |
#49
| |||
| |||
|
|
Thanks all, but I still must be doing something wrong. I've switched SSMS into SQLCMD mode and tried running all of the following. ... Each of these generate the following error message: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'S'. Above is because you are connected to SQL Server from SSMS, and SQL Server expects a SQL command. SQLCMD is not a SQL command, it is an EXE file. Run it from a bat file. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Rubens" <rubensrose (AT) hotmail (DOT) com> wrote in message news:BEB5AF0C-B17A-4E4D-8DD7-1078827CE69A (AT) microsoft (DOT) com... Thanks all, but I still must be doing something wrong. I've switched SSMS into SQLCMD mode and tried running all of the following. SQLCMD -Stcp:MIS-RROSE1 -E SQLCMD -S tcp:MIS-RROSE1 -E SQLCMD -S tcp:{MIS-RROSE1} -E SQLCMD -S tcp:[MIS-RROSE1] -E SQLCMD -SMIS-RROSE1 -E SQLCMD -S MIS-RROSE1 -E SQLCMD -S {MIS-RROSE1} -E SQLCMD -S [MIS-RROSE1] -E Each of these generate the following error message: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'S'. Any idea? FYI... the reason I had initially tested forcing tcp on port 1433 is I'd like to verify connectivity using this specific connection. And going forward, I'd like to be able to test this way if we change the default port. Thank-you, Rubens "Hans" <hansxlion (AT) hotmail (DOT) com> wrote in message news:2CD4AE4A-33C1-4341-A197-56AF30B930D9 (AT) microsoft (DOT) com... Hi, It should be like this: SQLCMD -S tcp:ServerName -E "Rubens" <Rubens (AT) discussions (DOT) microsoft.com> 写入消息 news:7C95C60D-3331-4481-9392-B9900CAB60C2 (AT) microsoft (DOT) com... I am using the following comand to test a SQL 2005 connection, but I seem to have the syntax incorrect. SQLCMD -Stcp:ServerName,1433 -E What am I doing wrong? Thanks, Rubens |
#50
| |||
| |||
|
|
Thanks all, but I still must be doing something wrong. I've switched SSMS into SQLCMD mode and tried running all of the following. ... Each of these generate the following error message: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'S'. Above is because you are connected to SQL Server from SSMS, and SQL Server expects a SQL command. SQLCMD is not a SQL command, it is an EXE file. Run it from a bat file. -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Rubens" <rubensrose (AT) hotmail (DOT) com> wrote in message news:BEB5AF0C-B17A-4E4D-8DD7-1078827CE69A (AT) microsoft (DOT) com... Thanks all, but I still must be doing something wrong. I've switched SSMS into SQLCMD mode and tried running all of the following. SQLCMD -Stcp:MIS-RROSE1 -E SQLCMD -S tcp:MIS-RROSE1 -E SQLCMD -S tcp:{MIS-RROSE1} -E SQLCMD -S tcp:[MIS-RROSE1] -E SQLCMD -SMIS-RROSE1 -E SQLCMD -S MIS-RROSE1 -E SQLCMD -S {MIS-RROSE1} -E SQLCMD -S [MIS-RROSE1] -E Each of these generate the following error message: Msg 102, Level 15, State 1, Line 1 Incorrect syntax near 'S'. Any idea? FYI... the reason I had initially tested forcing tcp on port 1433 is I'd like to verify connectivity using this specific connection. And going forward, I'd like to be able to test this way if we change the default port. Thank-you, Rubens "Hans" <hansxlion (AT) hotmail (DOT) com> wrote in message news:2CD4AE4A-33C1-4341-A197-56AF30B930D9 (AT) microsoft (DOT) com... Hi, It should be like this: SQLCMD -S tcp:ServerName -E "Rubens" <Rubens (AT) discussions (DOT) microsoft.com> 写入消息 news:7C95C60D-3331-4481-9392-B9900CAB60C2 (AT) microsoft (DOT) com... I am using the following comand to test a SQL 2005 connection, but I seem to have the syntax incorrect. SQLCMD -Stcp:ServerName,1433 -E What am I doing wrong? Thanks, Rubens |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.