Showing posts with label sp4. Show all posts
Showing posts with label sp4. Show all posts

Monday, March 26, 2012

Problem with installing sp4

I can't install sp4. I got error :Error running script: replsys.sql (1)
looking in sqllog, I have this lines (at the end of file).
...
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\setup.iss returned: 0, 0
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
12:13:12 SetFileSecuritySQLAndAdmin for returned: 3, 3
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlstp.log returned: 0, 0
12:13:12 SetFileSecPerfAndLogUsers for C:\Program Files\Microsoft SQL
Server\MSSQL\Binn\SQLCTR80.DLL returned: 1332, 1332
12:13:12 Begin ServPriv (MSSQLSERVER)
12:13:12 End ServPriv()
12:13:13 Upgrading databases
12:13:13 Upgrading databases on instance 'MSSQLSERVER'
12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\s cm.exe -Silent
1 -Action 6 -Service MSSQLSERVER
12:13:13 Process Exit Code: (0)
12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\s cm.exe -Silent
1 -Action 6 -Service MSSQLSERVER
12:13:13 Process Exit Code: (0)
12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\s cm.exe -Silent
1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022 \-T4010 \-m
12:13:34 Process Exit Code: (0)
12:13:34 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:BOGIBATINA -b -n -d master -o
"C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out" -i
"C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.sql" -Usa -P"
12:13:34 Process Exit Code: (1)
12:14:10 Error running script: replsys.sql (1)
12:14:10 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\s cm.exe -Silent
1 -Action 6 -Service MSSQLSERVER
12:14:25 Process Exit Code: (0)
12:14:25 Action CleanUpInstall:
12:14:25 Installation Failed.
Have you looked in this file?
C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out
R.
"Radovan" <radovan@.servis24.hr> wrote in message
news:OWXdLAeuFHA.2072@.TK2MSFTNGP14.phx.gbl...
> I can't install sp4. I got error :Error running script: replsys.sql (1)
> looking in sqllog, I have this lines (at the end of file).
> ...
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\setup.iss returned: 0, 0
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
> 12:13:12 SetFileSecuritySQLAndAdmin for returned: 3, 3
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlstp.log returned: 0, 0
> 12:13:12 SetFileSecPerfAndLogUsers for C:\Program Files\Microsoft SQL
> Server\MSSQL\Binn\SQLCTR80.DLL returned: 1332, 1332
> 12:13:12 Begin ServPriv (MSSQLSERVER)
> 12:13:12 End ServPriv()
> 12:13:13 Upgrading databases
> 12:13:13 Upgrading databases on instance 'MSSQLSERVER'
> 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\s cm.exe -Silent
> 1 -Action 6 -Service MSSQLSERVER
> 12:13:13 Process Exit Code: (0)
> 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\s cm.exe -Silent
> 1 -Action 6 -Service MSSQLSERVER
> 12:13:13 Process Exit Code: (0)
> 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\s cm.exe -Silent
> 1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022 \-T4010 \-m
> 12:13:34 Process Exit Code: (0)
> 12:13:34 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:BOGIBATINA -b -n -d master -o
> "C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out" -i
> "C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.sql" -Usa -P"
> 12:13:34 Process Exit Code: (1)
> 12:14:10 Error running script: replsys.sql (1)
> 12:14:10 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\s cm.exe -Silent
> 1 -Action 6 -Service MSSQLSERVER
> 12:14:25 Process Exit Code: (0)
> 12:14:25 Action CleanUpInstall:
> 12:14:25 Installation Failed.
>
|||Check what other processes are running on your server. I had the same
problem updating to SP4. I had to stop MOM services, Windows update
processes, and end anything else that may be using SQL. Then the SP4
install will go OK.
Mike
R wrote:[vbcol=seagreen]
> Have you looked in this file?
> C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out
> R.
> "Radovan" <radovan@.servis24.hr> wrote in message
> news:OWXdLAeuFHA.2072@.TK2MSFTNGP14.phx.gbl...
|||Thanks that helps.
Radovan
"inqbbus" <inqbbus@.gmail.com> wrote in message
news:1126820621.538655.83620@.g47g2000cwa.googlegro ups.com...
> Check what other processes are running on your server. I had the same
> problem updating to SP4. I had to stop MOM services, Windows update
> processes, and end anything else that may be using SQL. Then the SP4
> install will go OK.
> Mike
> R wrote:
>

Problem with installing sp4

I can't install sp4. I got error :Error running script: replsys.sql (1)
looking in sqllog, I have this lines (at the end of file).
...
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\setup.iss returned: 0, 0
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
12:13:12 SetFileSecuritySQLAndAdmin for returned: 3, 3
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlstp.log returned: 0, 0
12:13:12 SetFileSecPerfAndLogUsers for C:\Program Files\Microsoft SQL
Server\MSSQL\Binn\SQLCTR80.DLL returned: 1332, 1332
12:13:12 Begin ServPriv (MSSQLSERVER)
12:13:12 End ServPriv()
12:13:13 Upgrading databases
12:13:13 Upgrading databases on instance 'MSSQLSERVER'
12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlS
etup\Bin\scm.exe -Silent
1 -Action 6 -Service MSSQLSERVER
12:13:13 Process Exit Code: (0)
12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlS
etup\Bin\scm.exe -Silent
1 -Action 6 -Service MSSQLSERVER
12:13:13 Process Exit Code: (0)
12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlS
etup\Bin\scm.exe -Silent
1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022 \-T4010 \-m
12:13:34 Process Exit Code: (0)
12:13:34 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:BOGIBATINA -b -n -d master -o
"C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out" -i
"C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.sql" -Usa -P"
12:13:34 Process Exit Code: (1)
12:14:10 Error running script: replsys.sql (1)
12:14:10 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlS
etup\Bin\scm.exe -Silent
1 -Action 6 -Service MSSQLSERVER
12:14:25 Process Exit Code: (0)
12:14:25 Action CleanUpInstall:
12:14:25 Installation Failed.Have you looked in this file?
C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out
R.
"Radovan" <radovan@.servis24.hr> wrote in message
news:OWXdLAeuFHA.2072@.TK2MSFTNGP14.phx.gbl...
> I can't install sp4. I got error :Error running script: replsys.sql (1)
> looking in sqllog, I have this lines (at the end of file).
> ...
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\setup.iss returned: 0, 0
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
> 12:13:12 SetFileSecuritySQLAndAdmin for returned: 3, 3
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlstp.log returned: 0, 0
> 12:13:12 SetFileSecPerfAndLogUsers for C:\Program Files\Microsoft SQL
> Server\MSSQL\Binn\SQLCTR80.DLL returned: 1332, 1332
> 12:13:12 Begin ServPriv (MSSQLSERVER)
> 12:13:12 End ServPriv()
> 12:13:13 Upgrading databases
> 12:13:13 Upgrading databases on instance 'MSSQLSERVER'
> 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlS
etup\Bin\scm.exe -Silent
> 1 -Action 6 -Service MSSQLSERVER
> 12:13:13 Process Exit Code: (0)
> 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlS
etup\Bin\scm.exe -Silent
> 1 -Action 6 -Service MSSQLSERVER
> 12:13:13 Process Exit Code: (0)
> 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlS
etup\Bin\scm.exe -Silent
> 1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022 \-T4010 \-m
> 12:13:34 Process Exit Code: (0)
> 12:13:34 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:BOGIBATINA -b -n -d master -o
> "C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out" -i
> "C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.sql" -Usa -P"
> 12:13:34 Process Exit Code: (1)
> 12:14:10 Error running script: replsys.sql (1)
> 12:14:10 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlS
etup\Bin\scm.exe -Silent
> 1 -Action 6 -Service MSSQLSERVER
> 12:14:25 Process Exit Code: (0)
> 12:14:25 Action CleanUpInstall:
> 12:14:25 Installation Failed.
>|||Check what other processes are running on your server. I had the same
problem updating to SP4. I had to stop MOM services, Windows update
processes, and end anything else that may be using SQL. Then the SP4
install will go OK.
Mike
R wrote:[vbcol=seagreen]
> Have you looked in this file?
> C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out
> R.
> "Radovan" <radovan@.servis24.hr> wrote in message
> news:OWXdLAeuFHA.2072@.TK2MSFTNGP14.phx.gbl...|||Thanks that helps.
Radovan
"inqbbus" <inqbbus@.gmail.com> wrote in message
news:1126820621.538655.83620@.g47g2000cwa.googlegroups.com...
> Check what other processes are running on your server. I had the same
> problem updating to SP4. I had to stop MOM services, Windows update
> processes, and end anything else that may be using SQL. Then the SP4
> install will go OK.
> Mike
> R wrote:
>sql

Problem with installing sp4

I can't install sp4. I got error :Error running script: replsys.sql (1)
looking in sqllog, I have this lines (at the end of file).
...
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\setup.iss returned: 0, 0
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
12:13:12 SetFileSecuritySQLAndAdmin for returned: 3, 3
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlstp.log returned: 0, 0
12:13:12 SetFileSecPerfAndLogUsers for C:\Program Files\Microsoft SQL
Server\MSSQL\Binn\SQLCTR80.DLL returned: 1332, 1332
12:13:12 Begin ServPriv (MSSQLSERVER)
12:13:12 End ServPriv()
12:13:13 Upgrading databases
12:13:13 Upgrading databases on instance 'MSSQLSERVER'
12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
1 -Action 6 -Service MSSQLSERVER
12:13:13 Process Exit Code: (0)
12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
1 -Action 6 -Service MSSQLSERVER
12:13:13 Process Exit Code: (0)
12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022 \-T4010 \-m
12:13:34 Process Exit Code: (0)
12:13:34 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:BOGIBATINA -b -n -d master -o
"C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out" -i
"C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.sql" -Usa -P"
12:13:34 Process Exit Code: (1)
12:14:10 Error running script: replsys.sql (1)
12:14:10 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
1 -Action 6 -Service MSSQLSERVER
12:14:25 Process Exit Code: (0)
12:14:25 Action CleanUpInstall:
12:14:25 Installation Failed.Have you looked in this file?
C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out
R.
"Radovan" <radovan@.servis24.hr> wrote in message
news:OWXdLAeuFHA.2072@.TK2MSFTNGP14.phx.gbl...
> I can't install sp4. I got error :Error running script: replsys.sql (1)
> looking in sqllog, I have this lines (at the end of file).
> ...
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\setup.iss returned: 0, 0
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
> 12:13:12 SetFileSecuritySQLAndAdmin for returned: 3, 3
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
> 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlstp.log returned: 0, 0
> 12:13:12 SetFileSecPerfAndLogUsers for C:\Program Files\Microsoft SQL
> Server\MSSQL\Binn\SQLCTR80.DLL returned: 1332, 1332
> 12:13:12 Begin ServPriv (MSSQLSERVER)
> 12:13:12 End ServPriv()
> 12:13:13 Upgrading databases
> 12:13:13 Upgrading databases on instance 'MSSQLSERVER'
> 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
> 1 -Action 6 -Service MSSQLSERVER
> 12:13:13 Process Exit Code: (0)
> 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
> 1 -Action 6 -Service MSSQLSERVER
> 12:13:13 Process Exit Code: (0)
> 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
> 1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022 \-T4010 \-m
> 12:13:34 Process Exit Code: (0)
> 12:13:34 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:BOGIBATINA -b -n -d master -o
> "C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out" -i
> "C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.sql" -Usa -P"
> 12:13:34 Process Exit Code: (1)
> 12:14:10 Error running script: replsys.sql (1)
> 12:14:10 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
> 1 -Action 6 -Service MSSQLSERVER
> 12:14:25 Process Exit Code: (0)
> 12:14:25 Action CleanUpInstall:
> 12:14:25 Installation Failed.
>|||Check what other processes are running on your server. I had the same
problem updating to SP4. I had to stop MOM services, Windows update
processes, and end anything else that may be using SQL. Then the SP4
install will go OK.
Mike
R wrote:
> Have you looked in this file?
> C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out
> R.
> "Radovan" <radovan@.servis24.hr> wrote in message
> news:OWXdLAeuFHA.2072@.TK2MSFTNGP14.phx.gbl...
> > I can't install sp4. I got error :Error running script: replsys.sql (1)
> >
> > looking in sqllog, I have this lines (at the end of file).
> >
> > ...
> > 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\setup.iss returned: 0, 0
> > 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
> >
> > 12:13:12 SetFileSecuritySQLAndAdmin for returned: 3, 3
> >
> > 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0, 0
> >
> > 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlstp.log returned: 0, 0
> >
> > 12:13:12 SetFileSecPerfAndLogUsers for C:\Program Files\Microsoft SQL
> > Server\MSSQL\Binn\SQLCTR80.DLL returned: 1332, 1332
> >
> > 12:13:12 Begin ServPriv (MSSQLSERVER)
> >
> > 12:13:12 End ServPriv()
> >
> > 12:13:13 Upgrading databases
> >
> > 12:13:13 Upgrading databases on instance 'MSSQLSERVER'
> >
> > 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
> > 1 -Action 6 -Service MSSQLSERVER
> >
> > 12:13:13 Process Exit Code: (0)
> >
> > 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
> > 1 -Action 6 -Service MSSQLSERVER
> >
> > 12:13:13 Process Exit Code: (0)
> >
> > 12:13:13 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
> > 1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022 \-T4010 \-m
> >
> > 12:13:34 Process Exit Code: (0)
> >
> > 12:13:34 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:BOGIBATINA -b -n -d master -o
> > "C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out" -i
> > "C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.sql" -Usa -P"
> >
> > 12:13:34 Process Exit Code: (1)
> >
> > 12:14:10 Error running script: replsys.sql (1)
> >
> > 12:14:10 C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
> > 1 -Action 6 -Service MSSQLSERVER
> >
> > 12:14:25 Process Exit Code: (0)
> >
> > 12:14:25 Action CleanUpInstall:
> >
> > 12:14:25 Installation Failed.
> >
> >|||Thanks that helps.
Radovan
"inqbbus" <inqbbus@.gmail.com> wrote in message
news:1126820621.538655.83620@.g47g2000cwa.googlegroups.com...
> Check what other processes are running on your server. I had the same
> problem updating to SP4. I had to stop MOM services, Windows update
> processes, and end anything else that may be using SQL. Then the SP4
> install will go OK.
> Mike
> R wrote:
>> Have you looked in this file?
>> C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out
>> R.
>> "Radovan" <radovan@.servis24.hr> wrote in message
>> news:OWXdLAeuFHA.2072@.TK2MSFTNGP14.phx.gbl...
>> > I can't install sp4. I got error :Error running script: replsys.sql (1)
>> >
>> > looking in sqllog, I have this lines (at the end of file).
>> >
>> > ...
>> > 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\setup.iss returned: 0,
>> > 0
>> > 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0,
>> > 0
>> >
>> > 12:13:12 SetFileSecuritySQLAndAdmin for returned: 3, 3
>> >
>> > 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlsp.log returned: 0,
>> > 0
>> >
>> > 12:13:12 SetFileSecuritySQLAndAdmin for C:\WINNT\sqlstp.log returned:
>> > 0, 0
>> >
>> > 12:13:12 SetFileSecPerfAndLogUsers for C:\Program Files\Microsoft SQL
>> > Server\MSSQL\Binn\SQLCTR80.DLL returned: 1332, 1332
>> >
>> > 12:13:12 Begin ServPriv (MSSQLSERVER)
>> >
>> > 12:13:12 End ServPriv()
>> >
>> > 12:13:13 Upgrading databases
>> >
>> > 12:13:13 Upgrading databases on instance 'MSSQLSERVER'
>> >
>> > 12:13:13
>> > C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
>> > 1 -Action 6 -Service MSSQLSERVER
>> >
>> > 12:13:13 Process Exit Code: (0)
>> >
>> > 12:13:13
>> > C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
>> > 1 -Action 6 -Service MSSQLSERVER
>> >
>> > 12:13:13 Process Exit Code: (0)
>> >
>> > 12:13:13
>> > C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
>> > 1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022 \-T4010 \-m
>> >
>> > 12:13:34 Process Exit Code: (0)
>> >
>> > 12:13:34 C:\SQL2KSP4\x86\BINN\osql.exe -Slpc:BOGIBATINA -b -n -d
>> > master -o
>> > "C:\Program Files\Microsoft SQL Server\MSSQL\install\replsys.out" -i
>> > "C:\Program Files\Microsoft SQL
>> > Server\MSSQL\install\replsys.sql" -Usa -P"
>> >
>> > 12:13:34 Process Exit Code: (1)
>> >
>> > 12:14:10 Error running script: replsys.sql (1)
>> >
>> > 12:14:10
>> > C:\DOCUME~1\radovan\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe -Silent
>> > 1 -Action 6 -Service MSSQLSERVER
>> >
>> > 12:14:25 Process Exit Code: (0)
>> >
>> > 12:14:25 Action CleanUpInstall:
>> >
>> > 12:14:25 Installation Failed.
>> >
>> >
>

Friday, March 9, 2012

Problem with DTS

Hi there.
I have the following environment:
Windows 2000 Server SP4, SQL Server 2000 Sp3.
There are some DTS which have been creating some time ago. They are
scheduled are have been runngin until now. Now the jobs fail. Can't say
what has been changed. Haven't been responsible for those systems and
those who are say they didnt change anything (same story as always ;)
...)
The DTS have been created when connecting with an Windows Domain
Account. When I connect with this Windows Account I can open and run
those DTS. But when login as local Admin directly on the server and open
Enterprise Manager with the local Admin User and try to open the DTS I
get an error:
Error Source : Microsfot OLE DB Provider for SQL Server
Error Description: [DBNETLIB]ConnectionOpen(Connect()).]SQL Server does
not exist or access is denied.
The DTS is a Local Package (I have some Meta Data Service Packages ...
same there).
The simlest DTS has two SQL Server connection using a SQL User. First a
Delete on the first connection is made, then some data is copied from
connection2 to connection1.
As I said, when I login with Domain User Account I can open it, edit it,
run it .. no problems. But with the local Admin of the SQL Server ...
error.
SQL Server and SQL Agent are running as local System Accounts.
Why am I getting this error? I think it cant be the Connections in the
DTS, because there SQL Users are used which exists and work.
The Local Administartor is also a SQL System Admin, as are the Domain
Admins.
Any hints? Anyone knows where I could investigate further?
mfg
Marc Eggenberger
Someone removed the BUILTIN\Administrators login from SQL Server, as they
should have, and have replaced it with the [NT AUTHORITY\SYSTEM] group;
however, they should have followed proper Change Control policies. I'm
surprised you haven't been having more problems.
At the VERY least, you should be running the MSSQL and SQLAGENT service
under local accounts, NOT SYSTEM. And, if you can, run the services under a
Domain Account.
So you know, SYSTEM = [NT AUTHORITY]\SYSTEM and is not a Local User but a
GLOBAL AD GROUP. The members of this group are all the <Machine Name>$
server accounts that are created whenever you add a server as a Domain Member.
Next, if you use a Domain Account for the services, you can grant explicit
privleges to those accounts on other server network shares.
As you know, DTS runs in the process space and under the security context of
the user that executes the DTSRun command. When the package runs as a job,
it uses the server's memory space and the SYSTEM account because that is what
the SQLAgent is running as and where it is running.
You can not log in as SYSTEM and SYSTEM and Local Administrator are two
different security contexts. Another good reason to have an explicitly
defined account to run the SQL Server services under: you can log in to the
server as that user and "see" what the services would see when they log in.
Sincerely,
Anthony Thomas
"Marc Eggenberger" wrote:

> Hi there.
> I have the following environment:
> Windows 2000 Server SP4, SQL Server 2000 Sp3.
> There are some DTS which have been creating some time ago. They are
> scheduled are have been runngin until now. Now the jobs fail. Can't say
> what has been changed. Haven't been responsible for those systems and
> those who are say they didnt change anything (same story as always ;)
> ...)
> The DTS have been created when connecting with an Windows Domain
> Account. When I connect with this Windows Account I can open and run
> those DTS. But when login as local Admin directly on the server and open
> Enterprise Manager with the local Admin User and try to open the DTS I
> get an error:
> Error Source : Microsfot OLE DB Provider for SQL Server
> Error Description: [DBNETLIB]ConnectionOpen(Connect()).]SQL Server does
> not exist or access is denied.
> The DTS is a Local Package (I have some Meta Data Service Packages ...
> same there).
> The simlest DTS has two SQL Server connection using a SQL User. First a
> Delete on the first connection is made, then some data is copied from
> connection2 to connection1.
> As I said, when I login with Domain User Account I can open it, edit it,
> run it .. no problems. But with the local Admin of the SQL Server ...
> error.
> SQL Server and SQL Agent are running as local System Accounts.
> Why am I getting this error? I think it cant be the Connections in the
> DTS, because there SQL Users are used which exists and work.
> The Local Administartor is also a SQL System Admin, as are the Domain
> Admins.
> Any hints? Anyone knows where I could investigate further?
>
> --
> mfg
> Marc Eggenberger
>

Problem with DTS

Hi there.
I have the following environment:
Windows 2000 Server SP4, SQL Server 2000 Sp3.
There are some DTS which have been creating some time ago. They are
scheduled are have been runngin until now. Now the jobs fail. Can't say
what has been changed. Haven't been responsible for those systems and
those who are say they didnt change anything (same story as always ;)
...)
The DTS have been created when connecting with an Windows Domain
Account. When I connect with this Windows Account I can open and run
those DTS. But when login as local Admin directly on the server and open
Enterprise Manager with the local Admin User and try to open the DTS I
get an error:
Error Source : Microsfot OLE DB Provider for SQL Server
Error Description: [DBNETLIB]ConnectionOpen(Connect()).]SQL Server does
not exist or access is denied.
The DTS is a Local Package (I have some Meta Data Service Packages ...
same there).
The simlest DTS has two SQL Server connection using a SQL User. First a
Delete on the first connection is made, then some data is copied from
connection2 to connection1.
As I said, when I login with Domain User Account I can open it, edit it,
run it .. no problems. But with the local Admin of the SQL Server ...
error.
SQL Server and SQL Agent are running as local System Accounts.
Why am I getting this error? I think it cant be the Connections in the
DTS, because there SQL Users are used which exists and work.
The Local Administartor is also a SQL System Admin, as are the Domain
Admins.
Any hints? Anyone knows where I could investigate further?
mfg
Marc EggenbergerSomeone removed the BUILTIN\Administrators login from SQL Server, as they
should have, and have replaced it with the [NT AUTHORITY\SYSTEM] group;
however, they should have followed proper Change Control policies. I'm
surprised you haven't been having more problems.
At the VERY least, you should be running the MSSQL and SQLAGENT service
under local accounts, NOT SYSTEM. And, if you can, run the services under a
Domain Account.
So you know, SYSTEM = [NT AUTHORITY]\SYSTEM and is not a Local User but
a
GLOBAL AD GROUP. The members of this group are all the <Machine Name>$
server accounts that are created whenever you add a server as a Domain Membe
r.
Next, if you use a Domain Account for the services, you can grant explicit
privleges to those accounts on other server network shares.
As you know, DTS runs in the process space and under the security context of
the user that executes the DTSRun command. When the package runs as a job,
it uses the server's memory space and the SYSTEM account because that is wha
t
the SQLAgent is running as and where it is running.
You can not log in as SYSTEM and SYSTEM and Local Administrator are two
different security contexts. Another good reason to have an explicitly
defined account to run the SQL Server services under: you can log in to the
server as that user and "see" what the services would see when they log in.
Sincerely,
Anthony Thomas
"Marc Eggenberger" wrote:

> Hi there.
> I have the following environment:
> Windows 2000 Server SP4, SQL Server 2000 Sp3.
> There are some DTS which have been creating some time ago. They are
> scheduled are have been runngin until now. Now the jobs fail. Can't say
> what has been changed. Haven't been responsible for those systems and
> those who are say they didnt change anything (same story as always ;)
> ...)
> The DTS have been created when connecting with an Windows Domain
> Account. When I connect with this Windows Account I can open and run
> those DTS. But when login as local Admin directly on the server and open
> Enterprise Manager with the local Admin User and try to open the DTS I
> get an error:
> Error Source : Microsfot OLE DB Provider for SQL Server
> Error Description: [DBNETLIB]ConnectionOpen(Connect()).]SQL Server doe
s
> not exist or access is denied.
> The DTS is a Local Package (I have some Meta Data Service Packages ...
> same there).
> The simlest DTS has two SQL Server connection using a SQL User. First a
> Delete on the first connection is made, then some data is copied from
> connection2 to connection1.
> As I said, when I login with Domain User Account I can open it, edit it,
> run it .. no problems. But with the local Admin of the SQL Server ...
> error.
> SQL Server and SQL Agent are running as local System Accounts.
> Why am I getting this error? I think it cant be the Connections in the
> DTS, because there SQL Users are used which exists and work.
> The Local Administartor is also a SQL System Admin, as are the Domain
> Admins.
> Any hints? Anyone knows where I could investigate further?
>
> --
> mfg
> Marc Eggenberger
>

Problem with DTS

Hi there.
I have the following environment:
Windows 2000 Server SP4, SQL Server 2000 Sp3.
There are some DTS which have been creating some time ago. They are
scheduled are have been runngin until now. Now the jobs fail. Can't say
what has been changed. Haven't been responsible for those systems and
those who are say they didnt change anything (same story as always ;)
...)
The DTS have been created when connecting with an Windows Domain
Account. When I connect with this Windows Account I can open and run
those DTS. But when login as local Admin directly on the server and open
Enterprise Manager with the local Admin User and try to open the DTS I
get an error:
Error Source : Microsfot OLE DB Provider for SQL Server
Error Description: [DBNETLIB]ConnectionOpen(Connect()).]SQL Server does
not exist or access is denied.
The DTS is a Local Package (I have some Meta Data Service Packages ...
same there).
The simlest DTS has two SQL Server connection using a SQL User. First a
Delete on the first connection is made, then some data is copied from
connection2 to connection1.
As I said, when I login with Domain User Account I can open it, edit it,
run it .. no problems. But with the local Admin of the SQL Server ...
error.
SQL Server and SQL Agent are running as local System Accounts.
Why am I getting this error? I think it cant be the Connections in the
DTS, because there SQL Users are used which exists and work.
The Local Administartor is also a SQL System Admin, as are the Domain
Admins.
Any hints? Anyone knows where I could investigate further?
--
mfg
Marc EggenbergerSomeone removed the BUILTIN\Administrators login from SQL Server, as they
should have, and have replaced it with the [NT AUTHORITY\SYSTEM] group;
however, they should have followed proper Change Control policies. I'm
surprised you haven't been having more problems.
At the VERY least, you should be running the MSSQL and SQLAGENT service
under local accounts, NOT SYSTEM. And, if you can, run the services under a
Domain Account.
So you know, SYSTEM = [NT AUTHORITY]\SYSTEM and is not a Local User but a
GLOBAL AD GROUP. The members of this group are all the <Machine Name>$
server accounts that are created whenever you add a server as a Domain Member.
Next, if you use a Domain Account for the services, you can grant explicit
privleges to those accounts on other server network shares.
As you know, DTS runs in the process space and under the security context of
the user that executes the DTSRun command. When the package runs as a job,
it uses the server's memory space and the SYSTEM account because that is what
the SQLAgent is running as and where it is running.
You can not log in as SYSTEM and SYSTEM and Local Administrator are two
different security contexts. Another good reason to have an explicitly
defined account to run the SQL Server services under: you can log in to the
server as that user and "see" what the services would see when they log in.
Sincerely,
Anthony Thomas
"Marc Eggenberger" wrote:
> Hi there.
> I have the following environment:
> Windows 2000 Server SP4, SQL Server 2000 Sp3.
> There are some DTS which have been creating some time ago. They are
> scheduled are have been runngin until now. Now the jobs fail. Can't say
> what has been changed. Haven't been responsible for those systems and
> those who are say they didnt change anything (same story as always ;)
> ...)
> The DTS have been created when connecting with an Windows Domain
> Account. When I connect with this Windows Account I can open and run
> those DTS. But when login as local Admin directly on the server and open
> Enterprise Manager with the local Admin User and try to open the DTS I
> get an error:
> Error Source : Microsfot OLE DB Provider for SQL Server
> Error Description: [DBNETLIB]ConnectionOpen(Connect()).]SQL Server does
> not exist or access is denied.
> The DTS is a Local Package (I have some Meta Data Service Packages ...
> same there).
> The simlest DTS has two SQL Server connection using a SQL User. First a
> Delete on the first connection is made, then some data is copied from
> connection2 to connection1.
> As I said, when I login with Domain User Account I can open it, edit it,
> run it .. no problems. But with the local Admin of the SQL Server ...
> error.
> SQL Server and SQL Agent are running as local System Accounts.
> Why am I getting this error? I think it cant be the Connections in the
> DTS, because there SQL Users are used which exists and work.
> The Local Administartor is also a SQL System Admin, as are the Domain
> Admins.
> Any hints? Anyone knows where I could investigate further?
>
> --
> mfg
> Marc Eggenberger
>