sql2k sp3
win2k sp4
Im trying to create a Pull Subscription for replication and get "Error 8198:
Could not obtain information about Windows NT group/ user 'domain/ user'".
I read this:
http://support.microsoft.com/?kbid=834124
But both boxes are in the same domain and the same subnet. Both use the same
domain admin account for SQL Server and the Agent accounts.
I also read this:
http://support.microsoft.com/?kbid=838460
But Im not about to install sp4 Beta on anything.
Is there anything else I can do?
TIA, ChrisRright click on your agent and make the agent owner sa. Restart your job.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"ChrisR" <noemail@.bla.com> wrote in message
news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
> sql2k sp3
> win2k sp4
> Im trying to create a Pull Subscription for replication and get "Error
8198:
> Could not obtain information about Windows NT group/ user 'domain/ user'".
> I read this:
> http://support.microsoft.com/?kbid=834124
> But both boxes are in the same domain and the same subnet. Both use the
same
> domain admin account for SQL Server and the Agent accounts.
> I also read this:
> http://support.microsoft.com/?kbid=838460
> But Im not about to install sp4 Beta on anything.
> Is there anything else I can do?
> TIA, ChrisR
>|||Which Agent are you referring too? All of the jobs are owned by SA.
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23RPeZF2SFHA.3544@.TK2MSFTNGP12.phx.gbl...
> right click on your agent and make the agent owner sa. Restart your job.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "ChrisR" <noemail@.bla.com> wrote in message
> news:OZAuC21SFHA.2256@.tk2msftngp13.phx.gbl...
>> sql2k sp3
>> win2k sp4
>> Im trying to create a Pull Subscription for replication and get "Error
> 8198:
>> Could not obtain information about Windows NT group/ user 'domain/
>> user'".
>> I read this:
>> http://support.microsoft.com/?kbid=834124
>> But both boxes are in the same domain and the same subnet. Both use the
> same
>> domain admin account for SQL Server and the Agent accounts.
>> I also read this:
>> http://support.microsoft.com/?kbid=838460
>> But Im not about to install sp4 Beta on anything.
>> Is there anything else I can do?
>> TIA, ChrisR
>>
>
Showing posts with label win2k. Show all posts
Showing posts with label win2k. Show all posts
Thursday, March 22, 2012
Sunday, March 11, 2012
Error 5172
Hello,
I hava an sql server 2000 sp3a on a win2k sp4 machine running all ok. I tried to build a raid 1 using the hdd where sqlserver was and a new one, but i failed to build it and consecuently i lost all data bases.
Using some programs, i recover the mdf, ldf and ndf files from my old sql server 2000.
I reinstalled all the system exactly the same, win2k sp4 and sql server 2000 with sp3a ( i know sp4 is out ), installed all the apps and overwrites mdf,nfs and ldf files with the old data, and when i tried to put databse online i get this error:
error 5172: header not valid on file "C:\dbtest.mdf". Pageaudit property is not valid.
Any one can help me?http://www.dbforums.com/t749523.html
http://www.lazydba.com/sql/1__728.html
There's lots of stuff out there...just google it...|||well, i've tried this before post with no result. i just ask here becouse i'm very lost.|||I tried command:
exec sp_attach_db @.dbname ... with so meny variation and i get the same error. Can anyone help me?
Thanks.
I hava an sql server 2000 sp3a on a win2k sp4 machine running all ok. I tried to build a raid 1 using the hdd where sqlserver was and a new one, but i failed to build it and consecuently i lost all data bases.
Using some programs, i recover the mdf, ldf and ndf files from my old sql server 2000.
I reinstalled all the system exactly the same, win2k sp4 and sql server 2000 with sp3a ( i know sp4 is out ), installed all the apps and overwrites mdf,nfs and ldf files with the old data, and when i tried to put databse online i get this error:
error 5172: header not valid on file "C:\dbtest.mdf". Pageaudit property is not valid.
Any one can help me?http://www.dbforums.com/t749523.html
http://www.lazydba.com/sql/1__728.html
There's lots of stuff out there...just google it...|||well, i've tried this before post with no result. i just ask here becouse i'm very lost.|||I tried command:
exec sp_attach_db @.dbname ... with so meny variation and i get the same error. Can anyone help me?
Thanks.
Friday, March 9, 2012
Error 5: Access denied
Upgraded an NT 4 server to WIN2K Server with SQL Server 2000 already
installed. Now getting MSSQLSERVER service startup errors with access
denied despite having domain admin as logon. What gives?
Check the 'logon as' in Control Panel\Services. Did the password for that
account get changed during the upgrade? Or should it be a new login all
together? In any case, check that.
hth
"Terry Johnson" <tjohnson@.contech.com> wrote in message
news:%23etTiUw1EHA.2316@.TK2MSFTNGP15.phx.gbl...
> Upgraded an NT 4 server to WIN2K Server with SQL Server 2000 already
> installed. Now getting MSSQLSERVER service startup errors with access
> denied despite having domain admin as logon. What gives?
>
installed. Now getting MSSQLSERVER service startup errors with access
denied despite having domain admin as logon. What gives?
Check the 'logon as' in Control Panel\Services. Did the password for that
account get changed during the upgrade? Or should it be a new login all
together? In any case, check that.
hth
"Terry Johnson" <tjohnson@.contech.com> wrote in message
news:%23etTiUw1EHA.2316@.TK2MSFTNGP15.phx.gbl...
> Upgraded an NT 4 server to WIN2K Server with SQL Server 2000 already
> installed. Now getting MSSQLSERVER service startup errors with access
> denied despite having domain admin as logon. What gives?
>
Error 5 Access Denied
Upgraded an NT 4 server to WIN2K Server with SQL Server 2000 already
installed. Now getting MSSQLSERVER service startup errors with access
denied despite having domain admin as logon. What gives'Check the drive in which the Binn files are installed. Make sure they arent
ReadOnly, also try giving explicit rights ot your account to those folders
and try agian.
Thanks.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
installed. Now getting MSSQLSERVER service startup errors with access
denied despite having domain admin as logon. What gives'Check the drive in which the Binn files are installed. Make sure they arent
ReadOnly, also try giving explicit rights ot your account to those folders
and try agian.
Thanks.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Error 5 Access Denied
Upgraded an NT 4 server to WIN2K Server with SQL Server 2000 already
installed. Now getting MSSQLSERVER service startup errors with access
denied despite having domain admin as logon. What gives?
Check the drive in which the Binn files are installed. Make sure they arent
ReadOnly, also try giving explicit rights ot your account to those folders
and try agian.
Thanks.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
installed. Now getting MSSQLSERVER service startup errors with access
denied despite having domain admin as logon. What gives?
Check the drive in which the Binn files are installed. Make sure they arent
ReadOnly, also try giving explicit rights ot your account to those folders
and try agian.
Thanks.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Error 5 Access Denied
Upgraded an NT 4 server to WIN2K Server with SQL Server 2000 already
installed. Now getting MSSQLSERVER service startup errors with access
denied despite having domain admin as logon. What gives'Check the drive in which the Binn files are installed. Make sure they arent
ReadOnly, also try giving explicit rights ot your account to those folders
and try agian.
Thanks.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
installed. Now getting MSSQLSERVER service startup errors with access
denied despite having domain admin as logon. What gives'Check the drive in which the Binn files are installed. Make sure they arent
ReadOnly, also try giving explicit rights ot your account to those folders
and try agian.
Thanks.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Subscribe to:
Posts (Atom)