May 13, 2010 at 8:03 pm
Hello,
First and foremost thatnks for your time and efforts in hopefully helping me solve the situation i have below.
The problem is i am not able to connect remotely to the named instance on this particualr server. I have made sure the SQL Browser Services are running as i have read in a couple of other blogs on the site. I have made sure all the "remote" connection areas have been set properly to allow these types of connections and restarted the services /reboot many times to no avail. The following is the successful connection to the default instance with the named instance below that errored out. Any ideas would be greatful.
Thanks Again...
bash-3.2$ sqlcmd -S tcp:wcosdbm2,1433 -d master -E /Q sp_spaceused
database_name database_size unallocatedspace
------------------------------------------------------------------------------------
master 4.75 MB 1.30 MB
reserved data index_size unused
------------------ ------------------ ------------------ ------------------
2768 KB 1096 KB 1072 KB 600 KB
bash-3.2$ sqlcmd -S tcp:wcosdbm2\scomsupt,1433 -d master -E /Q sp_spaceused
HResult 0x2AF9, Level 16, State 1
TCP Provider: No such host is known.
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re may be caused by the fact that under the default settings SQL Server does not
allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
bash-3.2$
DHeath
May 13, 2010 at 11:05 pm
The issue was that the named instance needs to be on a separate port and then you are able to connect. example below
bash-3.2$ sqlcmd -S tcp:wcosdbm2,1400 -d scom_support -E /Q sp_spaceused
database_name database_size unallocated space
--------------------------------------------------------------------------------
scom_support 3.00 MB 0.89 MB
reserved data index_size unused
------------------ ------------------ ------------------ ------------------
1136 KB 488 KB 560 KB 88 KB
Thanks to all that read and spent time here.. much appreciated.. =]
DHeath
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply