Hi, Again

I'm very new to MS SQl Server, i Downloaded MS SQl Server express edition, the problem is i can't deal with it, when i downloaded (Microsoft SQL Server Management Studio Express - Community Technical Preview (CTP) November 2005) every time i try to install it , it give me error message says "The system administrator has set policies To Prevent this installation"
How can i over come this problem and install this interface to be able to deal with sql server?
is there any other software can do this job "making interface for the sql server express edition"?
ThxI downloaded the Nov CTP as well of the Management studio, but can't go beyond this error.

This installation package cannot be installed by the windows installer service. You must install a windows service pack that contains a newer version of the windows installer service.

I have Windows 2000 SP4 and also the Windows Installer 3.0, MSXML 6.0 Still

Thanks in advance for any help.
Kalyan.|||Go to the following link an install the latest update to Windows Installer: http://www.microsoft.com/downloads/details.aspx?FamilyID=889482fc-5f56-4a38-b838-de776fd4138c&DisplayLang=en

Cheers,
Dan|||hi,
I have the windows installer 3.1 but yet i can't install (TCP) managment studio keep getting the same error "administrator has set policies to prevent this installation"
additional hint : - i use windows xp_sp2 - when i used to counter this problem i downloaded MS Visual Web developer express 2005 and i was able to connect to sql server, but really i'm new to sql and i need to see interface to be able to learn it at least|||Sorry for the messege, i downloaded the SQl Server Management Studio Express Again and when i tried to install it , it worked seems it was a problem in the first time i downloaded it something was wrong in it
anyway thx guys

heres a challenge for you all.

Ok, here's the problem. I have CA's Unicenter ServiceIT Enterprise Edition 5.0 running on a production box that has NT4 (SP6) and SQL server 2000 running on it.

Just before we continue, this is about backing up the database that ServiceIT connects to.

I know that you can schedule EM to make backup's of a specific database over a certain time, but this is part of the problem. What i have since discovered is that ServiceIT will not run on a database backed up and restored by EM.

It will however run on the restored backup created through the dos command pdm_backup (comes with ServiceIT).

What i am trying to figure out is to try a find a way that i can run a dos prompt command to do the following tasks at a specific time of day:

Stop the Paradigm Server Daemons (service)
Run a DBCC CHECKDB on the database AHDTEST50.
If there are no errors, create a verbose backup using the dos command pdm_backup -v -fC:\backup\[todaysdate]
If there are errors run a script to correct them, then run a backup
Restart the Paradigm Server DaemonsSchedule a batch file?|||can you set a batch file to do all of the above though?|||Only generating filenames with today's date (yyyymmdd) is usually a pain in batch (regional settings stuff like that) so I have a tendency to use a parameter instead. Next, I don't know how to check for errors the verbose backup might give; is there a log-file, would it suffice to do a find on it? I should think there's a way to cover that, so, other than that: I'd give it a go.|||Could you use something like:CREATE PROCEDURE Backup_ServiceIT
AS

DECLARE @.cBackup VARCHAR(500)
SET @.cBackup = pdm_backup -v -fC:\backup\' + Convert(CHAR(8), GetDate(), 112)

EXECUTE @.rc = master.dbo.xp_cmdshell 'NET STOP <paradigm service name>'
if 0 = @.rc DBCC CHECKDB ('AHDTEST50')
if 0 = @.@.error EXECUTE @.rc = master.dbo.xp_cmdshell @.cBackup
if 0 <> @.rc EXECUTE @.rc = master.dbo.xp_cmdshell '<fix error batch file>'
EXECUTE @.rc = master.dbo.xp_cmdshell 'NET START <paradigm service name>'

RETURN
GO-PatP|||Hey...when did you add your location?

http://www.ifb.net/webit/inveruri.htm

Help:MS SQL 2000 SP4 dont run !

I have installed MS SQL 2000 Personal Edition on XP SP2 and It works !
I verified its version :
SQL Server 2000 Original Release 8.00.194 RTM

When I try to install SP4 after extracting locally I see the first windows for a moment and then nothing appens !

x86\setup\setupsql.exe process remain in task manager without make nothing.

Someone can help me ?Check windows event log & SQL error lgo for any information.
Also try to download the file again, make sure you're using correct SP4 file from MS.|||Thank you !

I have found only this warning in eventlog

SuperSocket info: (SpnRegister) : Error 1355.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

But I think it's because I have no SP4 installed .
When I try to install SP4 I have no message in any logs.
Process do nothing because, I suppose , It's waiting for a Dialog Window that I don't see :-(|||There was a problem on the Clustered environment previously as per KBA http://support.microsoft.com/?id=303411 , but yours it not that case. Anyway try downloading SP3a for SQL 2000 and apply, then use SP4.

BTW mention the filename of SP4 you're using to apply.|||I have the same problem with SP3.
File name is SQL2000-KB884525-SP4-x86-ENU.EXE
May be MSI ? I have 3.1
Or IIS ? I have 5.1
How can I remove IIS ?

HELP: SSEE problems

I've a Windows 2003 Server Web Edition server. I've installed SSEE on
the same server. I've 5 domains (and 5 different web applications).
Every app needs to connect to 1 different db.
Both, with native securiy or Windows security, I obtain that only 1 app
work correctly while with the others I obtain "Application Server
Unavailable". If I connect all the apps to the same db then all works right.
Can someone hel me to solve this problem?
Thanks in advance,
FrancoHi Fransis
"Fransis il Mulo" wrote:

> I've a Windows 2003 Server Web Edition server. I've installed SSEE on
> the same server. I've 5 domains (and 5 different web applications).
> Every app needs to connect to 1 different db.
> Both, with native securiy or Windows security, I obtain that only 1 app
> work correctly while with the others I obtain "Application Server
> Unavailable". If I connect all the apps to the same db then all works righ
t.
> Can someone hel me to solve this problem?
> Thanks in advance,
> Franco
Have you enabled network protocols for SQL Express? By default they will be
disabled, but that can be overridden when you install SQL Express or later
using SQL Server Configuration Manager see
http://msdn2.microsoft.com/en-us/library/ms165718.aspx
John