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.

Postgresql migration tool?

I have a postgres db and would like to convert to SQL Express or standard edition. Is there a conversion or migration tool available?

I can dump the postgres db to a sql file but MS has slightly different syntax and datatypes so I have to go in a manually modify the sql file for every table and data type. Is there an easier way? Thanks!

I'm not aware of any such tool from Microsoft but I've moved this thread to the database engine forum where you're more likely to find a knowledgeable answer.

Paul

Postgres to SQL Express

Is there a utility that will allow migrating Postgres dtatbases to SQL Expre
ss?Thank you for your assistance John.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Patrick
> Postgres is not one of the databases that has a migration assistant
> http://www.microsoft.com/sql/soluti...on/default.mspx so you will
> have to do this manually. The Import/Export wizard may allow you to transf
er
> tables/data across but you may still have to manipulate the data afterward
s
> and change some datatypes, therefore scripting the DDL and
> exporting/importing the data via flat files may be the best option.
> HTH
> John
> "Patrick" wrote:
>|||Hi Patrick
Postgres is not one of the databases that has a migration assistant
http://www.microsoft.com/sql/soluti...on/default.mspx so you will
have to do this manually. The Import/Export wizard may allow you to transfer
tables/data across but you may still have to manipulate the data afterwards
and change some datatypes, therefore scripting the DDL and
exporting/importing the data via flat files may be the best option.
HTH
John
"Patrick" wrote:
[vbcol=seagreen]
> Is there a utility that will allow migrating Postgres dtatbases to SQL Express?[/v
bcol]

Postgres to SQL Express

Is there a utility that will allow migrating Postgres dtatbases to SQL Express?
Thank you for your assistance John.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Patrick
> Postgres is not one of the databases that has a migration assistant
> http://www.microsoft.com/sql/solutions/migration/default.mspx so you will
> have to do this manually. The Import/Export wizard may allow you to transfer
> tables/data across but you may still have to manipulate the data afterwards
> and change some datatypes, therefore scripting the DDL and
> exporting/importing the data via flat files may be the best option.
> HTH
> John
> "Patrick" wrote:
|||Hi Patrick
Postgres is not one of the databases that has a migration assistant
http://www.microsoft.com/sql/solutions/migration/default.mspx so you will
have to do this manually. The Import/Export wizard may allow you to transfer
tables/data across but you may still have to manipulate the data afterwards
and change some datatypes, therefore scripting the DDL and
exporting/importing the data via flat files may be the best option.
HTH
John
"Patrick" wrote:

> Is there a utility that will allow migrating Postgres dtatbases to SQL Express?
sql

Post update for SQLServer SP2--is there one for SQLServer Express?

Regarding KB935356, is there a "post" service pack 2 update for SQLServer Express?

Thanks.

hi,

LizWard wrote:

Regarding KB935356, is there a "post" service pack 2 update for SQLServer Express?

Thanks.

I'm currently at 3159 build (both on SQL Server 2005 Dev editions and SQLEpxress), so I did not install 3161, but the "Applies to" section reports SQLExpress and SQLExpress With Advanced Services as well, so you should be able to install it on them, as long as you really need them and contact Microsoft for it..

regards

|||For SQLExpress, you stated that you are currently on build 3159. Where did you get that build from? I'm currently on this version:

9.00.3042.00.

I downloaded what seemed to be the latest SQLExpress...please send the URL that you used.

Thanks very much.

|||

hi,

it's "linked" above in the "3159" word

anyway, it's at http://support.microsoft.com/default.aspx/kb/934459/en-us

regards

|||

Andrea:

There is a later one: http://support.microsoft.com/kb/935356/en-us which is Build 3161 -- Article dated 4/19/2007.

Our company has that one downloaded so I will try it when I go "off call" next Wednesday.

Thanks for your help....I hope it will work on SQLExpress.

Lisa

|||

Andrea:

I was able to apply the hotfix that I mentioned in my post on 4/19. Sorry for the delay in replying.

Thanks for your help.

Lisa

sql

Post update for SQLServer SP2--is there one for SQLServer Express?

Regarding KB935356, is there a "post" service pack 2 update for SQLServer Express?

Thanks.

hi,

LizWard wrote:

Regarding KB935356, is there a "post" service pack 2 update for SQLServer Express?

Thanks.

I'm currently at 3159 build (both on SQL Server 2005 Dev editions and SQLEpxress), so I did not install 3161, but the "Applies to" section reports SQLExpress and SQLExpress With Advanced Services as well, so you should be able to install it on them, as long as you really need them and contact Microsoft for it..

regards

|||For SQLExpress, you stated that you are currently on build 3159. Where did you get that build from? I'm currently on this version:

9.00.3042.00.

I downloaded what seemed to be the latest SQLExpress...please send the URL that you used.

Thanks very much.

|||

hi,

it's "linked" above in the "3159" word

anyway, it's at http://support.microsoft.com/default.aspx/kb/934459/en-us

regards

|||

Andrea:

There is a later one: http://support.microsoft.com/kb/935356/en-us which is Build 3161 -- Article dated 4/19/2007.

Our company has that one downloaded so I will try it when I go "off call" next Wednesday.

Thanks for your help....I hope it will work on SQLExpress.

Lisa

|||

Andrea:

I was able to apply the hotfix that I mentioned in my post on 4/19. Sorry for the delay in replying.

Thanks for your help.

Lisa

possible setup.exe exit codes?

As part of our application deployment we have wrapped and automated the SQL Server Express install by launching the setup.exe with our parameters and waiting around for the process to exit.

I had been checking for a Exit Code != 0 to detect errors returned by setup.exe but this does not appear to be foolproof. Several customers' deployments have returned non-zero exit codes, but SQL Express seems to be successfully installed.

I have not found a reference of possible codes returned and their meaning that I could use to fine tune our checking. Does one exist? Or am I going about this the wrong way and should just check for the existence of our instance after setup is complete?

thank you for any input.

I *think* the only other success error code you need to code around is error code 3010, which signifies success, but a reboot is necessary.

Here is a list of other possible Windows Installer error codes:

http://msdn2.microsoft.com/en-us/library/aa368542.aspx

Thanks,
Sam Lester (MSFT)

Possible Fix SQL Server 2005 Express Install Errors 29503 or 1067

Hello,

I spent days trying repeatedly to install SQL Server 2005 Express edition and always received an error message. I uninstalled SQL Server 2000, cleaned the registry, uninstalled/reinstalled Visual Basic 2005 Express, read all the forums and tried every combination. I always received this failure message:

The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1067) The process terminated unexpectedly. Error Number : 29503

If this is the particular error you are receiving, then maybe this post will help.

The solution for me was NOT to uninstall Visual Basic 2005 Express Edition, or install SQL Server 2005 in any particular order vs installing VB 2005 Express.

These are the steps that worked for me. Run setup for SQL Server 2005 Express. On the first setup screen, there is a checkbox that says "Hide advanced setup/installation options" (or somesuch). It is checked by default. UNCHECK IT. (You DO want to select advanced options because the defaults are not working for you.)

Look closely at the screens that follow. Look for the dropdown that says "Install SQL Server as a... Network Service. In the dropdown, change the choice to Local Service.

In another screen, look for the Authentication method. Do NOT use Windows authentication, which is the default. Select Mixed Mode authentication, and provide a strong password.

Now, let it install. For me, it no longer failed. SQL Server installed with no further problems.

Hope this helps somebody (including MS in figuring out how come). It worked for me when nothing else did!

SQL Wizard (who?)

SQl Wizard - I am having this exact same issue on my win xp pro sp2 machine. However, I tried what you suggested and still got the same error. I also had sql 2000 installed prior (uninstalled it prior to installing sql 2005) - did you clean up anything in the registry before you started?

Thanks for your help.....

csqlrun