Hello everyone,
We have a bit of a problem with replication between two SQL servers
belonging to different domains.
Basically we have two active directory domains: DomA and DomB (neither of
them is local domain).
Each of then has a SQL Server 2000 Enterprise edition installed with SP3.
There is a database on DomA that has to be merge replicated with DomB
through dial-up connection.
We establish the dial-up connection (RRAS is running on DomA) between the
domains and create a pull subscription on DomB but when we start the
synchronisation process we always get the error that server in DomA does not
exist or access denied.
Just to mention that the replication agent on DomB is set up to run with sql
server login 'sa' (checked the password a hundred times).
Any ideas appreciated. We would not mind switching to active directory
enabled replication between the two is someone could give us guidelines.
Thank you all in advance.
Best regards,
GAZCreate an admin account on both servers with the same name and password.
Have sql server agent run under this account on both servers. Use the
impersonate the sql server agent option.
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
"asd" <asd@.asd.com> wrote in message
news:uJmqQCaIGHA.3176@.TK2MSFTNGP12.phx.gbl...
> Hello everyone,
> We have a bit of a problem with replication between two SQL servers
> belonging to different domains.
> Basically we have two active directory domains: DomA and DomB (neither of
> them is local domain).
> Each of then has a SQL Server 2000 Enterprise edition installed with SP3.
> There is a database on DomA that has to be merge replicated with DomB
> through dial-up connection.
> We establish the dial-up connection (RRAS is running on DomA) between the
> domains and create a pull subscription on DomB but when we start the
> synchronisation process we always get the error that server in DomA does
> not exist or access denied.
> Just to mention that the replication agent on DomB is set up to run with
> sql server login 'sa' (checked the password a hundred times).
> Any ideas appreciated. We would not mind switching to active directory
> enabled replication between the two is someone could give us guidelines.
> Thank you all in advance.
> Best regards,
> GAZ
>|||Thanks for the aswer but unfortunately it does not work. We still get the
same message 'SQL server does not exist or access denied.'
We can ping the server in question with both the IP address and its name,
but still we cannot run the replication.|||Is the sa account you are using in your agent to connect to the subscriber
the publisher sa account or the subscriber one? It should be the publisher
one.
This could be a name resolution problem or a account problem. It sound like
its not a name resolution problem as you can connect to the publisher and
configure the pull. So it probably is an account problem.
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
"asd" <asd@.asd.com> wrote in message
news:ujJqbTbIGHA.3752@.TK2MSFTNGP11.phx.gbl...
> Thanks for the aswer but unfortunately it does not work. We still get the
> same message 'SQL server does not exist or access denied.'
> We can ping the server in question with both the IP address and its name,
> but still we cannot run the replication.
>|||Hello,
You could check the job owner of the merge job:
1. Right click the pull subscription->Properites->Synchrnization->Agent
Properites
2. Change the job owner to the local account with SQL system admin account
on both local and resmote server to test.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN
This posting is provided "AS IS" with no warranties, and confers no rights.
--
>From: "Hilary Cotter" <hilary.cotter@.gmail.com>
>References: <uJmqQCaIGHA.3176@.TK2MSFTNGP12.phx.gbl>
<e9uuFgaIGHA.596@.TK2MSFTNGP10.phx.gbl>
<ujJqbTbIGHA.3752@.TK2MSFTNGP11.phx.gbl>
>Subject: Re: Multi Domain Replication Security Issue
>Date: Wed, 25 Jan 2006 09:48:50 -0500
>Lines: 26
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.3790.1830
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>X-RFC2646: Format=Flowed; Response
>Message-ID: <#s1N35bIGHA.3408@.TK2MSFTNGP12.phx.gbl>
>Newsgroups:
microsoft.public.sqlserver.relationalserver.performance,microsoft.public.sql
server.replication,microsoft.public.sqlserver.security,microsoft.public.sqls
erver.securitytools
>NNTP-Posting-Host: 165.1.27.105
>Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
>Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.replication:68745
microsoft.public.sqlserver.security:26245
microsoft.public.sqlserver.securitytools:1079
microsoft.public.sqlserver.relationalserver.performance:117
>X-Tomcat-NG: microsoft.public.sqlserver.security
>Is the sa account you are using in your agent to connect to the subscriber
>the publisher sa account or the subscriber one? It should be the publisher
>one.
>This could be a name resolution problem or a account problem. It sound
like
>its not a name resolution problem as you can connect to the publisher and
>configure the pull. So it probably is an account problem.
>--
>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
>"asd" <asd@.asd.com> wrote in message
>news:ujJqbTbIGHA.3752@.TK2MSFTNGP11.phx.gbl...
the[vbcol=seagreen]
name,[vbcol=seagreen]
>
>|||Both sa accounts have the same password. Whatever we try there are no
results. We shall try to create a clean domain B installation and start from
scratch. Maybe we shall have better luck this time.
Still, any ideas and suggestions are welcome.
BR,
GAZ
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23s1N35bIGHA.3408@.TK2MSFTNGP12.phx.gbl...
> Is the sa account you are using in your agent to connect to the subscriber
> the publisher sa account or the subscriber one? It should be the publisher
> one.
> This could be a name resolution problem or a account problem. It sound
> like its not a name resolution problem as you can connect to the publisher
> and configure the pull. So it probably is an account problem.
> --
> 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
> "asd" <asd@.asd.com> wrote in message
> news:ujJqbTbIGHA.3752@.TK2MSFTNGP11.phx.gbl...
>|||To be sure we started off with jobs being owned by the domain admin
accounts. No avail.
Any thoughts appreciated.
BR,
GAZ
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:Cs4jakhIGHA.3944@.TK2MSFTNGXA02.phx.gbl...
> Hello,
> You could check the job owner of the merge job:
> 1. Right click the pull subscription->Properites->Synchrnization->Agent
> Properites
> 2. Change the job owner to the local account with SQL system admin account
> on both local and resmote server to test.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> Business-Critical Phone Support (BCPS) provides you with technical phone
> support at no charge during critical LAN
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> --
> <e9uuFgaIGHA.596@.TK2MSFTNGP10.phx.gbl>
> <ujJqbTbIGHA.3752@.TK2MSFTNGP11.phx.gbl>
> microsoft.public.sqlserver.relationalserver.performance,microsoft.public.s
ql
> server.replication,microsoft.public.sqlserver.security,microsoft.public.sq
ls
> erver.securitytools
> microsoft.public.sqlserver.security:26245
> microsoft.public.sqlserver.securitytools:1079
> microsoft.public.sqlserver.relationalserver.performance:117
> like
> the
> name,
>|||is xp_cmdshell enabled on the subscriber?
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
"asd" <asd@.asd.com> wrote in message
news:OrjMwdoIGHA.668@.TK2MSFTNGP11.phx.gbl...
> Both sa accounts have the same password. Whatever we try there are no
> results. We shall try to create a clean domain B installation and start
> from scratch. Maybe we shall have better luck this time.
> Still, any ideas and suggestions are welcome.
> BR,
> GAZ
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%23s1N35bIGHA.3408@.TK2MSFTNGP12.phx.gbl...
>|||Yes. It can be executed and it works like a charm. We are just in the
process of setting up the new domain to try this from scratch. Let you all
know how it went.
BR,
GAZ
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:u0$K8BqIGHA.964@.tk2msftngp13.phx.gbl...
> is xp_cmdshell enabled on the subscriber?
> --
> 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
> "asd" <asd@.asd.com> wrote in message
> news:OrjMwdoIGHA.668@.TK2MSFTNGP11.phx.gbl...
>|||We reinstalled the DomB and now everything works like clockworks. We haven't
the foggiest what the problem was but for now ignorance is a bliss. We'll
have to set up a new network soon with the same parameters and we'll keep a
keener eye on things.
Thanks everyone for your help.
GAZsql
Showing posts with label domain. Show all posts
Showing posts with label domain. Show all posts
Monday, March 26, 2012
Multi Domain Replication Security Issue
Hello everyone,
We have a bit of a problem with replication between two SQL servers
belonging to different domains.
Basically we have two active directory domains: DomA and DomB (neither of
them is local domain).
Each of then has a SQL Server 2000 Enterprise edition installed with SP3.
There is a database on DomA that has to be merge replicated with DomB
through dial-up connection.
We establish the dial-up connection (RRAS is running on DomA) between the
domains and create a pull subscription on DomB but when we start the
synchronisation process we always get the error that server in DomA does not
exist or access denied.
Just to mention that the replication agent on DomB is set up to run with sql
server login 'sa' (checked the password a hundred times).
Any ideas appreciated. We would not mind switching to active directory
enabled replication between the two is someone could give us guidelines.
Thank you all in advance.
Best regards,
GAZ
Create an admin account on both servers with the same name and password.
Have sql server agent run under this account on both servers. Use the
impersonate the sql server agent option.
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
"asd" <asd@.asd.com> wrote in message
news:uJmqQCaIGHA.3176@.TK2MSFTNGP12.phx.gbl...
> Hello everyone,
> We have a bit of a problem with replication between two SQL servers
> belonging to different domains.
> Basically we have two active directory domains: DomA and DomB (neither of
> them is local domain).
> Each of then has a SQL Server 2000 Enterprise edition installed with SP3.
> There is a database on DomA that has to be merge replicated with DomB
> through dial-up connection.
> We establish the dial-up connection (RRAS is running on DomA) between the
> domains and create a pull subscription on DomB but when we start the
> synchronisation process we always get the error that server in DomA does
> not exist or access denied.
> Just to mention that the replication agent on DomB is set up to run with
> sql server login 'sa' (checked the password a hundred times).
> Any ideas appreciated. We would not mind switching to active directory
> enabled replication between the two is someone could give us guidelines.
> Thank you all in advance.
> Best regards,
> GAZ
>
|||Thanks for the aswer but unfortunately it does not work. We still get the
same message 'SQL server does not exist or access denied.'
We can ping the server in question with both the IP address and its name,
but still we cannot run the replication.
|||Is the sa account you are using in your agent to connect to the subscriber
the publisher sa account or the subscriber one? It should be the publisher
one.
This could be a name resolution problem or a account problem. It sound like
its not a name resolution problem as you can connect to the publisher and
configure the pull. So it probably is an account problem.
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
"asd" <asd@.asd.com> wrote in message
news:ujJqbTbIGHA.3752@.TK2MSFTNGP11.phx.gbl...
> Thanks for the aswer but unfortunately it does not work. We still get the
> same message 'SQL server does not exist or access denied.'
> We can ping the server in question with both the IP address and its name,
> but still we cannot run the replication.
>
|||Both sa accounts have the same password. Whatever we try there are no
results. We shall try to create a clean domain B installation and start from
scratch. Maybe we shall have better luck this time.
Still, any ideas and suggestions are welcome.
BR,
GAZ
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23s1N35bIGHA.3408@.TK2MSFTNGP12.phx.gbl...
> Is the sa account you are using in your agent to connect to the subscriber
> the publisher sa account or the subscriber one? It should be the publisher
> one.
> This could be a name resolution problem or a account problem. It sound
> like its not a name resolution problem as you can connect to the publisher
> and configure the pull. So it probably is an account problem.
> --
> 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
> "asd" <asd@.asd.com> wrote in message
> news:ujJqbTbIGHA.3752@.TK2MSFTNGP11.phx.gbl...
>
|||is xp_cmdshell enabled on the subscriber?
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
"asd" <asd@.asd.com> wrote in message
news:OrjMwdoIGHA.668@.TK2MSFTNGP11.phx.gbl...
> Both sa accounts have the same password. Whatever we try there are no
> results. We shall try to create a clean domain B installation and start
> from scratch. Maybe we shall have better luck this time.
> Still, any ideas and suggestions are welcome.
> BR,
> GAZ
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%23s1N35bIGHA.3408@.TK2MSFTNGP12.phx.gbl...
>
|||Yes. It can be executed and it works like a charm. We are just in the
process of setting up the new domain to try this from scratch. Let you all
know how it went.
BR,
GAZ
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:u0$K8BqIGHA.964@.tk2msftngp13.phx.gbl...
> is xp_cmdshell enabled on the subscriber?
> --
> 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
> "asd" <asd@.asd.com> wrote in message
> news:OrjMwdoIGHA.668@.TK2MSFTNGP11.phx.gbl...
>
|||We reinstalled the DomB and now everything works like clockworks. We haven't
the foggiest what the problem was but for now ignorance is a bliss. We'll
have to set up a new network soon with the same parameters and we'll keep a
keener eye on things.
Thanks everyone for your help.
GAZ
We have a bit of a problem with replication between two SQL servers
belonging to different domains.
Basically we have two active directory domains: DomA and DomB (neither of
them is local domain).
Each of then has a SQL Server 2000 Enterprise edition installed with SP3.
There is a database on DomA that has to be merge replicated with DomB
through dial-up connection.
We establish the dial-up connection (RRAS is running on DomA) between the
domains and create a pull subscription on DomB but when we start the
synchronisation process we always get the error that server in DomA does not
exist or access denied.
Just to mention that the replication agent on DomB is set up to run with sql
server login 'sa' (checked the password a hundred times).
Any ideas appreciated. We would not mind switching to active directory
enabled replication between the two is someone could give us guidelines.
Thank you all in advance.
Best regards,
GAZ
Create an admin account on both servers with the same name and password.
Have sql server agent run under this account on both servers. Use the
impersonate the sql server agent option.
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
"asd" <asd@.asd.com> wrote in message
news:uJmqQCaIGHA.3176@.TK2MSFTNGP12.phx.gbl...
> Hello everyone,
> We have a bit of a problem with replication between two SQL servers
> belonging to different domains.
> Basically we have two active directory domains: DomA and DomB (neither of
> them is local domain).
> Each of then has a SQL Server 2000 Enterprise edition installed with SP3.
> There is a database on DomA that has to be merge replicated with DomB
> through dial-up connection.
> We establish the dial-up connection (RRAS is running on DomA) between the
> domains and create a pull subscription on DomB but when we start the
> synchronisation process we always get the error that server in DomA does
> not exist or access denied.
> Just to mention that the replication agent on DomB is set up to run with
> sql server login 'sa' (checked the password a hundred times).
> Any ideas appreciated. We would not mind switching to active directory
> enabled replication between the two is someone could give us guidelines.
> Thank you all in advance.
> Best regards,
> GAZ
>
|||Thanks for the aswer but unfortunately it does not work. We still get the
same message 'SQL server does not exist or access denied.'
We can ping the server in question with both the IP address and its name,
but still we cannot run the replication.
|||Is the sa account you are using in your agent to connect to the subscriber
the publisher sa account or the subscriber one? It should be the publisher
one.
This could be a name resolution problem or a account problem. It sound like
its not a name resolution problem as you can connect to the publisher and
configure the pull. So it probably is an account problem.
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
"asd" <asd@.asd.com> wrote in message
news:ujJqbTbIGHA.3752@.TK2MSFTNGP11.phx.gbl...
> Thanks for the aswer but unfortunately it does not work. We still get the
> same message 'SQL server does not exist or access denied.'
> We can ping the server in question with both the IP address and its name,
> but still we cannot run the replication.
>
|||Both sa accounts have the same password. Whatever we try there are no
results. We shall try to create a clean domain B installation and start from
scratch. Maybe we shall have better luck this time.
Still, any ideas and suggestions are welcome.
BR,
GAZ
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23s1N35bIGHA.3408@.TK2MSFTNGP12.phx.gbl...
> Is the sa account you are using in your agent to connect to the subscriber
> the publisher sa account or the subscriber one? It should be the publisher
> one.
> This could be a name resolution problem or a account problem. It sound
> like its not a name resolution problem as you can connect to the publisher
> and configure the pull. So it probably is an account problem.
> --
> 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
> "asd" <asd@.asd.com> wrote in message
> news:ujJqbTbIGHA.3752@.TK2MSFTNGP11.phx.gbl...
>
|||is xp_cmdshell enabled on the subscriber?
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
"asd" <asd@.asd.com> wrote in message
news:OrjMwdoIGHA.668@.TK2MSFTNGP11.phx.gbl...
> Both sa accounts have the same password. Whatever we try there are no
> results. We shall try to create a clean domain B installation and start
> from scratch. Maybe we shall have better luck this time.
> Still, any ideas and suggestions are welcome.
> BR,
> GAZ
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%23s1N35bIGHA.3408@.TK2MSFTNGP12.phx.gbl...
>
|||Yes. It can be executed and it works like a charm. We are just in the
process of setting up the new domain to try this from scratch. Let you all
know how it went.
BR,
GAZ
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:u0$K8BqIGHA.964@.tk2msftngp13.phx.gbl...
> is xp_cmdshell enabled on the subscriber?
> --
> 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
> "asd" <asd@.asd.com> wrote in message
> news:OrjMwdoIGHA.668@.TK2MSFTNGP11.phx.gbl...
>
|||We reinstalled the DomB and now everything works like clockworks. We haven't
the foggiest what the problem was but for now ignorance is a bliss. We'll
have to set up a new network soon with the same parameters and we'll keep a
keener eye on things.
Thanks everyone for your help.
GAZ
Multi Domain Replication Security Issue
Hello everyone,
We have a bit of a problem with replication between two SQL servers
belonging to different domains.
Basically we have two active directory domains: DomA and DomB (neither of
them is local domain).
Each of then has a SQL Server 2000 Enterprise edition installed with SP3.
There is a database on DomA that has to be merge replicated with DomB
through dial-up connection.
We establish the dial-up connection (RRAS is running on DomA) between the
domains and create a pull subscription on DomB but when we start the
synchronisation process we always get the error that server in DomA does not
exist or access denied.
Just to mention that the replication agent on DomB is set up to run with sql
server login 'sa' (checked the password a hundred times).
Any ideas appreciated. We would not mind switching to active directory
enabled replication between the two is someone could give us guidelines.
Thank you all in advance.
Best regards,
GAZ
Create an admin account on both servers with the same name and password.
Have sql server agent run under this account on both servers. Use the
impersonate the sql server agent option.
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
"asd" <asd@.asd.com> wrote in message
news:uJmqQCaIGHA.3176@.TK2MSFTNGP12.phx.gbl...
> Hello everyone,
> We have a bit of a problem with replication between two SQL servers
> belonging to different domains.
> Basically we have two active directory domains: DomA and DomB (neither of
> them is local domain).
> Each of then has a SQL Server 2000 Enterprise edition installed with SP3.
> There is a database on DomA that has to be merge replicated with DomB
> through dial-up connection.
> We establish the dial-up connection (RRAS is running on DomA) between the
> domains and create a pull subscription on DomB but when we start the
> synchronisation process we always get the error that server in DomA does
> not exist or access denied.
> Just to mention that the replication agent on DomB is set up to run with
> sql server login 'sa' (checked the password a hundred times).
> Any ideas appreciated. We would not mind switching to active directory
> enabled replication between the two is someone could give us guidelines.
> Thank you all in advance.
> Best regards,
> GAZ
>
|||Thanks for the aswer but unfortunately it does not work. We still get the
same message 'SQL server does not exist or access denied.'
We can ping the server in question with both the IP address and its name,
but still we cannot run the replication.
|||Is the sa account you are using in your agent to connect to the subscriber
the publisher sa account or the subscriber one? It should be the publisher
one.
This could be a name resolution problem or a account problem. It sound like
its not a name resolution problem as you can connect to the publisher and
configure the pull. So it probably is an account problem.
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
"asd" <asd@.asd.com> wrote in message
news:ujJqbTbIGHA.3752@.TK2MSFTNGP11.phx.gbl...
> Thanks for the aswer but unfortunately it does not work. We still get the
> same message 'SQL server does not exist or access denied.'
> We can ping the server in question with both the IP address and its name,
> but still we cannot run the replication.
>
|||Both sa accounts have the same password. Whatever we try there are no
results. We shall try to create a clean domain B installation and start from
scratch. Maybe we shall have better luck this time.
Still, any ideas and suggestions are welcome.
BR,
GAZ
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23s1N35bIGHA.3408@.TK2MSFTNGP12.phx.gbl...
> Is the sa account you are using in your agent to connect to the subscriber
> the publisher sa account or the subscriber one? It should be the publisher
> one.
> This could be a name resolution problem or a account problem. It sound
> like its not a name resolution problem as you can connect to the publisher
> and configure the pull. So it probably is an account problem.
> --
> 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
> "asd" <asd@.asd.com> wrote in message
> news:ujJqbTbIGHA.3752@.TK2MSFTNGP11.phx.gbl...
>
|||is xp_cmdshell enabled on the subscriber?
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
"asd" <asd@.asd.com> wrote in message
news:OrjMwdoIGHA.668@.TK2MSFTNGP11.phx.gbl...
> Both sa accounts have the same password. Whatever we try there are no
> results. We shall try to create a clean domain B installation and start
> from scratch. Maybe we shall have better luck this time.
> Still, any ideas and suggestions are welcome.
> BR,
> GAZ
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%23s1N35bIGHA.3408@.TK2MSFTNGP12.phx.gbl...
>
|||Yes. It can be executed and it works like a charm. We are just in the
process of setting up the new domain to try this from scratch. Let you all
know how it went.
BR,
GAZ
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:u0$K8BqIGHA.964@.tk2msftngp13.phx.gbl...
> is xp_cmdshell enabled on the subscriber?
> --
> 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
> "asd" <asd@.asd.com> wrote in message
> news:OrjMwdoIGHA.668@.TK2MSFTNGP11.phx.gbl...
>
|||We reinstalled the DomB and now everything works like clockworks. We haven't
the foggiest what the problem was but for now ignorance is a bliss. We'll
have to set up a new network soon with the same parameters and we'll keep a
keener eye on things.
Thanks everyone for your help.
GAZ
We have a bit of a problem with replication between two SQL servers
belonging to different domains.
Basically we have two active directory domains: DomA and DomB (neither of
them is local domain).
Each of then has a SQL Server 2000 Enterprise edition installed with SP3.
There is a database on DomA that has to be merge replicated with DomB
through dial-up connection.
We establish the dial-up connection (RRAS is running on DomA) between the
domains and create a pull subscription on DomB but when we start the
synchronisation process we always get the error that server in DomA does not
exist or access denied.
Just to mention that the replication agent on DomB is set up to run with sql
server login 'sa' (checked the password a hundred times).
Any ideas appreciated. We would not mind switching to active directory
enabled replication between the two is someone could give us guidelines.
Thank you all in advance.
Best regards,
GAZ
Create an admin account on both servers with the same name and password.
Have sql server agent run under this account on both servers. Use the
impersonate the sql server agent option.
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
"asd" <asd@.asd.com> wrote in message
news:uJmqQCaIGHA.3176@.TK2MSFTNGP12.phx.gbl...
> Hello everyone,
> We have a bit of a problem with replication between two SQL servers
> belonging to different domains.
> Basically we have two active directory domains: DomA and DomB (neither of
> them is local domain).
> Each of then has a SQL Server 2000 Enterprise edition installed with SP3.
> There is a database on DomA that has to be merge replicated with DomB
> through dial-up connection.
> We establish the dial-up connection (RRAS is running on DomA) between the
> domains and create a pull subscription on DomB but when we start the
> synchronisation process we always get the error that server in DomA does
> not exist or access denied.
> Just to mention that the replication agent on DomB is set up to run with
> sql server login 'sa' (checked the password a hundred times).
> Any ideas appreciated. We would not mind switching to active directory
> enabled replication between the two is someone could give us guidelines.
> Thank you all in advance.
> Best regards,
> GAZ
>
|||Thanks for the aswer but unfortunately it does not work. We still get the
same message 'SQL server does not exist or access denied.'
We can ping the server in question with both the IP address and its name,
but still we cannot run the replication.
|||Is the sa account you are using in your agent to connect to the subscriber
the publisher sa account or the subscriber one? It should be the publisher
one.
This could be a name resolution problem or a account problem. It sound like
its not a name resolution problem as you can connect to the publisher and
configure the pull. So it probably is an account problem.
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
"asd" <asd@.asd.com> wrote in message
news:ujJqbTbIGHA.3752@.TK2MSFTNGP11.phx.gbl...
> Thanks for the aswer but unfortunately it does not work. We still get the
> same message 'SQL server does not exist or access denied.'
> We can ping the server in question with both the IP address and its name,
> but still we cannot run the replication.
>
|||Both sa accounts have the same password. Whatever we try there are no
results. We shall try to create a clean domain B installation and start from
scratch. Maybe we shall have better luck this time.
Still, any ideas and suggestions are welcome.
BR,
GAZ
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23s1N35bIGHA.3408@.TK2MSFTNGP12.phx.gbl...
> Is the sa account you are using in your agent to connect to the subscriber
> the publisher sa account or the subscriber one? It should be the publisher
> one.
> This could be a name resolution problem or a account problem. It sound
> like its not a name resolution problem as you can connect to the publisher
> and configure the pull. So it probably is an account problem.
> --
> 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
> "asd" <asd@.asd.com> wrote in message
> news:ujJqbTbIGHA.3752@.TK2MSFTNGP11.phx.gbl...
>
|||is xp_cmdshell enabled on the subscriber?
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
"asd" <asd@.asd.com> wrote in message
news:OrjMwdoIGHA.668@.TK2MSFTNGP11.phx.gbl...
> Both sa accounts have the same password. Whatever we try there are no
> results. We shall try to create a clean domain B installation and start
> from scratch. Maybe we shall have better luck this time.
> Still, any ideas and suggestions are welcome.
> BR,
> GAZ
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%23s1N35bIGHA.3408@.TK2MSFTNGP12.phx.gbl...
>
|||Yes. It can be executed and it works like a charm. We are just in the
process of setting up the new domain to try this from scratch. Let you all
know how it went.
BR,
GAZ
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:u0$K8BqIGHA.964@.tk2msftngp13.phx.gbl...
> is xp_cmdshell enabled on the subscriber?
> --
> 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
> "asd" <asd@.asd.com> wrote in message
> news:OrjMwdoIGHA.668@.TK2MSFTNGP11.phx.gbl...
>
|||We reinstalled the DomB and now everything works like clockworks. We haven't
the foggiest what the problem was but for now ignorance is a bliss. We'll
have to set up a new network soon with the same parameters and we'll keep a
keener eye on things.
Thanks everyone for your help.
GAZ
Wednesday, March 21, 2012
MSTDC and windows domain
Hi,
i have this scenario :
a have web application (NT4) that use a MSTDC service on my application
server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
The service MSTDC on application server and db server start with the same
domain administration account (administrator)
Now i have install a new domain windwos 2003 and a new cluster SQL2000/MSTDC
on 2 windows 2003 server and try to modify my application to point to new
windows 2003 cluster but when i try to test it a error appared :
Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction. OLE/DB provider returned
message: New transaction cannot enlist in the specified transaction
coordinator.
and found a kb article and make the modify adding a network service into
MSDTC service on cluster 2003 but the problem is not resoleved! :-(
This is because are 2 different domain and network service on 2003 isn't any
account on NT4 domain ?
If i try to trust a windows 2003 and NT4 domain i resolved it ?
The trust is only one solution or exist other solution ?
Thanks in advance.
make sure you are ussing the cluster version of DTC. On each node you
should have run comclust.exe.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> i have this scenario :
> a have web application (NT4) that use a MSTDC service on my application
> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
> The service MSTDC on application server and db server start with the same
> domain administration account (administrator)
> Now i have install a new domain windwos 2003 and a new cluster
SQL2000/MSTDC
> on 2 windows 2003 server and try to modify my application to point to new
> windows 2003 cluster but when i try to test it a error appared :
> Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB provider
'SQLOLEDB'
> was unable to begin a distributed transaction. OLE/DB provider returned
> message: New transaction cannot enlist in the specified transaction
> coordinator.
> and found a kb article and make the modify adding a network service into
> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
> This is because are 2 different domain and network service on 2003 isn't
any
> account on NT4 domain ?
> If i try to trust a windows 2003 and NT4 domain i resolved it ?
> The trust is only one solution or exist other solution ?
> Thanks in advance.
>
|||Hi,
yes ai use DTC cluster .
But on windows2003 for clustering DTC i don't type comclust but i must
create it manuallty ,
are you sure ?
Thanks.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:%23C7I0Pp5EHA.2572@.tk2msftngp13.phx.gbl...
> make sure you are ussing the cluster version of DTC. On each node you
> should have run comclust.exe.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> <io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> SQL2000/MSTDC
> 'SQLOLEDB'
> any
>
|||Hi,
i foun a solutiontoi my problem , the solution is :
- Trust 2 way from NT4 and 2K3
- Modify lmhost/host file for all server that are involved (i try for 2
hour first found the the optimal configuration of this file)
I habve used dctping.exe and dctester.exe for troubleshooting
And now work
Other solution instead trust is :
http://support.microsoft.com/default...b;en-us;827805
Thanks !
this is happy day!
:-)
<io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> i have this scenario :
> a have web application (NT4) that use a MSTDC service on my application
> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
> The service MSTDC on application server and db server start with the same
> domain administration account (administrator)
> Now i have install a new domain windwos 2003 and a new cluster
> SQL2000/MSTDC on 2 windows 2003 server and try to modify my application to
> point to new windows 2003 cluster but when i try to test it a error
> appared :
> Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB provider
> 'SQLOLEDB'
> was unable to begin a distributed transaction. OLE/DB provider returned
> message: New transaction cannot enlist in the specified transaction
> coordinator.
> and found a kb article and make the modify adding a network service into
> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
> This is because are 2 different domain and network service on 2003 isn't
> any account on NT4 domain ?
> If i try to trust a windows 2003 and NT4 domain i resolved it ?
> The trust is only one solution or exist other solution ?
> Thanks in advance.
>
i have this scenario :
a have web application (NT4) that use a MSTDC service on my application
server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
The service MSTDC on application server and db server start with the same
domain administration account (administrator)
Now i have install a new domain windwos 2003 and a new cluster SQL2000/MSTDC
on 2 windows 2003 server and try to modify my application to point to new
windows 2003 cluster but when i try to test it a error appared :
Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction. OLE/DB provider returned
message: New transaction cannot enlist in the specified transaction
coordinator.
and found a kb article and make the modify adding a network service into
MSDTC service on cluster 2003 but the problem is not resoleved! :-(
This is because are 2 different domain and network service on 2003 isn't any
account on NT4 domain ?
If i try to trust a windows 2003 and NT4 domain i resolved it ?
The trust is only one solution or exist other solution ?
Thanks in advance.
make sure you are ussing the cluster version of DTC. On each node you
should have run comclust.exe.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> i have this scenario :
> a have web application (NT4) that use a MSTDC service on my application
> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
> The service MSTDC on application server and db server start with the same
> domain administration account (administrator)
> Now i have install a new domain windwos 2003 and a new cluster
SQL2000/MSTDC
> on 2 windows 2003 server and try to modify my application to point to new
> windows 2003 cluster but when i try to test it a error appared :
> Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB provider
'SQLOLEDB'
> was unable to begin a distributed transaction. OLE/DB provider returned
> message: New transaction cannot enlist in the specified transaction
> coordinator.
> and found a kb article and make the modify adding a network service into
> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
> This is because are 2 different domain and network service on 2003 isn't
any
> account on NT4 domain ?
> If i try to trust a windows 2003 and NT4 domain i resolved it ?
> The trust is only one solution or exist other solution ?
> Thanks in advance.
>
|||Hi,
yes ai use DTC cluster .
But on windows2003 for clustering DTC i don't type comclust but i must
create it manuallty ,
are you sure ?
Thanks.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:%23C7I0Pp5EHA.2572@.tk2msftngp13.phx.gbl...
> make sure you are ussing the cluster version of DTC. On each node you
> should have run comclust.exe.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> <io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> SQL2000/MSTDC
> 'SQLOLEDB'
> any
>
|||Hi,
i foun a solutiontoi my problem , the solution is :
- Trust 2 way from NT4 and 2K3
- Modify lmhost/host file for all server that are involved (i try for 2
hour first found the the optimal configuration of this file)
I habve used dctping.exe and dctester.exe for troubleshooting
And now work
Other solution instead trust is :
http://support.microsoft.com/default...b;en-us;827805
Thanks !
this is happy day!
:-)
<io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> i have this scenario :
> a have web application (NT4) that use a MSTDC service on my application
> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
> The service MSTDC on application server and db server start with the same
> domain administration account (administrator)
> Now i have install a new domain windwos 2003 and a new cluster
> SQL2000/MSTDC on 2 windows 2003 server and try to modify my application to
> point to new windows 2003 cluster but when i try to test it a error
> appared :
> Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB provider
> 'SQLOLEDB'
> was unable to begin a distributed transaction. OLE/DB provider returned
> message: New transaction cannot enlist in the specified transaction
> coordinator.
> and found a kb article and make the modify adding a network service into
> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
> This is because are 2 different domain and network service on 2003 isn't
> any account on NT4 domain ?
> If i try to trust a windows 2003 and NT4 domain i resolved it ?
> The trust is only one solution or exist other solution ?
> Thanks in advance.
>
MSTDC and windows domain
Hi,
i have this scenario :
a have web application (NT4) that use a MSTDC service on my application
server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
The service MSTDC on application server and db server start with the same
domain administration account (administrator)
Now i have install a new domain windwos 2003 and a new cluster SQL2000/MSTDC
on 2 windows 2003 server and try to modify my application to point to new
windows 2003 cluster but when i try to test it a error appared :
Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction. OLE/DB provider returned
message: New transaction cannot enlist in the specified transaction
coordinator.
and found a kb article and make the modify adding a network service into
MSDTC service on cluster 2003 but the problem is not resoleved! :-(
This is because are 2 different domain and network service on 2003 isn't any
account on NT4 domain ?
If i try to trust a windows 2003 and NT4 domain i resolved it ?
The trust is only one solution or exist other solution ?
Thanks in advance.make sure you are ussing the cluster version of DTC. On each node you
should have run comclust.exe.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> i have this scenario :
> a have web application (NT4) that use a MSTDC service on my application
> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
> The service MSTDC on application server and db server start with the same
> domain administration account (administrator)
> Now i have install a new domain windwos 2003 and a new cluster
SQL2000/MSTDC
> on 2 windows 2003 server and try to modify my application to point to new
> windows 2003 cluster but when i try to test it a error appared :
> Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB provider
'SQLOLEDB'
> was unable to begin a distributed transaction. OLE/DB provider returned
> message: New transaction cannot enlist in the specified transaction
> coordinator.
> and found a kb article and make the modify adding a network service into
> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
> This is because are 2 different domain and network service on 2003 isn't
any
> account on NT4 domain ?
> If i try to trust a windows 2003 and NT4 domain i resolved it ?
> The trust is only one solution or exist other solution ?
> Thanks in advance.
>|||Hi,
yes ai use DTC cluster .
But on windows2003 for clustering DTC i don't type comclust but i must
create it manuallty ,
are you sure ?
Thanks.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:%23C7I0Pp5EHA.2572@.tk2msftngp13.phx.gbl...
> make sure you are ussing the cluster version of DTC. On each node you
> should have run comclust.exe.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> <io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
>> Hi,
>> i have this scenario :
>> a have web application (NT4) that use a MSTDC service on my application
>> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
>> The service MSTDC on application server and db server start with the same
>> domain administration account (administrator)
>> Now i have install a new domain windwos 2003 and a new cluster
> SQL2000/MSTDC
>> on 2 windows 2003 server and try to modify my application to point to new
>> windows 2003 cluster but when i try to test it a error appared :
>> Server: Msg 7391, Level 16, State 1, Line 2
>> The operation could not be performed because the OLE DB provider
> 'SQLOLEDB'
>> was unable to begin a distributed transaction. OLE/DB provider returned
>> message: New transaction cannot enlist in the specified transaction
>> coordinator.
>> and found a kb article and make the modify adding a network service into
>> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
>> This is because are 2 different domain and network service on 2003 isn't
> any
>> account on NT4 domain ?
>> If i try to trust a windows 2003 and NT4 domain i resolved it ?
>> The trust is only one solution or exist other solution ?
>> Thanks in advance.
>>
>|||Hi,
i foun a solutiontoi my problem , the solution is :
- Trust 2 way from NT4 and 2K3
- Modify lmhost/host file for all server that are involved (i try for 2
hour first found the the optimal configuration of this file)
I habve used dctping.exe and dctester.exe for troubleshooting
And now work
Other solution instead trust is :
http://support.microsoft.com/default.aspx?scid=kb;en-us;827805http://support.microsoft.com/default.aspx?scid=kb;en-us;827805
Thanks !
this is happy day!
:-)
<io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> i have this scenario :
> a have web application (NT4) that use a MSTDC service on my application
> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
> The service MSTDC on application server and db server start with the same
> domain administration account (administrator)
> Now i have install a new domain windwos 2003 and a new cluster
> SQL2000/MSTDC on 2 windows 2003 server and try to modify my application to
> point to new windows 2003 cluster but when i try to test it a error
> appared :
> Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB provider
> 'SQLOLEDB'
> was unable to begin a distributed transaction. OLE/DB provider returned
> message: New transaction cannot enlist in the specified transaction
> coordinator.
> and found a kb article and make the modify adding a network service into
> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
> This is because are 2 different domain and network service on 2003 isn't
> any account on NT4 domain ?
> If i try to trust a windows 2003 and NT4 domain i resolved it ?
> The trust is only one solution or exist other solution ?
> Thanks in advance.
>
i have this scenario :
a have web application (NT4) that use a MSTDC service on my application
server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
The service MSTDC on application server and db server start with the same
domain administration account (administrator)
Now i have install a new domain windwos 2003 and a new cluster SQL2000/MSTDC
on 2 windows 2003 server and try to modify my application to point to new
windows 2003 cluster but when i try to test it a error appared :
Server: Msg 7391, Level 16, State 1, Line 2
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction. OLE/DB provider returned
message: New transaction cannot enlist in the specified transaction
coordinator.
and found a kb article and make the modify adding a network service into
MSDTC service on cluster 2003 but the problem is not resoleved! :-(
This is because are 2 different domain and network service on 2003 isn't any
account on NT4 domain ?
If i try to trust a windows 2003 and NT4 domain i resolved it ?
The trust is only one solution or exist other solution ?
Thanks in advance.make sure you are ussing the cluster version of DTC. On each node you
should have run comclust.exe.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> i have this scenario :
> a have web application (NT4) that use a MSTDC service on my application
> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
> The service MSTDC on application server and db server start with the same
> domain administration account (administrator)
> Now i have install a new domain windwos 2003 and a new cluster
SQL2000/MSTDC
> on 2 windows 2003 server and try to modify my application to point to new
> windows 2003 cluster but when i try to test it a error appared :
> Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB provider
'SQLOLEDB'
> was unable to begin a distributed transaction. OLE/DB provider returned
> message: New transaction cannot enlist in the specified transaction
> coordinator.
> and found a kb article and make the modify adding a network service into
> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
> This is because are 2 different domain and network service on 2003 isn't
any
> account on NT4 domain ?
> If i try to trust a windows 2003 and NT4 domain i resolved it ?
> The trust is only one solution or exist other solution ?
> Thanks in advance.
>|||Hi,
yes ai use DTC cluster .
But on windows2003 for clustering DTC i don't type comclust but i must
create it manuallty ,
are you sure ?
Thanks.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:%23C7I0Pp5EHA.2572@.tk2msftngp13.phx.gbl...
> make sure you are ussing the cluster version of DTC. On each node you
> should have run comclust.exe.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> <io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
>> Hi,
>> i have this scenario :
>> a have web application (NT4) that use a MSTDC service on my application
>> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
>> The service MSTDC on application server and db server start with the same
>> domain administration account (administrator)
>> Now i have install a new domain windwos 2003 and a new cluster
> SQL2000/MSTDC
>> on 2 windows 2003 server and try to modify my application to point to new
>> windows 2003 cluster but when i try to test it a error appared :
>> Server: Msg 7391, Level 16, State 1, Line 2
>> The operation could not be performed because the OLE DB provider
> 'SQLOLEDB'
>> was unable to begin a distributed transaction. OLE/DB provider returned
>> message: New transaction cannot enlist in the specified transaction
>> coordinator.
>> and found a kb article and make the modify adding a network service into
>> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
>> This is because are 2 different domain and network service on 2003 isn't
> any
>> account on NT4 domain ?
>> If i try to trust a windows 2003 and NT4 domain i resolved it ?
>> The trust is only one solution or exist other solution ?
>> Thanks in advance.
>>
>|||Hi,
i foun a solutiontoi my problem , the solution is :
- Trust 2 way from NT4 and 2K3
- Modify lmhost/host file for all server that are involved (i try for 2
hour first found the the optimal configuration of this file)
I habve used dctping.exe and dctester.exe for troubleshooting
And now work
Other solution instead trust is :
http://support.microsoft.com/default.aspx?scid=kb;en-us;827805http://support.microsoft.com/default.aspx?scid=kb;en-us;827805
Thanks !
this is happy day!
:-)
<io.com> wrote in message news:%23NqzJ1I5EHA.2624@.TK2MSFTNGP11.phx.gbl...
> Hi,
> i have this scenario :
> a have web application (NT4) that use a MSTDC service on my application
> server (NT4) and DB and MSDTC on my cluster windows (2000/SQL2000)
> The service MSTDC on application server and db server start with the same
> domain administration account (administrator)
> Now i have install a new domain windwos 2003 and a new cluster
> SQL2000/MSTDC on 2 windows 2003 server and try to modify my application to
> point to new windows 2003 cluster but when i try to test it a error
> appared :
> Server: Msg 7391, Level 16, State 1, Line 2
> The operation could not be performed because the OLE DB provider
> 'SQLOLEDB'
> was unable to begin a distributed transaction. OLE/DB provider returned
> message: New transaction cannot enlist in the specified transaction
> coordinator.
> and found a kb article and make the modify adding a network service into
> MSDTC service on cluster 2003 but the problem is not resoleved! :-(
> This is because are 2 different domain and network service on 2003 isn't
> any account on NT4 domain ?
> If i try to trust a windows 2003 and NT4 domain i resolved it ?
> The trust is only one solution or exist other solution ?
> Thanks in advance.
>
Monday, March 12, 2012
MSSqlServer service and Windows password reset
Hello,
I hope you guys can help me with a problem that I am facing...
I hope you guys can help me with a problem that I am facing...
I have started the MSSqlServer service and SQLServerAgent services
with a domain username and password.
There are periodic password resets to this user. Security policies
within the company dictate that the password for this domain account
cannot be permenant.
Would there be any way to automatically reset the pwd in these
services instead of manually changing them each time?
ThanksKannan (pv_kannan@.yahoo.com) writes:
> Would there be any way to automatically reset the pwd in these
> services instead of manually changing them each time?
I doubt there is, but since this is not really a MS SQL Server issue,
but rather a generic Windows question, a question to the approriate
newsgroup for Windows.
Personally, I would investigate possibilities to set up the account
so that it only can log in as service or some such, which would permit
unexpirable passwords.
--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
mssqlserver account
What account should run mssqlserver and sqlserveragent.
Should it be a local account or a domain account?
Thanks,
MTI like using a Domain account when there may be multiple servers because it
is easier to share file permissions etc... If there is only one server it
doesn't much matter.. If you wish to use mail integration for SQL Server
you may wish to use multiple domain accounts, since email is connected to
the login account - if you wish to separate the email for each server...
The Domain account should have limited permissions (as doc'd in BOL.)
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"mt" <miketownsend33@.yahoo.com> wrote in message
news:028601c37775$9fe611c0$a001280a@.phx.gbl...
> What account should run mssqlserver and sqlserveragent.
> Should it be a local account or a domain account?
> Thanks,
> MT
Should it be a local account or a domain account?
Thanks,
MTI like using a Domain account when there may be multiple servers because it
is easier to share file permissions etc... If there is only one server it
doesn't much matter.. If you wish to use mail integration for SQL Server
you may wish to use multiple domain accounts, since email is connected to
the login account - if you wish to separate the email for each server...
The Domain account should have limited permissions (as doc'd in BOL.)
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"mt" <miketownsend33@.yahoo.com> wrote in message
news:028601c37775$9fe611c0$a001280a@.phx.gbl...
> What account should run mssqlserver and sqlserveragent.
> Should it be a local account or a domain account?
> Thanks,
> MT
mssqlserver account
What account should run mssqlserver and sqlserveragent.
Should it be a local account or a domain account?
Thanks,
MTYou often need a domain account. If SQL Server agent executes a job which fetches a file from
another machine, for instance., Or you want to use SQL Mail, where you need a domain account for the
mail account.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"mt" <miketownsend33@.yahoo.com> wrote in message news:0a7201c37775$a0c993f0$a301280a@.phx.gbl...
> What account should run mssqlserver and sqlserveragent.
> Should it be a local account or a domain account?
> Thanks,
> MT
Should it be a local account or a domain account?
Thanks,
MTYou often need a domain account. If SQL Server agent executes a job which fetches a file from
another machine, for instance., Or you want to use SQL Mail, where you need a domain account for the
mail account.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"mt" <miketownsend33@.yahoo.com> wrote in message news:0a7201c37775$a0c993f0$a301280a@.phx.gbl...
> What account should run mssqlserver and sqlserveragent.
> Should it be a local account or a domain account?
> Thanks,
> MT
MSSQLSERVER & SQLSERVERAGENT startup account
I'm currently using a domain account that has sysadmin rights; does this
account need to be an administrator unter Window's 2000 server? I'm confused
by everthing I've read.
It's not necessarily required. The following article lists
the necessary rights and permissions:
http://support.microsoft.com/?id=283811
The section on Windows user rights addresses your question.
-Sue
On Tue, 28 Sep 2004 09:41:28 -0700, "Jerrick D.H"
<JerrickDH@.discussions.microsoft.com> wrote:
>I'm currently using a domain account that has sysadmin rights; does this
>account need to be an administrator unter Window's 2000 server? I'm confused
>by everthing I've read.
account need to be an administrator unter Window's 2000 server? I'm confused
by everthing I've read.
It's not necessarily required. The following article lists
the necessary rights and permissions:
http://support.microsoft.com/?id=283811
The section on Windows user rights addresses your question.
-Sue
On Tue, 28 Sep 2004 09:41:28 -0700, "Jerrick D.H"
<JerrickDH@.discussions.microsoft.com> wrote:
>I'm currently using a domain account that has sysadmin rights; does this
>account need to be an administrator unter Window's 2000 server? I'm confused
>by everthing I've read.
MSSQLSERVER & SQLSERVERAGENT startup account
I'm currently using a domain account that has sysadmin rights; does this
account need to be an administrator unter Window's 2000 server? I'm confused
by everthing I've read.It's not necessarily required. The following article lists
the necessary rights and permissions:
http://support.microsoft.com/?id=283811
The section on Windows user rights addresses your question.
-Sue
On Tue, 28 Sep 2004 09:41:28 -0700, "Jerrick D.H"
<JerrickDH@.discussions.microsoft.com> wrote:
>I'm currently using a domain account that has sysadmin rights; does this
>account need to be an administrator unter Window's 2000 server? I'm confused
>by everthing I've read.
account need to be an administrator unter Window's 2000 server? I'm confused
by everthing I've read.It's not necessarily required. The following article lists
the necessary rights and permissions:
http://support.microsoft.com/?id=283811
The section on Windows user rights addresses your question.
-Sue
On Tue, 28 Sep 2004 09:41:28 -0700, "Jerrick D.H"
<JerrickDH@.discussions.microsoft.com> wrote:
>I'm currently using a domain account that has sysadmin rights; does this
>account need to be an administrator unter Window's 2000 server? I'm confused
>by everthing I've read.
Saturday, February 25, 2012
mssql server started and then stopped
I have a problem with all mssql servers in the domain that is unable to
start
The error is
the mssql server started and then stopped. All mssql service is started
with the local system account
any idea?
ERROR.LOG contains something? Event Viewer?
"nobody" <nobody@.nobody.com> wrote in message
news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>I have a problem with all mssql servers in the domain that is unable to
>start
> The error is
> the mssql server started and then stopped. All mssql service is started
> with the local system account
>
> any idea?
>
|||didnt see anything in event viewer but error.log in mssql\log shows this
2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-11-13 06:40:43.76 server All rights reserved.
2007-11-13 06:40:43.76 server Server Process ID is 2448.
2007-11-13 06:40:43.76 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
2007-11-13 06:40:43.77 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2007-11-13 06:40:43.81 server SQL Server configured for thread mode
processing.
2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
because it is marked IN LOAD.
2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is in
the middle of a restore.
I am not doing any restores
please help
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
> ERROR.LOG contains something? Event Viewer?
>
>
> "nobody" <nobody@.nobody.com> wrote in message
> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>
|||Hi
Peraphs it got corrupted.Do you have a backup?
/*
Bypassing recovery for database 'model'
because it is marked IN LOAD.
2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is in
the middle of a restore.
*/
"nobody" <nobody@.nobody.com> wrote in message
news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
> didnt see anything in event viewer but error.log in mssql\log shows this
>
> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2007-11-13 06:40:43.76 server All rights reserved.
> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
> 2007-11-13 06:40:43.77 server SQL Server is starting at priority class
> 'normal'(1 CPU detected).
> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
> processing.
> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500] Lock
> Blocks, [1000] Lock Owner Blocks.
> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
> because it is marked IN LOAD.
> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
> in the middle of a restore.
>
> I am not doing any restores
> please help
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>
|||the thing is several mssql on the same domain is failing to start. I think
it might have to do with backup exec backups failed last night.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
> Hi
> Peraphs it got corrupted.Do you have a backup?
> /*
> Bypassing recovery for database 'model'
> because it is marked IN LOAD.
> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
> in
> the middle of a restore.
> */
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
>
|||The problem is I did not do any restores. In backup exec I backed up the
databases but selected the option (continue backup if consistency check
fails)
"Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
news:C089955B-5CE2-40B7-8095-AC669BA0C873@.microsoft.com...
> Also, there is a KB about this problem, you may want to read it.
> http://support.microsoft.com/kb/822852
> --
> Ekrem nsoy
>
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23o1dp0gJIHA.484@.TK2MSFTNGP06.phx.gbl...
>
|||how do I run dbcc from query analyzer? I have another machine failed to
start sql. I believe this had to do with backup exec
"nobody" <nobody@.nobody.com> wrote in message
news:uFm1nphJIHA.5208@.TK2MSFTNGP04.phx.gbl...
> The problem is I did not do any restores. In backup exec I backed up the
> databases but selected the option (continue backup if consistency check
> fails)
>
> "Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
> news:C089955B-5CE2-40B7-8095-AC669BA0C873@.microsoft.com...
>
start
The error is
the mssql server started and then stopped. All mssql service is started
with the local system account
any idea?
ERROR.LOG contains something? Event Viewer?
"nobody" <nobody@.nobody.com> wrote in message
news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>I have a problem with all mssql servers in the domain that is unable to
>start
> The error is
> the mssql server started and then stopped. All mssql service is started
> with the local system account
>
> any idea?
>
|||didnt see anything in event viewer but error.log in mssql\log shows this
2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-11-13 06:40:43.76 server All rights reserved.
2007-11-13 06:40:43.76 server Server Process ID is 2448.
2007-11-13 06:40:43.76 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
2007-11-13 06:40:43.77 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2007-11-13 06:40:43.81 server SQL Server configured for thread mode
processing.
2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
because it is marked IN LOAD.
2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is in
the middle of a restore.
I am not doing any restores
please help
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
> ERROR.LOG contains something? Event Viewer?
>
>
> "nobody" <nobody@.nobody.com> wrote in message
> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>
|||Hi
Peraphs it got corrupted.Do you have a backup?
/*
Bypassing recovery for database 'model'
because it is marked IN LOAD.
2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is in
the middle of a restore.
*/
"nobody" <nobody@.nobody.com> wrote in message
news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
> didnt see anything in event viewer but error.log in mssql\log shows this
>
> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2007-11-13 06:40:43.76 server All rights reserved.
> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
> 2007-11-13 06:40:43.77 server SQL Server is starting at priority class
> 'normal'(1 CPU detected).
> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
> processing.
> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500] Lock
> Blocks, [1000] Lock Owner Blocks.
> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
> because it is marked IN LOAD.
> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
> in the middle of a restore.
>
> I am not doing any restores
> please help
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>
|||the thing is several mssql on the same domain is failing to start. I think
it might have to do with backup exec backups failed last night.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
> Hi
> Peraphs it got corrupted.Do you have a backup?
> /*
> Bypassing recovery for database 'model'
> because it is marked IN LOAD.
> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
> in
> the middle of a restore.
> */
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
>
|||The problem is I did not do any restores. In backup exec I backed up the
databases but selected the option (continue backup if consistency check
fails)
"Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
news:C089955B-5CE2-40B7-8095-AC669BA0C873@.microsoft.com...
> Also, there is a KB about this problem, you may want to read it.
> http://support.microsoft.com/kb/822852
> --
> Ekrem nsoy
>
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23o1dp0gJIHA.484@.TK2MSFTNGP06.phx.gbl...
>
|||how do I run dbcc from query analyzer? I have another machine failed to
start sql. I believe this had to do with backup exec
"nobody" <nobody@.nobody.com> wrote in message
news:uFm1nphJIHA.5208@.TK2MSFTNGP04.phx.gbl...
> The problem is I did not do any restores. In backup exec I backed up the
> databases but selected the option (continue backup if consistency check
> fails)
>
> "Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
> news:C089955B-5CE2-40B7-8095-AC669BA0C873@.microsoft.com...
>
mssql server started and then stopped
I have a problem with all mssql servers in the domain that is unable to
start
The error is
the mssql server started and then stopped. All mssql service is started
with the local system account
any idea?ERROR.LOG contains something? Event Viewer?
"nobody" <nobody@.nobody.com> wrote in message
news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>I have a problem with all mssql servers in the domain that is unable to
>start
> The error is
> the mssql server started and then stopped. All mssql service is started
> with the local system account
>
> any idea?
>|||didnt see anything in event viewer but error.log in mssql\log shows this
2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-11-13 06:40:43.76 server All rights reserved.
2007-11-13 06:40:43.76 server Server Process ID is 2448.
2007-11-13 06:40:43.76 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
2007-11-13 06:40:43.77 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2007-11-13 06:40:43.81 server SQL Server configured for thread mode
processing.
2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
because it is marked IN LOAD.
2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is in
the middle of a restore.
I am not doing any restores
please help
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
> ERROR.LOG contains something? Event Viewer?
>
>
> "nobody" <nobody@.nobody.com> wrote in message
> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>I have a problem with all mssql servers in the domain that is unable to
>>start
>> The error is
>> the mssql server started and then stopped. All mssql service is started
>> with the local system account
>>
>> any idea?
>|||Hi
Peraphs it got corrupted.Do you have a backup?
/*
Bypassing recovery for database 'model'
because it is marked IN LOAD.
2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is in
the middle of a restore.
*/
"nobody" <nobody@.nobody.com> wrote in message
news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
> didnt see anything in event viewer but error.log in mssql\log shows this
>
> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2007-11-13 06:40:43.76 server All rights reserved.
> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
> 2007-11-13 06:40:43.77 server SQL Server is starting at priority class
> 'normal'(1 CPU detected).
> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
> processing.
> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500] Lock
> Blocks, [1000] Lock Owner Blocks.
> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
> because it is marked IN LOAD.
> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
> in the middle of a restore.
>
> I am not doing any restores
> please help
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>> ERROR.LOG contains something? Event Viewer?
>>
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>I have a problem with all mssql servers in the domain that is unable to
>>start
>> The error is
>> the mssql server started and then stopped. All mssql service is started
>> with the local system account
>>
>> any idea?
>>
>|||the thing is several mssql on the same domain is failing to start. I think
it might have to do with backup exec backups failed last night.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
> Hi
> Peraphs it got corrupted.Do you have a backup?
> /*
> Bypassing recovery for database 'model'
> because it is marked IN LOAD.
> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
> in
> the middle of a restore.
> */
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
>> didnt see anything in event viewer but error.log in mssql\log shows this
>>
>> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
>> (Intel X86)
>> Dec 17 2002 14:22:05
>> Copyright (c) 1988-2003 Microsoft Corporation
>> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
>> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
>> Corporation.
>> 2007-11-13 06:40:43.76 server All rights reserved.
>> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
>> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
>> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
>> 2007-11-13 06:40:43.77 server SQL Server is starting at priority class
>> 'normal'(1 CPU detected).
>> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
>> processing.
>> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500]
>> Lock Blocks, [1000] Lock Owner Blocks.
>> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
>> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
>> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
>> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
>> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
>> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
>> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
>> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
>> because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
>> in the middle of a restore.
>>
>> I am not doing any restores
>> please help
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>> ERROR.LOG contains something? Event Viewer?
>>
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>I have a problem with all mssql servers in the domain that is unable to
>>start
>> The error is
>> the mssql server started and then stopped. All mssql service is
>> started with the local system account
>>
>> any idea?
>>
>>
>|||Also, there is a KB about this problem, you may want to read it.
http://support.microsoft.com/kb/822852
--
Ekrem Önsoy
"nobody" <nobody@.nobody.com> wrote in message
news:%23o1dp0gJIHA.484@.TK2MSFTNGP06.phx.gbl...
> the thing is several mssql on the same domain is failing to start. I think
> it might have to do with backup exec backups failed last night.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
>> Hi
>> Peraphs it got corrupted.Do you have a backup?
>> /*
>> Bypassing recovery for database 'model'
>> because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
>> in
>> the middle of a restore.
>> */
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
>> didnt see anything in event viewer but error.log in mssql\log shows this
>>
>> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
>> (Intel X86)
>> Dec 17 2002 14:22:05
>> Copyright (c) 1988-2003 Microsoft Corporation
>> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
>> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
>> Corporation.
>> 2007-11-13 06:40:43.76 server All rights reserved.
>> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
>> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
>> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
>> 2007-11-13 06:40:43.77 server SQL Server is starting at priority
>> class 'normal'(1 CPU detected).
>> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
>> processing.
>> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500]
>> Lock Blocks, [1000] Lock Owner Blocks.
>> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
>> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
>> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
>> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
>> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1:
>> 1310.
>> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
>> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
>> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
>> because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It
>> is in the middle of a restore.
>>
>> I am not doing any restores
>> please help
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>> ERROR.LOG contains something? Event Viewer?
>>
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>I have a problem with all mssql servers in the domain that is unable to
>>start
>> The error is
>> the mssql server started and then stopped. All mssql service is
>> started with the local system account
>>
>> any idea?
>>
>>
>>
>|||The problem is I did not do any restores. In backup exec I backed up the
databases but selected the option (continue backup if consistency check
fails)
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:C089955B-5CE2-40B7-8095-AC669BA0C873@.microsoft.com...
> Also, there is a KB about this problem, you may want to read it.
> http://support.microsoft.com/kb/822852
> --
> Ekrem Önsoy
>
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23o1dp0gJIHA.484@.TK2MSFTNGP06.phx.gbl...
>> the thing is several mssql on the same domain is failing to start. I
>> think it might have to do with backup exec backups failed last night.
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
>> Hi
>> Peraphs it got corrupted.Do you have a backup?
>> /*
>> Bypassing recovery for database 'model'
>> because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It
>> is in
>> the middle of a restore.
>> */
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
>> didnt see anything in event viewer but error.log in mssql\log shows
>> this
>>
>> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
>> (Intel X86)
>> Dec 17 2002 14:22:05
>> Copyright (c) 1988-2003 Microsoft Corporation
>> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
>> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
>> Corporation.
>> 2007-11-13 06:40:43.76 server All rights reserved.
>> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
>> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
>> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
>> 2007-11-13 06:40:43.77 server SQL Server is starting at priority
>> class 'normal'(1 CPU detected).
>> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
>> processing.
>> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500]
>> Lock Blocks, [1000] Lock Owner Blocks.
>> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
>> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version
>> '8.0.760'.
>> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
>> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
>> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1:
>> 1310.
>> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 4
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 6
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 7
>> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
>> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database
>> 'model' because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It
>> is in the middle of a restore.
>>
>> I am not doing any restores
>> please help
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>> ERROR.LOG contains something? Event Viewer?
>>
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>I have a problem with all mssql servers in the domain that is unable
>>to start
>> The error is
>> the mssql server started and then stopped. All mssql service is
>> started with the local system account
>>
>> any idea?
>>
>>
>>
>>
>|||how do I run dbcc from query analyzer? I have another machine failed to
start sql. I believe this had to do with backup exec
"nobody" <nobody@.nobody.com> wrote in message
news:uFm1nphJIHA.5208@.TK2MSFTNGP04.phx.gbl...
> The problem is I did not do any restores. In backup exec I backed up the
> databases but selected the option (continue backup if consistency check
> fails)
>
> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
> news:C089955B-5CE2-40B7-8095-AC669BA0C873@.microsoft.com...
>> Also, there is a KB about this problem, you may want to read it.
>> http://support.microsoft.com/kb/822852
>> --
>> Ekrem Önsoy
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%23o1dp0gJIHA.484@.TK2MSFTNGP06.phx.gbl...
>> the thing is several mssql on the same domain is failing to start. I
>> think it might have to do with backup exec backups failed last night.
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
>> Hi
>> Peraphs it got corrupted.Do you have a backup?
>> /*
>> Bypassing recovery for database 'model'
>> because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It
>> is in
>> the middle of a restore.
>> */
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
>> didnt see anything in event viewer but error.log in mssql\log shows
>> this
>>
>> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
>> (Intel X86)
>> Dec 17 2002 14:22:05
>> Copyright (c) 1988-2003 Microsoft Corporation
>> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
>> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
>> Corporation.
>> 2007-11-13 06:40:43.76 server All rights reserved.
>> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
>> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
>> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
>> 2007-11-13 06:40:43.77 server SQL Server is starting at priority
>> class 'normal'(1 CPU detected).
>> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
>> processing.
>> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500]
>> Lock Blocks, [1000] Lock Owner Blocks.
>> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
>> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version
>> '8.0.760'.
>> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
>> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x:
>> 1310.
>> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1:
>> 1310.
>> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 4
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 6
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 7
>> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
>> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database
>> 'model' because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It
>> is in the middle of a restore.
>>
>> I am not doing any restores
>> please help
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>> ERROR.LOG contains something? Event Viewer?
>>
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>>I have a problem with all mssql servers in the domain that is unable
>>>to start
>>>
>>> The error is
>>>
>>> the mssql server started and then stopped. All mssql service is
>>> started with the local system account
>>>
>>>
>>> any idea?
>>>
>>
>>
>>
>>
>
start
The error is
the mssql server started and then stopped. All mssql service is started
with the local system account
any idea?ERROR.LOG contains something? Event Viewer?
"nobody" <nobody@.nobody.com> wrote in message
news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>I have a problem with all mssql servers in the domain that is unable to
>start
> The error is
> the mssql server started and then stopped. All mssql service is started
> with the local system account
>
> any idea?
>|||didnt see anything in event viewer but error.log in mssql\log shows this
2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-11-13 06:40:43.76 server All rights reserved.
2007-11-13 06:40:43.76 server Server Process ID is 2448.
2007-11-13 06:40:43.76 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
2007-11-13 06:40:43.77 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2007-11-13 06:40:43.81 server SQL Server configured for thread mode
processing.
2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
because it is marked IN LOAD.
2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is in
the middle of a restore.
I am not doing any restores
please help
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
> ERROR.LOG contains something? Event Viewer?
>
>
> "nobody" <nobody@.nobody.com> wrote in message
> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>I have a problem with all mssql servers in the domain that is unable to
>>start
>> The error is
>> the mssql server started and then stopped. All mssql service is started
>> with the local system account
>>
>> any idea?
>|||Hi
Peraphs it got corrupted.Do you have a backup?
/*
Bypassing recovery for database 'model'
because it is marked IN LOAD.
2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is in
the middle of a restore.
*/
"nobody" <nobody@.nobody.com> wrote in message
news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
> didnt see anything in event viewer but error.log in mssql\log shows this
>
> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2007-11-13 06:40:43.76 server All rights reserved.
> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
> 2007-11-13 06:40:43.77 server SQL Server is starting at priority class
> 'normal'(1 CPU detected).
> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
> processing.
> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500] Lock
> Blocks, [1000] Lock Owner Blocks.
> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
> because it is marked IN LOAD.
> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
> in the middle of a restore.
>
> I am not doing any restores
> please help
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>> ERROR.LOG contains something? Event Viewer?
>>
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>I have a problem with all mssql servers in the domain that is unable to
>>start
>> The error is
>> the mssql server started and then stopped. All mssql service is started
>> with the local system account
>>
>> any idea?
>>
>|||the thing is several mssql on the same domain is failing to start. I think
it might have to do with backup exec backups failed last night.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
> Hi
> Peraphs it got corrupted.Do you have a backup?
> /*
> Bypassing recovery for database 'model'
> because it is marked IN LOAD.
> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
> in
> the middle of a restore.
> */
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
>> didnt see anything in event viewer but error.log in mssql\log shows this
>>
>> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
>> (Intel X86)
>> Dec 17 2002 14:22:05
>> Copyright (c) 1988-2003 Microsoft Corporation
>> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
>> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
>> Corporation.
>> 2007-11-13 06:40:43.76 server All rights reserved.
>> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
>> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
>> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
>> 2007-11-13 06:40:43.77 server SQL Server is starting at priority class
>> 'normal'(1 CPU detected).
>> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
>> processing.
>> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500]
>> Lock Blocks, [1000] Lock Owner Blocks.
>> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
>> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
>> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
>> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
>> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
>> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
>> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
>> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
>> because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
>> in the middle of a restore.
>>
>> I am not doing any restores
>> please help
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>> ERROR.LOG contains something? Event Viewer?
>>
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>I have a problem with all mssql servers in the domain that is unable to
>>start
>> The error is
>> the mssql server started and then stopped. All mssql service is
>> started with the local system account
>>
>> any idea?
>>
>>
>|||Also, there is a KB about this problem, you may want to read it.
http://support.microsoft.com/kb/822852
--
Ekrem Önsoy
"nobody" <nobody@.nobody.com> wrote in message
news:%23o1dp0gJIHA.484@.TK2MSFTNGP06.phx.gbl...
> the thing is several mssql on the same domain is failing to start. I think
> it might have to do with backup exec backups failed last night.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
>> Hi
>> Peraphs it got corrupted.Do you have a backup?
>> /*
>> Bypassing recovery for database 'model'
>> because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
>> in
>> the middle of a restore.
>> */
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
>> didnt see anything in event viewer but error.log in mssql\log shows this
>>
>> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
>> (Intel X86)
>> Dec 17 2002 14:22:05
>> Copyright (c) 1988-2003 Microsoft Corporation
>> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
>> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
>> Corporation.
>> 2007-11-13 06:40:43.76 server All rights reserved.
>> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
>> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
>> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
>> 2007-11-13 06:40:43.77 server SQL Server is starting at priority
>> class 'normal'(1 CPU detected).
>> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
>> processing.
>> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500]
>> Lock Blocks, [1000] Lock Owner Blocks.
>> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
>> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
>> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
>> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
>> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1:
>> 1310.
>> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
>> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
>> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
>> because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It
>> is in the middle of a restore.
>>
>> I am not doing any restores
>> please help
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>> ERROR.LOG contains something? Event Viewer?
>>
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>I have a problem with all mssql servers in the domain that is unable to
>>start
>> The error is
>> the mssql server started and then stopped. All mssql service is
>> started with the local system account
>>
>> any idea?
>>
>>
>>
>|||The problem is I did not do any restores. In backup exec I backed up the
databases but selected the option (continue backup if consistency check
fails)
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:C089955B-5CE2-40B7-8095-AC669BA0C873@.microsoft.com...
> Also, there is a KB about this problem, you may want to read it.
> http://support.microsoft.com/kb/822852
> --
> Ekrem Önsoy
>
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23o1dp0gJIHA.484@.TK2MSFTNGP06.phx.gbl...
>> the thing is several mssql on the same domain is failing to start. I
>> think it might have to do with backup exec backups failed last night.
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
>> Hi
>> Peraphs it got corrupted.Do you have a backup?
>> /*
>> Bypassing recovery for database 'model'
>> because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It
>> is in
>> the middle of a restore.
>> */
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
>> didnt see anything in event viewer but error.log in mssql\log shows
>> this
>>
>> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
>> (Intel X86)
>> Dec 17 2002 14:22:05
>> Copyright (c) 1988-2003 Microsoft Corporation
>> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
>> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
>> Corporation.
>> 2007-11-13 06:40:43.76 server All rights reserved.
>> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
>> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
>> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
>> 2007-11-13 06:40:43.77 server SQL Server is starting at priority
>> class 'normal'(1 CPU detected).
>> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
>> processing.
>> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500]
>> Lock Blocks, [1000] Lock Owner Blocks.
>> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
>> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version
>> '8.0.760'.
>> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
>> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
>> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1:
>> 1310.
>> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 4
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 6
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 7
>> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
>> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database
>> 'model' because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It
>> is in the middle of a restore.
>>
>> I am not doing any restores
>> please help
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>> ERROR.LOG contains something? Event Viewer?
>>
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>I have a problem with all mssql servers in the domain that is unable
>>to start
>> The error is
>> the mssql server started and then stopped. All mssql service is
>> started with the local system account
>>
>> any idea?
>>
>>
>>
>>
>|||how do I run dbcc from query analyzer? I have another machine failed to
start sql. I believe this had to do with backup exec
"nobody" <nobody@.nobody.com> wrote in message
news:uFm1nphJIHA.5208@.TK2MSFTNGP04.phx.gbl...
> The problem is I did not do any restores. In backup exec I backed up the
> databases but selected the option (continue backup if consistency check
> fails)
>
> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
> news:C089955B-5CE2-40B7-8095-AC669BA0C873@.microsoft.com...
>> Also, there is a KB about this problem, you may want to read it.
>> http://support.microsoft.com/kb/822852
>> --
>> Ekrem Önsoy
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%23o1dp0gJIHA.484@.TK2MSFTNGP06.phx.gbl...
>> the thing is several mssql on the same domain is failing to start. I
>> think it might have to do with backup exec backups failed last night.
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
>> Hi
>> Peraphs it got corrupted.Do you have a backup?
>> /*
>> Bypassing recovery for database 'model'
>> because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It
>> is in
>> the middle of a restore.
>> */
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
>> didnt see anything in event viewer but error.log in mssql\log shows
>> this
>>
>> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
>> (Intel X86)
>> Dec 17 2002 14:22:05
>> Copyright (c) 1988-2003 Microsoft Corporation
>> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
>> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
>> Corporation.
>> 2007-11-13 06:40:43.76 server All rights reserved.
>> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
>> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
>> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
>> 2007-11-13 06:40:43.77 server SQL Server is starting at priority
>> class 'normal'(1 CPU detected).
>> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
>> processing.
>> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500]
>> Lock Blocks, [1000] Lock Owner Blocks.
>> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
>> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version
>> '8.0.760'.
>> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
>> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x:
>> 1310.
>> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1:
>> 1310.
>> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 4
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 6
>> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id
>> 7
>> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
>> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database
>> 'model' because it is marked IN LOAD.
>> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It
>> is in the middle of a restore.
>>
>> I am not doing any restores
>> please help
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>> ERROR.LOG contains something? Event Viewer?
>>
>>
>> "nobody" <nobody@.nobody.com> wrote in message
>> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>>>I have a problem with all mssql servers in the domain that is unable
>>>to start
>>>
>>> The error is
>>>
>>> the mssql server started and then stopped. All mssql service is
>>> started with the local system account
>>>
>>>
>>> any idea?
>>>
>>
>>
>>
>>
>
mssql server started and then stopped
I have a problem with all mssql servers in the domain that is unable to
start
The error is
the mssql server started and then stopped. All mssql service is started
with the local system account
any idea?ERROR.LOG contains something? Event Viewer?
"nobody" <nobody@.nobody.com> wrote in message
news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>I have a problem with all mssql servers in the domain that is unable to
>start
> The error is
> the mssql server started and then stopped. All mssql service is started
> with the local system account
>
> any idea?
>|||didnt see anything in event viewer but error.log in mssql\log shows this
2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-11-13 06:40:43.76 server All rights reserved.
2007-11-13 06:40:43.76 server Server Process ID is 2448.
2007-11-13 06:40:43.76 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
2007-11-13 06:40:43.77 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2007-11-13 06:40:43.81 server SQL Server configured for thread mode
processing.
2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500] Lo
ck
Blocks, [1000] Lock Owner Blocks.
2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
because it is marked IN LOAD.
2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is in
the middle of a restore.
I am not doing any restores
please help
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
> ERROR.LOG contains something? Event Viewer?
>
>
> "nobody" <nobody@.nobody.com> wrote in message
> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>|||Hi
Peraphs it got corrupted.Do you have a backup?
/*
Bypassing recovery for database 'model'
because it is marked IN LOAD.
2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is in
the middle of a restore.
*/
"nobody" <nobody@.nobody.com> wrote in message
news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
> didnt see anything in event viewer but error.log in mssql\log shows this
>
> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2007-11-13 06:40:43.76 server All rights reserved.
> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
> 2007-11-13 06:40:43.77 server SQL Server is starting at priority class
> 'normal'(1 CPU detected).
> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
> processing.
> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500]
Lock
> Blocks, [1000] Lock Owner Blocks.
> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
> because it is marked IN LOAD.
> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
> in the middle of a restore.
>
> I am not doing any restores
> please help
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>|||the thing is several mssql on the same domain is failing to start. I think
it might have to do with backup exec backups failed last night.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
> Hi
> Peraphs it got corrupted.Do you have a backup?
> /*
> Bypassing recovery for database 'model'
> because it is marked IN LOAD.
> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
> in
> the middle of a restore.
> */
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
>|||Also, there is a KB about this problem, you may want to read it.
http://support.microsoft.com/kb/822852
Ekrem nsoy
"nobody" <nobody@.nobody.com> wrote in message
news:%23o1dp0gJIHA.484@.TK2MSFTNGP06.phx.gbl...
> the thing is several mssql on the same domain is failing to start. I think
> it might have to do with backup exec backups failed last night.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
>|||The problem is I did not do any restores. In backup exec I backed up the
databases but selected the option (continue backup if consistency check
fails)
"Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
news:C089955B-5CE2-40B7-8095-AC669BA0C873@.microsoft.com...
> Also, there is a KB about this problem, you may want to read it.
> http://support.microsoft.com/kb/822852
> --
> Ekrem nsoy
>
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23o1dp0gJIHA.484@.TK2MSFTNGP06.phx.gbl...
>|||how do I run dbcc from query analyzer? I have another machine failed to
start sql. I believe this had to do with backup exec
"nobody" <nobody@.nobody.com> wrote in message
news:uFm1nphJIHA.5208@.TK2MSFTNGP04.phx.gbl...
> The problem is I did not do any restores. In backup exec I backed up the
> databases but selected the option (continue backup if consistency check
> fails)
>
> "Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
> news:C089955B-5CE2-40B7-8095-AC669BA0C873@.microsoft.com...
>
start
The error is
the mssql server started and then stopped. All mssql service is started
with the local system account
any idea?ERROR.LOG contains something? Event Viewer?
"nobody" <nobody@.nobody.com> wrote in message
news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>I have a problem with all mssql servers in the domain that is unable to
>start
> The error is
> the mssql server started and then stopped. All mssql service is started
> with the local system account
>
> any idea?
>|||didnt see anything in event viewer but error.log in mssql\log shows this
2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-11-13 06:40:43.76 server All rights reserved.
2007-11-13 06:40:43.76 server Server Process ID is 2448.
2007-11-13 06:40:43.76 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
2007-11-13 06:40:43.77 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2007-11-13 06:40:43.81 server SQL Server configured for thread mode
processing.
2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500] Lo
ck
Blocks, [1000] Lock Owner Blocks.
2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
because it is marked IN LOAD.
2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is in
the middle of a restore.
I am not doing any restores
please help
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
> ERROR.LOG contains something? Event Viewer?
>
>
> "nobody" <nobody@.nobody.com> wrote in message
> news:%239kS1WgJIHA.5400@.TK2MSFTNGP04.phx.gbl...
>|||Hi
Peraphs it got corrupted.Do you have a backup?
/*
Bypassing recovery for database 'model'
because it is marked IN LOAD.
2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is in
the middle of a restore.
*/
"nobody" <nobody@.nobody.com> wrote in message
news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
> didnt see anything in event viewer but error.log in mssql\log shows this
>
> 2007-11-13 06:40:43.75 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 1)
> 2007-11-13 06:40:43.76 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2007-11-13 06:40:43.76 server All rights reserved.
> 2007-11-13 06:40:43.76 server Server Process ID is 2448.
> 2007-11-13 06:40:43.76 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL$WSSERVER\LOG\ERRORLOG'.
> 2007-11-13 06:40:43.77 server SQL Server is starting at priority class
> 'normal'(1 CPU detected).
> 2007-11-13 06:40:43.81 server SQL Server configured for thread mode
> processing.
> 2007-11-13 06:40:43.81 server Using dynamic lock allocation. [500]
Lock
> Blocks, [1000] Lock Owner Blocks.
> 2007-11-13 06:40:43.82 spid3 Starting up database 'master'.
> 2007-11-13 06:40:43.93 server Using 'SSNETLIB.DLL' version '8.0.760'.
> 2007-11-13 06:40:43.95 spid5 Starting up database 'model'.
> 2007-11-13 06:40:43.98 server SQL server listening on x.x.x.x: 1310.
> 2007-11-13 06:40:43.98 server SQL server listening on 127.0.0.1: 1310.
> 2007-11-13 06:40:43.98 spid3 Server name is 'HALIBUT\WSSERVER'.
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 4
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 6
> 2007-11-13 06:40:43.98 spid3 Skipping startup of clean database id 7
> 2007-11-13 06:40:43.98 spid3 Starting up database 'WSDBMain'.
> 2007-11-13 06:40:44.05 spid5 Bypassing recovery for database 'model'
> because it is marked IN LOAD.
> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
> in the middle of a restore.
>
> I am not doing any restores
> please help
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eH2hQegJIHA.5624@.TK2MSFTNGP04.phx.gbl...
>|||the thing is several mssql on the same domain is failing to start. I think
it might have to do with backup exec backups failed last night.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
> Hi
> Peraphs it got corrupted.Do you have a backup?
> /*
> Bypassing recovery for database 'model'
> because it is marked IN LOAD.
> 2007-11-13 06:40:44.09 spid5 Database 'model' cannot be opened. It is
> in
> the middle of a restore.
> */
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23Vsp%23kgJIHA.3636@.TK2MSFTNGP03.phx.gbl...
>|||Also, there is a KB about this problem, you may want to read it.
http://support.microsoft.com/kb/822852
Ekrem nsoy
"nobody" <nobody@.nobody.com> wrote in message
news:%23o1dp0gJIHA.484@.TK2MSFTNGP06.phx.gbl...
> the thing is several mssql on the same domain is failing to start. I think
> it might have to do with backup exec backups failed last night.
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:e7Uy6ngJIHA.1188@.TK2MSFTNGP04.phx.gbl...
>|||The problem is I did not do any restores. In backup exec I backed up the
databases but selected the option (continue backup if consistency check
fails)
"Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
news:C089955B-5CE2-40B7-8095-AC669BA0C873@.microsoft.com...
> Also, there is a KB about this problem, you may want to read it.
> http://support.microsoft.com/kb/822852
> --
> Ekrem nsoy
>
> "nobody" <nobody@.nobody.com> wrote in message
> news:%23o1dp0gJIHA.484@.TK2MSFTNGP06.phx.gbl...
>|||how do I run dbcc from query analyzer? I have another machine failed to
start sql. I believe this had to do with backup exec
"nobody" <nobody@.nobody.com> wrote in message
news:uFm1nphJIHA.5208@.TK2MSFTNGP04.phx.gbl...
> The problem is I did not do any restores. In backup exec I backed up the
> databases but selected the option (continue backup if consistency check
> fails)
>
> "Ekrem nsoy" <ekrem@.btegitim.com> wrote in message
> news:C089955B-5CE2-40B7-8095-AC669BA0C873@.microsoft.com...
>
Subscribe to:
Posts (Atom)