Problem in Installing SQL Server Management Studio

Hi all, i have already installed Visual Studio 2005 Professional Addition, due to which the following components have been installed on my computer

Microsoft .NET Compact Framework 1.0 SP3 Developer

Microsoft Compact Framework 2.0

Microsoft .NET Framework 2.0

Microsoft Device Emulator version 1.0-ENU

Microsoft Document Explorer 2005

Microsoft SQL Server 2005

Microsoft SQL Server 2005 Mobile [ENU] Developers Tools

Microsoft SQL Server Native Client

Microsoft SQL Server Setup Support Files

Microsoft SQL Server VSS Writer

Microsoft Visual J# 2.0 Redistributable Package

Microsoft Visual Studio 2005 Professional Edition - ENU

MSDN Library for Visual Studio 2005

MSXML 6.0 Parser

My visual studio 2005 professional edition is working correctly, but now i want to install Microsoft SQL Server Management Studio. I have a CD on which i have following folders

1.SQL Kit and Reporting Services(this folder contains folowing setups,

SQLServer2005_SSMSEE,

SQLEXPR_ADV,

SQLEXPR_TOOLKit)

2.Database Publising Wizard 1.0 RC(this folder contains a setup named as Database Publising Wizard 1.0 RC)

3.Book folder contains a setup named as SqlServer2k5_BOL_june2006

My problem is that, i don't know in which sequence i have to run these setups, so that the management studio successfully insatlled on my computer. If anybody understands my problem, plz help.

It looks like you have SQL 2005 Express Edition. To install the Express version of SSMS, run the setup or installer in SQLServer2005_SSMSEE .

|||

You have solved my problem, thank you so much for replying.

Problem in Installing SQL Server 2000 Personal

Hi... I recently reformatted my pc due to a very slow operation. Then I reinstall SQL Server 2000 Personal to my PC running Windows XP OS....As I run the setup, it will display INTERNAL ERROR and won't continue... What seemed to be the problem there? Before I reformatted the PC, it was installed well...

In windows XP I think you can only install Client tools ! ! ! anything from the setup log ?|||

Deepak... you can install Personal Edition on XP as well.. the problem seems to be something else... check error log or post the exact error what u get

BTW why u want to install 2000 , you have SQL Server 2005 Express downloadable edition. I think u should install that...

http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx

http://www.databasejournal.com/features/mssql/article.php/1442281

Madhu

|||Madhu, Thanks for pointing out my mistake.......apologize for my ignorance|||

No Deepak... we all make mistake... we all are there for a common cause to its help each other and there by improve our knowledge... so pse do not take it as personal...

Madhu

|||

Madhu, I didnt take it personnally.I am indeed happy that you pointed out my mistake so that i can learn from my mistakes.......i just felt like apologising for providing a wrong information........thanks once again friend

|||

Hi...Thanks for your immediate replies...Madhu the exact error displays

"Internal Error. Contact Microsoft Technical Support."

I already have SQL Server 2005 Express installed and it does not allow connections to other pc...

I have found out about SQL Management Studio and used it instead....And it really has a good environment...

Thank for replying here.... Happy programming!

sql

Problem during reinstalling SQL 2000

Hi Group,
I had to unistall my SQL server 2000 SQP4 instalation due to management
console failure.
The problem is, during the reinstallation while the setup is configuring the
server after copy files, setup stops with 'can't not configure the server'
window.
I'm gong to add the lasts rows of SqlStp.log, and i wish to know the best
practices of cleaning an old installation (registry keys, etc...)
Thank a lot to all...
16:49:51 El programa de instalacin no pudo configurar el servidor. Consulte
los registros de errores y C:\Documents and
Settings\sergior\WINDOWS\sqlstp.log para obtener ms informacin.
16:49:51 Action CleanUpInstall:
16:49:51 C:\DOCUME~1\sergior\CONFIG~1\Temp\SqlSetup\Bin\scm .exe -Silent
1 -Action 4 -Service SQLSERVERAGENT
16:49:51 Process Exit Code: (1060) El servicio especificado no existe como
servicio instalado.
16:49:51 C:\DOCUME~1\sergior\CONFIG~1\Temp\SqlSetup\Bin\scm .exe -Silent
1 -Action 4 -Service MSSQLSERVER
16:49:51 Process Exit Code: (0)
16:49:51 StatsGenerate returned: 2
16:49:51 StatsGenerate (0x0,0x1,0xf00000,0x100,1034,303,0x0,0x1,0,0,0
16:49:51 StatsGenerate -1,sergior)
16:49:51 Installation Failed.
Hi Sergio
"Sergio" wrote:

> Hi Group,
> I had to unistall my SQL server 2000 SQP4 instalation due to management
> console failure.
> The problem is, during the reinstallation while the setup is configuring the
> server after copy files, setup stops with 'can't not configure the server'
> window.
> I'm goXng to add the lasts rows of SqlStp.log, and i wish to know the best
> practices of cleaning an old installation (registry keys, etc...)
> Thank a lot to all...
>
> 16:49:51 El programa de instalación no pudo configurar el servidor. Consulte
> los registros de errores y C:\Documents and
> Settings\sergior\WINDOWS\sqlstp.log para obtener más información.
> 16:49:51 Action CleanUpInstall:
> 16:49:51 C:\DOCUME~1\sergior\CONFIG~1\Temp\SqlSetup\Bin\scm .exe -Silent
> 1 -Action 4 -Service SQLSERVERAGENT
> 16:49:51 Process Exit Code: (1060) El servicio especificado no existe como
> servicio instalado.
> 16:49:51 C:\DOCUME~1\sergior\CONFIG~1\Temp\SqlSetup\Bin\scm .exe -Silent
> 1 -Action 4 -Service MSSQLSERVER
> 16:49:51 Process Exit Code: (0)
> 16:49:51 StatsGenerate returned: 2
> 16:49:51 StatsGenerate (0x0,0x1,0xf00000,0x100,1034,303,0x0,0x1,0,0,0
> 16:49:51 StatsGenerate -1,sergior)
> 16:49:51 Installation Failed.
>
This seems to be the same problem as http://tinyurl.com/2c3tdf, the solution
suggested there is to remove the SQL Server installation, download and
install MDAC or check that you current configuration is up-to-date and not
corrupted, then install SQL Server in debug mode "setupsql.exe k=dbg"
so you can skip over the MDAC installation step.
John
|||Ok John,
Thanks for your fast reply, i'm gonna probe it...
"John Bell" <jbellnewsposts@.hotmail.com> escribi en el mensaje
news:24F82C2A-2919-482A-AC7D-C2965BD7D690@.microsoft.com...
> Hi Sergio
> "Sergio" wrote:
> This seems to be the same problem as http://tinyurl.com/2c3tdf, the
> solution
> suggested there is to remove the SQL Server installation, download and
> install MDAC or check that you current configuration is up-to-date and not
> corrupted, then install SQL Server in debug mode "setupsql.exe k=dbg"
> so you can skip over the MDAC installation step.
> John

Problem during reinstalling SQL 2000

Hi Group,
I had to unistall my SQL server 2000 SQP4 instalation due to management
console failure.
The problem is, during the reinstallation while the setup is configuring the
server after copy files, setup stops with 'can't not configure the server'
window.
I'm gong to add the lasts rows of SqlStp.log, and i wish to know the best
practices of cleaning an old installation (registry keys, etc...)
Thank a lot to all...
16:49:51 El programa de instalacin no pudo configurar el servidor. Consulte
los registros de errores y C:\Documents and
Settings\sergior\WINDOWS\sqlstp.log para obtener ms informacin.
16:49:51 Action CleanUpInstall:
16:49:51 C:\DOCUME~1\sergior\CONFIG~1\Temp\SqlSet
up\Bin\scm.exe -Silent
1 -Action 4 -Service SQLSERVERAGENT
16:49:51 Process Exit Code: (1060) El servicio especificado no existe como
servicio instalado.
16:49:51 C:\DOCUME~1\sergior\CONFIG~1\Temp\SqlSet
up\Bin\scm.exe -Silent
1 -Action 4 -Service MSSQLSERVER
16:49:51 Process Exit Code: (0)
16:49:51 StatsGenerate returned: 2
16:49:51 StatsGenerate (0x0,0x1,0xf00000,0x100,1034,303,0x0,0x1
,0,0,0
16:49:51 StatsGenerate -1,sergior)
16:49:51 Installation Failed.Hi Sergio
"Sergio" wrote:

> Hi Group,
> I had to unistall my SQL server 2000 SQP4 instalation due to management
> console failure.
> The problem is, during the reinstallation while the setup is configuring t
he
> server after copy files, setup stops with 'can't not configure the server'
> window.
> I'm go_ng to add the lasts rows of SqlStp.log, and i wish to know the be
st
> practices of cleaning an old installation (registry keys, etc...)
> Thank a lot to all...
>
> 16:49:51 El programa de instalación no pudo configurar el servidor. Consu
lte
> los registros de errores y C:\Documents and
> Settings\sergior\WINDOWS\sqlstp.log para obtener más información.
> 16:49:51 Action CleanUpInstall:
> 16:49:51 C:\DOCUME~1\sergior\CONFIG~1\Temp\SqlSet
up\Bin\scm.exe -Silent
> 1 -Action 4 -Service SQLSERVERAGENT
> 16:49:51 Process Exit Code: (1060) El servicio especificado no existe como
> servicio instalado.
> 16:49:51 C:\DOCUME~1\sergior\CONFIG~1\Temp\SqlSet
up\Bin\scm.exe -Silent
> 1 -Action 4 -Service MSSQLSERVER
> 16:49:51 Process Exit Code: (0)
> 16:49:51 StatsGenerate returned: 2
> 16:49:51 StatsGenerate (0x0,0x1,0xf00000,0x100,1034,303,0x0,0x1
,0,0,0
> 16:49:51 StatsGenerate -1,sergior)
> 16:49:51 Installation Failed.
>
This seems to be the same problem as http://tinyurl.com/2c3tdf, the solution
suggested there is to remove the SQL Server installation, download and
install MDAC or check that you current configuration is up-to-date and not
corrupted, then install SQL Server in debug mode "setupsql.exe k=dbg"
so you can skip over the MDAC installation step.
John|||Ok John,
Thanks for your fast reply, i'm gonna probe it...
"John Bell" <jbellnewsposts@.hotmail.com> escribi en el mensaje
news:24F82C2A-2919-482A-AC7D-C2965BD7D690@.microsoft.com...
> Hi Sergio
> "Sergio" wrote:
>
> This seems to be the same problem as http://tinyurl.com/2c3tdf, the
> solution
> suggested there is to remove the SQL Server installation, download and
> install MDAC or check that you current configuration is up-to-date and not
> corrupted, then install SQL Server in debug mode "setupsql.exe k=dbg"
> so you can skip over the MDAC installation step.
> John

Problem during reinstalling SQL 2000

Hi Group,
I had to unistall my SQL server 2000 SQP4 instalation due to management
console failure.
The problem is, during the reinstallation while the setup is configuring the
server after copy files, setup stops with 'can't not configure the server'
window.
I'm goíng to add the lasts rows of SqlStp.log, and i wish to know the best
practices of cleaning an old installation (registry keys, etc...)
Thank a lot to all...
16:49:51 El programa de instalación no pudo configurar el servidor. Consulte
los registros de errores y C:\Documents and
Settings\sergior\WINDOWS\sqlstp.log para obtener más información.
16:49:51 Action CleanUpInstall:
16:49:51 C:\DOCUME~1\sergior\CONFIG~1\Temp\SqlSetup\Bin\scm.exe -Silent
1 -Action 4 -Service SQLSERVERAGENT
16:49:51 Process Exit Code: (1060) El servicio especificado no existe como
servicio instalado.
16:49:51 C:\DOCUME~1\sergior\CONFIG~1\Temp\SqlSetup\Bin\scm.exe -Silent
1 -Action 4 -Service MSSQLSERVER
16:49:51 Process Exit Code: (0)
16:49:51 StatsGenerate returned: 2
16:49:51 StatsGenerate (0x0,0x1,0xf00000,0x100,1034,303,0x0,0x1,0,0,0
16:49:51 StatsGenerate -1,sergior)
16:49:51 Installation Failed.Hi Sergio
"Sergio" wrote:
> Hi Group,
> I had to unistall my SQL server 2000 SQP4 instalation due to management
> console failure.
> The problem is, during the reinstallation while the setup is configuring the
> server after copy files, setup stops with 'can't not configure the server'
> window.
> I'm goíng to add the lasts rows of SqlStp.log, and i wish to know the best
> practices of cleaning an old installation (registry keys, etc...)
> Thank a lot to all...
>
> 16:49:51 El programa de instalación no pudo configurar el servidor. Consulte
> los registros de errores y C:\Documents and
> Settings\sergior\WINDOWS\sqlstp.log para obtener más información.
> 16:49:51 Action CleanUpInstall:
> 16:49:51 C:\DOCUME~1\sergior\CONFIG~1\Temp\SqlSetup\Bin\scm.exe -Silent
> 1 -Action 4 -Service SQLSERVERAGENT
> 16:49:51 Process Exit Code: (1060) El servicio especificado no existe como
> servicio instalado.
> 16:49:51 C:\DOCUME~1\sergior\CONFIG~1\Temp\SqlSetup\Bin\scm.exe -Silent
> 1 -Action 4 -Service MSSQLSERVER
> 16:49:51 Process Exit Code: (0)
> 16:49:51 StatsGenerate returned: 2
> 16:49:51 StatsGenerate (0x0,0x1,0xf00000,0x100,1034,303,0x0,0x1,0,0,0
> 16:49:51 StatsGenerate -1,sergior)
> 16:49:51 Installation Failed.
>
This seems to be the same problem as http://tinyurl.com/2c3tdf, the solution
suggested there is to remove the SQL Server installation, download and
install MDAC or check that you current configuration is up-to-date and not
corrupted, then install SQL Server in debug mode "setupsql.exe k=dbg"
so you can skip over the MDAC installation step.
John|||Ok John,
Thanks for your fast reply, i'm gonna probe it...
"John Bell" <jbellnewsposts@.hotmail.com> escribió en el mensaje
news:24F82C2A-2919-482A-AC7D-C2965BD7D690@.microsoft.com...
> Hi Sergio
> "Sergio" wrote:
>> Hi Group,
>> I had to unistall my SQL server 2000 SQP4 instalation due to management
>> console failure.
>> The problem is, during the reinstallation while the setup is configuring
>> the
>> server after copy files, setup stops with 'can't not configure the
>> server'
>> window.
>> I'm goíng to add the lasts rows of SqlStp.log, and i wish to know the
>> best
>> practices of cleaning an old installation (registry keys, etc...)
>> Thank a lot to all...
>>
>> 16:49:51 El programa de instalación no pudo configurar el servidor.
>> Consulte
>> los registros de errores y C:\Documents and
>> Settings\sergior\WINDOWS\sqlstp.log para obtener más información.
>> 16:49:51 Action CleanUpInstall:
>> 16:49:51 C:\DOCUME~1\sergior\CONFIG~1\Temp\SqlSetup\Bin\scm.exe -Silent
>> 1 -Action 4 -Service SQLSERVERAGENT
>> 16:49:51 Process Exit Code: (1060) El servicio especificado no existe
>> como
>> servicio instalado.
>> 16:49:51 C:\DOCUME~1\sergior\CONFIG~1\Temp\SqlSetup\Bin\scm.exe -Silent
>> 1 -Action 4 -Service MSSQLSERVER
>> 16:49:51 Process Exit Code: (0)
>> 16:49:51 StatsGenerate returned: 2
>> 16:49:51 StatsGenerate (0x0,0x1,0xf00000,0x100,1034,303,0x0,0x1,0,0,0
>> 16:49:51 StatsGenerate -1,sergior)
>> 16:49:51 Installation Failed.
> This seems to be the same problem as http://tinyurl.com/2c3tdf, the
> solution
> suggested there is to remove the SQL Server installation, download and
> install MDAC or check that you current configuration is up-to-date and not
> corrupted, then install SQL Server in debug mode "setupsql.exe k=dbg"
> so you can skip over the MDAC installation step.
> John

Problem due to locking in MSSQLServer 2000

Insert or update statements seems to be locking entire
page or table rather than locking
the corresponding row to be inserted or updated.
lets assume the table with 3 rows.
scenario 1)
In transaction A, I'm updating the 3'rd row. and in
another transaction B I'm reading
row 1.
Transaction B seems to be waiting for transaction A to
finish before returning the select results.
Scenario 2)
In transaction A, I'm inserting new row (4'th row) and in
another transaction B I'm reading
row 1.
here as well trasaction B does not return the row 1 unless
transaction A is complete.
Select operation is blocked due to insert.
Ideally in both the scenarios , read operation should have
returned the results without waiting
for update/insert to finish. As the read is being done on
different rows than that of being updated
or inserted.
I have tried both the insert/update as well as select
queries with all the possible locking hints
such as ROWLOCK, READCOMMITED, UPDLOCK etc...
The only way select query returns the row without blocking
is by using the NOLOCK locking hint. But then this is
not the proper solution as it gives us the dirty read.
Please suggest me any solution or workaround for above
issue.Adding to Tony's comments (the DDL/DML will be useful), you might find the
problem is that it's the index page that's locked during the update/insert
which is blocking the select. How many rows are in the table we're
discussing?
Depending on the WHERE clause and the optimizer query plans, sometimes row
locks are NOT released until the entire statement has finished, and
sometimes these can be escalated to table locks. See
http://www.hanlincrest.com/SQLServerLockEscalation.htm for a description.
I couldn't quite figure it out from your note, but is it the same process
attempting to execute two separate transactions on two SQL Server sessions
and thus blocking itself? If this is the case it would be wise to rethink it
so only one transaction is active from the process ar once.
Kind Regards, Howard
"Sangram Deshmukh" <sangram@.savvion.com> wrote in message
news:0c2e01c34ad9$841875a0$a301280a@.phx.gbl...
> Insert or update statements seems to be locking entire
> page or table rather than locking
> the corresponding row to be inserted or updated.
> lets assume the table with 3 rows.
> scenario 1)
> In transaction A, I'm updating the 3'rd row. and in
> another transaction B I'm reading
> row 1.
> Transaction B seems to be waiting for transaction A to
> finish before returning the select results.
>
> Scenario 2)
> In transaction A, I'm inserting new row (4'th row) and in
> another transaction B I'm reading
> row 1.
> here as well trasaction B does not return the row 1 unless
> transaction A is complete.
> Select operation is blocked due to insert.
>
> Ideally in both the scenarios , read operation should have
> returned the results without waiting
> for update/insert to finish. As the read is being done on
> different rows than that of being updated
> or inserted.
> I have tried both the insert/update as well as select
> queries with all the possible locking hints
> such as ROWLOCK, READCOMMITED, UPDLOCK etc...
> The only way select query returns the row without blocking
> is by using the NOLOCK locking hint. But then this is
> not the proper solution as it gives us the dirty read.
> Please suggest me any solution or workaround for above
> issue.