February 7, 2011 at 7:19 pm
Hi i had installed SQL server 2005 in my box but when i try to connect the default instance i am able to connect it thru IP address or by typing '.' but when i use the host name it is showing a error in connectivity wat could be the reason
Note: i am selecting the hostname by clicking the browse button in server name drop down
February 7, 2011 at 7:26 pm
connect using the ip or ".", then in a query run SELECT @@SERVERNAME.
is this name the same as your host?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 7, 2011 at 7:40 pm
Yes it is the same as the hostname..... i am getting a error like this "network related issue or instance specific error verify instance name is correct or it is allowed to establish a remote connections"
February 7, 2011 at 7:49 pm
What happens when you try with the full name (including the Domain)?
For E.g. ServerName.ad.dev
February 7, 2011 at 8:48 pm
still it is not connecting ... because of this my service pack installation is getting failed at authorization check
February 7, 2011 at 10:40 pm
are you sure you connecting to correct server or no one changed the name of the server using 'sp_dropserver and sp_addserver'.
The problem could be that someone chaged the server name to new name and when you running @@servername, its giving you the new name while in connection it will accept only the name which you provided during installation.
----------
Ashish
February 7, 2011 at 10:52 pm
is it possible to view the previous hostname declared while installation.....????? bcos of this my service pack installation is getting stopped....can you help me to get rid of this
February 7, 2011 at 11:00 pm
if you remember your old name then :-
1) open dos prompt (CMD)
2) type... sqlcmd -L > C:\serverlist.txt
3) Once it finish, go to your C drive and open serverlist.txt. You will see the servername there and will be able to see your real server name(if you remember) or if its not big list then you can try to connect on each one.
----------
Ashish
February 7, 2011 at 11:12 pm
it is listing only one server..."CMS" and that is wat i am trying connect and it fails
February 7, 2011 at 11:25 pm
if you connect your sql server from sqlcmd, are you getting any error:-
try with this syntax
sqlcmd -S yourservername -E
----------
Ashish
February 7, 2011 at 11:37 pm
I am getting the below error when i try executing the cmd
HResult 0x274C, Level 16, State 1
TCP Provider: A connection attempt failed because the connected party did not properly
respond after a period of time, or established connection failed because
connected host has failed to respond.
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.
Note : i have 1 aliases name in sql configuration manager i had furnished the details of that
aliases name : same as server name
Protocol : TCP/IP
Servername : Servername(hostname)
February 8, 2011 at 12:53 am
can you remove the alias or change it to something else.
As well can you see your server properties and it have 'Allow remote connection....' as enabled.
----------
Ashish
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply