Our server is experiencing random slowdowns (for specific
inserts, updates or selects) at a certain time each week.
I've checked to make sure something else is not running
and do not see any scheduled jobs during this time. I've
captured a trace file and don't see any reason why it
would take a long time. It is not a busy time on the
server, either.
Any suggestions for some obvious things I could check?
Our environment is SQL Server 2000 with Service Pack 3 on
Windows 2000 with Service Pack 3.
TIA,
Jeanne UngerIs your database configured for auto-shrink? Is there some other activity on
your network that could be causing a slow down?
Jim
"Jeanne Unger" <anonymous@.discussions.microsoft.com> wrote in message
news:0a9601c3fb02$5f1bf540$a101280a@.phx.gbl...
> Our server is experiencing random slowdowns (for specific
> inserts, updates or selects) at a certain time each week.
> I've checked to make sure something else is not running
> and do not see any scheduled jobs during this time. I've
> captured a trace file and don't see any reason why it
> would take a long time. It is not a busy time on the
> server, either.
> Any suggestions for some obvious things I could check?
> Our environment is SQL Server 2000 with Service Pack 3 on
> Windows 2000 with Service Pack 3.
> TIA,
> Jeanne Unger|||It was configured to auto shrink, so I turned that off
yesterday. I will find out Sunday night whether or not it
made a difference.
I haven't been able to find anything on the network that
is causing the slowdown, and it is specific to this
particular database. For example, the queries usually
take 0-16 milliseconds but at 00:30 GMT it can take 3-4
minutes. No other applications that run across the
network are affected.
>--Original Message--
>Is your database configured for auto-shrink? Is there
some other activity on
>your network that could be causing a slow down?
>Jim
>"Jeanne Unger" <anonymous@.discussions.microsoft.com>
wrote in message
>news:0a9601c3fb02$5f1bf540$a101280a@.phx.gbl...
specific
week.
I've
on
>
>.
>
Showing posts with label experiencing. Show all posts
Showing posts with label experiencing. Show all posts
Wednesday, March 28, 2012
Long response time at a certain time each week
Our server is experiencing random slowdowns (for specific
inserts, updates or selects) at a certain time each week.
I've checked to make sure something else is not running
and do not see any scheduled jobs during this time. I've
captured a trace file and don't see any reason why it
would take a long time. It is not a busy time on the
server, either.
Any suggestions for some obvious things I could check?
Our environment is SQL Server 2000 with Service Pack 3 on
Windows 2000 with Service Pack 3.
TIA,
Jeanne UngerIs your database configured for auto-shrink? Is there some other activity on
your network that could be causing a slow down?
Jim
"Jeanne Unger" <anonymous@.discussions.microsoft.com> wrote in message
news:0a9601c3fb02$5f1bf540$a101280a@.phx.gbl...
> Our server is experiencing random slowdowns (for specific
> inserts, updates or selects) at a certain time each week.
> I've checked to make sure something else is not running
> and do not see any scheduled jobs during this time. I've
> captured a trace file and don't see any reason why it
> would take a long time. It is not a busy time on the
> server, either.
> Any suggestions for some obvious things I could check?
> Our environment is SQL Server 2000 with Service Pack 3 on
> Windows 2000 with Service Pack 3.
> TIA,
> Jeanne Unger|||It was configured to auto shrink, so I turned that off
yesterday. I will find out Sunday night whether or not it
made a difference.
I haven't been able to find anything on the network that
is causing the slowdown, and it is specific to this
particular database. For example, the queries usually
take 0-16 milliseconds but at 00:30 GMT it can take 3-4
minutes. No other applications that run across the
network are affected.
>--Original Message--
>Is your database configured for auto-shrink? Is there
some other activity on
>your network that could be causing a slow down?
>Jim
>"Jeanne Unger" <anonymous@.discussions.microsoft.com>
wrote in message
>news:0a9601c3fb02$5f1bf540$a101280a@.phx.gbl...
>> Our server is experiencing random slowdowns (for
specific
>> inserts, updates or selects) at a certain time each
week.
>> I've checked to make sure something else is not running
>> and do not see any scheduled jobs during this time.
I've
>> captured a trace file and don't see any reason why it
>> would take a long time. It is not a busy time on the
>> server, either.
>> Any suggestions for some obvious things I could check?
>> Our environment is SQL Server 2000 with Service Pack 3
on
>> Windows 2000 with Service Pack 3.
>> TIA,
>> Jeanne Unger
>
>.
>
inserts, updates or selects) at a certain time each week.
I've checked to make sure something else is not running
and do not see any scheduled jobs during this time. I've
captured a trace file and don't see any reason why it
would take a long time. It is not a busy time on the
server, either.
Any suggestions for some obvious things I could check?
Our environment is SQL Server 2000 with Service Pack 3 on
Windows 2000 with Service Pack 3.
TIA,
Jeanne UngerIs your database configured for auto-shrink? Is there some other activity on
your network that could be causing a slow down?
Jim
"Jeanne Unger" <anonymous@.discussions.microsoft.com> wrote in message
news:0a9601c3fb02$5f1bf540$a101280a@.phx.gbl...
> Our server is experiencing random slowdowns (for specific
> inserts, updates or selects) at a certain time each week.
> I've checked to make sure something else is not running
> and do not see any scheduled jobs during this time. I've
> captured a trace file and don't see any reason why it
> would take a long time. It is not a busy time on the
> server, either.
> Any suggestions for some obvious things I could check?
> Our environment is SQL Server 2000 with Service Pack 3 on
> Windows 2000 with Service Pack 3.
> TIA,
> Jeanne Unger|||It was configured to auto shrink, so I turned that off
yesterday. I will find out Sunday night whether or not it
made a difference.
I haven't been able to find anything on the network that
is causing the slowdown, and it is specific to this
particular database. For example, the queries usually
take 0-16 milliseconds but at 00:30 GMT it can take 3-4
minutes. No other applications that run across the
network are affected.
>--Original Message--
>Is your database configured for auto-shrink? Is there
some other activity on
>your network that could be causing a slow down?
>Jim
>"Jeanne Unger" <anonymous@.discussions.microsoft.com>
wrote in message
>news:0a9601c3fb02$5f1bf540$a101280a@.phx.gbl...
>> Our server is experiencing random slowdowns (for
specific
>> inserts, updates or selects) at a certain time each
week.
>> I've checked to make sure something else is not running
>> and do not see any scheduled jobs during this time.
I've
>> captured a trace file and don't see any reason why it
>> would take a long time. It is not a busy time on the
>> server, either.
>> Any suggestions for some obvious things I could check?
>> Our environment is SQL Server 2000 with Service Pack 3
on
>> Windows 2000 with Service Pack 3.
>> TIA,
>> Jeanne Unger
>
>.
>
Wednesday, March 21, 2012
Logon window - Another one
Hi all,
I'm experiencing problems that so many people already had...except for
the fact, that no given solution worked for me.
Some of my users are getting windows-logon-popups, when they click on a
report. Admins have no troubles, just *some* users.
I tried Adding them in the virtual server security dialog, didn't work.
I tried the IE settings, didn't solve the problem.
Does anybody have other ideas?
Regards,
Bj=F6rnAdd the report server to the INTRANET zone (you want it to pass the users
authentication credentials). The INTRANET zone by default does this.
When I say add it to the INTRANET zone, be sure to add the fully qualified
name, not just the server name.
i.e. http://reportserver.mydomain
=-Chris
"Bjorn" <bjorn.vaessen@.gmail.com> wrote in message
news:1161766822.164928.118120@.h48g2000cwc.googlegroups.com...
Hi all,
I'm experiencing problems that so many people already had...except for
the fact, that no given solution worked for me.
Some of my users are getting windows-logon-popups, when they click on a
report. Admins have no troubles, just *some* users.
I tried Adding them in the virtual server security dialog, didn't work.
I tried the IE settings, didn't solve the problem.
Does anybody have other ideas?
Regards,
Björn
I'm experiencing problems that so many people already had...except for
the fact, that no given solution worked for me.
Some of my users are getting windows-logon-popups, when they click on a
report. Admins have no troubles, just *some* users.
I tried Adding them in the virtual server security dialog, didn't work.
I tried the IE settings, didn't solve the problem.
Does anybody have other ideas?
Regards,
Bj=F6rnAdd the report server to the INTRANET zone (you want it to pass the users
authentication credentials). The INTRANET zone by default does this.
When I say add it to the INTRANET zone, be sure to add the fully qualified
name, not just the server name.
i.e. http://reportserver.mydomain
=-Chris
"Bjorn" <bjorn.vaessen@.gmail.com> wrote in message
news:1161766822.164928.118120@.h48g2000cwc.googlegroups.com...
Hi all,
I'm experiencing problems that so many people already had...except for
the fact, that no given solution worked for me.
Some of my users are getting windows-logon-popups, when they click on a
report. Admins have no troubles, just *some* users.
I tried Adding them in the virtual server security dialog, didn't work.
I tried the IE settings, didn't solve the problem.
Does anybody have other ideas?
Regards,
Björn
Wednesday, March 7, 2012
Login succeeded followed by Logon Failed
We are experiencing some strange behaviour on SQL Server 2000. Certain
members of a domain group are unable to login. The error log says something
like
2007-04-27 08:45:14.33 logon Login succeeded for user 'Accounts\joe'.
Connection: Trusted.
2007-04-27 08:45:14.33 logon Login failed for user 'Accounts\joe'.
This is only affecting certain members of the group. (The SQL Server Error
msg says the user can not access their default database).Any suggestions as
to why this might be happening.stu,
If you are granting access to the server through domain groups rather that
to individual user accounts, then Accounts\Joe may be in several groups.
If he is in a group that has been assigned a default database to which he
does not have rights, then he _may_ fail to attach to his default database.
(Why won't everyone fail? Because they are not all members of the same
group and (as far as I have been able to discover) which group will provide
the default database for the user login is not deterministic.)
Actions:
1) Check to see if any Group Logins have a default database assignment to a
database in which they have no rights. If so, correct this.
2) Explicitly set the default database for the logins that are failing.
Even though all rights will still be granted through their group
memberships, the login account default database will have priority over any
group settings.
sp_defaultdb 'Accounts\Joe', 'GoodDefaultDB'
You do not have to create an Accounts\Joe login, but the sp_defaultdb will
create one for you in this case.
RLF
"stu" <stu@.discussions.microsoft.com> wrote in message
news:F8CDE8B3-B206-473A-94C5-F6A408B61064@.microsoft.com...
> We are experiencing some strange behaviour on SQL Server 2000. Certain
> members of a domain group are unable to login. The error log says
> something
> like
> 2007-04-27 08:45:14.33 logon Login succeeded for user 'Accounts\joe'.
> Connection: Trusted.
> 2007-04-27 08:45:14.33 logon Login failed for user 'Accounts\joe'.
> This is only affecting certain members of the group. (The SQL Server Error
> msg says the user can not access their default database).Any suggestions
> as
> to why this might be happening.
members of a domain group are unable to login. The error log says something
like
2007-04-27 08:45:14.33 logon Login succeeded for user 'Accounts\joe'.
Connection: Trusted.
2007-04-27 08:45:14.33 logon Login failed for user 'Accounts\joe'.
This is only affecting certain members of the group. (The SQL Server Error
msg says the user can not access their default database).Any suggestions as
to why this might be happening.stu,
If you are granting access to the server through domain groups rather that
to individual user accounts, then Accounts\Joe may be in several groups.
If he is in a group that has been assigned a default database to which he
does not have rights, then he _may_ fail to attach to his default database.
(Why won't everyone fail? Because they are not all members of the same
group and (as far as I have been able to discover) which group will provide
the default database for the user login is not deterministic.)
Actions:
1) Check to see if any Group Logins have a default database assignment to a
database in which they have no rights. If so, correct this.
2) Explicitly set the default database for the logins that are failing.
Even though all rights will still be granted through their group
memberships, the login account default database will have priority over any
group settings.
sp_defaultdb 'Accounts\Joe', 'GoodDefaultDB'
You do not have to create an Accounts\Joe login, but the sp_defaultdb will
create one for you in this case.
RLF
"stu" <stu@.discussions.microsoft.com> wrote in message
news:F8CDE8B3-B206-473A-94C5-F6A408B61064@.microsoft.com...
> We are experiencing some strange behaviour on SQL Server 2000. Certain
> members of a domain group are unable to login. The error log says
> something
> like
> 2007-04-27 08:45:14.33 logon Login succeeded for user 'Accounts\joe'.
> Connection: Trusted.
> 2007-04-27 08:45:14.33 logon Login failed for user 'Accounts\joe'.
> This is only affecting certain members of the group. (The SQL Server Error
> msg says the user can not access their default database).Any suggestions
> as
> to why this might be happening.
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)