Hello,
For various reasons our default web site is not listening on port 80, but
81. The installation of Reporting Services went OK and I can do all
administration from the browser. Ie., everything seems OK with the
installation.
However, Visual Studio does not manage to connect to the reportserver for
deployment of reports.
How can I make VS connect?
Is there any other way to deploy reports?
Best regards,
VemundHello again,
Found the answer myself after some research.
Visual Studio doesn't manage to connect to the webserver when the
TargetServerURL is written with an IP address, eg.
http://10.0.0.1:81/ReportServer.
The solution to this was to add an entry in the hosts file as '10.0.0.1
OurReportServer'. Then the TargetServerURL in VS was entered as
http://OurReportServer:81/ReportServer and the deployment went without a
hitch.
Instead of using the hosts file, this should of course be entered into the
local DNS.
Best regards,
Vemund
"Vemund Haga" <vemund.haga@.nospam.nospam> wrote in message
news:%23ZYGIH%23kEHA.1644@.tk2msftngp13.phx.gbl...
> Hello,
> For various reasons our default web site is not listening on port 80, but
> 81. The installation of Reporting Services went OK and I can do all
> administration from the browser. Ie., everything seems OK with the
> installation.
> However, Visual Studio does not manage to connect to the reportserver for
> deployment of reports.
> How can I make VS connect?
> Is there any other way to deploy reports?
> Best regards,
> Vemund
>
Showing posts with label port. Show all posts
Showing posts with label port. Show all posts
Saturday, February 25, 2012
Tuesday, February 14, 2012
Default port problem
My default port was of course 1433. I recently changed to to 5 digit number
but had some problems with it in Delphi. So I changed it back. Now I can't
get EM to connect. I looked at the db registration settings but nothing in
there about port #. How do I get EM to work again? Also, now it seems that
to run QA I have to include 1433 in the server name when I open up QA
outside of EM. I never had to do that before. Why would this change and how
do I get it back to the way it was (without reinstalling MS SQL 2k).
Thanks,
KeithHi Keith,
On the machine running SQL server go under Programs->Microsoft SQL Server
and run both the Client Network Utility and the Server Network utility. In
both of these, select TCP/IP and select properties. Make sure the port
numbers in both match.
You should then (if possible) restart your SQL service.
If you're still having problems, go back into the mentionned utilities and
look at the preference order of each of the protocols. Let me know what the
order in each is, and I'll try to help further!
Adam
--
Adam J Warne, MCDBA
"Keith G Hicks" wrote:
> My default port was of course 1433. I recently changed to to 5 digit numbe
r
> but had some problems with it in Delphi. So I changed it back. Now I can't
> get EM to connect. I looked at the db registration settings but nothing in
> there about port #. How do I get EM to work again? Also, now it seems that
> to run QA I have to include 1433 in the server name when I open up QA
> outside of EM. I never had to do that before. Why would this change and ho
w
> do I get it back to the way it was (without reinstalling MS SQL 2k).
> Thanks,
> Keith
>
>|||That helped a lot. Thanks :-).
"Adam Warne" <AdamWarne@.discussions.microsoft.com> wrote in message
news:61D96FFA-B230-42B9-AF1E-C8C10F1187A5@.microsoft.com...
Hi Keith,
On the machine running SQL server go under Programs->Microsoft SQL Server
and run both the Client Network Utility and the Server Network utility. In
both of these, select TCP/IP and select properties. Make sure the port
numbers in both match.
You should then (if possible) restart your SQL service.
If you're still having problems, go back into the mentionned utilities and
look at the preference order of each of the protocols. Let me know what the
order in each is, and I'll try to help further!
Adam
--
Adam J Warne, MCDBA
"Keith G Hicks" wrote:
> My default port was of course 1433. I recently changed to to 5 digit
number
> but had some problems with it in Delphi. So I changed it back. Now I can't
> get EM to connect. I looked at the db registration settings but nothing in
> there about port #. How do I get EM to work again? Also, now it seems that
> to run QA I have to include 1433 in the server name when I open up QA
> outside of EM. I never had to do that before. Why would this change and
how
> do I get it back to the way it was (without reinstalling MS SQL 2k).
> Thanks,
> Keith
>
>|||Hi Adam,
I recently changed my default port settings as well and have followed all
the advice that's available, but I have had no luck connecting through my
development platform - Delphi. Things worked fine until I changed port
settings. Is there somewhere else to check for settings, such as the
registry, that could be causing problems? I'm also hearing that different
versions of MDAC are producing varying results in Delphi.
Bill
"Adam Warne" <AdamWarne@.discussions.microsoft.com> wrote in message
news:61D96FFA-B230-42B9-AF1E-C8C10F1187A5@.microsoft.com...
> Hi Keith,
> On the machine running SQL server go under Programs->Microsoft SQL Server
> and run both the Client Network Utility and the Server Network utility.
> In
> both of these, select TCP/IP and select properties. Make sure the port
> numbers in both match.
> You should then (if possible) restart your SQL service.
> If you're still having problems, go back into the mentionned utilities and
> look at the preference order of each of the protocols. Let me know what
> the
> order in each is, and I'll try to help further!
> Adam
> --
> Adam J Warne, MCDBA
>
> "Keith G Hicks" wrote:
>
but had some problems with it in Delphi. So I changed it back. Now I can't
get EM to connect. I looked at the db registration settings but nothing in
there about port #. How do I get EM to work again? Also, now it seems that
to run QA I have to include 1433 in the server name when I open up QA
outside of EM. I never had to do that before. Why would this change and how
do I get it back to the way it was (without reinstalling MS SQL 2k).
Thanks,
KeithHi Keith,
On the machine running SQL server go under Programs->Microsoft SQL Server
and run both the Client Network Utility and the Server Network utility. In
both of these, select TCP/IP and select properties. Make sure the port
numbers in both match.
You should then (if possible) restart your SQL service.
If you're still having problems, go back into the mentionned utilities and
look at the preference order of each of the protocols. Let me know what the
order in each is, and I'll try to help further!
Adam
--
Adam J Warne, MCDBA
"Keith G Hicks" wrote:
> My default port was of course 1433. I recently changed to to 5 digit numbe
r
> but had some problems with it in Delphi. So I changed it back. Now I can't
> get EM to connect. I looked at the db registration settings but nothing in
> there about port #. How do I get EM to work again? Also, now it seems that
> to run QA I have to include 1433 in the server name when I open up QA
> outside of EM. I never had to do that before. Why would this change and ho
w
> do I get it back to the way it was (without reinstalling MS SQL 2k).
> Thanks,
> Keith
>
>|||That helped a lot. Thanks :-).
"Adam Warne" <AdamWarne@.discussions.microsoft.com> wrote in message
news:61D96FFA-B230-42B9-AF1E-C8C10F1187A5@.microsoft.com...
Hi Keith,
On the machine running SQL server go under Programs->Microsoft SQL Server
and run both the Client Network Utility and the Server Network utility. In
both of these, select TCP/IP and select properties. Make sure the port
numbers in both match.
You should then (if possible) restart your SQL service.
If you're still having problems, go back into the mentionned utilities and
look at the preference order of each of the protocols. Let me know what the
order in each is, and I'll try to help further!
Adam
--
Adam J Warne, MCDBA
"Keith G Hicks" wrote:
> My default port was of course 1433. I recently changed to to 5 digit
number
> but had some problems with it in Delphi. So I changed it back. Now I can't
> get EM to connect. I looked at the db registration settings but nothing in
> there about port #. How do I get EM to work again? Also, now it seems that
> to run QA I have to include 1433 in the server name when I open up QA
> outside of EM. I never had to do that before. Why would this change and
how
> do I get it back to the way it was (without reinstalling MS SQL 2k).
> Thanks,
> Keith
>
>|||Hi Adam,
I recently changed my default port settings as well and have followed all
the advice that's available, but I have had no luck connecting through my
development platform - Delphi. Things worked fine until I changed port
settings. Is there somewhere else to check for settings, such as the
registry, that could be causing problems? I'm also hearing that different
versions of MDAC are producing varying results in Delphi.
Bill
"Adam Warne" <AdamWarne@.discussions.microsoft.com> wrote in message
news:61D96FFA-B230-42B9-AF1E-C8C10F1187A5@.microsoft.com...
> Hi Keith,
> On the machine running SQL server go under Programs->Microsoft SQL Server
> and run both the Client Network Utility and the Server Network utility.
> In
> both of these, select TCP/IP and select properties. Make sure the port
> numbers in both match.
> You should then (if possible) restart your SQL service.
> If you're still having problems, go back into the mentionned utilities and
> look at the preference order of each of the protocols. Let me know what
> the
> order in each is, and I'll try to help further!
> Adam
> --
> Adam J Warne, MCDBA
>
> "Keith G Hicks" wrote:
>
default port of MSDE
I know default port of MSSQL is 1433, but how about MSDE? How to change the
port no (if any)?
Million Thanks
Hi,
The default port for MSDE is 1433. You could change the port number by
running "svrnetcn.exe"
Thanks
Hari
MCDBA
"Grey" <erickwyum@.i-cable.com> wrote in message
news:#taJDibhEHA.216@.tk2msftngp13.phx.gbl...
> I know default port of MSSQL is 1433, but how about MSDE? How to change
the
> port no (if any)?
> Million Thanks
>
|||I thought that it picked whatever port number wasn't in use whenever it
started up? Or is that only for named instances? I don't think mine is ever
configured to use 1433 by itself.
"Hari Prasad" wrote:
> Hi,
> The default port for MSDE is 1433. You could change the port number by
> running "svrnetcn.exe"
> Thanks
> Hari
> MCDBA
>
>
> "Grey" <erickwyum@.i-cable.com> wrote in message
> news:#taJDibhEHA.216@.tk2msftngp13.phx.gbl...
> the
>
>
|||Andrew,
MSDE uses port 1433 by default. This can be changed by server network
utility to use any port that you want on startup. Named instances TCP port
is dynamic. You can see what port it used by looking in the SQL Server
Error log of that particular instance when Instance is running.
-Tom
Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.
port no (if any)?
Million Thanks
Hi,
The default port for MSDE is 1433. You could change the port number by
running "svrnetcn.exe"
Thanks
Hari
MCDBA
"Grey" <erickwyum@.i-cable.com> wrote in message
news:#taJDibhEHA.216@.tk2msftngp13.phx.gbl...
> I know default port of MSSQL is 1433, but how about MSDE? How to change
the
> port no (if any)?
> Million Thanks
>
|||I thought that it picked whatever port number wasn't in use whenever it
started up? Or is that only for named instances? I don't think mine is ever
configured to use 1433 by itself.
"Hari Prasad" wrote:
> Hi,
> The default port for MSDE is 1433. You could change the port number by
> running "svrnetcn.exe"
> Thanks
> Hari
> MCDBA
>
>
> "Grey" <erickwyum@.i-cable.com> wrote in message
> news:#taJDibhEHA.216@.tk2msftngp13.phx.gbl...
> the
>
>
|||Andrew,
MSDE uses port 1433 by default. This can be changed by server network
utility to use any port that you want on startup. Named instances TCP port
is dynamic. You can see what port it used by looking in the SQL Server
Error log of that particular instance when Instance is running.
-Tom
Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to:
Posts (Atom)