November 18, 2015 at 7:25 am
I inherited an application from a developer who left our company, so there are some details about the setup that I don't understand. There is a production sql 2012 server that appears to only have one instance on it:aaa-web1\sql_prod_01. SQL Installation manager discovery reports and sql configuration manager show the aaa-web1\sql_prod_01 instance and a sqlexpress instance; they don't show a default instance on aaa-web1
SSIS is installed on the aaa-web1. I am relatively new to SSIS but I now understand, I think, that "SSIS doesn't support multi-instance". So it looks like SSIS is setup on aaa-web1, not aaa-web1\sql_prod_01. But that's just SSIS not a database engine?
However, for some reason I can reference the databases that are stored on the aaa-web1\sql_prod_01 instance by connecting to aaa-web1. If I go into SSMS I can connect directly to aaa-web1 under "Integration Services", which makes sense. On the other hand, I can ALSO connect to aaa-web1 under Database Engine - in this case I can type cba-web1 directly in the dropdown text box and it connects to it. When I navigate through it I see the exact same databases and other objects that I see under aaa-web1\sql_prod_01. In fact if I create a new database on aaa-web1\sql_prod_01 it immediately shows up on aaa-web1. If, however, instead of typing the aaa-web1 directly into the dropdown text box I "browse for more", I only see aaa-web1\sql_prod_01 and aaa-web1\sqlexpress. On the attached screen shot you can see that If I right click on the aaa-web1 in SSMS and go to restart the service it says "are you sure you want to restart the service MSSQL$AAA_PROD_01 on aaa-web1" . If bring up the property page for aaa-web1 I see that the "name" is aaa-web1\sql_prod_01.
I can connect to both aaa-web1 and aaa-web1\sql_prod_01 via ODBC or programattically with connection strings.
On the aaa-web1 server in sql configuration manager there is an an alias aaa-web1\sqlprod. However there is not an alias from aaa-web1\sql_prod_01 to aaa-web1.
Can anyone explain to me why I see the reference to aaa-web1\sql_prod_01 duplicated as aaa-web1?
Thanks.
November 18, 2015 at 8:25 am
November 18, 2015 at 8:34 am
What do you see when you execute select @@servername from both the instances. I think they both pointing to same instance.
Edit: I mean some alias name
November 18, 2015 at 8:35 am
In the port config for the instance in config manager do you happen to have a default port 1433 and a dynamic port assigned?
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 18, 2015 at 9:11 am
My money is on port 1433. I often use this technique.
mark.williams 37494 (11/18/2015)
In the port config for the instance in config manager do you happen to have a default port 1433 and a dynamic port assigned?
-- Gianluca Sartori
November 18, 2015 at 9:12 am
joeroshan (11/18/2015)
What do you see when you execute select @@servername from both the instances. I think they both pointing to same instance.Edit: I mean some alias name
servername servicename
AAA-WEB1\AAA_SQL_PROD_01AAA_SQL_PROD_01
for both AAA-WEB1 and AAA-WEB1\AAA-SQL_PROD_01
So my question is why, when there is no alias.
November 18, 2015 at 9:20 am
MadAdmin (11/18/2015)
Can you list the SQL services you have as well as whether they are running or not.
Here is a screen shot of the services. Note that where I refer to 'AAA-WEB1', AAA refers to a our company name, which is actually not AAA, so I am blanking it out for confidentiality reasons.
November 18, 2015 at 9:25 am
itguy2015 (11/18/2015)
MadAdmin (11/18/2015)
Can you list the SQL services you have as well as whether they are running or not.Here is a screen shot of the services. Note that where I refer to 'AAA-WEB1', AAA refers to a our company name, which is actually not AAA, so I am blanking it out for confidentiality reasons.
other than your express instance you definitely only have one other. Can you scroll up and answer my question regarding your port listeners for the instance
_________________________________________________________________
"The problem with internet quotes is that you cant always depend on their accuracy" -Abraham Lincoln, 1864
November 18, 2015 at 9:39 am
mark.williams 37494 (11/18/2015)
In the port config for the instance in config manager do you happen to have a default port 1433 and a dynamic port assigned?
I went to the network configuration/protocols for the instance/tcp/ip/properties - I don't have much familiarity with the details on this, but I think that's what you are looking for.
There are 4 IP addresses and then an "IPAll" with various combinations for port number, dynamic ports, ip4 or ip6 address. I've attached screen shots. What does this tell me?
November 18, 2015 at 9:40 am
mark.williams 37494 (11/18/2015)
In the port config for the instance in config manager do you happen to have a default port 1433 and a dynamic port assigned?
forgot the attachments on last post
November 18, 2015 at 9:49 am
itguy2015 (11/18/2015)
MadAdmin (11/18/2015)
Can you list the SQL services you have as well as whether they are running or not.Here is a screen shot of the services. Note that where I refer to 'AAA-WEB1', AAA refers to a our company name, which is actually not AAA, so I am blanking it out for confidentiality reasons.
It is definitely some sort of alias to me, please do a ping both server and see what is the IP. If it is from just one server you are seeing this behavior, I think some one would have added an alias in the host file, if you can reach from the entire network, probably chase your DNS admin.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply