preconfigure port number while command line installing

Hi,

I want set a specific port number of SQL Server(express) during installation not by Configuration Manager after install.
Is it possible?

hi,

probably becouse of the multi instances support of SQL Server up to version 2000, which introduced the SQL Server Resolution Service listening on UDP 1434, now SQLBrowser, this feature has been removed from the configurable settings..

but you can interact via SMO as well, but probably after your installer has finished..

regards

PRB SQL Express Installation not installing Manager

PRB SQL Express Installation not installing Manager.
Please help,
We are trying to work with SQL Server Express 2005, but we are having
several installation problems.
#1) Despite all efforts, the Database Manager program (ssmsee.exe) is NOT
being installed on some XP-Pro machines even though the user has FULL admin
right (and then some) to their machine. And the machine is fully 100% updated
with all MS patches, including IE 7. This includes many uninstall-reinstall
efforts.
#2) On some machines that HAD the Database MAnager, the user logs in, and
then suddenly it is GONE. The file and the short cut link.
#3) We need a profiler tool like SQL Server's 2000 Profiler which worked on
MSDE, but does not seem to be able to work on SQL Express 2005.
Thank you for the reply,
You have answered 1 and 2 through that link. Basically to explain 1 and 2 in
other words. We installed SQL Express 2005 and it DID install the management
tool, the same one that is in that link you provided. But it did not do this
on every machine. And on some machine, after a few days, it disappeared. And
no matter what we tried to do on the machines that never got it, or once had
it, we could never get it again. From this, I would have to say, that perhaps
the SQL Express 2005 installer has some bug that is making it install the
manager tool either from itself, or maybe the web, some of the time, and then
perhaps removing it from the SQL Server Express 2005 service. As nothing else
can explain this behavior. We have tested this out over 7 machines, including
2 of which were Windows 2000. Strangely, the Windows 2000 machines were the
only one to get the manager tool and keep them so far.
As for the #3, can one use the SQL Server 2000 profiler with a SQL Express
2005 database? Once upon a time, with MSDE, one could do that.
|||ONLY if you have a legitimately purchased and licensed copy of SQL Server
which gives you license to use Profiler.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"ATS" <ATS@.discussions.microsoft.com> wrote in message
news:94AFAA47-854B-493C-A6E8-3C9CFA365FFF@.microsoft.com...
> Thank you for the reply,
> You have answered 1 and 2 through that link. Basically to explain 1 and 2
> in
> other words. We installed SQL Express 2005 and it DID install the
> management
> tool, the same one that is in that link you provided. But it did not do
> this
> on every machine. And on some machine, after a few days, it disappeared.
> And
> no matter what we tried to do on the machines that never got it, or once
> had
> it, we could never get it again. From this, I would have to say, that
> perhaps
> the SQL Express 2005 installer has some bug that is making it install the
> manager tool either from itself, or maybe the web, some of the time, and
> then
> perhaps removing it from the SQL Server Express 2005 service. As nothing
> else
> can explain this behavior. We have tested this out over 7 machines,
> including
> 2 of which were Windows 2000. Strangely, the Windows 2000 machines were
> the
> only one to get the manager tool and keep them so far.
> As for the #3, can one use the SQL Server 2000 profiler with a SQL Express
> 2005 database? Once upon a time, with MSDE, one could do that.

Possible to Export EM SQL Registrations?

I have a development laptop that I frequently need to reimage (ghost). I have about 25 SQL Servers registered in Enterprise Manager. Some use Windows Auth, some SQL Auth. Can I export the registration information so I don’t have to re-enter it every
time I rebuild my laptop?
I have been able to export/import the server aliases using this key (this works fine): [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer \Client\ConnectTo]
I have also exported/imported: [HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X]
But All I get are the groups, no servers.
TIA
Hi TIA,
I have noticed you posted another issue with topic "Export/Import SQL EM
Registrations?", I will add a reply to that thread. If you have any further
question, please post there and I will be glad to follow up
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Microsoft Developer Community Support
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Thanks, yea I got an error while posting... could not tell if the post wet through.
Thanks!
""Mingqing Cheng [MSFT]"" wrote:

> Hi TIA,
> I have noticed you posted another issue with topic "Export/Import SQL EM
> Registrations?", I will add a reply to that thread. If you have any further
> question, please post there and I will be glad to follow up
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Microsoft Developer Community Support
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>

Possible to download Enterprise Manager?

Does anyone know if it is possible to download Enterprise Manager?

ThanksNo. However, you can get the developers edition quite cheaply.

Amazon has it for $42.

Possible SOAP version mismatch

Hi,
I am getting an error when I go to view my websites Report Manager. i go to
http://www.mysite.com/Reports (reports maps to the Report Manager folder).
when ever i go there i keep getting some generic Error Page. the only
information it has on there is: Possible SOAP version mismatch: Envelope
namespace http://schemas.xmlsoap.org/wsdl/ was unexpected. Expecting
http://schemas.xmlsoap.org/soap/envelope/.
I dont know how this has happened. Can anyone help me?
Thank you,
PaulHave you come up with a solution yet?
I have the same error. I had installed the Enterprise version of RS with
the database and report manager on one server - and applied SP1. I then
installed the Enterprise RS Report Manger on another machine and am using the
first server's SQL Server to house another instance of the Report Server DB.
Once installed, I get the 'SOAP version mismatch' error when trying to view
the Report Manager.
I tried upgrading to SP1, but still get the error. Anyone see this issue
before?
"Paul W" wrote:
> Hi,
> I am getting an error when I go to view my websites Report Manager. i go to
> http://www.mysite.com/Reports (reports maps to the Report Manager folder).
> when ever i go there i keep getting some generic Error Page. the only
> information it has on there is: Possible SOAP version mismatch: Envelope
> namespace http://schemas.xmlsoap.org/wsdl/ was unexpected. Expecting
> http://schemas.xmlsoap.org/soap/envelope/.
> I dont know how this has happened. Can anyone help me?
> Thank you,
> Paul
>
>|||I also have the same error. Were you able to find out what the answer is?
If you haven't I'll break down and pay Microsoft for the answer and then post
it here. Can you please reply.
"Paul W" wrote:
> Hi,
> I am getting an error when I go to view my websites Report Manager. i go to
> http://www.mysite.com/Reports (reports maps to the Report Manager folder).
> when ever i go there i keep getting some generic Error Page. the only
> information it has on there is: Possible SOAP version mismatch: Envelope
> namespace http://schemas.xmlsoap.org/wsdl/ was unexpected. Expecting
> http://schemas.xmlsoap.org/soap/envelope/.
> I dont know how this has happened. Can anyone help me?
> Thank you,
> Paul
>
>|||I had some other staff work this issue out on the server side and will need
to double check with them for the exact solution. But, if I remember
correctly, it had something to do with the server name being uppercase - but
RS was trying to access it using all lowercase letters (or vice versa).
I'll see if I can get the exact story posted.
-mike
"Shane McEwan" wrote:
> I also have the same error. Were you able to find out what the answer is?
> If you haven't I'll break down and pay Microsoft for the answer and then post
> it here. Can you please reply.
> "Paul W" wrote:
> > Hi,
> > I am getting an error when I go to view my websites Report Manager. i go to
> > http://www.mysite.com/Reports (reports maps to the Report Manager folder).
> > when ever i go there i keep getting some generic Error Page. the only
> > information it has on there is: Possible SOAP version mismatch: Envelope
> > namespace http://schemas.xmlsoap.org/wsdl/ was unexpected. Expecting
> > http://schemas.xmlsoap.org/soap/envelope/.
> >
> > I dont know how this has happened. Can anyone help me?
> > Thank you,
> > Paul
> >
> >
> >

Possible BUG: SP2 Printing Linked Reports in Report Manager

Hello,
I may have discovered a possible bug with the new SP2 Client Printing
capabilities.
To reproduce:
1) Create a report with margins of 0.3in top, left, bottom and right, and
page size of 8.5 x 11 (standard US letter size)
2) Deploy the report to Report Manager
3) Confirm that client printing respects margins set in report. Click on
the print button, click on Print Preview, click on Margins, you should now
see 0.3in margins all around
4) Create a linked report by going to Properties and clicking Create Link
Report button.
5) Click on the print button, click on Print Preview, click on Margins, you
should now see 0.5in margins all around, instead of 0.3in. This does not
occur while exporting linked report to PDF format.
I confirmed this behaviour numerous times, and it's not only with margin but
also with page-layout. Is there a work-around?
Many thanks,
EdgarThe work around is to call SetProperties for the linked report, setting the
PageHeight, PageWidth, TopMargin, BottomMargin, LeftMargin and RightMargin
to the values you wish. All values should be expressed in mm.
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Edgar Allik" <Edgar Allik@.discussions.microsoft.com> wrote in message
news:0F3C537B-ECBF-4B69-BCE3-BFF8143B7BED@.microsoft.com...
> Hello,
> I may have discovered a possible bug with the new SP2 Client Printing
> capabilities.
> To reproduce:
> 1) Create a report with margins of 0.3in top, left, bottom and right, and
> page size of 8.5 x 11 (standard US letter size)
> 2) Deploy the report to Report Manager
> 3) Confirm that client printing respects margins set in report. Click on
> the print button, click on Print Preview, click on Margins, you should now
> see 0.3in margins all around
> 4) Create a linked report by going to Properties and clicking Create Link
> Report button.
> 5) Click on the print button, click on Print Preview, click on Margins,
> you
> should now see 0.5in margins all around, instead of 0.3in. This does not
> occur while exporting linked report to PDF format.
> I confirmed this behaviour numerous times, and it's not only with margin
> but
> also with page-layout. Is there a work-around?
> Many thanks,
> Edgar
>|||Hi, I am also experiencing the same error in SP2 where the page layout
properties don't seem to be set as they should be in a linked report.
I'm presuming "call SetProperties" is done via code - is there a work
around or way of doing this via Report Manager to fix this problem?
I'm not using any code with my reports, just URL access.
Thanks
Jeanine
Daniel Reib (MSFT) wrote:
> The work around is to call SetProperties for the linked report,
setting the
> PageHeight, PageWidth, TopMargin, BottomMargin, LeftMargin and
RightMargin
> to the values you wish. All values should be expressed in mm.
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Edgar Allik" <Edgar Allik@.discussions.microsoft.com> wrote in
message
> news:0F3C537B-ECBF-4B69-BCE3-BFF8143B7BED@.microsoft.com...
> > Hello,
> >
> > I may have discovered a possible bug with the new SP2 Client
Printing
> > capabilities.
> >
> > To reproduce:
> > 1) Create a report with margins of 0.3in top, left, bottom and
right, and
> > page size of 8.5 x 11 (standard US letter size)
> > 2) Deploy the report to Report Manager
> > 3) Confirm that client printing respects margins set in report.
Click on
> > the print button, click on Print Preview, click on Margins, you
should now
> > see 0.3in margins all around
> > 4) Create a linked report by going to Properties and clicking
Create Link
> > Report button.
> > 5) Click on the print button, click on Print Preview, click on
Margins,
> > you
> > should now see 0.5in margins all around, instead of 0.3in. This
does not
> > occur while exporting linked report to PDF format.
> >
> > I confirmed this behaviour numerous times, and it's not only with
margin
> > but
> > also with page-layout. Is there a work-around?
> >
> > Many thanks,
> >
> > Edgar
> >

possibility in enterprise manager

Hi,

I'm using enterprise manager to remotely connect to a MS SQL Server for one of my client's websites. The problem I'm having is that the connection times out when I try to expand the "Databases" folder. The reason that it's timing out is because the company that hosts the DB has hundreds of other clients who all share the same IP, but each with their own seperate login/password/database, but even though I don't have access to all the rest of the DBs on the server, it still wants to list them all for me. What I'm wondering is is there a way to set EM to ignore all of the databases on the server that cannot be accessed with my credentials? So basically when I expand the Databases folder all that appears is the one that I can access?

Thanks,
DanteSeems like I've seen this question on the forum before and the answer was "nope". Sorry.

positioning of report parameters when diaplayed in report manager

hi all

i have a report with set of parametrers.

by default when we create parameters they r displayed adjacent to each other.

is there any way by which we can specify position of parameter to be displayed in parameter area?

for eg:- suppose i have two parameters say age & name

then i want to display them one below the other.

is this possible?

if yes how?

plz help me.

waiting for reply.

You cannot customize report manager in this area.

The closest you can get is to e.g. with VS 2005 build your own frontend application (Winforms or Webforms) that deals with the parameters and then use RS Winforms/Webforms ReportViewer controls to display the report based on the selected parameters. More information on the ReportViewer controls: http://www.gotreportviewer.com/

-- Robert

Ports And Protocols

Hi Folks ,

Got one for you ....

By default what ports and protocols do the following sql tools use...?

Enterprise Manager
SQL Query Analyser
SQL Profiler

And if anybody knows :

Performance Monitor
Mapping drives
Event Viewer
User/Server Manager

Any help would be greatly appreciated ....Do you mean TCP/IP ports and protocols?

Microsoft SQL uses port 1433 for the default instance, and 1434 for named instances. It uses the TDS protocol.

The other tools use a mish-mash of ports and protocols, but I'd start with port 135.

-PatP