Showing posts with label non-default. Show all posts
Showing posts with label non-default. Show all posts

Tuesday, March 20, 2012

Non-Default SQL Server Port

Using Visual Studio .NET 2005 and I cannot make a database connection in sever explorer to a SQL server that listens on a non-default port. I can do this with VS .NET 2003, but not 2005. Please assist.Please help on this.|||

What is the version of the SQL Server?

Does the SQL Server and the connection application run on the same machine or on two different machines?

What protocols are enabled on the SQL Server?

What connection string does the application use?

Depending on your connection string you may need to start the SQL Browser service on the machine running SQL Server.

|||

SQL Server 2000
SQL Server 2000 and Visual Studio .NET 2005 are on seperate boxes.
SQL Server is listening on a non-default port (9696).
Just trying to connect to the database in server explorer.

Non-default IIS Web site

Hi,
Can I install reporting service to non-default IIS Web site?
If Yes, How?
Thanks.
SaraNope.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Sara" <Sara@.discussions.microsoft.com> wrote in message
news:6D63FBB0-77A0-4042-9392-25CA9FF9AAE5@.microsoft.com...
> Hi,
> Can I install reporting service to non-default IIS Web site?
> If Yes, How?
> Thanks.
> Sara|||I should add that you might be able to do this with SQL 2005, if the
standalone reporting options work as I understand them being described.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:O0%23uyZP9EHA.3260@.TK2MSFTNGP14.phx.gbl...
> Nope.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Sara" <Sara@.discussions.microsoft.com> wrote in message
> news:6D63FBB0-77A0-4042-9392-25CA9FF9AAE5@.microsoft.com...
>> Hi,
>> Can I install reporting service to non-default IIS Web site?
>> If Yes, How?
>> Thanks.
>> Sara
>|||This is a multi-part message in MIME format.
--=_NextPart_000_0018_01C4F4D3.BC870AA0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
I don't think you can but I have been wrong before...
What we do instead is enable Default Web, install RS to it, then move =them to our other site. One thing to watch out for (on Windows Server =2003) is ensuring that you add the aspnet_isapi library for =ReportServer. We spent a few days looking at everything but that at one =point in time...
-- TIM ELLISON
"Sara" <Sara@.discussions.microsoft.com> wrote in message =news:6D63FBB0-77A0-4042-9392-25CA9FF9AAE5@.microsoft.com...
Hi,
Can I install reporting service to non-default IIS Web site?
If Yes, How?
Thanks.
Sara
--=_NextPart_000_0018_01C4F4D3.BC870AA0
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

I don't think you can but I have been =wrong before...
What we do instead is enable Default =Web, install RS to it, then move them to our other site. One thing to watch out =for (on Windows Server 2003) is ensuring that you add the aspnet_isapi library =for ReportServer. We spent a few days looking at everything but that =at one point in time...
-- TIM ELLISON
"Sara" wrote in message news:6D6=3FBB0-77A0-4042-9392-25CA9FF9AAE5@.microsoft.com...Hi,Ca=n I install reporting service to non-default IIS Web site?If Yes, How?Thanks.Sara

--=_NextPart_000_0018_01C4F4D3.BC870AA0--|||This is a multi-part message in MIME format.
--=_NextPart_000_005E_01C4F7F9.C4BF5F50
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
You can do that easily. Try to look at this site, they explain how to =move reporting services' Virtual directory very well. =http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C34674.scuk=
good Luck!!
"Tim Ellison" <TimEllison@.direcway.com> a =C3=A9crit dans le message =de news:OZHlm2P9EHA.2196@.TK2MSFTNGP11.phx.gbl...
I don't think you can but I have been wrong before...
What we do instead is enable Default Web, install RS to it, then move =them to our other site. One thing to watch out for (on Windows Server =2003) is ensuring that you add the aspnet_isapi library for =ReportServer. We spent a few days looking at everything but that at one =point in time...
-- TIM ELLISON
"Sara" <Sara@.discussions.microsoft.com> wrote in message =news:6D63FBB0-77A0-4042-9392-25CA9FF9AAE5@.microsoft.com...
Hi,
Can I install reporting service to non-default IIS Web site?
If Yes, How?
Thanks.
Sara
--=_NextPart_000_005E_01C4F7F9.C4BF5F50
Content-Type: text/html;
charset="Utf-8"
Content-Transfer-Encoding: quoted-printable
=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

You can do that easily. Try to look at this site, they explain how to move reporting services' =Virtual directory very well. http://www.sqljunkies.com/HowTo/525B575A-7F61-483A-AC8F-FEC700C=34674.scuk
good Luck!!
"Tim Ellison" =a =C3=A9crit dans le message de news:OZHlm2P9EHA.2196=@.TK2MSFTNGP11.phx.gbl...
I don't think you can but I have been =wrong before...

What we do instead is enable Default =Web, install RS to it, then move them to our other site. One thing to watch =out for (on Windows Server 2003) is ensuring that you add the aspnet_isapi =library for ReportServer. We spent a few days looking at everything but that =at one point in time...
-- TIM ELLISON
"Sara" wrote in message news:6D6=3FBB0-77A0-4042-9392-25CA9FF9AAE5@.microsoft.com...Hi,Ca=n I install reporting service to non-default IIS Web site?If Yes, =How?Thanks.Sara

--=_NextPart_000_005E_01C4F7F9.C4BF5F50--