I can't connect to this new box via sql server 2000, every time I try to
register sql server to this new server, I get this message:" SQL Server does
not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
running on the new box when I connect via remote access to the box. How can
I connect? They also created a DNS, but still can't connect via sql server.
Thanks.
--
New SQL Server DBAWhat account or login are you using when you try to register sql? I'm
guessing you are trying to register the new SQL server to your Enterprise
Manager?
JD
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:910795E9-3EB7-4DD2-89D3-E2FBA95100E4@.microsoft.com...
>I can't connect to this new box via sql server 2000, every time I try to
> register sql server to this new server, I get this message:" SQL Server
> does
> not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
> running on the new box when I connect via remote access to the box. How
> can
> I connect? They also created a DNS, but still can't connect via sql
> server.
> Thanks.
> --
> New SQL Server DBA|||I am using the sa account. Yes i am using EM. Thanks.
--
New SQL Server DBA
"Joe D" wrote:
> What account or login are you using when you try to register sql? I'm
> guessing you are trying to register the new SQL server to your Enterprise
> Manager?
> JD
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:910795E9-3EB7-4DD2-89D3-E2FBA95100E4@.microsoft.com...
>
>
Showing posts with label message. Show all posts
Showing posts with label message. Show all posts
Thursday, March 29, 2012
Can't Connect
I can't connect to this new box via sql server 2000, every time I try to
register sql server to this new server, I get this message:" SQL Server does
not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
running on the new box when I connect via remote access to the box. How can
I connect? They also created a DNS, but still can't connect via sql server.
Thanks.
New SQL Server DBA
What account or login are you using when you try to register sql? I'm
guessing you are trying to register the new SQL server to your Enterprise
Manager?
JD
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:910795E9-3EB7-4DD2-89D3-E2FBA95100E4@.microsoft.com...
>I can't connect to this new box via sql server 2000, every time I try to
> register sql server to this new server, I get this message:" SQL Server
> does
> not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
> running on the new box when I connect via remote access to the box. How
> can
> I connect? They also created a DNS, but still can't connect via sql
> server.
> Thanks.
> --
> New SQL Server DBA
|||I am using the sa account. Yes i am using EM. Thanks.
New SQL Server DBA
"Joe D" wrote:
> What account or login are you using when you try to register sql? I'm
> guessing you are trying to register the new SQL server to your Enterprise
> Manager?
> JD
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:910795E9-3EB7-4DD2-89D3-E2FBA95100E4@.microsoft.com...
>
>
register sql server to this new server, I get this message:" SQL Server does
not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
running on the new box when I connect via remote access to the box. How can
I connect? They also created a DNS, but still can't connect via sql server.
Thanks.
New SQL Server DBA
What account or login are you using when you try to register sql? I'm
guessing you are trying to register the new SQL server to your Enterprise
Manager?
JD
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:910795E9-3EB7-4DD2-89D3-E2FBA95100E4@.microsoft.com...
>I can't connect to this new box via sql server 2000, every time I try to
> register sql server to this new server, I get this message:" SQL Server
> does
> not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
> running on the new box when I connect via remote access to the box. How
> can
> I connect? They also created a DNS, but still can't connect via sql
> server.
> Thanks.
> --
> New SQL Server DBA
|||I am using the sa account. Yes i am using EM. Thanks.
New SQL Server DBA
"Joe D" wrote:
> What account or login are you using when you try to register sql? I'm
> guessing you are trying to register the new SQL server to your Enterprise
> Manager?
> JD
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:910795E9-3EB7-4DD2-89D3-E2FBA95100E4@.microsoft.com...
>
>
Can't Connect
I can't connect to this new box via sql server 2000, every time I try to
register sql server to this new server, I get this message:" SQL Server does
not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
running on the new box when I connect via remote access to the box. How can
I connect? They also created a DNS, but still can't connect via sql server.
Thanks.
--
New SQL Server DBAWhat account or login are you using when you try to register sql? I'm
guessing you are trying to register the new SQL server to your Enterprise
Manager?
JD
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:910795E9-3EB7-4DD2-89D3-E2FBA95100E4@.microsoft.com...
>I can't connect to this new box via sql server 2000, every time I try to
> register sql server to this new server, I get this message:" SQL Server
> does
> not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
> running on the new box when I connect via remote access to the box. How
> can
> I connect? They also created a DNS, but still can't connect via sql
> server.
> Thanks.
> --
> New SQL Server DBA|||I am using the sa account. Yes i am using EM. Thanks.
--
New SQL Server DBA
"Joe D" wrote:
> What account or login are you using when you try to register sql? I'm
> guessing you are trying to register the new SQL server to your Enterprise
> Manager?
> JD
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:910795E9-3EB7-4DD2-89D3-E2FBA95100E4@.microsoft.com...
> >I can't connect to this new box via sql server 2000, every time I try to
> > register sql server to this new server, I get this message:" SQL Server
> > does
> > not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
> > running on the new box when I connect via remote access to the box. How
> > can
> > I connect? They also created a DNS, but still can't connect via sql
> > server.
> > Thanks.
> > --
> > New SQL Server DBA
>
>
register sql server to this new server, I get this message:" SQL Server does
not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
running on the new box when I connect via remote access to the box. How can
I connect? They also created a DNS, but still can't connect via sql server.
Thanks.
--
New SQL Server DBAWhat account or login are you using when you try to register sql? I'm
guessing you are trying to register the new SQL server to your Enterprise
Manager?
JD
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:910795E9-3EB7-4DD2-89D3-E2FBA95100E4@.microsoft.com...
>I can't connect to this new box via sql server 2000, every time I try to
> register sql server to this new server, I get this message:" SQL Server
> does
> not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
> running on the new box when I connect via remote access to the box. How
> can
> I connect? They also created a DNS, but still can't connect via sql
> server.
> Thanks.
> --
> New SQL Server DBA|||I am using the sa account. Yes i am using EM. Thanks.
--
New SQL Server DBA
"Joe D" wrote:
> What account or login are you using when you try to register sql? I'm
> guessing you are trying to register the new SQL server to your Enterprise
> Manager?
> JD
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:910795E9-3EB7-4DD2-89D3-E2FBA95100E4@.microsoft.com...
> >I can't connect to this new box via sql server 2000, every time I try to
> > register sql server to this new server, I get this message:" SQL Server
> > does
> > not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
> > running on the new box when I connect via remote access to the box. How
> > can
> > I connect? They also created a DNS, but still can't connect via sql
> > server.
> > Thanks.
> > --
> > New SQL Server DBA
>
>
Thursday, March 22, 2012
Can't achieve backups with SQL Server 7.00.1063 on Win2k
Good morning,
On a brand new powerful server, I've had this intermittent problem with
the following message for over a week, when I tried to make a manual or
scheduled backup. I get this message instantly when I start the backup as a
pop-up in Enterprise Manager and in the SQL Server logs.
BackupMedium::ReportIoError: write failure on backup device
'd:\MSSQL7\BACKUP\FmdtestPascal.BAK'. Operating system error
1453(Insufficient quota to complete the requested service.).
The backup to be made is on a small 1.5 gb database. On the array, there's
about 189 Gb of free space on the hard drive. It behaves like a hardware
problem
Hi
Check that disk quotas are not enabled for the destination drive at OS level.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Pascal" wrote:
> Good morning,
> On a brand new powerful server, I've had this intermittent problem with
> the following message for over a week, when I tried to make a manual or
> scheduled backup. I get this message instantly when I start the backup as a
> pop-up in Enterprise Manager and in the SQL Server logs.
> BackupMedium::ReportIoError: write failure on backup device
> 'd:\MSSQL7\BACKUP\FmdtestPascal.BAK'. Operating system error
> 1453(Insufficient quota to complete the requested service.).
> The backup to be made is on a small 1.5 gb database. On the array, there's
> about 189 Gb of free space on the hard drive. It behaves like a hardware
> problem
On a brand new powerful server, I've had this intermittent problem with
the following message for over a week, when I tried to make a manual or
scheduled backup. I get this message instantly when I start the backup as a
pop-up in Enterprise Manager and in the SQL Server logs.
BackupMedium::ReportIoError: write failure on backup device
'd:\MSSQL7\BACKUP\FmdtestPascal.BAK'. Operating system error
1453(Insufficient quota to complete the requested service.).
The backup to be made is on a small 1.5 gb database. On the array, there's
about 189 Gb of free space on the hard drive. It behaves like a hardware
problem
Hi
Check that disk quotas are not enabled for the destination drive at OS level.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Pascal" wrote:
> Good morning,
> On a brand new powerful server, I've had this intermittent problem with
> the following message for over a week, when I tried to make a manual or
> scheduled backup. I get this message instantly when I start the backup as a
> pop-up in Enterprise Manager and in the SQL Server logs.
> BackupMedium::ReportIoError: write failure on backup device
> 'd:\MSSQL7\BACKUP\FmdtestPascal.BAK'. Operating system error
> 1453(Insufficient quota to complete the requested service.).
> The backup to be made is on a small 1.5 gb database. On the array, there's
> about 189 Gb of free space on the hard drive. It behaves like a hardware
> problem
Can't achieve backups with SQL Server 7.00.1063 on Win2k
Good morning,
On a brand new powerful server, I've had this intermittent problem with
the following message for over a week, when I tried to make a manual or
scheduled backup. I get this message instantly when I start the backup as a
pop-up in Enterprise Manager and in the SQL Server logs.
BackupMedium::ReportIoError: write failure on backup device
'd:\MSSQL7\BACKUP\FmdtestPascal.BAK'. Operating system error
1453(Insufficient quota to complete the requested service.).
The backup to be made is on a small 1.5 gb database. On the array, there's
about 189 Gb of free space on the hard drive. It behaves like a hardware
problemHi
Check that disk quotas are not enabled for the destination drive at OS level.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Pascal" wrote:
> Good morning,
> On a brand new powerful server, I've had this intermittent problem with
> the following message for over a week, when I tried to make a manual or
> scheduled backup. I get this message instantly when I start the backup as a
> pop-up in Enterprise Manager and in the SQL Server logs.
> BackupMedium::ReportIoError: write failure on backup device
> 'd:\MSSQL7\BACKUP\FmdtestPascal.BAK'. Operating system error
> 1453(Insufficient quota to complete the requested service.).
> The backup to be made is on a small 1.5 gb database. On the array, there's
> about 189 Gb of free space on the hard drive. It behaves like a hardware
> problem
On a brand new powerful server, I've had this intermittent problem with
the following message for over a week, when I tried to make a manual or
scheduled backup. I get this message instantly when I start the backup as a
pop-up in Enterprise Manager and in the SQL Server logs.
BackupMedium::ReportIoError: write failure on backup device
'd:\MSSQL7\BACKUP\FmdtestPascal.BAK'. Operating system error
1453(Insufficient quota to complete the requested service.).
The backup to be made is on a small 1.5 gb database. On the array, there's
about 189 Gb of free space on the hard drive. It behaves like a hardware
problemHi
Check that disk quotas are not enabled for the destination drive at OS level.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Pascal" wrote:
> Good morning,
> On a brand new powerful server, I've had this intermittent problem with
> the following message for over a week, when I tried to make a manual or
> scheduled backup. I get this message instantly when I start the backup as a
> pop-up in Enterprise Manager and in the SQL Server logs.
> BackupMedium::ReportIoError: write failure on backup device
> 'd:\MSSQL7\BACKUP\FmdtestPascal.BAK'. Operating system error
> 1453(Insufficient quota to complete the requested service.).
> The backup to be made is on a small 1.5 gb database. On the array, there's
> about 189 Gb of free space on the hard drive. It behaves like a hardware
> problem
Can't achieve backups with SQL Server 7.00.1063 on Win2k
Good morning,
On a brand new powerful server, I've had this intermittent problem with
the following message for over a week, when I tried to make a manual or
scheduled backup. I get this message instantly when I start the backup as a
pop-up in Enterprise Manager and in the SQL Server logs.
BackupMedium::ReportIoError: write failure on backup device
'd:\MSSQL7\BACKUP\FmdtestPascal.BAK'. Operating system error
1453(Insufficient quota to complete the requested service.).
The backup to be made is on a small 1.5 gb database. On the array, there's
about 189 Gb of free space on the hard drive. It behaves like a hardware
problemHi
Check that disk quotas are not enabled for the destination drive at OS level
.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Pascal" wrote:
> Good morning,
> On a brand new powerful server, I've had this intermittent problem with
> the following message for over a week, when I tried to make a manual or
> scheduled backup. I get this message instantly when I start the backup as
a
> pop-up in Enterprise Manager and in the SQL Server logs.
> BackupMedium::ReportIoError: write failure on backup device
> 'd:\MSSQL7\BACKUP\FmdtestPascal.BAK'. Operating system error
> 1453(Insufficient quota to complete the requested service.).
> The backup to be made is on a small 1.5 gb database. On the array, there'
s
> about 189 Gb of free space on the hard drive. It behaves like a hardware
> problemsql
On a brand new powerful server, I've had this intermittent problem with
the following message for over a week, when I tried to make a manual or
scheduled backup. I get this message instantly when I start the backup as a
pop-up in Enterprise Manager and in the SQL Server logs.
BackupMedium::ReportIoError: write failure on backup device
'd:\MSSQL7\BACKUP\FmdtestPascal.BAK'. Operating system error
1453(Insufficient quota to complete the requested service.).
The backup to be made is on a small 1.5 gb database. On the array, there's
about 189 Gb of free space on the hard drive. It behaves like a hardware
problemHi
Check that disk quotas are not enabled for the destination drive at OS level
.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Pascal" wrote:
> Good morning,
> On a brand new powerful server, I've had this intermittent problem with
> the following message for over a week, when I tried to make a manual or
> scheduled backup. I get this message instantly when I start the backup as
a
> pop-up in Enterprise Manager and in the SQL Server logs.
> BackupMedium::ReportIoError: write failure on backup device
> 'd:\MSSQL7\BACKUP\FmdtestPascal.BAK'. Operating system error
> 1453(Insufficient quota to complete the requested service.).
> The backup to be made is on a small 1.5 gb database. On the array, there'
s
> about 189 Gb of free space on the hard drive. It behaves like a hardware
> problemsql
Monday, March 19, 2012
cann't send test mail
Hi,
I cann't send test mail with database mail, i get this Error:
Message
The mail could not be sent to the recipients because of the mail server
failure. (Sending Mail using Account 1 (2005-12-14T15:03:44). Exception
Message: Could not connect to mail server.
I did enable the database mail service and this service is started as well,
i am the member of sysadmin, and mssql service start under domain account and
not local system.
I did also enable mail profile for sql agent mail.
any idea what is wrong?
Thanks,
ShahinAre you confident your SMTP mail server is working? Are you using an
IP address or server name? If using a server name, is DNS functioning,
i.e., is it resolving to the IP of the SMTP server? You can check by
going to the console of the location of your SQL Server and ping
mail.whatever.com . See if your ping returns a reply.
Shahin wrote:
> Hi,
> I cann't send test mail with database mail, i get this Error:
> Message
> The mail could not be sent to the recipients because of the mail server
> failure. (Sending Mail using Account 1 (2005-12-14T15:03:44). Exception
> Message: Could not connect to mail server.
> I did enable the database mail service and this service is started as well,
> i am the member of sysadmin, and mssql service start under domain account and
> not local system.
> I did also enable mail profile for sql agent mail.
> any idea what is wrong?
> Thanks,
> Shahin|||Hi Corey,
Thanks for reply,
Yes iam sure that i can connect to mail server with no problem, coz i can
ping the server bouth with name and IP and with FQDN. but still no chance.
any idea?
"Corey Bunch" wrote:
> Are you confident your SMTP mail server is working? Are you using an
> IP address or server name? If using a server name, is DNS functioning,
> i.e., is it resolving to the IP of the SMTP server? You can check by
> going to the console of the location of your SQL Server and ping
> mail.whatever.com . See if your ping returns a reply.
>
> Shahin wrote:
> > Hi,
> >
> > I cann't send test mail with database mail, i get this Error:
> > Message
> > The mail could not be sent to the recipients because of the mail server
> > failure. (Sending Mail using Account 1 (2005-12-14T15:03:44). Exception
> > Message: Could not connect to mail server.
> >
> > I did enable the database mail service and this service is started as well,
> > i am the member of sysadmin, and mssql service start under domain account and
> > not local system.
> >
> > I did also enable mail profile for sql agent mail.
> > any idea what is wrong?
> >
> > Thanks,
> > Shahin
>|||Hmmmm...can you try another mail client, such as outlook, thunderbird,
eudora, netscape, etc.? Put in the same settings into your outgoing
SMTP area that you're using for DB Mail and try it out. Do you have
any internal firewall settings blocking port 25?|||I think this is really a smtp issuse coz if i telnet my server on port 25 i
can not connect to server, and it is very strong coz i did diable Firewall on
my server.
anyidea?
"Shahin" wrote:
> Hi Corey,
> Thanks for reply,
> Yes iam sure that i can connect to mail server with no problem, coz i can
> ping the server bouth with name and IP and with FQDN. but still no chance.
> any idea?
> "Corey Bunch" wrote:
> > Are you confident your SMTP mail server is working? Are you using an
> > IP address or server name? If using a server name, is DNS functioning,
> > i.e., is it resolving to the IP of the SMTP server? You can check by
> > going to the console of the location of your SQL Server and ping
> > mail.whatever.com . See if your ping returns a reply.
> >
> >
> > Shahin wrote:
> > > Hi,
> > >
> > > I cann't send test mail with database mail, i get this Error:
> > > Message
> > > The mail could not be sent to the recipients because of the mail server
> > > failure. (Sending Mail using Account 1 (2005-12-14T15:03:44). Exception
> > > Message: Could not connect to mail server.
> > >
> > > I did enable the database mail service and this service is started as well,
> > > i am the member of sysadmin, and mssql service start under domain account and
> > > not local system.
> > >
> > > I did also enable mail profile for sql agent mail.
> > > any idea what is wrong?
> > >
> > > Thanks,
> > > Shahin
> >
> >|||Doesn't telnet run on port 23? Did you try a basic email client?
Shahin wrote:
> I think this is really a smtp issuse coz if i telnet my server on port 25 i
> can not connect to server, and it is very strong coz i did diable Firewall on
> my server.
> anyidea?
> "Shahin" wrote:
> > Hi Corey,
> > Thanks for reply,
> > Yes iam sure that i can connect to mail server with no problem, coz i can
> > ping the server bouth with name and IP and with FQDN. but still no chance.
> >
> > any idea?
> >
> > "Corey Bunch" wrote:
> >
> > > Are you confident your SMTP mail server is working? Are you using an
> > > IP address or server name? If using a server name, is DNS functioning,
> > > i.e., is it resolving to the IP of the SMTP server? You can check by
> > > going to the console of the location of your SQL Server and ping
> > > mail.whatever.com . See if your ping returns a reply.
> > >
> > >
> > > Shahin wrote:
> > > > Hi,
> > > >
> > > > I cann't send test mail with database mail, i get this Error:
> > > > Message
> > > > The mail could not be sent to the recipients because of the mail server
> > > > failure. (Sending Mail using Account 1 (2005-12-14T15:03:44). Exception
> > > > Message: Could not connect to mail server.
> > > >
> > > > I did enable the database mail service and this service is started as well,
> > > > i am the member of sysadmin, and mssql service start under domain account and
> > > > not local system.
> > > >
> > > > I did also enable mail profile for sql agent mail.
> > > > any idea what is wrong?
> > > >
> > > > Thanks,
> > > > Shahin
> > >
> > >|||Hi corey,
To check if a port is open or not you can telnet that port,and yes i did try
outlook express, with the same result.
Shahin.
"Corey Bunch" wrote:
> Doesn't telnet run on port 23? Did you try a basic email client?
>
> Shahin wrote:
> > I think this is really a smtp issuse coz if i telnet my server on port 25 i
> > can not connect to server, and it is very strong coz i did diable Firewall on
> > my server.
> >
> > anyidea?
> >
> > "Shahin" wrote:
> >
> > > Hi Corey,
> > > Thanks for reply,
> > > Yes iam sure that i can connect to mail server with no problem, coz i can
> > > ping the server bouth with name and IP and with FQDN. but still no chance.
> > >
> > > any idea?
> > >
> > > "Corey Bunch" wrote:
> > >
> > > > Are you confident your SMTP mail server is working? Are you using an
> > > > IP address or server name? If using a server name, is DNS functioning,
> > > > i.e., is it resolving to the IP of the SMTP server? You can check by
> > > > going to the console of the location of your SQL Server and ping
> > > > mail.whatever.com . See if your ping returns a reply.
> > > >
> > > >
> > > > Shahin wrote:
> > > > > Hi,
> > > > >
> > > > > I cann't send test mail with database mail, i get this Error:
> > > > > Message
> > > > > The mail could not be sent to the recipients because of the mail server
> > > > > failure. (Sending Mail using Account 1 (2005-12-14T15:03:44). Exception
> > > > > Message: Could not connect to mail server.
> > > > >
> > > > > I did enable the database mail service and this service is started as well,
> > > > > i am the member of sysadmin, and mssql service start under domain account and
> > > > > not local system.
> > > > >
> > > > > I did also enable mail profile for sql agent mail.
> > > > > any idea what is wrong?
> > > > >
> > > > > Thanks,
> > > > > Shahin
> > > >
> > > >
>
I cann't send test mail with database mail, i get this Error:
Message
The mail could not be sent to the recipients because of the mail server
failure. (Sending Mail using Account 1 (2005-12-14T15:03:44). Exception
Message: Could not connect to mail server.
I did enable the database mail service and this service is started as well,
i am the member of sysadmin, and mssql service start under domain account and
not local system.
I did also enable mail profile for sql agent mail.
any idea what is wrong?
Thanks,
ShahinAre you confident your SMTP mail server is working? Are you using an
IP address or server name? If using a server name, is DNS functioning,
i.e., is it resolving to the IP of the SMTP server? You can check by
going to the console of the location of your SQL Server and ping
mail.whatever.com . See if your ping returns a reply.
Shahin wrote:
> Hi,
> I cann't send test mail with database mail, i get this Error:
> Message
> The mail could not be sent to the recipients because of the mail server
> failure. (Sending Mail using Account 1 (2005-12-14T15:03:44). Exception
> Message: Could not connect to mail server.
> I did enable the database mail service and this service is started as well,
> i am the member of sysadmin, and mssql service start under domain account and
> not local system.
> I did also enable mail profile for sql agent mail.
> any idea what is wrong?
> Thanks,
> Shahin|||Hi Corey,
Thanks for reply,
Yes iam sure that i can connect to mail server with no problem, coz i can
ping the server bouth with name and IP and with FQDN. but still no chance.
any idea?
"Corey Bunch" wrote:
> Are you confident your SMTP mail server is working? Are you using an
> IP address or server name? If using a server name, is DNS functioning,
> i.e., is it resolving to the IP of the SMTP server? You can check by
> going to the console of the location of your SQL Server and ping
> mail.whatever.com . See if your ping returns a reply.
>
> Shahin wrote:
> > Hi,
> >
> > I cann't send test mail with database mail, i get this Error:
> > Message
> > The mail could not be sent to the recipients because of the mail server
> > failure. (Sending Mail using Account 1 (2005-12-14T15:03:44). Exception
> > Message: Could not connect to mail server.
> >
> > I did enable the database mail service and this service is started as well,
> > i am the member of sysadmin, and mssql service start under domain account and
> > not local system.
> >
> > I did also enable mail profile for sql agent mail.
> > any idea what is wrong?
> >
> > Thanks,
> > Shahin
>|||Hmmmm...can you try another mail client, such as outlook, thunderbird,
eudora, netscape, etc.? Put in the same settings into your outgoing
SMTP area that you're using for DB Mail and try it out. Do you have
any internal firewall settings blocking port 25?|||I think this is really a smtp issuse coz if i telnet my server on port 25 i
can not connect to server, and it is very strong coz i did diable Firewall on
my server.
anyidea?
"Shahin" wrote:
> Hi Corey,
> Thanks for reply,
> Yes iam sure that i can connect to mail server with no problem, coz i can
> ping the server bouth with name and IP and with FQDN. but still no chance.
> any idea?
> "Corey Bunch" wrote:
> > Are you confident your SMTP mail server is working? Are you using an
> > IP address or server name? If using a server name, is DNS functioning,
> > i.e., is it resolving to the IP of the SMTP server? You can check by
> > going to the console of the location of your SQL Server and ping
> > mail.whatever.com . See if your ping returns a reply.
> >
> >
> > Shahin wrote:
> > > Hi,
> > >
> > > I cann't send test mail with database mail, i get this Error:
> > > Message
> > > The mail could not be sent to the recipients because of the mail server
> > > failure. (Sending Mail using Account 1 (2005-12-14T15:03:44). Exception
> > > Message: Could not connect to mail server.
> > >
> > > I did enable the database mail service and this service is started as well,
> > > i am the member of sysadmin, and mssql service start under domain account and
> > > not local system.
> > >
> > > I did also enable mail profile for sql agent mail.
> > > any idea what is wrong?
> > >
> > > Thanks,
> > > Shahin
> >
> >|||Doesn't telnet run on port 23? Did you try a basic email client?
Shahin wrote:
> I think this is really a smtp issuse coz if i telnet my server on port 25 i
> can not connect to server, and it is very strong coz i did diable Firewall on
> my server.
> anyidea?
> "Shahin" wrote:
> > Hi Corey,
> > Thanks for reply,
> > Yes iam sure that i can connect to mail server with no problem, coz i can
> > ping the server bouth with name and IP and with FQDN. but still no chance.
> >
> > any idea?
> >
> > "Corey Bunch" wrote:
> >
> > > Are you confident your SMTP mail server is working? Are you using an
> > > IP address or server name? If using a server name, is DNS functioning,
> > > i.e., is it resolving to the IP of the SMTP server? You can check by
> > > going to the console of the location of your SQL Server and ping
> > > mail.whatever.com . See if your ping returns a reply.
> > >
> > >
> > > Shahin wrote:
> > > > Hi,
> > > >
> > > > I cann't send test mail with database mail, i get this Error:
> > > > Message
> > > > The mail could not be sent to the recipients because of the mail server
> > > > failure. (Sending Mail using Account 1 (2005-12-14T15:03:44). Exception
> > > > Message: Could not connect to mail server.
> > > >
> > > > I did enable the database mail service and this service is started as well,
> > > > i am the member of sysadmin, and mssql service start under domain account and
> > > > not local system.
> > > >
> > > > I did also enable mail profile for sql agent mail.
> > > > any idea what is wrong?
> > > >
> > > > Thanks,
> > > > Shahin
> > >
> > >|||Hi corey,
To check if a port is open or not you can telnet that port,and yes i did try
outlook express, with the same result.
Shahin.
"Corey Bunch" wrote:
> Doesn't telnet run on port 23? Did you try a basic email client?
>
> Shahin wrote:
> > I think this is really a smtp issuse coz if i telnet my server on port 25 i
> > can not connect to server, and it is very strong coz i did diable Firewall on
> > my server.
> >
> > anyidea?
> >
> > "Shahin" wrote:
> >
> > > Hi Corey,
> > > Thanks for reply,
> > > Yes iam sure that i can connect to mail server with no problem, coz i can
> > > ping the server bouth with name and IP and with FQDN. but still no chance.
> > >
> > > any idea?
> > >
> > > "Corey Bunch" wrote:
> > >
> > > > Are you confident your SMTP mail server is working? Are you using an
> > > > IP address or server name? If using a server name, is DNS functioning,
> > > > i.e., is it resolving to the IP of the SMTP server? You can check by
> > > > going to the console of the location of your SQL Server and ping
> > > > mail.whatever.com . See if your ping returns a reply.
> > > >
> > > >
> > > > Shahin wrote:
> > > > > Hi,
> > > > >
> > > > > I cann't send test mail with database mail, i get this Error:
> > > > > Message
> > > > > The mail could not be sent to the recipients because of the mail server
> > > > > failure. (Sending Mail using Account 1 (2005-12-14T15:03:44). Exception
> > > > > Message: Could not connect to mail server.
> > > > >
> > > > > I did enable the database mail service and this service is started as well,
> > > > > i am the member of sysadmin, and mssql service start under domain account and
> > > > > not local system.
> > > > >
> > > > > I did also enable mail profile for sql agent mail.
> > > > > any idea what is wrong?
> > > > >
> > > > > Thanks,
> > > > > Shahin
> > > >
> > > >
>
Sunday, March 11, 2012
Cannot use the OUTPUT option when passing a constant to a stored p
Hi,
I'm trying to export a text column into a text file using the bcp command
but I keep getting the error message in the subject line. So I checked the
database properties and didn't find anything.
My Code:
bcp "Select Replace(Str(UNITNUM, 12, 0), ' ', '0') FROM PICUadmissions
WHERE Admit_Date>'2005-06-01' and Admit_Date<'2005-07-01'" out
"I:\sttr\STTRLabsIn.txt" -c -T
go
Does anyone know why I am getting this message?
Much Appreciated,
ChiekoError message? Wish I could see it.
ML|||Since your BCP source is a query rather than a table/view, you need to
specify 'queryout' instead of 'out'.
Hope this helps.
Dan Guzman
SQL Server MVP
"chieko" <chieko@.discussions.microsoft.com> wrote in message
news:A82B768C-9367-447E-81DE-8EBFFAFBD62C@.microsoft.com...
> Hi,
> I'm trying to export a text column into a text file using the bcp command
> but I keep getting the error message in the subject line. So I checked the
> database properties and didn't find anything.
> My Code:
> bcp "Select Replace(Str(UNITNUM, 12, 0), ' ', '0') FROM PICUadmissions
> WHERE Admit_Date>'2005-06-01' and Admit_Date<'2005-07-01'" out
> "I:\sttr\STTRLabsIn.txt" -c -T
> go
> Does anyone know why I am getting this message?
> Much Appreciated,
> Chieko
>
I'm trying to export a text column into a text file using the bcp command
but I keep getting the error message in the subject line. So I checked the
database properties and didn't find anything.
My Code:
bcp "Select Replace(Str(UNITNUM, 12, 0), ' ', '0') FROM PICUadmissions
WHERE Admit_Date>'2005-06-01' and Admit_Date<'2005-07-01'" out
"I:\sttr\STTRLabsIn.txt" -c -T
go
Does anyone know why I am getting this message?
Much Appreciated,
ChiekoError message? Wish I could see it.
ML|||Since your BCP source is a query rather than a table/view, you need to
specify 'queryout' instead of 'out'.
Hope this helps.
Dan Guzman
SQL Server MVP
"chieko" <chieko@.discussions.microsoft.com> wrote in message
news:A82B768C-9367-447E-81DE-8EBFFAFBD62C@.microsoft.com...
> Hi,
> I'm trying to export a text column into a text file using the bcp command
> but I keep getting the error message in the subject line. So I checked the
> database properties and didn't find anything.
> My Code:
> bcp "Select Replace(Str(UNITNUM, 12, 0), ' ', '0') FROM PICUadmissions
> WHERE Admit_Date>'2005-06-01' and Admit_Date<'2005-07-01'" out
> "I:\sttr\STTRLabsIn.txt" -c -T
> go
> Does anyone know why I am getting this message?
> Much Appreciated,
> Chieko
>
Cannot use the OUTPUT option when passing a constant to a stor
I just checked the message today. I have tried the queryout method but
without any success because I keep getting a syntax error.
My Code:
bcp "Select Replace(Str(UNITNUM, 12, 0), ' ', '0') FROM PICUadmissions
WHERE Admit_Date>'2005-06-01' and Admit_Date<'2005-07-01'" queryout
"I:\sttr\STTRLabsIn.txt" -c -T
go
The Error: "incorrect syntax near queryout"
Thanks reading my message.
Chieko
"Dan Guzman" wrote:
> Since your BCP source is a query rather than a table/view, you need to
> specify 'queryout' instead of 'out'.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "chieko" <chieko@.discussions.microsoft.com> wrote in message
> news:A82B768C-9367-447E-81DE-8EBFFAFBD62C@.microsoft.com...
>
>BCP is a command-prompt utility, not a Transact-SQL statement. You need to
run the command from a Windows command line rather than Query Analyzer.
Hope this helps.
Dan Guzman
SQL Server MVP
"chieko" <chieko@.discussions.microsoft.com> wrote in message
news:1CADD6C5-9A7A-4CD7-BFC4-6FC2366756F9@.microsoft.com...
>I just checked the message today. I have tried the queryout method but
> without any success because I keep getting a syntax error.
>
> My Code:
> bcp "Select Replace(Str(UNITNUM, 12, 0), ' ', '0') FROM PICUadmissions
> WHERE Admit_Date>'2005-06-01' and Admit_Date<'2005-07-01'" queryout
> "I:\sttr\STTRLabsIn.txt" -c -T
> go
> The Error: "incorrect syntax near queryout"
> Thanks reading my message.
> Chieko
> "Dan Guzman" wrote:
>|||Thanks,
"Dan Guzman" wrote:
> BCP is a command-prompt utility, not a Transact-SQL statement. You need t
o
> run the command from a Windows command line rather than Query Analyzer.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "chieko" <chieko@.discussions.microsoft.com> wrote in message
> news:1CADD6C5-9A7A-4CD7-BFC4-6FC2366756F9@.microsoft.com...
>
>
without any success because I keep getting a syntax error.
My Code:
bcp "Select Replace(Str(UNITNUM, 12, 0), ' ', '0') FROM PICUadmissions
WHERE Admit_Date>'2005-06-01' and Admit_Date<'2005-07-01'" queryout
"I:\sttr\STTRLabsIn.txt" -c -T
go
The Error: "incorrect syntax near queryout"
Thanks reading my message.
Chieko
"Dan Guzman" wrote:
> Since your BCP source is a query rather than a table/view, you need to
> specify 'queryout' instead of 'out'.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "chieko" <chieko@.discussions.microsoft.com> wrote in message
> news:A82B768C-9367-447E-81DE-8EBFFAFBD62C@.microsoft.com...
>
>BCP is a command-prompt utility, not a Transact-SQL statement. You need to
run the command from a Windows command line rather than Query Analyzer.
Hope this helps.
Dan Guzman
SQL Server MVP
"chieko" <chieko@.discussions.microsoft.com> wrote in message
news:1CADD6C5-9A7A-4CD7-BFC4-6FC2366756F9@.microsoft.com...
>I just checked the message today. I have tried the queryout method but
> without any success because I keep getting a syntax error.
>
> My Code:
> bcp "Select Replace(Str(UNITNUM, 12, 0), ' ', '0') FROM PICUadmissions
> WHERE Admit_Date>'2005-06-01' and Admit_Date<'2005-07-01'" queryout
> "I:\sttr\STTRLabsIn.txt" -c -T
> go
> The Error: "incorrect syntax near queryout"
> Thanks reading my message.
> Chieko
> "Dan Guzman" wrote:
>|||Thanks,
"Dan Guzman" wrote:
> BCP is a command-prompt utility, not a Transact-SQL statement. You need t
o
> run the command from a Windows command line rather than Query Analyzer.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "chieko" <chieko@.discussions.microsoft.com> wrote in message
> news:1CADD6C5-9A7A-4CD7-BFC4-6FC2366756F9@.microsoft.com...
>
>
Wednesday, March 7, 2012
Cannot start up local server
Recently I cannot start up my local SQL 2000.
I goto services panel, select MSSQLSEREVR, right click select 'Start', got
a message box:
"The MSSQKSERVER service on Local Computer started and then stopped. Some
services stop automatically if they have no work to do, for example, the
Performance Logs and Alerts server"
I tried to start 'Performance Logs and Alerts server' and still get the same
message box.Alan
Any errors in Event Viewer
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> Recently I cannot start up my local SQL 2000.
> I goto services panel, select MSSQLSEREVR, right click select 'Start',
> got a message box:
> "The MSSQKSERVER service on Local Computer started and then stopped. Some
> services stop automatically if they have no work to do, for example, the
> Performance Logs and Alerts server"
> I tried to start 'Performance Logs and Alerts server' and still get the
> same message box.
>|||Uri Dimant wrote:
> Alan
> Any errors in Event Viewer
>
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> > Recently I cannot start up my local SQL 2000.
> > I goto services panel, select MSSQLSEREVR, right click select 'Start',
> > got a message box:
> > "The MSSQKSERVER service on Local Computer started and then stopped. Some
> > services stop automatically if they have no work to do, for example, the
> > Performance Logs and Alerts server"
> >
> > I tried to start 'Performance Logs and Alerts server' and still get the
> > same message box.
> >
Try to find out errors in Event Viewer or SQL Server Errorlog.
Regards
Amish Shah
http://shahamishm.tripod.com|||Sorry, how do I open the EventViewer ?
"amish" <shahamishm@.gmail.com> wrote in message
news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
> Uri Dimant wrote:
>> Alan
>> Any errors in Event Viewer
>>
>>
>> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
>> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
>> > Recently I cannot start up my local SQL 2000.
>> > I goto services panel, select MSSQLSEREVR, right click select 'Start',
>> > got a message box:
>> > "The MSSQKSERVER service on Local Computer started and then stopped.
>> > Some
>> > services stop automatically if they have no work to do, for example,
>> > the
>> > Performance Logs and Alerts server"
>> >
>> > I tried to start 'Performance Logs and Alerts server' and still get the
>> > same message box.
>> >
> Try to find out errors in Event Viewer or SQL Server Errorlog.
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>|||Alan T wrote:
> Sorry, how do I open the EventViewer ?
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
> >
> > Uri Dimant wrote:
> >
> >> Alan
> >>
> >> Any errors in Event Viewer
> >>
> >>
> >>
> >>
> >> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> >> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> >> > Recently I cannot start up my local SQL 2000.
> >> > I goto services panel, select MSSQLSEREVR, right click select 'Start',
> >> > got a message box:
> >> > "The MSSQKSERVER service on Local Computer started and then stopped.
> >> > Some
> >> > services stop automatically if they have no work to do, for example,
> >> > the
> >> > Performance Logs and Alerts server"
> >> >
> >> > I tried to start 'Performance Logs and Alerts server' and still get the
> >> > same message box.
> >> >
> >
> > Try to find out errors in Event Viewer or SQL Server Errorlog.
> >
> > Regards
> > Amish Shah
> > http://shahamishm.tripod.com
> >
go to start--> run
type eventvwr
Regards
Amish Shah
http://shahamishm.tripod.com|||Hi,
Yes I opened the eventviewer and knowing my evaluation copy of SQL 2000
Enterprise has expired.
Can I install the SQL 2000 Developer Edition on the top of it?
"amish" <shahamishm@.gmail.com> wrote in message
news:1161240339.590000.279530@.m7g2000cwm.googlegroups.com...
> Alan T wrote:
>> Sorry, how do I open the EventViewer ?
>> "amish" <shahamishm@.gmail.com> wrote in message
>> news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
>> >
>> > Uri Dimant wrote:
>> >
>> >> Alan
>> >>
>> >> Any errors in Event Viewer
>> >>
>> >>
>> >>
>> >>
>> >> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
>> >> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
>> >> > Recently I cannot start up my local SQL 2000.
>> >> > I goto services panel, select MSSQLSEREVR, right click select
>> >> > 'Start',
>> >> > got a message box:
>> >> > "The MSSQKSERVER service on Local Computer started and then stopped.
>> >> > Some
>> >> > services stop automatically if they have no work to do, for example,
>> >> > the
>> >> > Performance Logs and Alerts server"
>> >> >
>> >> > I tried to start 'Performance Logs and Alerts server' and still get
>> >> > the
>> >> > same message box.
>> >> >
>> >
>> > Try to find out errors in Event Viewer or SQL Server Errorlog.
>> >
>> > Regards
>> > Amish Shah
>> > http://shahamishm.tripod.com
>> >
> go to start--> run
> type eventvwr
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>
I goto services panel, select MSSQLSEREVR, right click select 'Start', got
a message box:
"The MSSQKSERVER service on Local Computer started and then stopped. Some
services stop automatically if they have no work to do, for example, the
Performance Logs and Alerts server"
I tried to start 'Performance Logs and Alerts server' and still get the same
message box.Alan
Any errors in Event Viewer
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> Recently I cannot start up my local SQL 2000.
> I goto services panel, select MSSQLSEREVR, right click select 'Start',
> got a message box:
> "The MSSQKSERVER service on Local Computer started and then stopped. Some
> services stop automatically if they have no work to do, for example, the
> Performance Logs and Alerts server"
> I tried to start 'Performance Logs and Alerts server' and still get the
> same message box.
>|||Uri Dimant wrote:
> Alan
> Any errors in Event Viewer
>
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> > Recently I cannot start up my local SQL 2000.
> > I goto services panel, select MSSQLSEREVR, right click select 'Start',
> > got a message box:
> > "The MSSQKSERVER service on Local Computer started and then stopped. Some
> > services stop automatically if they have no work to do, for example, the
> > Performance Logs and Alerts server"
> >
> > I tried to start 'Performance Logs and Alerts server' and still get the
> > same message box.
> >
Try to find out errors in Event Viewer or SQL Server Errorlog.
Regards
Amish Shah
http://shahamishm.tripod.com|||Sorry, how do I open the EventViewer ?
"amish" <shahamishm@.gmail.com> wrote in message
news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
> Uri Dimant wrote:
>> Alan
>> Any errors in Event Viewer
>>
>>
>> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
>> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
>> > Recently I cannot start up my local SQL 2000.
>> > I goto services panel, select MSSQLSEREVR, right click select 'Start',
>> > got a message box:
>> > "The MSSQKSERVER service on Local Computer started and then stopped.
>> > Some
>> > services stop automatically if they have no work to do, for example,
>> > the
>> > Performance Logs and Alerts server"
>> >
>> > I tried to start 'Performance Logs and Alerts server' and still get the
>> > same message box.
>> >
> Try to find out errors in Event Viewer or SQL Server Errorlog.
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>|||Alan T wrote:
> Sorry, how do I open the EventViewer ?
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
> >
> > Uri Dimant wrote:
> >
> >> Alan
> >>
> >> Any errors in Event Viewer
> >>
> >>
> >>
> >>
> >> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> >> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> >> > Recently I cannot start up my local SQL 2000.
> >> > I goto services panel, select MSSQLSEREVR, right click select 'Start',
> >> > got a message box:
> >> > "The MSSQKSERVER service on Local Computer started and then stopped.
> >> > Some
> >> > services stop automatically if they have no work to do, for example,
> >> > the
> >> > Performance Logs and Alerts server"
> >> >
> >> > I tried to start 'Performance Logs and Alerts server' and still get the
> >> > same message box.
> >> >
> >
> > Try to find out errors in Event Viewer or SQL Server Errorlog.
> >
> > Regards
> > Amish Shah
> > http://shahamishm.tripod.com
> >
go to start--> run
type eventvwr
Regards
Amish Shah
http://shahamishm.tripod.com|||Hi,
Yes I opened the eventviewer and knowing my evaluation copy of SQL 2000
Enterprise has expired.
Can I install the SQL 2000 Developer Edition on the top of it?
"amish" <shahamishm@.gmail.com> wrote in message
news:1161240339.590000.279530@.m7g2000cwm.googlegroups.com...
> Alan T wrote:
>> Sorry, how do I open the EventViewer ?
>> "amish" <shahamishm@.gmail.com> wrote in message
>> news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
>> >
>> > Uri Dimant wrote:
>> >
>> >> Alan
>> >>
>> >> Any errors in Event Viewer
>> >>
>> >>
>> >>
>> >>
>> >> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
>> >> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
>> >> > Recently I cannot start up my local SQL 2000.
>> >> > I goto services panel, select MSSQLSEREVR, right click select
>> >> > 'Start',
>> >> > got a message box:
>> >> > "The MSSQKSERVER service on Local Computer started and then stopped.
>> >> > Some
>> >> > services stop automatically if they have no work to do, for example,
>> >> > the
>> >> > Performance Logs and Alerts server"
>> >> >
>> >> > I tried to start 'Performance Logs and Alerts server' and still get
>> >> > the
>> >> > same message box.
>> >> >
>> >
>> > Try to find out errors in Event Viewer or SQL Server Errorlog.
>> >
>> > Regards
>> > Amish Shah
>> > http://shahamishm.tripod.com
>> >
> go to start--> run
> type eventvwr
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>
Cannot start up local server
Recently I cannot start up my local SQL 2000.
I goto services panel, select MSSQLSEREVR, right click select 'Start', got
a message box:
"The MSSQKSERVER service on Local Computer started and then stopped. Some
services stop automatically if they have no work to do, for example, the
Performance Logs and Alerts server"
I tried to start 'Performance Logs and Alerts server' and still get the same
message box.
Alan
Any errors in Event Viewer
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> Recently I cannot start up my local SQL 2000.
> I goto services panel, select MSSQLSEREVR, right click select 'Start',
> got a message box:
> "The MSSQKSERVER service on Local Computer started and then stopped. Some
> services stop automatically if they have no work to do, for example, the
> Performance Logs and Alerts server"
> I tried to start 'Performance Logs and Alerts server' and still get the
> same message box.
>
|||Uri Dimant wrote:
[vbcol=seagreen]
> Alan
> Any errors in Event Viewer
>
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
Try to find out errors in Event Viewer or SQL Server Errorlog.
Regards
Amish Shah
http://shahamishm.tripod.com
|||Sorry, how do I open the EventViewer ?
"amish" <shahamishm@.gmail.com> wrote in message
news:1161168035.474752.181820@.e3g2000cwe.googlegro ups.com...
> Uri Dimant wrote:
>
> Try to find out errors in Event Viewer or SQL Server Errorlog.
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>
|||Alan T wrote:
[vbcol=seagreen]
> Sorry, how do I open the EventViewer ?
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1161168035.474752.181820@.e3g2000cwe.googlegro ups.com...
go to start--> run
type eventvwr
Regards
Amish Shah
http://shahamishm.tripod.com
I goto services panel, select MSSQLSEREVR, right click select 'Start', got
a message box:
"The MSSQKSERVER service on Local Computer started and then stopped. Some
services stop automatically if they have no work to do, for example, the
Performance Logs and Alerts server"
I tried to start 'Performance Logs and Alerts server' and still get the same
message box.
Alan
Any errors in Event Viewer
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> Recently I cannot start up my local SQL 2000.
> I goto services panel, select MSSQLSEREVR, right click select 'Start',
> got a message box:
> "The MSSQKSERVER service on Local Computer started and then stopped. Some
> services stop automatically if they have no work to do, for example, the
> Performance Logs and Alerts server"
> I tried to start 'Performance Logs and Alerts server' and still get the
> same message box.
>
|||Uri Dimant wrote:
[vbcol=seagreen]
> Alan
> Any errors in Event Viewer
>
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
Try to find out errors in Event Viewer or SQL Server Errorlog.
Regards
Amish Shah
http://shahamishm.tripod.com
|||Sorry, how do I open the EventViewer ?
"amish" <shahamishm@.gmail.com> wrote in message
news:1161168035.474752.181820@.e3g2000cwe.googlegro ups.com...
> Uri Dimant wrote:
>
> Try to find out errors in Event Viewer or SQL Server Errorlog.
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>
|||Alan T wrote:
[vbcol=seagreen]
> Sorry, how do I open the EventViewer ?
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1161168035.474752.181820@.e3g2000cwe.googlegro ups.com...
go to start--> run
type eventvwr
Regards
Amish Shah
http://shahamishm.tripod.com
Cannot start up local server
Recently I cannot start up my local SQL 2000.
I goto services panel, select MSSQLSEREVR, right click select 'Start', got
a message box:
"The MSSQKSERVER service on Local Computer started and then stopped. Some
services stop automatically if they have no work to do, for example, the
Performance Logs and Alerts server"
I tried to start 'Performance Logs and Alerts server' and still get the same
message box.Alan
Any errors in Event Viewer
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> Recently I cannot start up my local SQL 2000.
> I goto services panel, select MSSQLSEREVR, right click select 'Start',
> got a message box:
> "The MSSQKSERVER service on Local Computer started and then stopped. Some
> services stop automatically if they have no work to do, for example, the
> Performance Logs and Alerts server"
> I tried to start 'Performance Logs and Alerts server' and still get the
> same message box.
>|||Uri Dimant wrote:
[vbcol=seagreen]
> Alan
> Any errors in Event Viewer
>
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
Try to find out errors in Event Viewer or SQL Server Errorlog.
Regards
Amish Shah
http://shahamishm.tripod.com|||Sorry, how do I open the EventViewer ?
"amish" <shahamishm@.gmail.com> wrote in message
news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
> Uri Dimant wrote:
>
> Try to find out errors in Event Viewer or SQL Server Errorlog.
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>|||Alan T wrote:
[vbcol=seagreen]
> Sorry, how do I open the EventViewer ?
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
go to start--> run
type eventvwr
Regards
Amish Shah
http://shahamishm.tripod.com|||Hi,
Yes I opened the eventviewer and knowing my evaluation copy of SQL 2000
Enterprise has expired.
Can I install the SQL 2000 Developer Edition on the top of it?
"amish" <shahamishm@.gmail.com> wrote in message
news:1161240339.590000.279530@.m7g2000cwm.googlegroups.com...
> Alan T wrote:
>
> go to start--> run
> type eventvwr
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>
I goto services panel, select MSSQLSEREVR, right click select 'Start', got
a message box:
"The MSSQKSERVER service on Local Computer started and then stopped. Some
services stop automatically if they have no work to do, for example, the
Performance Logs and Alerts server"
I tried to start 'Performance Logs and Alerts server' and still get the same
message box.Alan
Any errors in Event Viewer
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> Recently I cannot start up my local SQL 2000.
> I goto services panel, select MSSQLSEREVR, right click select 'Start',
> got a message box:
> "The MSSQKSERVER service on Local Computer started and then stopped. Some
> services stop automatically if they have no work to do, for example, the
> Performance Logs and Alerts server"
> I tried to start 'Performance Logs and Alerts server' and still get the
> same message box.
>|||Uri Dimant wrote:
[vbcol=seagreen]
> Alan
> Any errors in Event Viewer
>
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
Try to find out errors in Event Viewer or SQL Server Errorlog.
Regards
Amish Shah
http://shahamishm.tripod.com|||Sorry, how do I open the EventViewer ?
"amish" <shahamishm@.gmail.com> wrote in message
news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
> Uri Dimant wrote:
>
> Try to find out errors in Event Viewer or SQL Server Errorlog.
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>|||Alan T wrote:
[vbcol=seagreen]
> Sorry, how do I open the EventViewer ?
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
go to start--> run
type eventvwr
Regards
Amish Shah
http://shahamishm.tripod.com|||Hi,
Yes I opened the eventviewer and knowing my evaluation copy of SQL 2000
Enterprise has expired.
Can I install the SQL 2000 Developer Edition on the top of it?
"amish" <shahamishm@.gmail.com> wrote in message
news:1161240339.590000.279530@.m7g2000cwm.googlegroups.com...
> Alan T wrote:
>
> go to start--> run
> type eventvwr
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>
'Cannot start transaction while in firehose mode'
I'm getting this error message in one of my procedures... Has anyone ever
seen this, I've searched the group's most messages I found mention a firehos
e
cursor which I know I'm not using... Here's the procedure thats generating
the error, this is the first time I've seen this error the application has
been working fine in production for months. I think this may have to do with
the fact that I'm using a linked server and I get an implied transaction whe
n
I use it, can I turn this off...?
Here's was the whole error message.
OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: Cannot start transaction while in
firehose mode]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x80004005: ].
CREATE PROCEDURE [dbo].[esp_csla_SalesPerson_Create]
@.SalesPersonID int = NULL OUTPUT,
@.VendorCode CHAR(10),
@.VendorGroup CHAR(10)
AS
BEGIN
DECLARE @.SSN AS CHAR(11),
@.Name AS CHAR(50),
@.FirstName AS VARCHAR(50),
@.LastName AS VARCHAR(50),
@.Index AS INT
SELECT
@.SSN = ven_tax_id,
@.Name = ven_name
FROM
LinkedServer.database.dbo.databasetable
WHERE
ven_cd = @.VendorCode AND
ven_grp_cd = @.VendorGroup
INSERT INTO SalesPersons (VendorCode,VendorGroup,SSN,FirstName,La
stName)
VALUES (@.VendorCode,@.VendorGroup,@.SSN, @.FirstName,@.LastName)
SET @.SalesPersonID = @.@.IDENTITY
END
GOAlien2_51 wrote:
> I'm getting this error message in one of my procedures... Has anyone
> ever seen this, I've searched the group's most messages I found
> mention a firehose cursor which I know I'm not using... Here's the
> procedure thats generating the error, this is the first time I've
> seen this error the application has been working fine in production
> for months. I think this may have to do with the fact that I'm using
> a linked server and I get an implied transaction when I use it, can I
> turn this off...?
> Here's was the whole error message.
> OLE DB provider 'SQLOLEDB' reported an error.
> [OLE/DB provider returned message: Cannot start transaction while in
> firehose mode]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
> ITransactionJoin::JoinTransaction returned 0x80004005: ].
>
> CREATE PROCEDURE [dbo].[esp_csla_SalesPerson_Create]
> @.SalesPersonID int = NULL OUTPUT,
> @.VendorCode CHAR(10),
> @.VendorGroup CHAR(10)
> AS
> BEGIN
> DECLARE @.SSN AS CHAR(11),
> @.Name AS CHAR(50),
> @.FirstName AS VARCHAR(50),
> @.LastName AS VARCHAR(50),
> @.Index AS INT
> SELECT
> @.SSN = ven_tax_id,
> @.Name = ven_name
> FROM
> LinkedServer.database.dbo.databasetable
> WHERE
> ven_cd = @.VendorCode AND
> ven_grp_cd = @.VendorGroup
> INSERT INTO SalesPersons
> (VendorCode,VendorGroup,SSN,FirstName,La
stName) VALUES
> (@.VendorCode,@.VendorGroup,@.SSN, @.FirstName,@.LastName)
> SET @.SalesPersonID = @.@.IDENTITY
> END
> GO
What type of cursor are you using if not a firehose (Server / read-only
/ forward-only)?
Maybe you could try wrapping the linked server call in a transaction? Is
that the whole procedure? Where are the @.SSN, @.FirstName,@.LastName being
set?
David Gugick
Imceda Software
www.imceda.com|||Not using a cursor, anywhere... The @.Name and @.SSN are being read from the
linked server, the first and last name are parsed from @.Name but that code
was irrelevant so I omitted it. The distributed transaction is implied even
though it's only a read on the linked server, MS DTC will still create a
transaction if the remote server supports the "ITransactionJoin" interface a
t
least thats what BOL says. I'd like to try and prevent the creation of the
transaction with the REMOTE_PROC_TRANSACTIONS option but I think I'll have t
o
create a procedure with output parameters on the linked server rather than
just reading from the table directly.
Here's an excerpt from BOL titled (Transact-SQL Distributed Transaction)...
I'm interpreting this as if I can create a procedure on the target of the
linked server execute it, read the output parameters and as long as I have
set the REMOTE_PROC_TRANSACTIONS OFF option for the connection I shouldn't
get a distributed transaction from MS DTC, am I correct in that assumption,
anyone...?
Starting Distributed Transactions
You can start distributed transactions in Transact-SQL in these ways:
Start an explicit distributed transaction using the BEGIN DISTRIBUTED
TRANSACTION statement.
You can also execute a distributed query against a linked server. The SQL
Server you have connected to calls MS DTC to manage the distributed
transaction with the linked server. You can also call remote stored
procedures on a remote SQL Server as part of the distributed transaction.
While in a local transaction, execute a distributed query.
If the OLE DB data source supports the ITransactionJoin interface, the
transaction is promoted to a distributed transaction, even if the query is a
read-only query. If the data source does not support ITransactionJoin, only
read-only statements are allowed.
If SET REMOTE_PROC_TRANSACTIONS ON has been executed and a local transaction
calls a remote stored procedure on another SQL Server, the local transaction
is promoted to a distributed transaction.
SQL Server uses MS DTC to coordinate the transaction with the remote server.
Calls to remote stored procedures execute outside the scope of a local
transaction if REMOTE_PROC_TRANSACTIONS is set to OFF. The work done by the
remote procedure is not rolled back if the local transaction is rolled back.
The work done by the remote stored procedure is committed at the time the
procedure completes, not when the local transaction is committed.
The REMOTE_PROC_TRANSACTIONS option is a compatibility option that affects
only remote stored procedure calls made to remote servers defined using
sp_addserver. For more information about remote stored procedures, see Remot
e
Stored Procedure Architecture. The option does not apply to distributed
queries that execute a stored procedure on a linked server defined using
sp_addlinkedserver. For more information about distributed queries, see
Distributed Queries.
"David Gugick" wrote:
> Alien2_51 wrote:
> What type of cursor are you using if not a firehose (Server / read-only
> / forward-only)?
> Maybe you could try wrapping the linked server call in a transaction? Is
> that the whole procedure? Where are the @.SSN, @.FirstName,@.LastName being
> set?
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Alien2_51 wrote:
> Not using a cursor, anywhere... The @.Name and @.SSN are being read
You always use a cursor when selecting data. It's inherent in the
mechanism of data retrieval. From your code ADO, ADO.Net, ODBC, etc. you
are setting parameters which define what type of cursor is used. Don't
confuse the word cursor with the SQL Server DECLARE CURSOR. It's not the
same thing. When you issue a query from QA, for example, QA is probably
using a firehose cursor, same when you open a table from SQL EM.
If this is run from your application, you are either setting these
parameters or using the defaults. A firehose cursor is nothing more than
using what SQL Server generates at the back-end. That is a server-side,
read-only, forward-only result set. If you can, change this result set
to a static, client-side cursor and it may eliminate the problem.
David Gugick
Imceda Software
www.imceda.com|||I remember reading that a firehose cursor is an obsolete term for a default
result set in BOL. How do I tell SQL Server to use something other than the
default cursor when selecting data..? How is that going to prevent the
distributed transaction..?
"David Gugick" wrote:
> Alien2_51 wrote:
> You always use a cursor when selecting data. It's inherent in the
> mechanism of data retrieval. From your code ADO, ADO.Net, ODBC, etc. you
> are setting parameters which define what type of cursor is used. Don't
> confuse the word cursor with the SQL Server DECLARE CURSOR. It's not the
> same thing. When you issue a query from QA, for example, QA is probably
> using a firehose cursor, same when you open a table from SQL EM.
> If this is run from your application, you are either setting these
> parameters or using the defaults. A firehose cursor is nothing more than
> using what SQL Server generates at the back-end. That is a server-side,
> read-only, forward-only result set. If you can, change this result set
> to a static, client-side cursor and it may eliminate the problem.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Alien2_51 wrote:
> I remember reading that a firehose cursor is an obsolete term for a
> default result set in BOL. How do I tell SQL Server to use something
> other than the default cursor when selecting data..? How is that
> going to prevent the distributed transaction..?
>
What are you programming in? This is a client, data-access library
issue, not a SQL Server one. Firehose cursors are still around, even in
.Net, although are are implemented by the datareader object, and are
considered the fastest method to return data to the client. There are
really the "no-cursor cursor". Ignore the SQL Server BOL comment. Here's
more information:
Firehose Cursors
Traditional ADO exposes four different types of cursors that change how
the ADO Recordset object functions. An ADO Recordset object behaves very
differently depending on how its CursorType property is set. For
example, by setting the CursorType to adOpenForwardOnly, the Recordset
remains connected to its data source and must be traversed in a
forward-only direction. However, when you set the CursorType property to
adOpenDynamic, the Recordset can be traversed forward or backward, or
you can even jump the cursor to a particular row. Through its CursorType
and CursorLocation properties, the ADO Recordset object takes the
approach of wrapping many solutions into a single object. ADO.NET takes
a different approach where it has distinct objects and methods that are
designed to handle specific situations.
In classic ADO forward-only, read-only cursors are implemented by
setting the CursorType to adOpenForwardOnly and the CursorLocation to
adUseServer (which are also the default settings). This makes the
Recordset object take the form of a forward-only, server-side cursor.
The MoveNext method repositions the Recordset to the next row and the
MovePrevious method is not allowed at all. You can, however, invoke the
MoveFirst method on a Recordset. It is a bit misleading, however, as it
does not reposition itself to the beginning of the current rowset.
Rather, it invokes the original SQL statement and refills the Recordset
from scratch, thus moving to the first record again.
This can easily be seen by opening the SQL Profiler tool and watching
the SQL execute every time the MoveFirst method is executed on a
traditional ADO Recordset with a CursorType of adOpenForwardOnly. This
type of cursor is commonly used in applications where thousands (or
more) rows need to be traversed one at a time or when a smaller rowset
is required but only needs to be traversed once, perhaps to be loaded
into a pick list:
'-- Forward-only Firehose Cursor in ASP and ADO
Set oRs.ActiveConnection = oCn
oRs.LockType = adLockReadOnly
oRs.CursorType = adOpenForwardOnly
oRs.CursorLocation = adUseServer
oRs.Open sSQL
The closest equivalent to this type of traditional ADO firehose cursor
is the ADO.NET DataReader object. Just like the traditional forward-only
ADO Recordset, the DataReader remains connected to its data source while
it is open and can be traversed only in a forward direction. However,
there are differences. One is that individual DataReader types are
written specifically for a data provider such as SQL Server? (the
SqlDataReader class) or an ODBC data source (the OdbcDataReader class).
The ADO.NET DataReader object is very efficient as it is built
specifically for the purpose of implementing forward-only, read-only
cursors. The classic ADO forward-only cursor is implemented through the
same Recordset object as a disconnected Recordset or even as a data
source-sensitive Recordset. The DataReader is designed solely to be a
lean firehose cursor.
' ASP.NET and ADO.NET in Visual Basic .NET
Dim oDr As SqlDataReader = oCmd.ExecuteReader()
// ASP.NET and ADO.NET in C#
SqlDataReader oDr = oCmd.ExecuteReader();
David Gugick
Imceda Software
www.imceda.com|||David,
Thank you very much for your time in helping me on this, it's very much
appreciated! The client application is written in VB.NET and uses Rocky
Lohtkas CSLA component framework. The stored procedure that's called that
generates this error is in the save method of one of my components, there's
no data reader there, although I do use DataReaders to populate the objects
with data. I'm still scepticle that this is a SQL Server (MS DTC) issue and
not a client cursor problem because the ITransactionJoin interface is
something MS DTC uses, right...? Also I have a powerbuilder application tha
t
has generated the same exact error.
Dan
"David Gugick" wrote:
> Alien2_51 wrote:
> What are you programming in? This is a client, data-access library
> issue, not a SQL Server one. Firehose cursors are still around, even in
> ..Net, although are are implemented by the datareader object, and are
> considered the fastest method to return data to the client. There are
> really the "no-cursor cursor". Ignore the SQL Server BOL comment. Here's
> more information:
> Firehose Cursors
> Traditional ADO exposes four different types of cursors that change how
> the ADO Recordset object functions. An ADO Recordset object behaves very
> differently depending on how its CursorType property is set. For
> example, by setting the CursorType to adOpenForwardOnly, the Recordset
> remains connected to its data source and must be traversed in a
> forward-only direction. However, when you set the CursorType property to
> adOpenDynamic, the Recordset can be traversed forward or backward, or
> you can even jump the cursor to a particular row. Through its CursorType
> and CursorLocation properties, the ADO Recordset object takes the
> approach of wrapping many solutions into a single object. ADO.NET takes
> a different approach where it has distinct objects and methods that are
> designed to handle specific situations.
> In classic ADO forward-only, read-only cursors are implemented by
> setting the CursorType to adOpenForwardOnly and the CursorLocation to
> adUseServer (which are also the default settings). This makes the
> Recordset object take the form of a forward-only, server-side cursor.
> The MoveNext method repositions the Recordset to the next row and the
> MovePrevious method is not allowed at all. You can, however, invoke the
> MoveFirst method on a Recordset. It is a bit misleading, however, as it
> does not reposition itself to the beginning of the current rowset.
> Rather, it invokes the original SQL statement and refills the Recordset
> from scratch, thus moving to the first record again.
> This can easily be seen by opening the SQL Profiler tool and watching
> the SQL execute every time the MoveFirst method is executed on a
> traditional ADO Recordset with a CursorType of adOpenForwardOnly. This
> type of cursor is commonly used in applications where thousands (or
> more) rows need to be traversed one at a time or when a smaller rowset
> is required but only needs to be traversed once, perhaps to be loaded
> into a pick list:
> '-- Forward-only Firehose Cursor in ASP and ADO
> Set oRs.ActiveConnection = oCn
> oRs.LockType = adLockReadOnly
> oRs.CursorType = adOpenForwardOnly
> oRs.CursorLocation = adUseServer
> oRs.Open sSQL
> The closest equivalent to this type of traditional ADO firehose cursor
> is the ADO.NET DataReader object. Just like the traditional forward-only
> ADO Recordset, the DataReader remains connected to its data source while
> it is open and can be traversed only in a forward direction. However,
> there are differences. One is that individual DataReader types are
> written specifically for a data provider such as SQL Server? (the
> SqlDataReader class) or an ODBC data source (the OdbcDataReader class).
> The ADO.NET DataReader object is very efficient as it is built
> specifically for the purpose of implementing forward-only, read-only
> cursors. The classic ADO forward-only cursor is implemented through the
> same Recordset object as a disconnected Recordset or even as a data
> source-sensitive Recordset. The DataReader is designed solely to be a
> lean firehose cursor.
> ' ASP.NET and ADO.NET in Visual Basic .NET
> Dim oDr As SqlDataReader = oCmd.ExecuteReader()
> // ASP.NET and ADO.NET in C#
> SqlDataReader oDr = oCmd.ExecuteReader();
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Alien2_51 wrote:
> David,
> Thank you very much for your time in helping me on this, it's very
> much appreciated! The client application is written in VB.NET and
> uses Rocky Lohtkas CSLA component framework. The stored procedure
> that's called that generates this error is in the save method of one
> of my components, there's no data reader there, although I do use
> DataReaders to populate the objects with data. I'm still scepticle
> that this is a SQL Server (MS DTC) issue and not a client cursor
> problem because the ITransactionJoin interface is something MS DTC
> uses, right...? Also I have a powerbuilder application that has
> generated the same exact error.
> Dan
I'm not going to be able help much more. A firehose cursor as set up by
one data access library is really the same as the next since there's no
client management of the cursor. The error you are receiving has been
reported in SQL EM as well.
When you run the procedure it sounds like you are using .Net call that
may be generating a recordset/resultset or whatever it's called in
.net. If that's the case, try and make an ADO.net call that does not
generate a result set.
You should also have a SET NOCOUNT ON at the top of every procedure. And
you should probbly be using SET @.SalesPersonID = SCOPE_IDENTITY()
instead of @.@.identity.
Bu as I mentioned, I'm out of ideas onthis issue.
David Gugick
Imceda Software
www.imceda.com|||Thanks David... I'm using ExecuteNonQuery which doesn't generate a result
set. Anybody else have any ideas...?
"David Gugick" wrote:
> Alien2_51 wrote:
> I'm not going to be able help much more. A firehose cursor as set up by
> one data access library is really the same as the next since there's no
> client management of the cursor. The error you are receiving has been
> reported in SQL EM as well.
> When you run the procedure it sounds like you are using .Net call that
> may be generating a recordset/resultset or whatever it's called in
> ..net. If that's the case, try and make an ADO.net call that does not
> generate a result set.
> You should also have a SET NOCOUNT ON at the top of every procedure. And
> you should probbly be using SET @.SalesPersonID = SCOPE_IDENTITY()
> instead of @.@.identity.
> Bu as I mentioned, I'm out of ideas onthis issue.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Alien2_51 wrote:
> Thanks David... I'm using ExecuteNonQuery which doesn't generate a
> result set. Anybody else have any ideas...?
>
Get the SET NOCOUNT ON in there and try again. Without it, there is a
phantom result set generated.
David Gugick
Imceda Software
www.imceda.com
seen this, I've searched the group's most messages I found mention a firehos
e
cursor which I know I'm not using... Here's the procedure thats generating
the error, this is the first time I've seen this error the application has
been working fine in production for months. I think this may have to do with
the fact that I'm using a linked server and I get an implied transaction whe
n
I use it, can I turn this off...?
Here's was the whole error message.
OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: Cannot start transaction while in
firehose mode]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
ITransactionJoin::JoinTransaction returned 0x80004005: ].
CREATE PROCEDURE [dbo].[esp_csla_SalesPerson_Create]
@.SalesPersonID int = NULL OUTPUT,
@.VendorCode CHAR(10),
@.VendorGroup CHAR(10)
AS
BEGIN
DECLARE @.SSN AS CHAR(11),
@.Name AS CHAR(50),
@.FirstName AS VARCHAR(50),
@.LastName AS VARCHAR(50),
@.Index AS INT
SELECT
@.SSN = ven_tax_id,
@.Name = ven_name
FROM
LinkedServer.database.dbo.databasetable
WHERE
ven_cd = @.VendorCode AND
ven_grp_cd = @.VendorGroup
INSERT INTO SalesPersons (VendorCode,VendorGroup,SSN,FirstName,La
stName)
VALUES (@.VendorCode,@.VendorGroup,@.SSN, @.FirstName,@.LastName)
SET @.SalesPersonID = @.@.IDENTITY
END
GOAlien2_51 wrote:
> I'm getting this error message in one of my procedures... Has anyone
> ever seen this, I've searched the group's most messages I found
> mention a firehose cursor which I know I'm not using... Here's the
> procedure thats generating the error, this is the first time I've
> seen this error the application has been working fine in production
> for months. I think this may have to do with the fact that I'm using
> a linked server and I get an implied transaction when I use it, can I
> turn this off...?
> Here's was the whole error message.
> OLE DB provider 'SQLOLEDB' reported an error.
> [OLE/DB provider returned message: Cannot start transaction while in
> firehose mode]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB'
> ITransactionJoin::JoinTransaction returned 0x80004005: ].
>
> CREATE PROCEDURE [dbo].[esp_csla_SalesPerson_Create]
> @.SalesPersonID int = NULL OUTPUT,
> @.VendorCode CHAR(10),
> @.VendorGroup CHAR(10)
> AS
> BEGIN
> DECLARE @.SSN AS CHAR(11),
> @.Name AS CHAR(50),
> @.FirstName AS VARCHAR(50),
> @.LastName AS VARCHAR(50),
> @.Index AS INT
> SELECT
> @.SSN = ven_tax_id,
> @.Name = ven_name
> FROM
> LinkedServer.database.dbo.databasetable
> WHERE
> ven_cd = @.VendorCode AND
> ven_grp_cd = @.VendorGroup
> INSERT INTO SalesPersons
> (VendorCode,VendorGroup,SSN,FirstName,La
stName) VALUES
> (@.VendorCode,@.VendorGroup,@.SSN, @.FirstName,@.LastName)
> SET @.SalesPersonID = @.@.IDENTITY
> END
> GO
What type of cursor are you using if not a firehose (Server / read-only
/ forward-only)?
Maybe you could try wrapping the linked server call in a transaction? Is
that the whole procedure? Where are the @.SSN, @.FirstName,@.LastName being
set?
David Gugick
Imceda Software
www.imceda.com|||Not using a cursor, anywhere... The @.Name and @.SSN are being read from the
linked server, the first and last name are parsed from @.Name but that code
was irrelevant so I omitted it. The distributed transaction is implied even
though it's only a read on the linked server, MS DTC will still create a
transaction if the remote server supports the "ITransactionJoin" interface a
t
least thats what BOL says. I'd like to try and prevent the creation of the
transaction with the REMOTE_PROC_TRANSACTIONS option but I think I'll have t
o
create a procedure with output parameters on the linked server rather than
just reading from the table directly.
Here's an excerpt from BOL titled (Transact-SQL Distributed Transaction)...
I'm interpreting this as if I can create a procedure on the target of the
linked server execute it, read the output parameters and as long as I have
set the REMOTE_PROC_TRANSACTIONS OFF option for the connection I shouldn't
get a distributed transaction from MS DTC, am I correct in that assumption,
anyone...?
Starting Distributed Transactions
You can start distributed transactions in Transact-SQL in these ways:
Start an explicit distributed transaction using the BEGIN DISTRIBUTED
TRANSACTION statement.
You can also execute a distributed query against a linked server. The SQL
Server you have connected to calls MS DTC to manage the distributed
transaction with the linked server. You can also call remote stored
procedures on a remote SQL Server as part of the distributed transaction.
While in a local transaction, execute a distributed query.
If the OLE DB data source supports the ITransactionJoin interface, the
transaction is promoted to a distributed transaction, even if the query is a
read-only query. If the data source does not support ITransactionJoin, only
read-only statements are allowed.
If SET REMOTE_PROC_TRANSACTIONS ON has been executed and a local transaction
calls a remote stored procedure on another SQL Server, the local transaction
is promoted to a distributed transaction.
SQL Server uses MS DTC to coordinate the transaction with the remote server.
Calls to remote stored procedures execute outside the scope of a local
transaction if REMOTE_PROC_TRANSACTIONS is set to OFF. The work done by the
remote procedure is not rolled back if the local transaction is rolled back.
The work done by the remote stored procedure is committed at the time the
procedure completes, not when the local transaction is committed.
The REMOTE_PROC_TRANSACTIONS option is a compatibility option that affects
only remote stored procedure calls made to remote servers defined using
sp_addserver. For more information about remote stored procedures, see Remot
e
Stored Procedure Architecture. The option does not apply to distributed
queries that execute a stored procedure on a linked server defined using
sp_addlinkedserver. For more information about distributed queries, see
Distributed Queries.
"David Gugick" wrote:
> Alien2_51 wrote:
> What type of cursor are you using if not a firehose (Server / read-only
> / forward-only)?
> Maybe you could try wrapping the linked server call in a transaction? Is
> that the whole procedure? Where are the @.SSN, @.FirstName,@.LastName being
> set?
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Alien2_51 wrote:
> Not using a cursor, anywhere... The @.Name and @.SSN are being read
You always use a cursor when selecting data. It's inherent in the
mechanism of data retrieval. From your code ADO, ADO.Net, ODBC, etc. you
are setting parameters which define what type of cursor is used. Don't
confuse the word cursor with the SQL Server DECLARE CURSOR. It's not the
same thing. When you issue a query from QA, for example, QA is probably
using a firehose cursor, same when you open a table from SQL EM.
If this is run from your application, you are either setting these
parameters or using the defaults. A firehose cursor is nothing more than
using what SQL Server generates at the back-end. That is a server-side,
read-only, forward-only result set. If you can, change this result set
to a static, client-side cursor and it may eliminate the problem.
David Gugick
Imceda Software
www.imceda.com|||I remember reading that a firehose cursor is an obsolete term for a default
result set in BOL. How do I tell SQL Server to use something other than the
default cursor when selecting data..? How is that going to prevent the
distributed transaction..?
"David Gugick" wrote:
> Alien2_51 wrote:
> You always use a cursor when selecting data. It's inherent in the
> mechanism of data retrieval. From your code ADO, ADO.Net, ODBC, etc. you
> are setting parameters which define what type of cursor is used. Don't
> confuse the word cursor with the SQL Server DECLARE CURSOR. It's not the
> same thing. When you issue a query from QA, for example, QA is probably
> using a firehose cursor, same when you open a table from SQL EM.
> If this is run from your application, you are either setting these
> parameters or using the defaults. A firehose cursor is nothing more than
> using what SQL Server generates at the back-end. That is a server-side,
> read-only, forward-only result set. If you can, change this result set
> to a static, client-side cursor and it may eliminate the problem.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Alien2_51 wrote:
> I remember reading that a firehose cursor is an obsolete term for a
> default result set in BOL. How do I tell SQL Server to use something
> other than the default cursor when selecting data..? How is that
> going to prevent the distributed transaction..?
>
What are you programming in? This is a client, data-access library
issue, not a SQL Server one. Firehose cursors are still around, even in
.Net, although are are implemented by the datareader object, and are
considered the fastest method to return data to the client. There are
really the "no-cursor cursor". Ignore the SQL Server BOL comment. Here's
more information:
Firehose Cursors
Traditional ADO exposes four different types of cursors that change how
the ADO Recordset object functions. An ADO Recordset object behaves very
differently depending on how its CursorType property is set. For
example, by setting the CursorType to adOpenForwardOnly, the Recordset
remains connected to its data source and must be traversed in a
forward-only direction. However, when you set the CursorType property to
adOpenDynamic, the Recordset can be traversed forward or backward, or
you can even jump the cursor to a particular row. Through its CursorType
and CursorLocation properties, the ADO Recordset object takes the
approach of wrapping many solutions into a single object. ADO.NET takes
a different approach where it has distinct objects and methods that are
designed to handle specific situations.
In classic ADO forward-only, read-only cursors are implemented by
setting the CursorType to adOpenForwardOnly and the CursorLocation to
adUseServer (which are also the default settings). This makes the
Recordset object take the form of a forward-only, server-side cursor.
The MoveNext method repositions the Recordset to the next row and the
MovePrevious method is not allowed at all. You can, however, invoke the
MoveFirst method on a Recordset. It is a bit misleading, however, as it
does not reposition itself to the beginning of the current rowset.
Rather, it invokes the original SQL statement and refills the Recordset
from scratch, thus moving to the first record again.
This can easily be seen by opening the SQL Profiler tool and watching
the SQL execute every time the MoveFirst method is executed on a
traditional ADO Recordset with a CursorType of adOpenForwardOnly. This
type of cursor is commonly used in applications where thousands (or
more) rows need to be traversed one at a time or when a smaller rowset
is required but only needs to be traversed once, perhaps to be loaded
into a pick list:
'-- Forward-only Firehose Cursor in ASP and ADO
Set oRs.ActiveConnection = oCn
oRs.LockType = adLockReadOnly
oRs.CursorType = adOpenForwardOnly
oRs.CursorLocation = adUseServer
oRs.Open sSQL
The closest equivalent to this type of traditional ADO firehose cursor
is the ADO.NET DataReader object. Just like the traditional forward-only
ADO Recordset, the DataReader remains connected to its data source while
it is open and can be traversed only in a forward direction. However,
there are differences. One is that individual DataReader types are
written specifically for a data provider such as SQL Server? (the
SqlDataReader class) or an ODBC data source (the OdbcDataReader class).
The ADO.NET DataReader object is very efficient as it is built
specifically for the purpose of implementing forward-only, read-only
cursors. The classic ADO forward-only cursor is implemented through the
same Recordset object as a disconnected Recordset or even as a data
source-sensitive Recordset. The DataReader is designed solely to be a
lean firehose cursor.
' ASP.NET and ADO.NET in Visual Basic .NET
Dim oDr As SqlDataReader = oCmd.ExecuteReader()
// ASP.NET and ADO.NET in C#
SqlDataReader oDr = oCmd.ExecuteReader();
David Gugick
Imceda Software
www.imceda.com|||David,
Thank you very much for your time in helping me on this, it's very much
appreciated! The client application is written in VB.NET and uses Rocky
Lohtkas CSLA component framework. The stored procedure that's called that
generates this error is in the save method of one of my components, there's
no data reader there, although I do use DataReaders to populate the objects
with data. I'm still scepticle that this is a SQL Server (MS DTC) issue and
not a client cursor problem because the ITransactionJoin interface is
something MS DTC uses, right...? Also I have a powerbuilder application tha
t
has generated the same exact error.
Dan
"David Gugick" wrote:
> Alien2_51 wrote:
> What are you programming in? This is a client, data-access library
> issue, not a SQL Server one. Firehose cursors are still around, even in
> ..Net, although are are implemented by the datareader object, and are
> considered the fastest method to return data to the client. There are
> really the "no-cursor cursor". Ignore the SQL Server BOL comment. Here's
> more information:
> Firehose Cursors
> Traditional ADO exposes four different types of cursors that change how
> the ADO Recordset object functions. An ADO Recordset object behaves very
> differently depending on how its CursorType property is set. For
> example, by setting the CursorType to adOpenForwardOnly, the Recordset
> remains connected to its data source and must be traversed in a
> forward-only direction. However, when you set the CursorType property to
> adOpenDynamic, the Recordset can be traversed forward or backward, or
> you can even jump the cursor to a particular row. Through its CursorType
> and CursorLocation properties, the ADO Recordset object takes the
> approach of wrapping many solutions into a single object. ADO.NET takes
> a different approach where it has distinct objects and methods that are
> designed to handle specific situations.
> In classic ADO forward-only, read-only cursors are implemented by
> setting the CursorType to adOpenForwardOnly and the CursorLocation to
> adUseServer (which are also the default settings). This makes the
> Recordset object take the form of a forward-only, server-side cursor.
> The MoveNext method repositions the Recordset to the next row and the
> MovePrevious method is not allowed at all. You can, however, invoke the
> MoveFirst method on a Recordset. It is a bit misleading, however, as it
> does not reposition itself to the beginning of the current rowset.
> Rather, it invokes the original SQL statement and refills the Recordset
> from scratch, thus moving to the first record again.
> This can easily be seen by opening the SQL Profiler tool and watching
> the SQL execute every time the MoveFirst method is executed on a
> traditional ADO Recordset with a CursorType of adOpenForwardOnly. This
> type of cursor is commonly used in applications where thousands (or
> more) rows need to be traversed one at a time or when a smaller rowset
> is required but only needs to be traversed once, perhaps to be loaded
> into a pick list:
> '-- Forward-only Firehose Cursor in ASP and ADO
> Set oRs.ActiveConnection = oCn
> oRs.LockType = adLockReadOnly
> oRs.CursorType = adOpenForwardOnly
> oRs.CursorLocation = adUseServer
> oRs.Open sSQL
> The closest equivalent to this type of traditional ADO firehose cursor
> is the ADO.NET DataReader object. Just like the traditional forward-only
> ADO Recordset, the DataReader remains connected to its data source while
> it is open and can be traversed only in a forward direction. However,
> there are differences. One is that individual DataReader types are
> written specifically for a data provider such as SQL Server? (the
> SqlDataReader class) or an ODBC data source (the OdbcDataReader class).
> The ADO.NET DataReader object is very efficient as it is built
> specifically for the purpose of implementing forward-only, read-only
> cursors. The classic ADO forward-only cursor is implemented through the
> same Recordset object as a disconnected Recordset or even as a data
> source-sensitive Recordset. The DataReader is designed solely to be a
> lean firehose cursor.
> ' ASP.NET and ADO.NET in Visual Basic .NET
> Dim oDr As SqlDataReader = oCmd.ExecuteReader()
> // ASP.NET and ADO.NET in C#
> SqlDataReader oDr = oCmd.ExecuteReader();
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Alien2_51 wrote:
> David,
> Thank you very much for your time in helping me on this, it's very
> much appreciated! The client application is written in VB.NET and
> uses Rocky Lohtkas CSLA component framework. The stored procedure
> that's called that generates this error is in the save method of one
> of my components, there's no data reader there, although I do use
> DataReaders to populate the objects with data. I'm still scepticle
> that this is a SQL Server (MS DTC) issue and not a client cursor
> problem because the ITransactionJoin interface is something MS DTC
> uses, right...? Also I have a powerbuilder application that has
> generated the same exact error.
> Dan
I'm not going to be able help much more. A firehose cursor as set up by
one data access library is really the same as the next since there's no
client management of the cursor. The error you are receiving has been
reported in SQL EM as well.
When you run the procedure it sounds like you are using .Net call that
may be generating a recordset/resultset or whatever it's called in
.net. If that's the case, try and make an ADO.net call that does not
generate a result set.
You should also have a SET NOCOUNT ON at the top of every procedure. And
you should probbly be using SET @.SalesPersonID = SCOPE_IDENTITY()
instead of @.@.identity.
Bu as I mentioned, I'm out of ideas onthis issue.
David Gugick
Imceda Software
www.imceda.com|||Thanks David... I'm using ExecuteNonQuery which doesn't generate a result
set. Anybody else have any ideas...?
"David Gugick" wrote:
> Alien2_51 wrote:
> I'm not going to be able help much more. A firehose cursor as set up by
> one data access library is really the same as the next since there's no
> client management of the cursor. The error you are receiving has been
> reported in SQL EM as well.
> When you run the procedure it sounds like you are using .Net call that
> may be generating a recordset/resultset or whatever it's called in
> ..net. If that's the case, try and make an ADO.net call that does not
> generate a result set.
> You should also have a SET NOCOUNT ON at the top of every procedure. And
> you should probbly be using SET @.SalesPersonID = SCOPE_IDENTITY()
> instead of @.@.identity.
> Bu as I mentioned, I'm out of ideas onthis issue.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>|||Alien2_51 wrote:
> Thanks David... I'm using ExecuteNonQuery which doesn't generate a
> result set. Anybody else have any ideas...?
>
Get the SET NOCOUNT ON in there and try again. Without it, there is a
phantom result set generated.
David Gugick
Imceda Software
www.imceda.com
cannot start sqlserver agent - urgent
I cannot start the sqlserver agent neither manually or automatically and I
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.
Is your local SQL Server instance running? Can you connect to your SQL
instance using a different tool (like Query Analyser or osql.exe) and
the same login (be it a SQL login or a trusted connection) that your
instance of SQLAgent is configured to use? Is SQLAgent configured to
use a trusted connection or a standard SQL login?
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
00allen_iverson wrote:
>I cannot start the sqlserver agent neither manually or automatically and I
>get this message in the event log:
>SQLServerAgent could not be started (reason: Unable to connect to server
>'(local)'; SQLServerAgent cannot start).
>Can anyone please help? Thanks.
>
>
|||How can I find out the SQLagent configuration of trust connection or standard SQL login? And how can I get help from this. Thanks.
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl...
Is your local SQL Server instance running? Can you connect to your SQL instance using a different tool (like Query Analyser or osql.exe) and the same login (be it a SQL login or a trusted connection) that your instance of SQLAgent is configured to use? Is SQLAgent configured to use a trusted connection or a standard SQL login?
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W http://www.mallesons.com
00allen_iverson wrote:
I cannot start the sqlserver agent neither manually or automatically and I
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.
|||Open SQL Enterprise Manager. Expand the branches to expose your local
instance. Left-click on the local instance; this will establish a
client connection (SQLEM being the client) to your server. If that is
successful then your SQL server is running and accepting client connections.
Expand the + next to the server name. Expand the + next to Management.
Right-click on SQL Server Agent and select the property menu option.
This will bring up the configuration dialog box for SQL Agent.
Click on the last tab (Connection). This will tell you how SQLAgent is
attempting to connect to the SQL server instance.
(I'm sure this basic GUI config stuff is described in SQL Books
Online...like here for instance:
http://msdn.microsoft.com/library/de...omate_01et.asp)
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
00allen_iverson wrote:
[vbcol=seagreen]
> How can I find out the SQLagent configuration of trust connection or
> standard SQL login? And how can I get help from this. Thanks.
>
> "Mike Hodgson" <mike.hodgson@.mallesons.nospam.com
> <mailto:mike.hodgson@.mallesons.nospam.com>> wrote in message
> news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl...
> Is your local SQL Server instance running? Can you connect to
> your SQL instance using a different tool (like Query Analyser or
> osql.exe) and the same login (be it a SQL login or a trusted
> connection) that your instance of SQLAgent is configured to use?
> Is SQLAgent configured to use a trusted connection or a standard
> SQL login?
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> http://www.mallesons.com
>
> 00allen_iverson wrote:
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.
Is your local SQL Server instance running? Can you connect to your SQL
instance using a different tool (like Query Analyser or osql.exe) and
the same login (be it a SQL login or a trusted connection) that your
instance of SQLAgent is configured to use? Is SQLAgent configured to
use a trusted connection or a standard SQL login?
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
00allen_iverson wrote:
>I cannot start the sqlserver agent neither manually or automatically and I
>get this message in the event log:
>SQLServerAgent could not be started (reason: Unable to connect to server
>'(local)'; SQLServerAgent cannot start).
>Can anyone please help? Thanks.
>
>
|||How can I find out the SQLagent configuration of trust connection or standard SQL login? And how can I get help from this. Thanks.
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl...
Is your local SQL Server instance running? Can you connect to your SQL instance using a different tool (like Query Analyser or osql.exe) and the same login (be it a SQL login or a trusted connection) that your instance of SQLAgent is configured to use? Is SQLAgent configured to use a trusted connection or a standard SQL login?
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W http://www.mallesons.com
00allen_iverson wrote:
I cannot start the sqlserver agent neither manually or automatically and I
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.
|||Open SQL Enterprise Manager. Expand the branches to expose your local
instance. Left-click on the local instance; this will establish a
client connection (SQLEM being the client) to your server. If that is
successful then your SQL server is running and accepting client connections.
Expand the + next to the server name. Expand the + next to Management.
Right-click on SQL Server Agent and select the property menu option.
This will bring up the configuration dialog box for SQL Agent.
Click on the last tab (Connection). This will tell you how SQLAgent is
attempting to connect to the SQL server instance.
(I'm sure this basic GUI config stuff is described in SQL Books
Online...like here for instance:
http://msdn.microsoft.com/library/de...omate_01et.asp)
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
00allen_iverson wrote:
[vbcol=seagreen]
> How can I find out the SQLagent configuration of trust connection or
> standard SQL login? And how can I get help from this. Thanks.
>
> "Mike Hodgson" <mike.hodgson@.mallesons.nospam.com
> <mailto:mike.hodgson@.mallesons.nospam.com>> wrote in message
> news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl...
> Is your local SQL Server instance running? Can you connect to
> your SQL instance using a different tool (like Query Analyser or
> osql.exe) and the same login (be it a SQL login or a trusted
> connection) that your instance of SQLAgent is configured to use?
> Is SQLAgent configured to use a trusted connection or a standard
> SQL login?
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> http://www.mallesons.com
>
> 00allen_iverson wrote:
cannot start sqlserver agent - urgent
I cannot start the sqlserver agent neither manually or automatically and I
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.Is your local SQL Server instance running? Can you connect to your SQL
instance using a different tool (like Query Analyser or osql.exe) and
the same login (be it a SQL login or a trusted connection) that your
instance of SQLAgent is configured to use? Is SQLAgent configured to
use a trusted connection or a standard SQL login?
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
00allen_iverson wrote:
>I cannot start the sqlserver agent neither manually or automatically and I
>get this message in the event log:
>SQLServerAgent could not be started (reason: Unable to connect to server
>'(local)'; SQLServerAgent cannot start).
>Can anyone please help? Thanks.
>
>|||How can I find out the SQLagent configuration of trust connection or standar
d SQL login? And how can I get help from this. Thanks.
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message news:u0r
F7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl...
Is your local SQL Server instance running? Can you connect to your SQL inst
ance using a different tool (like Query Analyser or osql.exe) and the same l
ogin (be it a SQL login or a trusted connection) that your instance of SQLAg
ent is configured to use? Is SQLAgent configured to use a trusted connectio
n or a standard SQL login?
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W http://www.mallesons.com
00allen_iverson wrote:
I cannot start the sqlserver agent neither manually or automatically and I
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.|||Open SQL Enterprise Manager. Expand the branches to expose your local
instance. Left-click on the local instance; this will establish a
client connection (SQLEM being the client) to your server. If that is
successful then your SQL server is running and accepting client connections.
Expand the + next to the server name. Expand the + next to Management.
Right-click on SQL Server Agent and select the property menu option.
This will bring up the configuration dialog box for SQL Agent.
Click on the last tab (Connection). This will tell you how SQLAgent is
attempting to connect to the SQL server instance.
(I'm sure this basic GUI config stuff is described in SQL Books
Online...like here for instance:
ate_01et.asp" target="_blank">http://msdn.microsoft.com/library/d...>
ate_01et.asp)
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
00allen_iverson wrote:
[vbcol=seagreen]
> How can I find out the SQLagent configuration of trust connection or
> standard SQL login? And how can I get help from this. Thanks.
>
> "Mike Hodgson" <mike.hodgson@.mallesons.nospam.com
> <mailto:mike.hodgson@.mallesons.nospam.com>> wrote in message
> news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl...
> Is your local SQL Server instance running? Can you connect to
> your SQL instance using a different tool (like Query Analyser or
> osql.exe) and the same login (be it a SQL login or a trusted
> connection) that your instance of SQLAgent is configured to use?
> Is SQLAgent configured to use a trusted connection or a standard
> SQL login?
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> http://www.mallesons.com
>
> 00allen_iverson wrote:
>
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.Is your local SQL Server instance running? Can you connect to your SQL
instance using a different tool (like Query Analyser or osql.exe) and
the same login (be it a SQL login or a trusted connection) that your
instance of SQLAgent is configured to use? Is SQLAgent configured to
use a trusted connection or a standard SQL login?
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
00allen_iverson wrote:
>I cannot start the sqlserver agent neither manually or automatically and I
>get this message in the event log:
>SQLServerAgent could not be started (reason: Unable to connect to server
>'(local)'; SQLServerAgent cannot start).
>Can anyone please help? Thanks.
>
>|||How can I find out the SQLagent configuration of trust connection or standar
d SQL login? And how can I get help from this. Thanks.
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message news:u0r
F7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl...
Is your local SQL Server instance running? Can you connect to your SQL inst
ance using a different tool (like Query Analyser or osql.exe) and the same l
ogin (be it a SQL login or a trusted connection) that your instance of SQLAg
ent is configured to use? Is SQLAgent configured to use a trusted connectio
n or a standard SQL login?
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W http://www.mallesons.com
00allen_iverson wrote:
I cannot start the sqlserver agent neither manually or automatically and I
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.|||Open SQL Enterprise Manager. Expand the branches to expose your local
instance. Left-click on the local instance; this will establish a
client connection (SQLEM being the client) to your server. If that is
successful then your SQL server is running and accepting client connections.
Expand the + next to the server name. Expand the + next to Management.
Right-click on SQL Server Agent and select the property menu option.
This will bring up the configuration dialog box for SQL Agent.
Click on the last tab (Connection). This will tell you how SQLAgent is
attempting to connect to the SQL server instance.
(I'm sure this basic GUI config stuff is described in SQL Books
Online...like here for instance:
ate_01et.asp" target="_blank">http://msdn.microsoft.com/library/d...>
ate_01et.asp)
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
00allen_iverson wrote:
[vbcol=seagreen]
> How can I find out the SQLagent configuration of trust connection or
> standard SQL login? And how can I get help from this. Thanks.
>
> "Mike Hodgson" <mike.hodgson@.mallesons.nospam.com
> <mailto:mike.hodgson@.mallesons.nospam.com>> wrote in message
> news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl...
> Is your local SQL Server instance running? Can you connect to
> your SQL instance using a different tool (like Query Analyser or
> osql.exe) and the same login (be it a SQL login or a trusted
> connection) that your instance of SQLAgent is configured to use?
> Is SQLAgent configured to use a trusted connection or a standard
> SQL login?
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> http://www.mallesons.com
>
> 00allen_iverson wrote:
>
cannot start sqlserver agent - urgent
I cannot start the sqlserver agent neither manually or automatically and I
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.This is a multi-part message in MIME format.
--000802080501040405060909
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Is your local SQL Server instance running? Can you connect to your SQL
instance using a different tool (like Query Analyser or osql.exe) and
the same login (be it a SQL login or a trusted connection) that your
instance of SQLAgent is configured to use? Is SQLAgent configured to
use a trusted connection or a standard SQL login?
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
00allen_iverson wrote:
>I cannot start the sqlserver agent neither manually or automatically and I
>get this message in the event log:
>SQLServerAgent could not be started (reason: Unable to connect to server
>'(local)'; SQLServerAgent cannot start).
>Can anyone please help? Thanks.
>
>
--000802080501040405060909
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Is your local SQL Server instance running? </tt><tt>Can you
connect to your SQL instance using a different tool (like Query
Analyser or osql.exe) and the same login (be it a SQL login or a
trusted connection) that your instance of SQLAgent is configured to
use? Is SQLAgent configured to use a trusted connection or a standard
SQL login?</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
00allen_iverson wrote:
<blockquote cite="mideM3MWIZYFHA.1404@.TK2MSFTNGP09.phx.gbl" type="cite">
<pre wrap="">I cannot start the sqlserver agent neither manually or automatically and I
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.
</pre>
</blockquote>
</body>
</html>
--000802080501040405060909--|||This is a multi-part message in MIME format.
--=_NextPart_000_000F_01C561D8.D5F683E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
How can I find out the SQLagent configuration of trust connection or =standard SQL login? And how can I get help from this. Thanks.
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message =news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl...
Is your local SQL Server instance running? Can you connect to your =SQL instance using a different tool (like Query Analyser or osql.exe) =and the same login (be it a SQL login or a trusted connection) that your =instance of SQLAgent is configured to use? Is SQLAgent configured to =use a trusted connection or a standard SQL login?
--
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W =http://www.mallesons.com=20
00allen_iverson wrote: I cannot start the sqlserver agent neither manually or automatically and =I get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server =
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.
--=_NextPart_000_000F_01C561D8.D5F683E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
How can I find out the SQLagent =configuration of trust connection or standard SQL login? And how can I get help =from this. Thanks.
"Mike Hodgson" wrote in message news:u0rF7QZYFHA.4060=@.TK2MSFTNGP10.phx.gbl...Is your local SQL Server instance running? Can you connect =to your SQL instance using a different tool (like Query Analyser or osql.exe) =and the same login (be it a SQL login or a trusted connection) that your =instance of SQLAgent is configured to use? Is SQLAgent configured to use a =trusted connection or a standard SQL login?
--mike =hodgson | database =administrator | mallesons =stephen jaquesT +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907E mailto:mike.hodgson@.mal=lesons.nospam.com | W http://www.mallesons.com 00allen_iverson wrote: I cannot start the sqlserver agent neither =manually or automatically and I get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server ='(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.
--=_NextPart_000_000F_01C561D8.D5F683E0--|||This is a multi-part message in MIME format.
--010604090704090006030404
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Open SQL Enterprise Manager. Expand the branches to expose your local
instance. Left-click on the local instance; this will establish a
client connection (SQLEM being the client) to your server. If that is
successful then your SQL server is running and accepting client connections.
Expand the + next to the server name. Expand the + next to Management.
Right-click on SQL Server Agent and select the property menu option.
This will bring up the configuration dialog box for SQL Agent.
Click on the last tab (Connection). This will tell you how SQLAgent is
attempting to connect to the SQL server instance.
(I'm sure this basic GUI config stuff is described in SQL Books
Online...like here for instance:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_automate_01et.asp)
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
00allen_iverson wrote:
> How can I find out the SQLagent configuration of trust connection or
> standard SQL login? And how can I get help from this. Thanks.
>
> "Mike Hodgson" <mike.hodgson@.mallesons.nospam.com
> <mailto:mike.hodgson@.mallesons.nospam.com>> wrote in message
> news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl...
> Is your local SQL Server instance running? Can you connect to
> your SQL instance using a different tool (like Query Analyser or
> osql.exe) and the same login (be it a SQL login or a trusted
> connection) that your instance of SQLAgent is configured to use?
> Is SQLAgent configured to use a trusted connection or a standard
> SQL login?
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> http://www.mallesons.com
>
> 00allen_iverson wrote:
>>I cannot start the sqlserver agent neither manually or automatically and I
>>get this message in the event log:
>>SQLServerAgent could not be started (reason: Unable to connect to server
>>'(local)'; SQLServerAgent cannot start).
>>Can anyone please help? Thanks.
>>
>>
--010604090704090006030404
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Open SQL Enterprise Manager. Expand the branches to expose your
local instance. Left-click on the local instance; this will establish
a client connection (SQLEM being the client) to your server. If that
is successful then your SQL server is running and accepting client
connections.<br>
<br>
Expand the + next to the server name. Expand the + next to
Management. Right-click on SQL Server Agent and select the property
menu option. This will bring up the configuration dialog box for SQL
Agent.<br>
<br>
Click on the last tab (Connection). This will tell you how SQLAgent is
attempting to connect to the SQL server instance.<br>
<br>
(I'm sure this basic GUI config stuff is described in SQL Books
Online...like here for instance:<br>
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_automate_01et.asp</a>)<br>">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_automate_01et.asp">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_automate_01et.asp</a>)<br>
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
00allen_iverson wrote:
<blockquote cite="mideGEYJXZYFHA.2128@.TK2MSFTNGP14.phx.gbl" type="cite">
<title></title>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<meta content="MSHTML 6.00.2900.2604" name="GENERATOR">
<style></style>
<div><font face="Arial" size="2">How can I find out the SQLagent
configuration of trust connection or standard SQL login? And how can I
get help from this. Thanks.</font></div>
<div> </div>
<blockquote
style="border-left: 2px solid rgb(0, 0, 0); padding-right: 0px; padding-left: 5px; margin-left: 5px; margin-right: 0px;"
dir="ltr">
<div>"Mike Hodgson" <<a
href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mike.hodgson@.mallesons.nospam.com</a>>
wrote in message <a href="http://links.10026.com/?link=news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl">news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl</a>...</div>
<tt>Is your local SQL Server instance running? </tt><tt>Can you
connect to your SQL instance using a different tool (like Query
Analyser or osql.exe) and the same login (be it a SQL login or a
trusted connection) that your instance of SQLAgent is configured to
use? Is SQLAgent configured to use a trusted connection or a standard
SQL login?</tt><br>
<div class="moz-signature">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2">database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font
face="Tahoma" size="2"> +61 (2) 9296 3668 |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">F</font></b><font
face="Tahoma" size="2"> +61 (2) 9296 3885 |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">M</font></b><font
face="Tahoma" size="2"> +61 (408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma"
size="2"> <a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a>
|</font><b><font face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=http://www.mallesons.com</a></font></span>">http://www.mallesons.com">http://www.mallesons.com</a></font></span>
</p>
</div>
<br>
<br>
00allen_iverson wrote:
<blockquote cite="mideM3MWIZYFHA.1404@.TK2MSFTNGP09.phx.gbl"
type="cite">
<pre wrap="">I cannot start the sqlserver agent neither manually or automatically and I
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.
</pre>
</blockquote>
</blockquote>
</blockquote>
</body>
</html>
--010604090704090006030404--
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.This is a multi-part message in MIME format.
--000802080501040405060909
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Is your local SQL Server instance running? Can you connect to your SQL
instance using a different tool (like Query Analyser or osql.exe) and
the same login (be it a SQL login or a trusted connection) that your
instance of SQLAgent is configured to use? Is SQLAgent configured to
use a trusted connection or a standard SQL login?
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
00allen_iverson wrote:
>I cannot start the sqlserver agent neither manually or automatically and I
>get this message in the event log:
>SQLServerAgent could not be started (reason: Unable to connect to server
>'(local)'; SQLServerAgent cannot start).
>Can anyone please help? Thanks.
>
>
--000802080501040405060909
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Is your local SQL Server instance running? </tt><tt>Can you
connect to your SQL instance using a different tool (like Query
Analyser or osql.exe) and the same login (be it a SQL login or a
trusted connection) that your instance of SQLAgent is configured to
use? Is SQLAgent configured to use a trusted connection or a standard
SQL login?</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
00allen_iverson wrote:
<blockquote cite="mideM3MWIZYFHA.1404@.TK2MSFTNGP09.phx.gbl" type="cite">
<pre wrap="">I cannot start the sqlserver agent neither manually or automatically and I
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.
</pre>
</blockquote>
</body>
</html>
--000802080501040405060909--|||This is a multi-part message in MIME format.
--=_NextPart_000_000F_01C561D8.D5F683E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
How can I find out the SQLagent configuration of trust connection or =standard SQL login? And how can I get help from this. Thanks.
"Mike Hodgson" <mike.hodgson@.mallesons.nospam.com> wrote in message =news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl...
Is your local SQL Server instance running? Can you connect to your =SQL instance using a different tool (like Query Analyser or osql.exe) =and the same login (be it a SQL login or a trusted connection) that your =instance of SQLAgent is configured to use? Is SQLAgent configured to =use a trusted connection or a standard SQL login?
--
mike hodgson | database administrator | mallesons stephen jaques
T +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907
E mailto:mike.hodgson@.mallesons.nospam.com | W =http://www.mallesons.com=20
00allen_iverson wrote: I cannot start the sqlserver agent neither manually or automatically and =I get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server =
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.
--=_NextPart_000_000F_01C561D8.D5F683E0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
How can I find out the SQLagent =configuration of trust connection or standard SQL login? And how can I get help =from this. Thanks.
"Mike Hodgson"
--mike =hodgson | database =administrator | mallesons =stephen jaquesT +61 (2) 9296 3668 | F +61 (2) 9296 3885 | M +61 (408) 675 907E mailto:mike.hodgson@.mal=lesons.nospam.com | W http://www.mallesons.com 00allen_iverson wrote: I cannot start the sqlserver agent neither =manually or automatically and I get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server ='(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.
--=_NextPart_000_000F_01C561D8.D5F683E0--|||This is a multi-part message in MIME format.
--010604090704090006030404
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Open SQL Enterprise Manager. Expand the branches to expose your local
instance. Left-click on the local instance; this will establish a
client connection (SQLEM being the client) to your server. If that is
successful then your SQL server is running and accepting client connections.
Expand the + next to the server name. Expand the + next to Management.
Right-click on SQL Server Agent and select the property menu option.
This will bring up the configuration dialog box for SQL Agent.
Click on the last tab (Connection). This will tell you how SQLAgent is
attempting to connect to the SQL server instance.
(I'm sure this basic GUI config stuff is described in SQL Books
Online...like here for instance:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_automate_01et.asp)
--
*mike hodgson* |/ database administrator/ | mallesons stephen jaques
*T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
*E* mailto:mike.hodgson@.mallesons.nospam.com |* W* http://www.mallesons.com
00allen_iverson wrote:
> How can I find out the SQLagent configuration of trust connection or
> standard SQL login? And how can I get help from this. Thanks.
>
> "Mike Hodgson" <mike.hodgson@.mallesons.nospam.com
> <mailto:mike.hodgson@.mallesons.nospam.com>> wrote in message
> news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl...
> Is your local SQL Server instance running? Can you connect to
> your SQL instance using a different tool (like Query Analyser or
> osql.exe) and the same login (be it a SQL login or a trusted
> connection) that your instance of SQLAgent is configured to use?
> Is SQLAgent configured to use a trusted connection or a standard
> SQL login?
> --
> *mike hodgson* |/ database administrator/ | mallesons stephen jaques
> *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907
> *E* mailto:mike.hodgson@.mallesons.nospam.com |* W*
> http://www.mallesons.com
>
> 00allen_iverson wrote:
>>I cannot start the sqlserver agent neither manually or automatically and I
>>get this message in the event log:
>>SQLServerAgent could not be started (reason: Unable to connect to server
>>'(local)'; SQLServerAgent cannot start).
>>Can anyone please help? Thanks.
>>
>>
--010604090704090006030404
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Open SQL Enterprise Manager. Expand the branches to expose your
local instance. Left-click on the local instance; this will establish
a client connection (SQLEM being the client) to your server. If that
is successful then your SQL server is running and accepting client
connections.<br>
<br>
Expand the + next to the server name. Expand the + next to
Management. Right-click on SQL Server Agent and select the property
menu option. This will bring up the configuration dialog box for SQL
Agent.<br>
<br>
Click on the last tab (Connection). This will tell you how SQLAgent is
attempting to connect to the SQL server instance.<br>
<br>
(I'm sure this basic GUI config stuff is described in SQL Books
Online...like here for instance:<br>
<a class="moz-txt-link-freetext" href="http://links.10026.com/?link=http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_automate_01et.asp</a>)<br>">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_automate_01et.asp">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_automate_01et.asp</a>)<br>
</tt>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font> </span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2"> database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2"> jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font face="Tahoma"
size="2"> +61 (2) 9296 3668 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2"> F</font></b><font face="Tahoma" size="2"> +61
(2) 9296 3885 |</font><b><font face="Tahoma"> </font><font
face="Tahoma" size="2">M</font></b><font face="Tahoma" size="2"> +61
(408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma" size="2">
<a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">
mailto:mike.hodgson@.mallesons.nospam.com</a> |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=/">http://www.mallesons.com">
http://www.mallesons.com</a></font></span> </p>
</div>
<br>
<br>
00allen_iverson wrote:
<blockquote cite="mideGEYJXZYFHA.2128@.TK2MSFTNGP14.phx.gbl" type="cite">
<title></title>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<meta content="MSHTML 6.00.2900.2604" name="GENERATOR">
<style></style>
<div><font face="Arial" size="2">How can I find out the SQLagent
configuration of trust connection or standard SQL login? And how can I
get help from this. Thanks.</font></div>
<div> </div>
<blockquote
style="border-left: 2px solid rgb(0, 0, 0); padding-right: 0px; padding-left: 5px; margin-left: 5px; margin-right: 0px;"
dir="ltr">
<div>"Mike Hodgson" <<a
href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mike.hodgson@.mallesons.nospam.com</a>>
wrote in message <a href="http://links.10026.com/?link=news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl">news:u0rF7QZYFHA.4060@.TK2MSFTNGP10.phx.gbl</a>...</div>
<tt>Is your local SQL Server instance running? </tt><tt>Can you
connect to your SQL instance using a different tool (like Query
Analyser or osql.exe) and the same login (be it a SQL login or a
trusted connection) that your instance of SQLAgent is configured to
use? Is SQLAgent configured to use a trusted connection or a standard
SQL login?</tt><br>
<div class="moz-signature">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span><b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"> <font face="Tahoma"
size="2">|</font><i><font face="Tahoma"> </font><font face="Tahoma"
size="2">database administrator</font></i><font face="Tahoma" size="2">
| mallesons</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">stephen</font><font face="Tahoma"> </font><font face="Tahoma"
size="2">jaques</font><font face="Tahoma"><br>
</font><b><font face="Tahoma" size="2">T</font></b><font
face="Tahoma" size="2"> +61 (2) 9296 3668 |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">F</font></b><font
face="Tahoma" size="2"> +61 (2) 9296 3885 |</font><b><font
face="Tahoma"> </font><font face="Tahoma" size="2">M</font></b><font
face="Tahoma" size="2"> +61 (408) 675 907</font><br>
<b><font face="Tahoma" size="2">E</font></b><font face="Tahoma"
size="2"> <a href="http://links.10026.com/?link=mailto:mike.hodgson@.mallesons.nospam.com">mailto:mike.hodgson@.mallesons.nospam.com</a>
|</font><b><font face="Tahoma"> </font><font face="Tahoma" size="2">W</font></b><font
face="Tahoma" size="2"> <a href="http://links.10026.com/?link=http://www.mallesons.com</a></font></span>">http://www.mallesons.com">http://www.mallesons.com</a></font></span>
</p>
</div>
<br>
<br>
00allen_iverson wrote:
<blockquote cite="mideM3MWIZYFHA.1404@.TK2MSFTNGP09.phx.gbl"
type="cite">
<pre wrap="">I cannot start the sqlserver agent neither manually or automatically and I
get this message in the event log:
SQLServerAgent could not be started (reason: Unable to connect to server
'(local)'; SQLServerAgent cannot start).
Can anyone please help? Thanks.
</pre>
</blockquote>
</blockquote>
</blockquote>
</body>
</html>
--010604090704090006030404--
Cannot Start SQL Server Agent
Whenever I attempt to start SQL Server Agent I get the following error message: "An error 5 - (Access is denied) occurred while performing this service operation on the SQLServerAgent service"
I log in to the SQL Server as 'sa'. What could be the possible problem?Originally posted by AlveenX
Whenever I attempt to start SQL Server Agent I get the following error message: "An error 5 - (Access is denied) occurred while performing this service operation on the SQLServerAgent service"
I log in to the SQL Server as 'sa'. What could be the possible problem?
What user is set to startup the SQLAgent service? This user must be added in SQLServer logins and give system administrator rights over the SQLServer.
ionut|||The easy way (i think), on Services, try to put the service starting with the "local system account"|||SQL Server uses a windows account to start the sql server agent service. This user should have preferably administrator rights on the machine where the sql server resides. This user can be a local user ( in that case "local system account" is best, as pal19 already mentioned) or, if the sql server has to communicate with other (sql) servers, a domain user account.
You can change the user account that is used in the enterprise manager. Go to management --> sql server agent --> right click and select properties --> general tab. You can also go to the services tab in the Windows administrative tools and change the properties of the sql server agent service there.|||Thanks Jora, Pal19 and Ionut Calin. SQL Server Agent has eventually started. Thanks so much for your help.
AlveenX
I log in to the SQL Server as 'sa'. What could be the possible problem?Originally posted by AlveenX
Whenever I attempt to start SQL Server Agent I get the following error message: "An error 5 - (Access is denied) occurred while performing this service operation on the SQLServerAgent service"
I log in to the SQL Server as 'sa'. What could be the possible problem?
What user is set to startup the SQLAgent service? This user must be added in SQLServer logins and give system administrator rights over the SQLServer.
ionut|||The easy way (i think), on Services, try to put the service starting with the "local system account"|||SQL Server uses a windows account to start the sql server agent service. This user should have preferably administrator rights on the machine where the sql server resides. This user can be a local user ( in that case "local system account" is best, as pal19 already mentioned) or, if the sql server has to communicate with other (sql) servers, a domain user account.
You can change the user account that is used in the enterprise manager. Go to management --> sql server agent --> right click and select properties --> general tab. You can also go to the services tab in the Windows administrative tools and change the properties of the sql server agent service there.|||Thanks Jora, Pal19 and Ionut Calin. SQL Server Agent has eventually started. Thanks so much for your help.
AlveenX
Saturday, February 25, 2012
Cannot start sql agent in 2005
I get this message when I try to start a sql 2005 server agent. Im
running windows 2003 service pack 1 and sql 2005 service pack 1. The
strange thing is the agent and sql service are running as a domain
account with sysadmin privileges.
Can anyone help?
SQLServerAgent could not be started (reason: SQLServerAgent must be
able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a
member of the SysAdmin role).You can see the login attributes used by Agent if you in SSMS right-click Agent, the Connection
page. Make sure that this account/login exists and a login in SQL Server and that it has sysadmin
privileges in SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Blakmk" <M.G.Blakey@.googlemail.com> wrote in message
news:1162379472.947639.182570@.b28g2000cwb.googlegroups.com...
>I get this message when I try to start a sql 2005 server agent. Im
> running windows 2003 service pack 1 and sql 2005 service pack 1. The
> strange thing is the agent and sql service are running as a domain
> account with sysadmin privileges.
> Can anyone help?
> SQLServerAgent could not be started (reason: SQLServerAgent must be
> able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a
> member of the SysAdmin role).
>
running windows 2003 service pack 1 and sql 2005 service pack 1. The
strange thing is the agent and sql service are running as a domain
account with sysadmin privileges.
Can anyone help?
SQLServerAgent could not be started (reason: SQLServerAgent must be
able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a
member of the SysAdmin role).You can see the login attributes used by Agent if you in SSMS right-click Agent, the Connection
page. Make sure that this account/login exists and a login in SQL Server and that it has sysadmin
privileges in SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Blakmk" <M.G.Blakey@.googlemail.com> wrote in message
news:1162379472.947639.182570@.b28g2000cwb.googlegroups.com...
>I get this message when I try to start a sql 2005 server agent. Im
> running windows 2003 service pack 1 and sql 2005 service pack 1. The
> strange thing is the agent and sql service are running as a domain
> account with sysadmin privileges.
> Can anyone help?
> SQLServerAgent could not be started (reason: SQLServerAgent must be
> able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a
> member of the SysAdmin role).
>
Cannot start sql agent in 2005
I get this message when I try to start a sql 2005 server agent. Im
running windows 2003 service pack 1 and sql 2005 service pack 1. The
strange thing is the agent and sql service are running as a domain
account with sysadmin privileges.
Can anyone help?
SQLServerAgent could not be started (reason: SQLServerAgent must be
able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a
member of the SysAdmin role).You can see the login attributes used by Agent if you in SSMS right-click Ag
ent, the Connection
page. Make sure that this account/login exists and a login in SQL Server and
that it has sysadmin
privileges in SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Blakmk" <M.G.Blakey@.googlemail.com> wrote in message
news:1162379472.947639.182570@.b28g2000cwb.googlegroups.com...
>I get this message when I try to start a sql 2005 server agent. Im
> running windows 2003 service pack 1 and sql 2005 service pack 1. The
> strange thing is the agent and sql service are running as a domain
> account with sysadmin privileges.
> Can anyone help?
> SQLServerAgent could not be started (reason: SQLServerAgent must be
> able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a
> member of the SysAdmin role).
>
running windows 2003 service pack 1 and sql 2005 service pack 1. The
strange thing is the agent and sql service are running as a domain
account with sysadmin privileges.
Can anyone help?
SQLServerAgent could not be started (reason: SQLServerAgent must be
able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a
member of the SysAdmin role).You can see the login attributes used by Agent if you in SSMS right-click Ag
ent, the Connection
page. Make sure that this account/login exists and a login in SQL Server and
that it has sysadmin
privileges in SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Blakmk" <M.G.Blakey@.googlemail.com> wrote in message
news:1162379472.947639.182570@.b28g2000cwb.googlegroups.com...
>I get this message when I try to start a sql 2005 server agent. Im
> running windows 2003 service pack 1 and sql 2005 service pack 1. The
> strange thing is the agent and sql service are running as a domain
> account with sysadmin privileges.
> Can anyone help?
> SQLServerAgent could not be started (reason: SQLServerAgent must be
> able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a
> member of the SysAdmin role).
>
cannot start more transactions on this session
when I modify data in Enterprise manager, I get the message
"cannot start more transactions on this session"
Why?Is the data your modifying contained within a view rather than a table..?
--
HTH
Ryan Waight, MCDBA, MCSE
"haode" <iamjhkang@.hotmail.com> wrote in message
news:enVQjp1oDHA.1740@.TK2MSFTNGP12.phx.gbl...
> when I modify data in Enterprise manager, I get the message
> "cannot start more transactions on this session"
> Why?
>|||It is a table for sure.
"Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:uepb573oDHA.3256@.tk2msftngp13.phx.gbl...
> Is the data your modifying contained within a view rather than a table..?
> --
> HTH
> Ryan Waight, MCDBA, MCSE
> "haode" <iamjhkang@.hotmail.com> wrote in message
> news:enVQjp1oDHA.1740@.TK2MSFTNGP12.phx.gbl...
> > when I modify data in Enterprise manager, I get the message
> > "cannot start more transactions on this session"
> >
> > Why?
> >
> >
>
"cannot start more transactions on this session"
Why?Is the data your modifying contained within a view rather than a table..?
--
HTH
Ryan Waight, MCDBA, MCSE
"haode" <iamjhkang@.hotmail.com> wrote in message
news:enVQjp1oDHA.1740@.TK2MSFTNGP12.phx.gbl...
> when I modify data in Enterprise manager, I get the message
> "cannot start more transactions on this session"
> Why?
>|||It is a table for sure.
"Ryan Waight" <Ryan_Waight@.nospam.hotmail.com> wrote in message
news:uepb573oDHA.3256@.tk2msftngp13.phx.gbl...
> Is the data your modifying contained within a view rather than a table..?
> --
> HTH
> Ryan Waight, MCDBA, MCSE
> "haode" <iamjhkang@.hotmail.com> wrote in message
> news:enVQjp1oDHA.1740@.TK2MSFTNGP12.phx.gbl...
> > when I modify data in Enterprise manager, I get the message
> > "cannot start more transactions on this session"
> >
> > Why?
> >
> >
>
Subscribe to:
Posts (Atom)