February 5, 2014 at 7:32 am
A very silly question: :blush:
I just upgraded from SQL 2008 R2 to SQL 2012 and also installed Data Tools.
I tried to use it but the first thing is, off course, prompt me to select the server name and instance name to log in, which stalks me. (screenshot is attached in this post)
I then opened the configuration manager to see if I can find out and the screenshot is attached in this post.
What should I put in there as server name and instance name? If the screenshot doesn't reveal enough info, where can I find it?
Thanks lots.
February 5, 2014 at 8:04 am
To verify your instance name open SQL Server Configuration Manager -> SQL Server Services (left pane) -> Double click your SQL Server service -> Click on the Service tab and look at the Binary Path property. At the very end of that string you should see the -s with the name of your instance following. Hope that helps
February 5, 2014 at 8:57 am
This is what I have:
Binary Path: C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\bin\ReportingServicesService.exe
Host Name: TISR9C5N5V
Name: SQL Server Reporting Services (MSSQLSERVER)
What should then I use as Server Name? When I open up the Reporting Services Connection Manager, it prompts me for Server Name and Report Server Instance, in the Server Name, it is default to TISR9C5N5V which is the host name, but when I click on Find, it throws an error saying "No Report Servers were found"
When I originally installed the Reporting Server, I couldn't add it to existing instance, I ended up install it as a new instance.
Thanks.
February 5, 2014 at 9:04 am
The MSSQLSERVER in the service name shows it is a default instance, so you should just be able to put in the hostname of the server.
February 5, 2014 at 9:24 am
Maddave (2/5/2014)
The MSSQLSERVER in the service name shows it is a default instance, so you should just be able to put in the hostname of the server.
Unfortunately still not working!
I've attached a screenshot for your convenience
February 5, 2014 at 11:36 am
I resolved the issue by re-installed everything, thanks.
February 6, 2014 at 2:49 pm
select serverproperty('servername'), @@servername
Sometimes the two are different, BTW.
February 7, 2014 at 3:22 am
halifaxdal (2/5/2014)
Maddave (2/5/2014)
The MSSQLSERVER in the service name shows it is a default instance, so you should just be able to put in the hostname of the server.Unfortunately still not working!
I've attached a screenshot for your convenience
You supplied the instance name as the servername, this is incorrect.
Had you typed the actual computername and clicked find, you would have been able to select MSSQLSERVER in the DDL box.
You also have 3 named instances and one default instance of the SQL Server database engine installed as well as a default instance of Analysis services, do you plan to check these too?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 7, 2014 at 3:24 am
halifaxdal (2/5/2014)
I just upgraded from SQL 2008 R2 to SQL 2012 and also installed Data Tools.I tried to use it but the first thing is, off course, prompt me to select the server name and instance name to log in, which stalks me.
An upgrade does not change the computername or the sql server instance name(s) so whatever you typed before you would type again 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply