can't start sql 2005 service

Hi guys, I have sql 2005 beta 2 installed.. It used to work before, toda
y I try to start the service, it said following messages.
I use local system account, my other instance sql 2000 can start, I think
it's only YUKON problem, I do not know how to troubleshoot this error.
Can you guys help? Thanks a lot!!Have you checked the SQL Server 2005 error log?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Britney" <britneychen_2001@.yahoo.com> wrote in message news:urW5U81oFHA.303
6@.TK2MSFTNGP14.phx.gbl...
Hi guys, I have sql 2005 beta 2 installed.. It used to work before, today
I try to start the service, it said following messages.
I use local system account, my other instance sql 2000 can start, I think
it's only YUKON problem, I do not know how to troubleshoot this error.
Can you guys help? Thanks a lot!!|||where do I look for the log?
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message news:%23F
eit92oFHA.3304@.tk2msftngp13.phx.gbl...
Have you checked the SQL Server 2005 error log?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Britney" <britneychen_2001@.yahoo.com> wrote in message news:urW5U81oFHA.303
6@.TK2MSFTNGP14.phx.gbl...
Hi guys, I have sql 2005 beta 2 installed.. It used to work before, toda
y I try to start the service, it said following messages.
I use local system account, my other instance sql 2000 can start, I think
it's only YUKON problem, I do not know how to troubleshoot this error.
Can you guys help? Thanks a lot!!

Can't start RS2005

Hi,
I am new and just installed SS2005 Developer Edition on a server.
I can see the following services on Configuration Manager -> Services
Integration Services - Running
FullText Search - Running
SQL Server - Running
Analysis Service - Running
Reporting Service - Stopped
Browser - Running
Agent - Running
I tried to start RS, it ends up with error:
The request failed or the service did not respond in a timely fashion.
Consult the event log or other applicable error logs for details.
Checked the event log:
- The Remote Procedure Call (RPC) service failed to start
- Service cannot be started.
Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:
=E7=84=A1=E6=B3=95=E8=BE=A8=E8=AD=98=E4=BD=BF=E7=94=A8=E8=80=85=E6=88=96=E7= =BE=A4=E7=B5=84=E5=90=8D=E7=A8=B1 'TPEW2KDM\ASPNET'=E3=80=82
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at
Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServ= er(Boolean
firstTime)
at
Microsoft.ReportingServices.Library.ServiceAppDomainController.Start(Boolean
firstTime)
at
Microsoft.ReportingServices.NTService.ReportService.OnStart(String[]
args)
at
System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object
state)
- The report server database is an invalid version.
I am wondering why reporting service is the only service that's not
running.
Any comments are highly appreciated.Still waiting for advice anyone? tks|||did you find a solution to this problem ?
From http://www.developmentnow.com/g/115_2006_1_0_0_679705/Cant-start-RS2005.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Can't start MSDTC

I can't start Distributed Transaction Coordinator (MSDTC)
I have following entries in event log
Event Type: Information
Event Source: MSDTC
Event Category: TM
Event ID: 53283
Date: 7/7/2004
Time: 9:19:01 AM
User: N/A
Computer: Some
Description:
DTC Security Configuration values. Network Administration of Transactions =
1, Network Clients = 0, Distributed Transactions using Native MSDTC
Protocol = 1, Transaction Internet Protocol (TIP) = 0, XA Transactions = 1.
(OFF = 0 and ON = 1).
Event Type: Error
Event Source: MSDTC
Event Category: LOG
Event ID: 4163
Date: 7/7/2004
Time: 9:19:01 AM
User: N/A
Computer: some
Description:
MS DTC log file not found. After ensuring that all Resource Managers
coordinated by MS DTC have no indoubt transactions, please run
msdtc -resetlog to create the log file.
[I have tried it and with no success]
Event Type: Error
Event Source: MSDTC
Event Category: SVC
Event ID: 4437
Date: 7/7/2004
Time: 9:19:01 AM
User: N/A
Computer: Some
Description:
The account that the MS DTC service is running under is invalid. This can
happen if the service account information has been changed using the
Services snap-in in Microsoft Management Console (MMC). MS DTC service will
continue to start. Please make sure that the MS DTC service account
information is updated using the Component Services Explorer.
How can I fix it?
It seems that because of it I can't install SQL Server 2005 Express.
If it is wrong newsgroup maybe someone can redirect me to the right one.
Thanks,
Shimon.
Go to Control panel->services or Administrative Tools-> services and find
the MS DTC service. There will be a properties box where you can change the
login/password under which dtc run... The first error message states that
the login/password is bad... (Maybe someone changed the password for the DTC
login...)
Hope this helps.
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
"Shimon Sim" <estshim@.att.net> wrote in message
news:ufa0SmIZEHA.728@.TK2MSFTNGP09.phx.gbl...
> I can't start Distributed Transaction Coordinator (MSDTC)
> I have following entries in event log
>
> Event Type: Information
> Event Source: MSDTC
> Event Category: TM
> Event ID: 53283
> Date: 7/7/2004
> Time: 9:19:01 AM
> User: N/A
> Computer: Some
> Description:
> DTC Security Configuration values. Network Administration of Transactions
=
> 1, Network Clients = 0, Distributed Transactions using Native MSDTC
> Protocol = 1, Transaction Internet Protocol (TIP) = 0, XA Transactions =
1.
> (OFF = 0 and ON = 1).
> Event Type: Error
> Event Source: MSDTC
> Event Category: LOG
> Event ID: 4163
> Date: 7/7/2004
> Time: 9:19:01 AM
> User: N/A
> Computer: some
> Description:
> MS DTC log file not found. After ensuring that all Resource Managers
> coordinated by MS DTC have no indoubt transactions, please run
> msdtc -resetlog to create the log file.
> [I have tried it and with no success]
> Event Type: Error
> Event Source: MSDTC
> Event Category: SVC
> Event ID: 4437
> Date: 7/7/2004
> Time: 9:19:01 AM
> User: N/A
> Computer: Some
> Description:
> The account that the MS DTC service is running under is invalid. This can
> happen if the service account information has been changed using the
> Services snap-in in Microsoft Management Console (MMC). MS DTC service
will
> continue to start. Please make sure that the MS DTC service account
> information is updated using the Component Services Explorer.
> How can I fix it?
> It seems that because of it I can't install SQL Server 2005 Express.
> If it is wrong newsgroup maybe someone can redirect me to the right one.
> Thanks,
> Shimon.
>
>
|||Is a local account option is good for this?
Shimon
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:O3zSJSOZEHA.3476@.tk2msftngp13.phx.gbl...
> Go to Control panel->services or Administrative Tools-> services and find
> the MS DTC service. There will be a properties box where you can change
the
> login/password under which dtc run... The first error message states that
> the login/password is bad... (Maybe someone changed the password for the
DTC[vbcol=seagreen]
> login...)
> Hope this helps.
> --
> 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
> "Shimon Sim" <estshim@.att.net> wrote in message
> news:ufa0SmIZEHA.728@.TK2MSFTNGP09.phx.gbl...
Transactions[vbcol=seagreen]
> =
=[vbcol=seagreen]
> 1.
can
> will
>

Can't start MSDTC

I can't start Distributed Transaction Coordinator (MSDTC)
I have following entries in event log
Event Type: Information
Event Source: MSDTC
Event Category: TM
Event ID: 53283
Date: 7/7/2004
Time: 9:19:01 AM
User: N/A
Computer: Some
Description:
DTC Security Configuration values. Network Administration of Transactions =
1, Network Clients = 0, Distributed Transactions using Native MSDTC
Protocol = 1, Transaction Internet Protocol (TIP) = 0, XA Transactions = 1.
(OFF = 0 and ON = 1).
Event Type: Error
Event Source: MSDTC
Event Category: LOG
Event ID: 4163
Date: 7/7/2004
Time: 9:19:01 AM
User: N/A
Computer: some
Description:
MS DTC log file not found. After ensuring that all Resource Managers
coordinated by MS DTC have no indoubt transactions, please run
msdtc -resetlog to create the log file.
[I have tried it and with no success]
Event Type: Error
Event Source: MSDTC
Event Category: SVC
Event ID: 4437
Date: 7/7/2004
Time: 9:19:01 AM
User: N/A
Computer: Some
Description:
The account that the MS DTC service is running under is invalid. This can
happen if the service account information has been changed using the
Services snap-in in Microsoft Management Console (MMC). MS DTC service will
continue to start. Please make sure that the MS DTC service account
information is updated using the Component Services Explorer.
How can I fix it?
It seems that because of it I can't install SQL Server 2005 Express.
If it is wrong newsgroup maybe someone can redirect me to the right one.
Thanks,
Shimon.Go to Control panel->services or Administrative Tools-> services and find
the MS DTC service. There will be a properties box where you can change the
login/password under which dtc run... The first error message states that
the login/password is bad... (Maybe someone changed the password for the DTC
login...)
Hope this helps.
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
"Shimon Sim" <estshim@.att.net> wrote in message
news:ufa0SmIZEHA.728@.TK2MSFTNGP09.phx.gbl...
> I can't start Distributed Transaction Coordinator (MSDTC)
> I have following entries in event log
>
> Event Type: Information
> Event Source: MSDTC
> Event Category: TM
> Event ID: 53283
> Date: 7/7/2004
> Time: 9:19:01 AM
> User: N/A
> Computer: Some
> Description:
> DTC Security Configuration values. Network Administration of Transactions
=
> 1, Network Clients = 0, Distributed Transactions using Native MSDTC
> Protocol = 1, Transaction Internet Protocol (TIP) = 0, XA Transactions =
1.
> (OFF = 0 and ON = 1).
> Event Type: Error
> Event Source: MSDTC
> Event Category: LOG
> Event ID: 4163
> Date: 7/7/2004
> Time: 9:19:01 AM
> User: N/A
> Computer: some
> Description:
> MS DTC log file not found. After ensuring that all Resource Managers
> coordinated by MS DTC have no indoubt transactions, please run
> msdtc -resetlog to create the log file.
> [I have tried it and with no success]
> Event Type: Error
> Event Source: MSDTC
> Event Category: SVC
> Event ID: 4437
> Date: 7/7/2004
> Time: 9:19:01 AM
> User: N/A
> Computer: Some
> Description:
> The account that the MS DTC service is running under is invalid. This can
> happen if the service account information has been changed using the
> Services snap-in in Microsoft Management Console (MMC). MS DTC service
will
> continue to start. Please make sure that the MS DTC service account
> information is updated using the Component Services Explorer.
> How can I fix it?
> It seems that because of it I can't install SQL Server 2005 Express.
> If it is wrong newsgroup maybe someone can redirect me to the right one.
> Thanks,
> Shimon.
>
>|||Is a local account option is good for this?
Shimon
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:O3zSJSOZEHA.3476@.tk2msftngp13.phx.gbl...
> Go to Control panel->services or Administrative Tools-> services and find
> the MS DTC service. There will be a properties box where you can change
the
> login/password under which dtc run... The first error message states that
> the login/password is bad... (Maybe someone changed the password for the
DTC
> login...)
> Hope this helps.
> --
> 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
> "Shimon Sim" <estshim@.att.net> wrote in message
> news:ufa0SmIZEHA.728@.TK2MSFTNGP09.phx.gbl...
Transactions[vbcol=seagreen]
> =
=[vbcol=seagreen]
> 1.
can[vbcol=seagreen]
> will
>

Can't start MSDTC

I can't start Distributed Transaction Coordinator (MSDTC)
I have following entries in event log
Event Type: Information
Event Source: MSDTC
Event Category: TM
Event ID: 53283
Date: 7/7/2004
Time: 9:19:01 AM
User: N/A
Computer: Some
Description:
DTC Security Configuration values. Network Administration of Transactions = 1, Network Clients = 0, Distributed Transactions using Native MSDTC
Protocol = 1, Transaction Internet Protocol (TIP) = 0, XA Transactions = 1.
(OFF = 0 and ON = 1).
Event Type: Error
Event Source: MSDTC
Event Category: LOG
Event ID: 4163
Date: 7/7/2004
Time: 9:19:01 AM
User: N/A
Computer: some
Description:
MS DTC log file not found. After ensuring that all Resource Managers
coordinated by MS DTC have no indoubt transactions, please run
msdtc -resetlog to create the log file.
[I have tried it and with no success]
Event Type: Error
Event Source: MSDTC
Event Category: SVC
Event ID: 4437
Date: 7/7/2004
Time: 9:19:01 AM
User: N/A
Computer: Some
Description:
The account that the MS DTC service is running under is invalid. This can
happen if the service account information has been changed using the
Services snap-in in Microsoft Management Console (MMC). MS DTC service will
continue to start. Please make sure that the MS DTC service account
information is updated using the Component Services Explorer.
How can I fix it?
It seems that because of it I can't install SQL Server 2005 Express.
If it is wrong newsgroup maybe someone can redirect me to the right one.
Thanks,
Shimon.Go to Control panel->services or Administrative Tools-> services and find
the MS DTC service. There will be a properties box where you can change the
login/password under which dtc run... The first error message states that
the login/password is bad... (Maybe someone changed the password for the DTC
login...)
Hope this helps.
--
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
"Shimon Sim" <estshim@.att.net> wrote in message
news:ufa0SmIZEHA.728@.TK2MSFTNGP09.phx.gbl...
> I can't start Distributed Transaction Coordinator (MSDTC)
> I have following entries in event log
>
> Event Type: Information
> Event Source: MSDTC
> Event Category: TM
> Event ID: 53283
> Date: 7/7/2004
> Time: 9:19:01 AM
> User: N/A
> Computer: Some
> Description:
> DTC Security Configuration values. Network Administration of Transactions
=> 1, Network Clients = 0, Distributed Transactions using Native MSDTC
> Protocol = 1, Transaction Internet Protocol (TIP) = 0, XA Transactions =1.
> (OFF = 0 and ON = 1).
> Event Type: Error
> Event Source: MSDTC
> Event Category: LOG
> Event ID: 4163
> Date: 7/7/2004
> Time: 9:19:01 AM
> User: N/A
> Computer: some
> Description:
> MS DTC log file not found. After ensuring that all Resource Managers
> coordinated by MS DTC have no indoubt transactions, please run
> msdtc -resetlog to create the log file.
> [I have tried it and with no success]
> Event Type: Error
> Event Source: MSDTC
> Event Category: SVC
> Event ID: 4437
> Date: 7/7/2004
> Time: 9:19:01 AM
> User: N/A
> Computer: Some
> Description:
> The account that the MS DTC service is running under is invalid. This can
> happen if the service account information has been changed using the
> Services snap-in in Microsoft Management Console (MMC). MS DTC service
will
> continue to start. Please make sure that the MS DTC service account
> information is updated using the Component Services Explorer.
> How can I fix it?
> It seems that because of it I can't install SQL Server 2005 Express.
> If it is wrong newsgroup maybe someone can redirect me to the right one.
> Thanks,
> Shimon.
>
>|||Is a local account option is good for this?
Shimon
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:O3zSJSOZEHA.3476@.tk2msftngp13.phx.gbl...
> Go to Control panel->services or Administrative Tools-> services and find
> the MS DTC service. There will be a properties box where you can change
the
> login/password under which dtc run... The first error message states that
> the login/password is bad... (Maybe someone changed the password for the
DTC
> login...)
> Hope this helps.
> --
> 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
> "Shimon Sim" <estshim@.att.net> wrote in message
> news:ufa0SmIZEHA.728@.TK2MSFTNGP09.phx.gbl...
> > I can't start Distributed Transaction Coordinator (MSDTC)
> > I have following entries in event log
> >
> >
> > Event Type: Information
> > Event Source: MSDTC
> > Event Category: TM
> > Event ID: 53283
> > Date: 7/7/2004
> > Time: 9:19:01 AM
> > User: N/A
> > Computer: Some
> > Description:
> > DTC Security Configuration values. Network Administration of
Transactions
> => > 1, Network Clients = 0, Distributed Transactions using Native MSDTC
> > Protocol = 1, Transaction Internet Protocol (TIP) = 0, XA Transactions
=> 1.
> > (OFF = 0 and ON = 1).
> >
> > Event Type: Error
> > Event Source: MSDTC
> > Event Category: LOG
> > Event ID: 4163
> > Date: 7/7/2004
> > Time: 9:19:01 AM
> > User: N/A
> > Computer: some
> > Description:
> > MS DTC log file not found. After ensuring that all Resource Managers
> > coordinated by MS DTC have no indoubt transactions, please run
> > msdtc -resetlog to create the log file.
> > [I have tried it and with no success]
> >
> > Event Type: Error
> > Event Source: MSDTC
> > Event Category: SVC
> > Event ID: 4437
> > Date: 7/7/2004
> > Time: 9:19:01 AM
> > User: N/A
> > Computer: Some
> > Description:
> > The account that the MS DTC service is running under is invalid. This
can
> > happen if the service account information has been changed using the
> > Services snap-in in Microsoft Management Console (MMC). MS DTC service
> will
> > continue to start. Please make sure that the MS DTC service account
> > information is updated using the Component Services Explorer.
> >
> > How can I fix it?
> > It seems that because of it I can't install SQL Server 2005 Express.
> > If it is wrong newsgroup maybe someone can redirect me to the right one.
> > Thanks,
> > Shimon.
> >
> >
> >
> >
>sql

Can't start DTC

I can't start Distributed Transaction Coordinator (MSDTC)
I have following entries in event log
Event Type: Information
Event Source: MSDTC
Event Category: TM
Event ID: 53283
Date: 7/7/2004
Time: 9:19:01 AM
User: N/A
Computer: Some
Description:
DTC Security Configuration values. Network Administration of Transactions =
1, Network Clients = 0, Distributed Transactions using Native MSDTC
Protocol = 1, Transaction Internet Protocol (TIP) = 0, XA Transactions = 1.
(OFF = 0 and ON = 1).
Event Type: Error
Event Source: MSDTC
Event Category: LOG
Event ID: 4163
Date: 7/7/2004
Time: 9:19:01 AM
User: N/A
Computer: some
Description:
MS DTC log file not found. After ensuring that all Resource Managers
coordinated by MS DTC have no indoubt transactions, please run
msdtc -resetlog to create the log file.
Event Type: Error
Event Source: MSDTC
Event Category: SVC
Event ID: 4437
Date: 7/7/2004
Time: 9:19:01 AM
User: N/A
Computer: Some
Description:
The account that the MS DTC service is running under is invalid. This can
happen if the service account information has been changed using the
Services snap-in in Microsoft Management Console (MMC). MS DTC service will
continue to start. Please make sure that the MS DTC service account
information is updated using the Component Services Explorer.
How can I fix it?
It seems that because of it I can't install SQL Server 2005 Express.
If it is wrong newsgroup maybe someone can redirect me to the right one.
Thanks,
Shimon.
Check what account is used to start MSDTC and its privileges.
"Shimon Sim" wrote:

> I can't start Distributed Transaction Coordinator (MSDTC)
> I have following entries in event log
>
> Event Type: Information
> Event Source: MSDTC
> Event Category: TM
> Event ID: 53283
> Date: 7/7/2004
> Time: 9:19:01 AM
> User: N/A
> Computer: Some
> Description:
> DTC Security Configuration values. Network Administration of Transactions =
> 1, Network Clients = 0, Distributed Transactions using Native MSDTC
> Protocol = 1, Transaction Internet Protocol (TIP) = 0, XA Transactions = 1.
> (OFF = 0 and ON = 1).
> Event Type: Error
> Event Source: MSDTC
> Event Category: LOG
> Event ID: 4163
> Date: 7/7/2004
> Time: 9:19:01 AM
> User: N/A
> Computer: some
> Description:
> MS DTC log file not found. After ensuring that all Resource Managers
> coordinated by MS DTC have no indoubt transactions, please run
> msdtc -resetlog to create the log file.
>
> Event Type: Error
> Event Source: MSDTC
> Event Category: SVC
> Event ID: 4437
> Date: 7/7/2004
> Time: 9:19:01 AM
> User: N/A
> Computer: Some
> Description:
> The account that the MS DTC service is running under is invalid. This can
> happen if the service account information has been changed using the
> Services snap-in in Microsoft Management Console (MMC). MS DTC service will
> continue to start. Please make sure that the MS DTC service account
> information is updated using the Component Services Explorer.
> How can I fix it?
> It seems that because of it I can't install SQL Server 2005 Express.
> If it is wrong newsgroup maybe someone can redirect me to the right one.
> Thanks,
> Shimon.
>
>
|||Thanks,
I found the problem. I tried to use local account for this service but it
must use special account. And also Log for it go corrupted (It seems that
because of using wrong account I had to reset log )
Shimon.
"SatyaSKJ" <SatyaSKJ@.discussions.microsoft.com> wrote in message
news:15DD352E-627F-46FF-8EA1-B70197A45C32@.microsoft.com...[vbcol=seagreen]
> Check what account is used to start MSDTC and its privileges.
> "Shimon Sim" wrote:
Transactions =[vbcol=seagreen]
= 1.[vbcol=seagreen]
can[vbcol=seagreen]
will[vbcol=seagreen]

Can't start 2005 Report Services on XP SP2

Hej,
I am attempting to get a test environment up and running on my XP SP2
machine but I can't start reporting services. I found the following log in
the Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles directory:
ReportingServicesService!servicecontroller!4!28-03-2006-09:27:22:: e ERROR:
Exception caught starting RPC server:
Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:
The user or group name 'ANEISHA\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at
Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean
firstTime)
Anybody have any clues?
Thanks in advance,
Antony C. Roberts.In desperation, I created an ASPNET user and gave it all possible roles.
That solved the problem... What is the CORRECT solution to this problem?
Thanks!
/Ant.
"Antony C. Roberts" <acr@.no.way.com> wrote in message
news:ONFgYrjUGHA.1444@.TK2MSFTNGP11.phx.gbl...
> Hej,
> I am attempting to get a test environment up and running on my XP SP2
> machine but I can't start reporting services. I found the following log in
> the Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles directory:
> ReportingServicesService!servicecontroller!4!28-03-2006-09:27:22:: e
> ERROR: Exception caught starting RPC server:
> Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:
> The user or group name 'ANEISHA\ASPNET' is not recognized.
> at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
> at
> Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean
> firstTime)
> Anybody have any clues?
> Thanks in advance,
> Antony C. Roberts.
>

Can't setup replication: Encryption error using CryptProtectData?

I am trying to setup replication but am having the following issues
Publisher:
SQL 2005 SP1 Enterprise Cluster (Active, Passive)
Subscriber:
SQL 2005 SP1 Enterprise


When trying to create a publication or subsubscription running under a Windows Domain account the following error message appears:

Replication-Replication Distribution Subsystem: agent ECHO\ECHO-InsDB-INS_CMS_PUB-HARPO-58 failed. Unable to start execution of step 2 (reason: Error authenticating proxy DETINI\srvRep_user, system error: Logon failure: unknown user name or bad password.). The step failed.

Further in the SQL logs we find that the above message is due to:

[298] SQLServer Error: 22046, Encryption error using CryptProtectData. [SQLSTATE 42000]

It appears that when Credentials for the agent proxy are being created that this message occurs. So when the SP that tries to run the agent (snapshot or distrobution) is called it always returns incorrect password details.

The Credentials do appear to be created, they are visible via SQL Studio, but you can't see the password. Changing the password via SQL Studio does not work as the Credentials are recreated every time.

I have checked the following:

MSDTC is running correctly
The Domain Account has the correct privileges to run these services
Regenerated the Service Master Key
Created Master Keys in each database effected by replication
Ensure SQL Service accounts have access to decrypt the Service Master Key
I can create a Publication and Subscription using the local system account on the cluster

Does anyone have any idea ?

Chris

Chirs,

My testing environment is the same as yours - the publisher/distributer is clustered SQL2005 enterprise with SP1 on windows 2003, and the subscriber is SQL2005 enterprise on 2003 server, and I have got the same error when I was trying to run the creating snapshot job. The only workaround I found was to put the distributor on the same server as the publisher, and use a local directory for shapshot folder, which was not ideal, but at least I could continue with my test. Then I had the same error again when I ran the push distribution job using a domain ammount. I had to change the security to use SQL agent account, which is a domain admin account.

I would like to know how to avoid the error too, since I want the distributor to be on a different machine than the publisher, and limit the rights of the credentials on the production environments.

Ying

sql

Can't setup replication: Encryption error using CryptProtectData?

I am trying to setup replication but am having the following issues
Publisher:
SQL 2005 SP1 Enterprise Cluster (Active, Passive)
Subscriber:
SQL 2005 SP1 Enterprise


When trying to create a publication or subsubscription running under a Windows Domain account the following error message appears:

Replication-Replication Distribution Subsystem: agent ECHO\ECHO-InsDB-INS_CMS_PUB-HARPO-58 failed. Unable to start execution of step 2 (reason: Error authenticating proxy DETINI\srvRep_user, system error: Logon failure: unknown user name or bad password.). The step failed.

Further in the SQL logs we find that the above message is due to:

[298] SQLServer Error: 22046, Encryption error using CryptProtectData. [SQLSTATE 42000]

It appears that when Credentials for the agent proxy are being created that this message occurs. So when the SP that tries to run the agent (snapshot or distrobution) is called it always returns incorrect password details.

The Credentials do appear to be created, they are visible via SQL Studio, but you can't see the password. Changing the password via SQL Studio does not work as the Credentials are recreated every time.

I have checked the following:

MSDTC is running correctly
The Domain Account has the correct privileges to run these services
Regenerated the Service Master Key
Created Master Keys in each database effected by replication
Ensure SQL Service accounts have access to decrypt the Service Master Key
I can create a Publication and Subscription using the local system account on the cluster

Does anyone have any idea ?

Chris

Chirs,

My testing environment is the same as yours - the publisher/distributer is clustered SQL2005 enterprise with SP1 on windows 2003, and the subscriber is SQL2005 enterprise on 2003 server, and I have got the same error when I was trying to run the creating snapshot job. The only workaround I found was to put the distributor on the same server as the publisher, and use a local directory for shapshot folder, which was not ideal, but at least I could continue with my test. Then I had the same error again when I ran the push distribution job using a domain ammount. I had to change the security to use SQL agent account, which is a domain admin account.

I would like to know how to avoid the error too, since I want the distributor to be on a different machine than the publisher, and limit the rights of the credentials on the production environments.

Ying

Can't setup replication

Initially, when I started to setup replication I received the error message ~
"one or more articles are published ...", so I issued the following commands
to remove replication settings from the DB:
sp_configure 'allow',1
GO
reconfigure with override
GO
USE ImageCraft
GO
sp_removedbreplication 'IMAGECRAFT'
GO
UPDATE sysobjects set replinfo=0 WHERE replinfo<>0
GO
Drop table MSdynamicsnapshotjobs
Drop table MSdynamicsnapshotviews
Drop table MSmerge_altsyncpartners
Drop table MSmerge_contents
Drop table MSmerge_delete_conflicts
Drop table MSmerge_errorlineage
Drop table MSmerge_genhistory
Drop table MSmerge_replinfo
Drop table MSmerge_tombstone
Drop table MSrepl_identity_range
Drop table sysmergearticles
Drop table sysmergepublications
Drop table sysmergeschemaarticles
Drop table sysmergeschemachange
Drop table sysmergesubscriptions
Drop table sysmergesubsetfilters
GO
sp_configure 'allow',0
GO
reconfigure with override
GO
Appearently, I overkilled it because I get an error message I've never seen
before when adding a table to the replication setup:
SQL Server Enterprise Manager could not initialize an article based on table
'BusinessUnit'.
Error 208: Invalid object name 'sysmergearticles'.
Invalid object name 'sysmergeschemaarticles'.
Invalid object name 'sysmergearticles'.
Invalid object name 'sysmergeschmaarticles'.
Could not use view or function 'sysmergeextendedarticlesview' because of
binding errors.
Could not use view or function 'sysmergeextendedarticlesview' because of
binding errors.
I did a restore on the I am trying to create the replication for, but still
get the same errors.
Any suggestions?
can you disable this database for merge publishing and then try to re-enable
it. Also what version of SQL are you running?
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
"Steven" <Steven@.discussions.microsoft.com> wrote in message
news:1838D345-A23E-4CB6-A122-3736554334BE@.microsoft.com...
> Initially, when I started to setup replication I received the error
> message ~
> "one or more articles are published ...", so I issued the following
> commands
> to remove replication settings from the DB:
> sp_configure 'allow',1
> GO
> reconfigure with override
> GO
> USE ImageCraft
> GO
> sp_removedbreplication 'IMAGECRAFT'
> GO
> UPDATE sysobjects set replinfo=0 WHERE replinfo<>0
> GO
> Drop table MSdynamicsnapshotjobs
> Drop table MSdynamicsnapshotviews
> Drop table MSmerge_altsyncpartners
> Drop table MSmerge_contents
> Drop table MSmerge_delete_conflicts
> Drop table MSmerge_errorlineage
> Drop table MSmerge_genhistory
> Drop table MSmerge_replinfo
> Drop table MSmerge_tombstone
> Drop table MSrepl_identity_range
> Drop table sysmergearticles
> Drop table sysmergepublications
> Drop table sysmergeschemaarticles
> Drop table sysmergeschemachange
> Drop table sysmergesubscriptions
> Drop table sysmergesubsetfilters
> GO
> sp_configure 'allow',0
> GO
> reconfigure with override
> GO
> Appearently, I overkilled it because I get an error message I've never
> seen
> before when adding a table to the replication setup:
> SQL Server Enterprise Manager could not initialize an article based on
> table
> 'BusinessUnit'.
> Error 208: Invalid object name 'sysmergearticles'.
> Invalid object name 'sysmergeschemaarticles'.
> Invalid object name 'sysmergearticles'.
> Invalid object name 'sysmergeschmaarticles'.
> Could not use view or function 'sysmergeextendedarticlesview' because of
> binding errors.
> Could not use view or function 'sysmergeextendedarticlesview' because of
> binding errors.
> I did a restore on the I am trying to create the replication for, but
> still
> get the same errors.
> Any suggestions?
>
|||I tried this, but no success. The system tables required for replication
have been deleted and I'm not sure how to bring them back. This seems to be
crux anyways. Any further thoughts?
"Narayana Vyas Kondreddi" wrote:

> Try this. Using sp_dboption set 'published' and 'merge publish' options to
> false.
> Then from the publisher properties dialog box in enterprise manager, enable
> this database again for replication.
> Then try to setup a publication and see if it works.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Steven" <Steven@.discussions.microsoft.com> wrote in message
> news:1838D345-A23E-4CB6-A122-3736554334BE@.microsoft.com...
>
>
|||I tried this too, but no success. I seem to have deleted the system tables
required for replication and need to bring them back.
"Hilary Cotter" wrote:

> can you disable this database for merge publishing and then try to re-enable
> it. Also what version of SQL are you running?
> --
> 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
> "Steven" <Steven@.discussions.microsoft.com> wrote in message
> news:1838D345-A23E-4CB6-A122-3736554334BE@.microsoft.com...
>
>

Can't Set variable Through Command Line

Hello everyone!

Bit of a problem executing a DTS command from a command line.

I have the following variables defined in my package:

UserVarchar1
UserVarchar2
UserVarchar3

All have a scope of Package, all of the mstrings

The command I'm attempting to run in 1 line is:

DTEXEC /FILE "C:\SSIS Packages\ED-Customers\Package.dtsx"
/SET \Package.Variables[User::UserVarchar1].value;"10"
/SET \Package.Variables[User::UserVarchar2].value;"30719"
/SET \Package.Variables[User::UserVarchar3].value;"BILLTO"

Description: The package path referenced an object that cannot be found: "\Package.Variables[User::UserVarchar1].value". This occurs when an attempt is made to resolve a package path to an object that cannot be found.

DTExec: Could not set \Package.Variables[User::UserVarchar1].value value to 10.

Any idea why?

Thanks for the help!What happens if you try:

\Package.Variables[User::UserVarchar1].Properties[Value];10|||For some reference:
http://blogs.conchango.com/jamiethomson/archive/2007/03/13/SSIS_3A00_-Property-Paths-syntax.aspx|||

How are you validating the path?

Check the path and remember the variables names are case sensitives.

|||

The syntax is wrong.

Check Phil's posts above.

-Jamie

|||I tried that.. Still says it can't assign it the value of 10.

It's case-accurate, in both path and variable names.

Description: The package path referenced an object that cannot be found: "\Package.Variables[User::UserVarchar1].value". This occurs when an attempt is made to resolve a package path to an object that cannot be found.

DTExec: Could not set \Package.Variables[User::UserVarchar1].value value to 10.

Is there something I'm missing in the design of the package, perhaps? All I did was add the variables to the package. Another variable uses these values and evaluates it as an expression. Doesn't seem too complex, yet I'm still miffed about why this won't execute.

Incidently, if I run the package WITHOUT variables, it will in fact run successfully.|||Adam, make sure the scope of that variable is at the package level, not some other component.|||By any chance is the ReadOnly property of the variable set to True? I get the same error if the value is true; if you want ot assign values at run time it should be set to false|||Thanks for the input, everyone! I finally figured it out.

The first reply was correct. I didn't notice .Properties[Value] in the first reply. Don't know how I missed it.

Sorry, it's been one fo those mornings..

Thanks again, everyone!

can't seem to get my GROUP BY ordering right

I have the following query, which works, but the ordering isn't quite
right, can anyone help?
SELECT
to_char(date_created,'DD-MON-YYYY') as date_joined,
COUNT(user_id) AS user_count
FROM
project_users
GROUP BY
to_char(date_created,'DD-MON-YYYY')
ORDER BY
to_char(date_created,'DD-MON-YYYY')
the output is shwon as follows:
02-APR-2006 - 1
03-APR-2006 - 1
04-APR-2006 - 4
05-APR-2006 - 8
06-APR-2006 - 11
08-MAR-2006 - 2
16-MAR-2006 - 2
17-MAR-2006 - 2
20-MAR-2006 - 3
21-MAR-2006 - 1
22-MAR-2006 - 1
but I would rather it was more logically ordered for a report, as so:
06-APR-2006 - 11
05-APR-2006 - 8
04-APR-2006 - 4
03-APR-2006 - 1
02-APR-2006 - 1
22-MAR-2006 - 1
21-MAR-2006 - 1
20-MAR-2006 - 3
17-MAR-2006 - 2
16-MAR-2006 - 2
08-MAR-2006 - 2
i.e. reverse order of date, and calendar month (not by month starting
letter)
TIA for any help and advicedid you try using DESC (for descending)?|||Kevin,
try
ORDER BY date_created DESC|||Also I suspect you're going to have to order desc by year/month/day
instead of d/m/y|||whooops.. forgot the mention that bit.. yup.. if I add DESC then the
order is reversed by DD, then MON, then YYYY... but that means that the
MAR dates appear before APR, as alphabetically, and in reverse order, M
comes before A.
I guess I should have mentioned that bit, eh' thanks for the quick
replies btw|||What if you try this (let me know if it helps..)
SELECT
to_char(date_created,'DD-MON-YYYY') as date_joined,
COUNT(user_id) AS user_count
FROM
project_users
GROUP BY
to_char(date_created,'DD-MON-YYYY')
ORDER BY
date_created desc
"Kevin Blount" wrote:

> I have the following query, which works, but the ordering isn't quite
> right, can anyone help?
> SELECT
> to_char(date_created,'DD-MON-YYYY') as date_joined,
> COUNT(user_id) AS user_count
> FROM
> project_users
> GROUP BY
> to_char(date_created,'DD-MON-YYYY')
> ORDER BY
> to_char(date_created,'DD-MON-YYYY')
>
> the output is shwon as follows:
> 02-APR-2006 - 1
> 03-APR-2006 - 1
> 04-APR-2006 - 4
> 05-APR-2006 - 8
> 06-APR-2006 - 11
> 08-MAR-2006 - 2
> 16-MAR-2006 - 2
> 17-MAR-2006 - 2
> 20-MAR-2006 - 3
> 21-MAR-2006 - 1
> 22-MAR-2006 - 1
> but I would rather it was more logically ordered for a report, as so:
> 06-APR-2006 - 11
> 05-APR-2006 - 8
> 04-APR-2006 - 4
> 03-APR-2006 - 1
> 02-APR-2006 - 1
> 22-MAR-2006 - 1
> 21-MAR-2006 - 1
> 20-MAR-2006 - 3
> 17-MAR-2006 - 2
> 16-MAR-2006 - 2
> 08-MAR-2006 - 2
> i.e. reverse order of date, and calendar month (not by month starting
> letter)
> TIA for any help and advice
>|||"Kevin Blount" <kevin.blount@.gmail.com> wrote in message
news:1144353616.181845.72600@.e56g2000cwe.googlegroups.com...
> whooops.. forgot the mention that bit.. yup.. if I add DESC then the
> order is reversed by DD, then MON, then YYYY... but that means that the
> MAR dates appear before APR, as alphabetically, and in reverse order, M
> comes before A.
> I guess I should have mentioned that bit, eh' thanks for the quick
> replies btw
>
I think you should have mentioned that this isn't a SQL Server query at all.
Oracle?
Anyway, try:
ORDER BY MIN(date_created)
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Thanks David, using ' MIN(date_created) DESC ' worked a charm (just '
date_created DESC ' didn't work at all for some reason).
I must confess, I saw SQL in the group name, but missed the SQLSERVER
part.. but then it's tricky finding a general group for queries..
unless someone knows of one?|||"Kevin Blount" <kevin.blount@.gmail.com> wrote in message
news:1144354904.773319.110340@.i40g2000cwc.googlegroups.com...
> I must confess, I saw SQL in the group name, but missed the SQLSERVER
> part.. but then it's tricky finding a general group for queries..
> unless someone knows of one?
There are specific groups for Oracle:
comp.databases.oracle.server
comp.databases.oracle.misc
For others check out http://groups.google.com
Whatever the product you are using, *always* state your version number.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

Can't see the SQL Server Express Instance on SQL Browser

Hi All,

I am using SQL Server Express to connect to the network using VPN on a local machine. I have done the following..

a.) Enabled the remote connections for the Express Instance and rebooted the machine.

b.) Connected to the machine with Express Edition locally and can also connect other SQL Server instances from it to verify connectivity.

c.) Yes, SQL Browser Service is running.

d.) Firewall is not turned on, so I do not have to configure any exceptions.

Now here is the big problem: When I browse for SQL Servers on the network the machine does not show up on the list, i.e "macinename\SQLExpress". I had uninstalled and reinstalled the Express edition and rebooted the machine several times with no luck on the SQL Express Instance showing up on the browser list. I even changed the default instance name to "machinename\MACHINE1" on one of the reinstalls. However, I can connect to other SQL Instances from it. But, I cannot connect to it from other machines since its not registered on the network. I have been working on this for the past few days by looking for a solution via this and other forumns. Is there some setting somewhere that I am missing that prevents this instance from not showing up on the browser list. This issue with SQL Express Edition is baffling as well as frustrating and any ideas that can resolve this issue is very much appreciated.

when you say you cant see it on the list, do you mean in the ODBC dialog list? or some other list? if its involves the ODBC dialog, ive had to actually type in the whole machinename \SQLExpress since it didnt show up initially for it to work.|||I am talking about the SQL Server Browser list, that one can see all of the live SQL Server database Instances. Not the dialog list...|||I have several of them that refuse to show up in any browser list. But, I can connect to just about all of them even though they don't show up in the browser list by just typing in the instance name. Is there a particular error that you are getting? Can you give us more detail on your configuration and exactly what steps you are doing?|||

After installing SQL Server Express Edition on a new HP laptop with WIN 2K sp2, I went to see if it was registered on the Network as "machinename/SQLEXPRESS", and what I can see on the Network is just the "machinename", with the instance name missing. So I reinstalled it with a new instance name "machinename/Machine1", and again it was missing the instance name "Machine1", but I can see the machinename. I tried to connect with the instance name only "Machine1" and believe me I have tried it every which way but I always get the infamous error:

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)"

Now here is the odd part, I had installed SQL Server Express Edition on a older (1 year) IBM laptop with WIN 2K sp2, about 1 month back and was able to see the complete instance name on the network and can connect just fine. The only difference in these two machines is the age, but they both have the same OS Software installed. I have been pulling my hair in trying to figure out what is going on with SQL Server Express Edition on this new HP laptop with WIN 2K sp2 installed. It just refuses to register itself correctly on the network.

|||I have several that the browser only sees the machine name. That still doesn't mean that is what you use for the connection string. If you are using a default instance of Express Edition, then you still need to connect to machinename\SQLExpress even if browsing only shows you just the machine name. Now, that doesn't mean that you aren't having issues similar to mine on one of my clients which refuses to allow me to connect, we just need to make sure there isn't something else wrong first.|||As I have mentioned before, I tried using "machinename\MACHINE1" as the complete instance name and it throws out the error as I posted before. I can connect other instances from this HP Laptop but cannot connect to it from other machines. Perhaps we are having the same issue. I have been asking our Network Admin, System Admin and Security Admin and they are all puzzled by this SQL Express behavior on this HP laptop. I am wondering if it has anything to do with particular PC machines as the IBM pc works fine, but not the HP, this is just a guess. But I am running out of ideas and my users are running out of patience as I try to find a solution to this big problem....|||

Not sure if this has anything to do with your issue, but you mentioned that you were using Win2000 SP2, that is not a supported platform for SQL 2005, you need to be running SP4. I'm surprised that install didn't block.

Mike

|||

Yes, it looks like you are having exactly the same issue as I'm having on one of my machines. I have everything configured correctly with all of the access configured the way it needs to be. I can quite literally do anything I want to on the client when I'm RDPed into the server including remotely launching applications, remotely stopping start services, etc. The only that that it refuses to do is recognize and connect to the SQL Server Express Edition instance. I'm having problem doing further troubleshooting and opening a support case is rather difficult since the problem machine is in CA and I'm in TX without any direct ability to get hands on with the machine. I thought I had another one exhibiting this behavior, but when I plugged the laptop into my network, it magically started working and it hasn't thrown the error since. Yes, I'm rather baffled. My only saving grace is that I don't have any more hair to pull out at this point. :)

I have several more machines to work through and I'm hoping that I can get at least one of them to exhibit this behavior.

|||

I'm getting a bit closer on my side and now have 2 machines that are having issues. So, I want to try something and see if your results duplicate mine.

Log on to the machine that is having problems using your accouunt. Once it is up and running, go over to another instance and login to the Express instance from the other machine using your Windows credentials. Let me know if that magically makes it work.

|||

Hi Michael,

Nope, I tried as you suggested and I keep getting that same error, from the other machine when I try to connect to the problem machine. However, I can connect from the problem machine to any other SQL Server 2005 instance...Do not know what to do at this point. Perhaps Microsoft needs to help out...I hope they are reading this Message.

|||I am wondering if this issue has anything to do with having 2 NIC cards in a Laptop machine, one for the Local Network and the other for the Wireless Network...That is the only difference I see with the 2 different Laptops I am working with. The IBM machine does not have a Wireless Network NIC and it works...The other newer HP has a Wireless NIC and it does not work..Is Microsoft listening.....|||I can rule that one out. I have machines that connect just fine with multiple NICs and a couple that don't that also have multiple NICs.|||Have you tried opening a support case with Microsoft. I am not sure how this particular Software is supported since it is freely distributed..|||

SQL Server Express Edition is fully supported. Just like you can call in and get support on Internet Explorer.

I found a couple of other things when I was doing additional configuration. Verify that your WINS scopes are set properly. Also verify that the machine is actually getting its IP address correctly registered into DNS. These two items fixed 100% of the connectivity issues that I was having within SQL Server.

Can't run the scheduled SQL Agent Job?

Hi,

I'm tried to run the job that created from maintenance plan. It fail and give me the following message:

[298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'DOMAIN\MYNAME', error code 0x5. [SQLSTATE 42000] (ConnIsLoginSysAdmin)

We are using the Windows Autheniciaton mode only and my id is set as sysadmin, setadmin, processadmin in the server roles.

I don't why I can't run the job, I check the SQL agent services is login using LOCALSYSTEM.

I try to the NT admin account to login the box, but still getting the same error message.

Any idea?

Thanks!

use a local login for the SQLAgent and try to schedule it again.|||

Hi,

What is local login? we only setup use the windows authenication mode for the sql server?

Thanks!

|||

this may help u : http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=102884&SiteID=1

change the owner of the job

Madhu

|||

Is the SQL Server machine in the same domain as the user mentioned in the error message?

The 0x5 error code means access denied - the DC doesn't allow you to query the user information. If there are different domains involved, you may need to set the trust between them.

Also, what did you say you tried at the end of your message? There is a word missing I think.

Thanks
Laurentiu

Can't Restore a DB backed up with COPY_ONLY in Mgmt Studio

If I create a backup using the following T-SQL, is there a specific reason that I cannot restore it through Mangement Studio.

BACKUP DATABASE MyDB

TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\MyDB_1.BAK'

WITH FORMAT, COPY_ONLY, NAME = 'Backup of MyDB'

I can still restore it using T-SQL but would like the conveinence of using Managment Studio. Any ideas? Is this a bug or is this by design? If by design, what would be the reason?

Any help is appreciated.

Are there any ideas on this one?|||SQL Server Management Studio does not support copy-only backups, as per BOL notes.

Can't Restore a DB backed up with COPY_ONLY in Mgmt Studio

If I create a backup using the following T-SQL, is there a specific reason that I cannot restore it through Mangement Studio.

BACKUP DATABASE MyDB

TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\MyDB_1.BAK'

WITH FORMAT, COPY_ONLY, NAME = 'Backup of MyDB'

I can still restore it using T-SQL but would like the conveinence of using Managment Studio. Any ideas? Is this a bug or is this by design? If by design, what would be the reason?

Any help is appreciated.

Are there any ideas on this one?|||SQL Server Management Studio does not support copy-only backups, as per BOL notes.

Can't restart mirroring. Error 1416 and 1443.

After stop mirroring, can't restart mirroring. Tried following two things, still can't restart mirroring.

1. Made a full DB backup and a log backup on principle, copied backup files to mirror and restored DB and log with NORECOVERY. Mirror DB is in "Restoring" status.

2. Delete DB on both principle and mirror, recreate DB on the principle, restore DB and log on the mirror with NORECOVERY. Mirror DB is in "Restoring" status.

In both cases, after clicked "Start Mirroring", got error 1416. In sql server log file, got error 1443 ("Database mirroring has been terminated..."). Please help.Never mind. Problem solved.|||How did you solve this - I get the same problem (using certificates for authorization of logins - Domain server not vaible in my situation)

Thanks

Can't receive messages on second server instance

Hi all!

Help, please!

I am trying to send messages between 2 different server instances. I am getting the following errors in Profiler:

"This message could not be delivered because the user with ID 0 in database ID 14 does not have permission to send to the service. Service name: 'TestService1'."

"The target service name could not be found. Ensure that the service name is specified correctly and/or the routing information has been supplied."

The scripts for object creation and messaging is following at the first server instance:

USE master
GO
CREATE ENDPOINT SBroker
STATE = STARTED
AS TCP ( LISTENER_PORT = 1212 )
FOR SERVICE_BROKER (
ENCRYPTION = DISABLED
);
GO

USE Test
GO
CREATE QUEUE TestQueue
WITH STATUS=ON

CREATE SERVICE TestService
AUTHORIZATION dbo
ON QUEUE TestQueue

CREATE ROUTE TestRoute
WITH
SERVICE_NAME = 'TestService1',
BROKER_INSTANCE ='2B7CE76A-9804-46F3-9AE8-0AE59313613A',
ADDRESS = 'TCP://10.17.11.17:4037' ;

// send message script:

DECLARE @.dh UNIQUEIDENTIFIER;

BEGIN DIALOG CONVERSATION @.dh
FROM SERVICE [TestService]
TO SERVICE 'TestService1','2B7CE76A-9804-46F3-9AE8-0AE59313613A'
ON CONTRACT [DEFAULT]
WITH ENCRYPTION = OFF;

SEND ON CONVERSATION @.dh MESSAGE TYPE [DEFAULT] ('this is message1');

DECLARE @.status nvarchar(1024);
SELECT status = GET_TRANSMISSION_STATUS(@.dh);

END CONVERSATION @.dh;

on second server instance:

use master
GO
CREATE ENDPOINT SBroker2
STATE = STARTED
AS TCP ( LISTENER_PORT = 1212 )
FOR SERVICE_BROKER (
ENCRYPTION = DISABLED
);
GO

in first server, in sys.transmission_queue transmission_status is empty

Both servers in the same domain, and databases on this server has the same owner.

on both servers, select @.@.version:
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Thanks a lot for help and explanation!

Sveta.

When you begin a dialog with encryption = off and there is no remote service binding for the target service in the initiator database, the inbound dialog at the target side will appear to be coming from user public (i.e. database principal 0). You will therefore need to grant send permission on the target service to user public. Of course, doing so means anyone can send messages to the target service.

If you want to authenticate the initiator, you will need to export the initiator service owner's certificate, create a user in the target database, import the certificate and make it owned by this user, and grant send permission for target service to this user. You could use Remus' Service Listings tool, which greatly simplied this process.

|||

Thank you for help,

after granting permission :

grant send on service::TestService1 to public

all messages received in second server.

Cant order by text values?

Hi,

I've got the following code that pulls out forum topics that have been added to on a particular day:

SELECT
forum_posts.post_date
, forum_threads.id
, forum_threads.subject
FROM forum_threads INNER JOIN forum_posts
ON forum_posts.thread_id = forum_threads.id
WHERE day(post_date)=day(getdate())
AND month(post_date)=month(getdate())
AND year(post_date)=year(getdate())
GROUP BY forum_threads.id
,forum_threads.subject
,forum_posts.post_date
ORDER BY forum_threads.id ASC, forum_posts.post_date ASC

I tried including the body of the post in this:

SELECT
forum_posts.post_date
, forum_posts.body
, forum_threads.id
, forum_threads.subject
FROM forum_threads INNER JOIN forum_posts
ON forum_posts.thread_id = forum_threads.id
WHERE day(post_date)=day(getdate())
AND month(post_date)=month(getdate())
AND year(post_date)=year(getdate())
GROUP BY forum_threads.id
,forum_threads.subject
,forum_posts.post_date
,forum_posts.body
ORDER BY forum_threads.id ASC, forum_posts.post_date ASC

But was told that "The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator."

Well, the body field is text datatype alright, but how do I therefore include it in the results?The GROUP BY is what it is complaining about. Why is that there?

Originally posted by Spudhead
Hi,

I've got the following code that pulls out forum topics that have been added to on a particular day:

SELECT
forum_posts.post_date
, forum_threads.id
, forum_threads.subject
FROM forum_threads INNER JOIN forum_posts
ON forum_posts.thread_id = forum_threads.id
WHERE day(post_date)=day(getdate())
AND month(post_date)=month(getdate())
AND year(post_date)=year(getdate())
GROUP BY forum_threads.id
,forum_threads.subject
,forum_posts.post_date
ORDER BY forum_threads.id ASC, forum_posts.post_date ASC

I tried including the body of the post in this:

SELECT
forum_posts.post_date
, forum_posts.body
, forum_threads.id
, forum_threads.subject
FROM forum_threads INNER JOIN forum_posts
ON forum_posts.thread_id = forum_threads.id
WHERE day(post_date)=day(getdate())
AND month(post_date)=month(getdate())
AND year(post_date)=year(getdate())
GROUP BY forum_threads.id
,forum_threads.subject
,forum_posts.post_date
,forum_posts.body
ORDER BY forum_threads.id ASC, forum_posts.post_date ASC

But was told that "The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator."

Well, the body field is text datatype alright, but how do I therefore include it in the results?|||Because I'm a muppet.

Thanks :)|||Make this...

SELECT
forum_threads.id
,forum_threads.subject
,forum_posts.post_date
FROM forum_threads INNER JOIN forum_posts
ON forum_posts.thread_id = forum_threads.id
GROUP BY forum_threads.id
,forum_threads.subject
,forum_posts.post_date
HAVING day(post_date)=day(getdate())
AND month(post_date)=month(getdate())
AND year(post_date)=year(getdate())
ORDER BY forum_threads.id, forum_posts.post_date

...the option ASC is default;
...use the command Having.

Can't login with remote servers

Able to connect just fine at the main server but when trying to get the other
servers to connect get the following error.
Using SQL Server 2005 Express Edition:
Connection Failed:
SQLState: '01000'
SQL Server Error: 11004
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
Connection Failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not
found.
Any ideas why I would be getting this error? All information is correct
according to where it is in the first server.
Dusitn D'Amour
Coyote Solutions Group
505.742.0066
www.coyotesolutions.com
Sure. See the archives of this list. We've discussed this any number of
times. Check back here if you don't find the answer(s).
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
Between now and Nov. 6th 2006 you can sign up for a substantial discount.
Look for the "Early Bird" discount checkbox on the registration form...
------
Microsoft MVP, Author, Mentor
Microsoft MVP
"Dustin D''Amour" <DustinDAmour@.discussions.microsoft.com> wrote in message
news:B13047CD-D41D-43A4-B80D-350B30B372AF@.microsoft.com...
> Able to connect just fine at the main server but when trying to get the
> other
> servers to connect get the following error.
> Using SQL Server 2005 Express Edition:
> Connection Failed:
> SQLState: '01000'
> SQL Server Error: 11004
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
> (Connect()).
> Connection Failed:
> SQLState: '08001'
> SQL Server Error: 6
> [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server
> not
> found.
>
> Any ideas why I would be getting this error? All information is correct
> according to where it is in the first server.
>
> --
> Dusitn D'Amour
> Coyote Solutions Group
> 505.742.0066
> www.coyotesolutions.com
|||Where is the archive located?
I should also mention that mixed authentication is selected and the remote
servers still can not connect.
Dusitn D'Amour
Coyote Solutions Group
505.742.0066
www.coyotesolutions.com
"William (Bill) Vaughn" wrote:

> Sure. See the archives of this list. We've discussed this any number of
> times. Check back here if you don't find the answer(s).
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> Between now and Nov. 6th 2006 you can sign up for a substantial discount.
> Look for the "Early Bird" discount checkbox on the registration form...
> ------
>
> Microsoft MVP, Author, Mentor
> Microsoft MVP
> "Dustin D''Amour" <DustinDAmour@.discussions.microsoft.com> wrote in message
> news:B13047CD-D41D-43A4-B80D-350B30B372AF@.microsoft.com...
>
>
|||I found http://support.microsoft.com/kb/306865 which show the same error I'm
having but when I go through the steps for the workaround it still doesn't
work.
Anyone else have any other ideas?
Dusitn D'Amour
Coyote Solutions Group
505.742.0066
www.coyotesolutions.com
"Dustin D''Amour" wrote:
[vbcol=seagreen]
> Where is the archive located?
> I should also mention that mixed authentication is selected and the remote
> servers still can not connect.
>
> --
> Dusitn D'Amour
> Coyote Solutions Group
> 505.742.0066
> www.coyotesolutions.com
>
> "William (Bill) Vaughn" wrote:
|||This thread had an answer that seems to work for now.
Dusitn D'Amour
Coyote Solutions Group
505.742.0066
www.coyotesolutions.com
"Dustin D''Amour" wrote:
[vbcol=seagreen]
> I found http://support.microsoft.com/kb/306865 which show the same error I'm
> having but when I go through the steps for the workaround it still doesn't
> work.
> Anyone else have any other ideas?
>
> --
> Dusitn D'Amour
> Coyote Solutions Group
> 505.742.0066
> www.coyotesolutions.com
>
> "Dustin D''Amour" wrote:
|||Forgot t put the link in.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=129105&SiteID=1
Dusitn D''Amour
Coyote Solutions Group
505.742.0066
www.coyotesolutions.com
"Dustin D''Amour" wrote:
[vbcol=seagreen]
> This thread had an answer that seems to work for now.
> --
> Dusitn D'Amour
> Coyote Solutions Group
> 505.742.0066
> www.coyotesolutions.com
>
> "Dustin D''Amour" wrote: