Hi All
I have a SQL Server 2005 Standard Edition on SP1 where the Re-Index
Maintenance task normally takes 5 minutes however every now and then the job
will take over 8 hours to complete.
Can anyone point me in the right direction to identify how to identify why
the re-index takes so long?
I have scripted the maintenance plan and listed below is a sample of the
re-index
ALTER INDEX [pk_Account] ON [dbo].[Account] REBUILD WITH ( PAD_INDEX = OFF,
STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON,
SORT_IN_TEMPDB = OFF, ONLINE = OFF )
Thanks
David
How big is database? Any activities on the server while you are running MP?
"David" <David@.discussions.microsoft.com> wrote in message
news:44134DDF-BCC0-4130-BE08-B053231876BA@.microsoft.com...
> Hi All
> I have a SQL Server 2005 Standard Edition on SP1 where the Re-Index
> Maintenance task normally takes 5 minutes however every now and then the
> job
> will take over 8 hours to complete.
> Can anyone point me in the right direction to identify how to identify why
> the re-index takes so long?
> I have scripted the maintenance plan and listed below is a sample of the
> re-index
> ALTER INDEX [pk_Account] ON [dbo].[Account] REBUILD WITH ( PAD_INDEX =
> OFF,
> STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS =
> ON,
> SORT_IN_TEMPDB = OFF, ONLINE = OFF )
> Thanks
|||Is there a long-running transaction that's holding a lock on the table? That
may prevent the index rebuild acquiring the locks it requires.
Paul Randal
Principal Lead Program Manager
Microsoft SQL Server Core Storage Engine,
http://blogs.msdn.com/sqlserverstorageengine/default.aspx
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23ycFxx7tHHA.4800@.TK2MSFTNGP05.phx.gbl...
> David
> How big is database? Any activities on the server while you are running
> MP?
>
>
> "David" <David@.discussions.microsoft.com> wrote in message
> news:44134DDF-BCC0-4130-BE08-B053231876BA@.microsoft.com...
>
Showing posts with label sp1. Show all posts
Showing posts with label sp1. Show all posts
Wednesday, March 28, 2012
Long Running Re-Index Task
Hi All
I have a SQL Server 2005 Standard Edition on SP1 where the Re-Index
Maintenance task normally takes 5 minutes however every now and then the job
will take over 8 hours to complete.
Can anyone point me in the right direction to identify how to identify why
the re-index takes so long?
I have scripted the maintenance plan and listed below is a sample of the
re-index
ALTER INDEX [pk_Account] ON [dbo].[Account] REBUILD WITH ( PAD_INDEX = OFF,
STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON,
SORT_IN_TEMPDB = OFF, ONLINE = OFF )
ThanksDavid
How big is database? Any activities on the server while you are running MP?
"David" <David@.discussions.microsoft.com> wrote in message
news:44134DDF-BCC0-4130-BE08-B053231876BA@.microsoft.com...
> Hi All
> I have a SQL Server 2005 Standard Edition on SP1 where the Re-Index
> Maintenance task normally takes 5 minutes however every now and then the
> job
> will take over 8 hours to complete.
> Can anyone point me in the right direction to identify how to identify why
> the re-index takes so long?
> I have scripted the maintenance plan and listed below is a sample of the
> re-index
> ALTER INDEX [pk_Account] ON [dbo].[Account] REBUILD WITH ( PAD_INDEX => OFF,
> STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS => ON,
> SORT_IN_TEMPDB = OFF, ONLINE = OFF )
> Thanks|||Is there a long-running transaction that's holding a lock on the table? That
may prevent the index rebuild acquiring the locks it requires.
--
Paul Randal
Principal Lead Program Manager
Microsoft SQL Server Core Storage Engine,
http://blogs.msdn.com/sqlserverstorageengine/default.aspx
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23ycFxx7tHHA.4800@.TK2MSFTNGP05.phx.gbl...
> David
> How big is database? Any activities on the server while you are running
> MP?
>
>
> "David" <David@.discussions.microsoft.com> wrote in message
> news:44134DDF-BCC0-4130-BE08-B053231876BA@.microsoft.com...
>> Hi All
>> I have a SQL Server 2005 Standard Edition on SP1 where the Re-Index
>> Maintenance task normally takes 5 minutes however every now and then the
>> job
>> will take over 8 hours to complete.
>> Can anyone point me in the right direction to identify how to identify
>> why
>> the re-index takes so long?
>> I have scripted the maintenance plan and listed below is a sample of the
>> re-index
>> ALTER INDEX [pk_Account] ON [dbo].[Account] REBUILD WITH ( PAD_INDEX =>> OFF,
>> STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS =>> ON,
>> SORT_IN_TEMPDB = OFF, ONLINE = OFF )
>> Thanks
>
I have a SQL Server 2005 Standard Edition on SP1 where the Re-Index
Maintenance task normally takes 5 minutes however every now and then the job
will take over 8 hours to complete.
Can anyone point me in the right direction to identify how to identify why
the re-index takes so long?
I have scripted the maintenance plan and listed below is a sample of the
re-index
ALTER INDEX [pk_Account] ON [dbo].[Account] REBUILD WITH ( PAD_INDEX = OFF,
STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON,
SORT_IN_TEMPDB = OFF, ONLINE = OFF )
ThanksDavid
How big is database? Any activities on the server while you are running MP?
"David" <David@.discussions.microsoft.com> wrote in message
news:44134DDF-BCC0-4130-BE08-B053231876BA@.microsoft.com...
> Hi All
> I have a SQL Server 2005 Standard Edition on SP1 where the Re-Index
> Maintenance task normally takes 5 minutes however every now and then the
> job
> will take over 8 hours to complete.
> Can anyone point me in the right direction to identify how to identify why
> the re-index takes so long?
> I have scripted the maintenance plan and listed below is a sample of the
> re-index
> ALTER INDEX [pk_Account] ON [dbo].[Account] REBUILD WITH ( PAD_INDEX => OFF,
> STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS => ON,
> SORT_IN_TEMPDB = OFF, ONLINE = OFF )
> Thanks|||Is there a long-running transaction that's holding a lock on the table? That
may prevent the index rebuild acquiring the locks it requires.
--
Paul Randal
Principal Lead Program Manager
Microsoft SQL Server Core Storage Engine,
http://blogs.msdn.com/sqlserverstorageengine/default.aspx
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23ycFxx7tHHA.4800@.TK2MSFTNGP05.phx.gbl...
> David
> How big is database? Any activities on the server while you are running
> MP?
>
>
> "David" <David@.discussions.microsoft.com> wrote in message
> news:44134DDF-BCC0-4130-BE08-B053231876BA@.microsoft.com...
>> Hi All
>> I have a SQL Server 2005 Standard Edition on SP1 where the Re-Index
>> Maintenance task normally takes 5 minutes however every now and then the
>> job
>> will take over 8 hours to complete.
>> Can anyone point me in the right direction to identify how to identify
>> why
>> the re-index takes so long?
>> I have scripted the maintenance plan and listed below is a sample of the
>> re-index
>> ALTER INDEX [pk_Account] ON [dbo].[Account] REBUILD WITH ( PAD_INDEX =>> OFF,
>> STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS =>> ON,
>> SORT_IN_TEMPDB = OFF, ONLINE = OFF )
>> Thanks
>
Long Running Re-Index Task
Hi All
I have a SQL Server 2005 Standard Edition on SP1 where the Re-Index
Maintenance task normally takes 5 minutes however every now and then the job
will take over 8 hours to complete.
Can anyone point me in the right direction to identify how to identify why
the re-index takes so long?
I have scripted the maintenance plan and listed below is a sample of the
re-index
ALTER INDEX [pk_Account] ON [dbo].[Account] REBUILD WITH ( PAD_I
NDEX = OFF,
STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON
,
SORT_IN_TEMPDB = OFF, ONLINE = OFF )
ThanksDavid
How big is database? Any activities on the server while you are running MP?
"David" <David@.discussions.microsoft.com> wrote in message
news:44134DDF-BCC0-4130-BE08-B053231876BA@.microsoft.com...
> Hi All
> I have a SQL Server 2005 Standard Edition on SP1 where the Re-Index
> Maintenance task normally takes 5 minutes however every now and then the
> job
> will take over 8 hours to complete.
> Can anyone point me in the right direction to identify how to identify why
> the re-index takes so long?
> I have scripted the maintenance plan and listed below is a sample of the
> re-index
> ALTER INDEX [pk_Account] ON [dbo].[Account] REBUILD WITH ( PAD
_INDEX =
> OFF,
> STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS =
> ON,
> SORT_IN_TEMPDB = OFF, ONLINE = OFF )
> Thanks|||Is there a long-running transaction that's holding a lock on the table? That
may prevent the index rebuild acquiring the locks it requires.
Paul Randal
Principal Lead Program Manager
Microsoft SQL Server Core Storage Engine,
http://blogs.msdn.com/sqlserverstor...ne/default.aspx
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23ycFxx7tHHA.4800@.TK2MSFTNGP05.phx.gbl...
> David
> How big is database? Any activities on the server while you are running
> MP?
>
>
> "David" <David@.discussions.microsoft.com> wrote in message
> news:44134DDF-BCC0-4130-BE08-B053231876BA@.microsoft.com...
>
I have a SQL Server 2005 Standard Edition on SP1 where the Re-Index
Maintenance task normally takes 5 minutes however every now and then the job
will take over 8 hours to complete.
Can anyone point me in the right direction to identify how to identify why
the re-index takes so long?
I have scripted the maintenance plan and listed below is a sample of the
re-index
ALTER INDEX [pk_Account] ON [dbo].[Account] REBUILD WITH ( PAD_I
NDEX = OFF,
STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON
,
SORT_IN_TEMPDB = OFF, ONLINE = OFF )
ThanksDavid
How big is database? Any activities on the server while you are running MP?
"David" <David@.discussions.microsoft.com> wrote in message
news:44134DDF-BCC0-4130-BE08-B053231876BA@.microsoft.com...
> Hi All
> I have a SQL Server 2005 Standard Edition on SP1 where the Re-Index
> Maintenance task normally takes 5 minutes however every now and then the
> job
> will take over 8 hours to complete.
> Can anyone point me in the right direction to identify how to identify why
> the re-index takes so long?
> I have scripted the maintenance plan and listed below is a sample of the
> re-index
> ALTER INDEX [pk_Account] ON [dbo].[Account] REBUILD WITH ( PAD
_INDEX =
> OFF,
> STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS =
> ON,
> SORT_IN_TEMPDB = OFF, ONLINE = OFF )
> Thanks|||Is there a long-running transaction that's holding a lock on the table? That
may prevent the index rebuild acquiring the locks it requires.
Paul Randal
Principal Lead Program Manager
Microsoft SQL Server Core Storage Engine,
http://blogs.msdn.com/sqlserverstor...ne/default.aspx
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23ycFxx7tHHA.4800@.TK2MSFTNGP05.phx.gbl...
> David
> How big is database? Any activities on the server while you are running
> MP?
>
>
> "David" <David@.discussions.microsoft.com> wrote in message
> news:44134DDF-BCC0-4130-BE08-B053231876BA@.microsoft.com...
>
Monday, March 19, 2012
Logon failed during timed subscriptions
Hello,
Environment: Win2003 server SP1, IIS 6.0, SQL Server 2000 SP4, Reporting
services 2000 SP2.
Reporting services using account of sql server authentycation with logon
name of 'sa' and password.
Executing reports from manager working fine, but timed subscriptions failing
on execution with the following error: 'Logon failed'.
RS log file has the following messages:
e!notification!1094!05/11/2007-03:23:05:: e ERROR: Error occured processing
notification. Logon failed.
ReportingServicesService!notification!1094!05/11/2007-03:23:05::
Notification 63d3f301-ff48-4fc2-9697-578eaf02d5da completed. Success: False,
Status: Logon failed., DeliveryExtension: Report Server Email, Report: Batch
Inventory-tmp, Attempt 0
ReportingServicesService!dbpolling!1094!05/11/2007-03:23:05::
NotificationPolling finished processing item
63d3f301-ff48-4fc2-9697-578eaf02d5da
ReportingServicesServic
Dears, what caused notification problems:
is it problems with scheduled jobs or is it authentycation problems with SMTP?
How to see (or somehow extract) more detailed log from RS?
Thanks,
Andrius.Update:
Reporting services Unattended Execution Account using sql server
authentycation method with logon name of 'sa' and password.
"Andrius" wrote:
> Hello,
> Environment: Win2003 server SP1, IIS 6.0, SQL Server 2000 SP4, Reporting
> services 2000 SP2.
> Reporting services using account of sql server authentycation with logon
> name of 'sa' and password.
> Executing reports from manager working fine, but timed subscriptions failing
> on execution with the following error: 'Logon failed'.
> RS log file has the following messages:
> e!notification!1094!05/11/2007-03:23:05:: e ERROR: Error occured processing
> notification. Logon failed.
> ReportingServicesService!notification!1094!05/11/2007-03:23:05::
> Notification 63d3f301-ff48-4fc2-9697-578eaf02d5da completed. Success: False,
> Status: Logon failed., DeliveryExtension: Report Server Email, Report: Batch
> Inventory-tmp, Attempt 0
> ReportingServicesService!dbpolling!1094!05/11/2007-03:23:05::
> NotificationPolling finished processing item
> 63d3f301-ff48-4fc2-9697-578eaf02d5da
> ReportingServicesServic
> Dears, what caused notification problems:
> is it problems with scheduled jobs or is it authentycation problems with SMTP?
> How to see (or somehow extract) more detailed log from RS?
> Thanks,
> Andrius.
>
Environment: Win2003 server SP1, IIS 6.0, SQL Server 2000 SP4, Reporting
services 2000 SP2.
Reporting services using account of sql server authentycation with logon
name of 'sa' and password.
Executing reports from manager working fine, but timed subscriptions failing
on execution with the following error: 'Logon failed'.
RS log file has the following messages:
e!notification!1094!05/11/2007-03:23:05:: e ERROR: Error occured processing
notification. Logon failed.
ReportingServicesService!notification!1094!05/11/2007-03:23:05::
Notification 63d3f301-ff48-4fc2-9697-578eaf02d5da completed. Success: False,
Status: Logon failed., DeliveryExtension: Report Server Email, Report: Batch
Inventory-tmp, Attempt 0
ReportingServicesService!dbpolling!1094!05/11/2007-03:23:05::
NotificationPolling finished processing item
63d3f301-ff48-4fc2-9697-578eaf02d5da
ReportingServicesServic
Dears, what caused notification problems:
is it problems with scheduled jobs or is it authentycation problems with SMTP?
How to see (or somehow extract) more detailed log from RS?
Thanks,
Andrius.Update:
Reporting services Unattended Execution Account using sql server
authentycation method with logon name of 'sa' and password.
"Andrius" wrote:
> Hello,
> Environment: Win2003 server SP1, IIS 6.0, SQL Server 2000 SP4, Reporting
> services 2000 SP2.
> Reporting services using account of sql server authentycation with logon
> name of 'sa' and password.
> Executing reports from manager working fine, but timed subscriptions failing
> on execution with the following error: 'Logon failed'.
> RS log file has the following messages:
> e!notification!1094!05/11/2007-03:23:05:: e ERROR: Error occured processing
> notification. Logon failed.
> ReportingServicesService!notification!1094!05/11/2007-03:23:05::
> Notification 63d3f301-ff48-4fc2-9697-578eaf02d5da completed. Success: False,
> Status: Logon failed., DeliveryExtension: Report Server Email, Report: Batch
> Inventory-tmp, Attempt 0
> ReportingServicesService!dbpolling!1094!05/11/2007-03:23:05::
> NotificationPolling finished processing item
> 63d3f301-ff48-4fc2-9697-578eaf02d5da
> ReportingServicesServic
> Dears, what caused notification problems:
> is it problems with scheduled jobs or is it authentycation problems with SMTP?
> How to see (or somehow extract) more detailed log from RS?
> Thanks,
> Andrius.
>
Monday, February 20, 2012
Login problem
Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4. No
we are experiencing som strange problems. If we login to a klient with a
local account, open query analyzer and try to login using 'sql server
authentication', it does not work 'access denied or server does not exist'.
When looking in the security log on the sql server, we can see logon attempts
by the local account from the client computer?! If logon to the same client
with a domain account, everything works fine. My belief was that when using
'sql server auth', windows security had nothing to do with it.. am I wrong.
Thanks for Your help!
Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server, properties, security.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Erik" <Erik@.discussions.microsoft.com> wrote in message
news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
> Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4. No
> we are experiencing som strange problems. If we login to a klient with a
> local account, open query analyzer and try to login using 'sql server
> authentication', it does not work 'access denied or server does not exist'.
> When looking in the security log on the sql server, we can see logon attempts
> by the local account from the client computer?! If logon to the same client
> with a domain account, everything works fine. My belief was that when using
> 'sql server auth', windows security had nothing to do with it.. am I wrong.
> Thanks for Your help!
|||Hi Tibor,
Thanks for your your reply.
The server is set up in mixed mode.
Strangly enough, if I connect to a share on the sql server with a domain
account (still logged on with a local account), I have no problem connecting
with the sql login I used earlier...
I've heard rumors that others are also experiencing this problem after
applying sp4. Anyhow, I've registered a case with Microsoft, I'll get back
with their reply.
By the way Tibor, I'm attending one of your classes at cornerstone on nov
4th, see you there :-)
Regards,
Erik
"Tibor Karaszi" wrote:
> Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server, properties, security.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Erik" <Erik@.discussions.microsoft.com> wrote in message
> news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
>
|||Hej Erik,
Perhaps IPC$ has anything to do with it? If you are using Named Pipes, you need to be able to use
IPC$ (at least this is how it used to work, not sure whether it changed). And perhaps you don't get
this validation at the Windows level when you login locally? You can check Client Network Utility on
the client whether you are using NP or IP Sockets.
See you in Nov :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Erik" <Erik@.discussions.microsoft.com> wrote in message
news:046970B4-5E32-42CA-812C-7183D197E76B@.microsoft.com...[vbcol=seagreen]
> Hi Tibor,
> Thanks for your your reply.
> The server is set up in mixed mode.
> Strangly enough, if I connect to a share on the sql server with a domain
> account (still logged on with a local account), I have no problem connecting
> with the sql login I used earlier...
> I've heard rumors that others are also experiencing this problem after
> applying sp4. Anyhow, I've registered a case with Microsoft, I'll get back
> with their reply.
> By the way Tibor, I'm attending one of your classes at cornerstone on nov
> 4th, see you there :-)
> Regards,
> Erik
> "Tibor Karaszi" wrote:
we are experiencing som strange problems. If we login to a klient with a
local account, open query analyzer and try to login using 'sql server
authentication', it does not work 'access denied or server does not exist'.
When looking in the security log on the sql server, we can see logon attempts
by the local account from the client computer?! If logon to the same client
with a domain account, everything works fine. My belief was that when using
'sql server auth', windows security had nothing to do with it.. am I wrong.
Thanks for Your help!
Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server, properties, security.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Erik" <Erik@.discussions.microsoft.com> wrote in message
news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
> Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4. No
> we are experiencing som strange problems. If we login to a klient with a
> local account, open query analyzer and try to login using 'sql server
> authentication', it does not work 'access denied or server does not exist'.
> When looking in the security log on the sql server, we can see logon attempts
> by the local account from the client computer?! If logon to the same client
> with a domain account, everything works fine. My belief was that when using
> 'sql server auth', windows security had nothing to do with it.. am I wrong.
> Thanks for Your help!
|||Hi Tibor,
Thanks for your your reply.
The server is set up in mixed mode.
Strangly enough, if I connect to a share on the sql server with a domain
account (still logged on with a local account), I have no problem connecting
with the sql login I used earlier...
I've heard rumors that others are also experiencing this problem after
applying sp4. Anyhow, I've registered a case with Microsoft, I'll get back
with their reply.
By the way Tibor, I'm attending one of your classes at cornerstone on nov
4th, see you there :-)
Regards,
Erik
"Tibor Karaszi" wrote:
> Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server, properties, security.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Erik" <Erik@.discussions.microsoft.com> wrote in message
> news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
>
|||Hej Erik,
Perhaps IPC$ has anything to do with it? If you are using Named Pipes, you need to be able to use
IPC$ (at least this is how it used to work, not sure whether it changed). And perhaps you don't get
this validation at the Windows level when you login locally? You can check Client Network Utility on
the client whether you are using NP or IP Sockets.
See you in Nov :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Erik" <Erik@.discussions.microsoft.com> wrote in message
news:046970B4-5E32-42CA-812C-7183D197E76B@.microsoft.com...[vbcol=seagreen]
> Hi Tibor,
> Thanks for your your reply.
> The server is set up in mixed mode.
> Strangly enough, if I connect to a share on the sql server with a domain
> account (still logged on with a local account), I have no problem connecting
> with the sql login I used earlier...
> I've heard rumors that others are also experiencing this problem after
> applying sp4. Anyhow, I've registered a case with Microsoft, I'll get back
> with their reply.
> By the way Tibor, I'm attending one of your classes at cornerstone on nov
> 4th, see you there :-)
> Regards,
> Erik
> "Tibor Karaszi" wrote:
Login problem
Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4. No
we are experiencing som strange problems. If we login to a klient with a
local account, open query analyzer and try to login using 'sql server
authentication', it does not work 'access denied or server does not exist'.
When looking in the security log on the sql server, we can see logon attempt
s
by the local account from the client computer?! If logon to the same client
with a domain account, everything works fine. My belief was that when using
'sql server auth', windows security had nothing to do with it.. am I wrong.
Thanks for Your help!Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server, pr
operties, security.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Erik" <Erik@.discussions.microsoft.com> wrote in message
news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
> Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4.
No
> we are experiencing som strange problems. If we login to a klient with a
> local account, open query analyzer and try to login using 'sql server
> authentication', it does not work 'access denied or server does not exist'
.
> When looking in the security log on the sql server, we can see logon attem
pts
> by the local account from the client computer?! If logon to the same clien
t
> with a domain account, everything works fine. My belief was that when usin
g
> 'sql server auth', windows security had nothing to do with it.. am I wrong
.
> Thanks for Your help!|||Hi Tibor,
Thanks for your your reply.
The server is set up in mixed mode.
Strangly enough, if I connect to a share on the sql server with a domain
account (still logged on with a local account), I have no problem connecting
with the sql login I used earlier...
I've heard rumors that others are also experiencing this problem after
applying sp4. Anyhow, I've registered a case with Microsoft, I'll get back
with their reply.
By the way Tibor, I'm attending one of your classes at cornerstone on nov
4th, see you there :-)
Regards,
Erik
"Tibor Karaszi" wrote:
> Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server,
properties, security.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Erik" <Erik@.discussions.microsoft.com> wrote in message
> news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
>|||Hej Erik,
Perhaps IPC$ has anything to do with it? If you are using Named Pipes, you n
eed to be able to use
IPC$ (at least this is how it used to work, not sure whether it changed). An
d perhaps you don't get
this validation at the Windows level when you login locally? You can check C
lient Network Utility on
the client whether you are using NP or IP Sockets.
See you in Nov :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Erik" <Erik@.discussions.microsoft.com> wrote in message
news:046970B4-5E32-42CA-812C-7183D197E76B@.microsoft.com...[vbcol=seagreen]
> Hi Tibor,
> Thanks for your your reply.
> The server is set up in mixed mode.
> Strangly enough, if I connect to a share on the sql server with a domain
> account (still logged on with a local account), I have no problem connecti
ng
> with the sql login I used earlier...
> I've heard rumors that others are also experiencing this problem after
> applying sp4. Anyhow, I've registered a case with Microsoft, I'll get back
> with their reply.
> By the way Tibor, I'm attending one of your classes at cornerstone on nov
> 4th, see you there :-)
> Regards,
> Erik
> "Tibor Karaszi" wrote:
>
we are experiencing som strange problems. If we login to a klient with a
local account, open query analyzer and try to login using 'sql server
authentication', it does not work 'access denied or server does not exist'.
When looking in the security log on the sql server, we can see logon attempt
s
by the local account from the client computer?! If logon to the same client
with a domain account, everything works fine. My belief was that when using
'sql server auth', windows security had nothing to do with it.. am I wrong.
Thanks for Your help!Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server, pr
operties, security.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Erik" <Erik@.discussions.microsoft.com> wrote in message
news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
> Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4.
No
> we are experiencing som strange problems. If we login to a klient with a
> local account, open query analyzer and try to login using 'sql server
> authentication', it does not work 'access denied or server does not exist'
.
> When looking in the security log on the sql server, we can see logon attem
pts
> by the local account from the client computer?! If logon to the same clien
t
> with a domain account, everything works fine. My belief was that when usin
g
> 'sql server auth', windows security had nothing to do with it.. am I wrong
.
> Thanks for Your help!|||Hi Tibor,
Thanks for your your reply.
The server is set up in mixed mode.
Strangly enough, if I connect to a share on the sql server with a domain
account (still logged on with a local account), I have no problem connecting
with the sql login I used earlier...
I've heard rumors that others are also experiencing this problem after
applying sp4. Anyhow, I've registered a case with Microsoft, I'll get back
with their reply.
By the way Tibor, I'm attending one of your classes at cornerstone on nov
4th, see you there :-)
Regards,
Erik
"Tibor Karaszi" wrote:
> Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server,
properties, security.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Erik" <Erik@.discussions.microsoft.com> wrote in message
> news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
>|||Hej Erik,
Perhaps IPC$ has anything to do with it? If you are using Named Pipes, you n
eed to be able to use
IPC$ (at least this is how it used to work, not sure whether it changed). An
d perhaps you don't get
this validation at the Windows level when you login locally? You can check C
lient Network Utility on
the client whether you are using NP or IP Sockets.
See you in Nov :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Erik" <Erik@.discussions.microsoft.com> wrote in message
news:046970B4-5E32-42CA-812C-7183D197E76B@.microsoft.com...[vbcol=seagreen]
> Hi Tibor,
> Thanks for your your reply.
> The server is set up in mixed mode.
> Strangly enough, if I connect to a share on the sql server with a domain
> account (still logged on with a local account), I have no problem connecti
ng
> with the sql login I used earlier...
> I've heard rumors that others are also experiencing this problem after
> applying sp4. Anyhow, I've registered a case with Microsoft, I'll get back
> with their reply.
> By the way Tibor, I'm attending one of your classes at cornerstone on nov
> 4th, see you there :-)
> Regards,
> Erik
> "Tibor Karaszi" wrote:
>
Login problem
Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4. No
we are experiencing som strange problems. If we login to a klient with a
local account, open query analyzer and try to login using 'sql server
authentication', it does not work 'access denied or server does not exist'.
When looking in the security log on the sql server, we can see logon attempts
by the local account from the client computer?! If logon to the same client
with a domain account, everything works fine. My belief was that when using
'sql server auth', windows security had nothing to do with it.. am I wrong.
Thanks for Your help!Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server, properties, security.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Erik" <Erik@.discussions.microsoft.com> wrote in message
news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
> Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4. No
> we are experiencing som strange problems. If we login to a klient with a
> local account, open query analyzer and try to login using 'sql server
> authentication', it does not work 'access denied or server does not exist'.
> When looking in the security log on the sql server, we can see logon attempts
> by the local account from the client computer?! If logon to the same client
> with a domain account, everything works fine. My belief was that when using
> 'sql server auth', windows security had nothing to do with it.. am I wrong.
> Thanks for Your help!|||Hi Tibor,
Thanks for your your reply.
The server is set up in mixed mode.
Strangly enough, if I connect to a share on the sql server with a domain
account (still logged on with a local account), I have no problem connecting
with the sql login I used earlier...
I've heard rumors that others are also experiencing this problem after
applying sp4. Anyhow, I've registered a case with Microsoft, I'll get back
with their reply.
By the way Tibor, I'm attending one of your classes at cornerstone on nov
4th, see you there :-)
Regards,
Erik
"Tibor Karaszi" wrote:
> Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server, properties, security.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Erik" <Erik@.discussions.microsoft.com> wrote in message
> news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
> > Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4. No
> > we are experiencing som strange problems. If we login to a klient with a
> > local account, open query analyzer and try to login using 'sql server
> > authentication', it does not work 'access denied or server does not exist'.
> > When looking in the security log on the sql server, we can see logon attempts
> > by the local account from the client computer?! If logon to the same client
> > with a domain account, everything works fine. My belief was that when using
> > 'sql server auth', windows security had nothing to do with it.. am I wrong.
> >
> > Thanks for Your help!
>|||Hej Erik,
Perhaps IPC$ has anything to do with it? If you are using Named Pipes, you need to be able to use
IPC$ (at least this is how it used to work, not sure whether it changed). And perhaps you don't get
this validation at the Windows level when you login locally? You can check Client Network Utility on
the client whether you are using NP or IP Sockets.
See you in Nov :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Erik" <Erik@.discussions.microsoft.com> wrote in message
news:046970B4-5E32-42CA-812C-7183D197E76B@.microsoft.com...
> Hi Tibor,
> Thanks for your your reply.
> The server is set up in mixed mode.
> Strangly enough, if I connect to a share on the sql server with a domain
> account (still logged on with a local account), I have no problem connecting
> with the sql login I used earlier...
> I've heard rumors that others are also experiencing this problem after
> applying sp4. Anyhow, I've registered a case with Microsoft, I'll get back
> with their reply.
> By the way Tibor, I'm attending one of your classes at cornerstone on nov
> 4th, see you there :-)
> Regards,
> Erik
> "Tibor Karaszi" wrote:
>> Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server, properties, security.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Erik" <Erik@.discussions.microsoft.com> wrote in message
>> news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
>> > Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4. No
>> > we are experiencing som strange problems. If we login to a klient with a
>> > local account, open query analyzer and try to login using 'sql server
>> > authentication', it does not work 'access denied or server does not exist'.
>> > When looking in the security log on the sql server, we can see logon attempts
>> > by the local account from the client computer?! If logon to the same client
>> > with a domain account, everything works fine. My belief was that when using
>> > 'sql server auth', windows security had nothing to do with it.. am I wrong.
>> >
>> > Thanks for Your help!
>>
we are experiencing som strange problems. If we login to a klient with a
local account, open query analyzer and try to login using 'sql server
authentication', it does not work 'access denied or server does not exist'.
When looking in the security log on the sql server, we can see logon attempts
by the local account from the client computer?! If logon to the same client
with a domain account, everything works fine. My belief was that when using
'sql server auth', windows security had nothing to do with it.. am I wrong.
Thanks for Your help!Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server, properties, security.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Erik" <Erik@.discussions.microsoft.com> wrote in message
news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
> Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4. No
> we are experiencing som strange problems. If we login to a klient with a
> local account, open query analyzer and try to login using 'sql server
> authentication', it does not work 'access denied or server does not exist'.
> When looking in the security log on the sql server, we can see logon attempts
> by the local account from the client computer?! If logon to the same client
> with a domain account, everything works fine. My belief was that when using
> 'sql server auth', windows security had nothing to do with it.. am I wrong.
> Thanks for Your help!|||Hi Tibor,
Thanks for your your reply.
The server is set up in mixed mode.
Strangly enough, if I connect to a share on the sql server with a domain
account (still logged on with a local account), I have no problem connecting
with the sql login I used earlier...
I've heard rumors that others are also experiencing this problem after
applying sp4. Anyhow, I've registered a case with Microsoft, I'll get back
with their reply.
By the way Tibor, I'm attending one of your classes at cornerstone on nov
4th, see you there :-)
Regards,
Erik
"Tibor Karaszi" wrote:
> Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server, properties, security.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Erik" <Erik@.discussions.microsoft.com> wrote in message
> news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
> > Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4. No
> > we are experiencing som strange problems. If we login to a klient with a
> > local account, open query analyzer and try to login using 'sql server
> > authentication', it does not work 'access denied or server does not exist'.
> > When looking in the security log on the sql server, we can see logon attempts
> > by the local account from the client computer?! If logon to the same client
> > with a domain account, everything works fine. My belief was that when using
> > 'sql server auth', windows security had nothing to do with it.. am I wrong.
> >
> > Thanks for Your help!
>|||Hej Erik,
Perhaps IPC$ has anything to do with it? If you are using Named Pipes, you need to be able to use
IPC$ (at least this is how it used to work, not sure whether it changed). And perhaps you don't get
this validation at the Windows level when you login locally? You can check Client Network Utility on
the client whether you are using NP or IP Sockets.
See you in Nov :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Erik" <Erik@.discussions.microsoft.com> wrote in message
news:046970B4-5E32-42CA-812C-7183D197E76B@.microsoft.com...
> Hi Tibor,
> Thanks for your your reply.
> The server is set up in mixed mode.
> Strangly enough, if I connect to a share on the sql server with a domain
> account (still logged on with a local account), I have no problem connecting
> with the sql login I used earlier...
> I've heard rumors that others are also experiencing this problem after
> applying sp4. Anyhow, I've registered a case with Microsoft, I'll get back
> with their reply.
> By the way Tibor, I'm attending one of your classes at cornerstone on nov
> 4th, see you there :-)
> Regards,
> Erik
> "Tibor Karaszi" wrote:
>> Perhaps SQL Server is in "Windows Only" mode? EM, right-click the server, properties, security.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> "Erik" <Erik@.discussions.microsoft.com> wrote in message
>> news:4ABD6C8E-8341-44E6-B00D-58D0BDAD7C5C@.microsoft.com...
>> > Hi all, We have installed a new Win2003Server sp1 with sql2000server sp4. No
>> > we are experiencing som strange problems. If we login to a klient with a
>> > local account, open query analyzer and try to login using 'sql server
>> > authentication', it does not work 'access denied or server does not exist'.
>> > When looking in the security log on the sql server, we can see logon attempts
>> > by the local account from the client computer?! If logon to the same client
>> > with a domain account, everything works fine. My belief was that when using
>> > 'sql server auth', windows security had nothing to do with it.. am I wrong.
>> >
>> > Thanks for Your help!
>>
Subscribe to:
Posts (Atom)