asp sql server: sp3a

Showing posts with label sp3a. Show all posts

Thursday, March 8, 2012

connection failed from client application

Hi ,
the client application used is ms access via odbc to sql server 2000 std
edition sp3a
sometimes the user just get the following error :
1 - Connection failed , SQL state : S1000 , SQL Server Error : 0 Cannot
generate SSPI context
2 - Connection failed , SQL state : HY000 , SQL Server Error : 0 Cannot
generate SSPI context
does anyone knows wat's the cause and how to resolve
if need to reinstall the odbc , how can i do that ?
tks & rdgsHi
You may want to check out
http://support.microsoft.com/kb/811889/
http://support.microsoft.com/default.aspx?scid=kb;en-us;267588
http://support.microsoft.com/default.aspx?scid=kb;en-us;814401
John
"maxzsim" wrote:
> Hi ,
> the client application used is ms access via odbc to sql server 2000 std
> edition sp3a
> sometimes the user just get the following error :
> 1 - Connection failed , SQL state : S1000 , SQL Server Error : 0 Cannot
> generate SSPI context
> 2 - Connection failed , SQL state : HY000 , SQL Server Error : 0 Cannot
> generate SSPI context
> does anyone knows wat's the cause and how to resolve
> if need to reinstall the odbc , how can i do that ?
> tks & rdgs
>

Wednesday, March 7, 2012

Connection Failed

I have added a domain global group to the local administrators group on server running sql 2000 with sp3a. The os on the server is w2k with sp4. The builtin\administrators group has sa rights. Yet members of the domain global group, after they logon to the server through a remote desktop session cannot open sql enterprise manager & connect to the local sql server (default instance). They get a message "Cannot open user default database. Login failed.." The users of the domain global group can connect to 2 other instances of of sql on the same server. The default instance is 8.00.818. The other 2 instances are 8.00.760. Thanks in advance for any advice.

*****************************************
* This message was posted via http://www.sqlmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse...7b2402cee65437e
*****************************************Mike Pavel via SQLMonster.com (forum@.SQLMonster.com) writes:
> I have added a domain global group to the local administrators group on
> server running sql 2000 with sp3a. The os on the server is w2k with sp4.
> The builtin\administrators group has sa rights. Yet members of the
> domain global group, after they logon to the server through a remote
> desktop session cannot open sql enterprise manager & connect to the
> local sql server (default instance). They get a message "Cannot open
> user default database. Login failed.." The users of the domain global
> group can connect to 2 other instances of of sql on the same server. The
> default instance is 8.00.818. The other 2 instances are 8.00.760. Thanks
> in advance for any advice.

Each login on an SQL Server has a default database. Now, if for some
reason they cannot access that database, login fails. This can be
because they don't have permission to the database or that database is
offline of non-existing.

You can use the stored procedure sp_defaultdb to change the default db
for a user. Please see Books Online for syntax.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||The domain global group is part of the nt local admins group on the server running sql which makes it part of the built\administrators group in sql which has dbo access to all the databases on the sql server. The default database does exist. Thanks for reponding to my question. Any more thoughts?

*****************************************
* A copy of the whole thread can be found at:
* http://www.sqlmonster.com/Uwe/Forum...sql-server/5079
*
* Report spam or abuse by clicking the following URL:
* http://www.sqlmonster.com/Uwe/Abuse...bfff59ba325a2b2
*****************************************|||Mike Pavel via SQLMonster.com (forum@.SQLMonster.com) writes:
> The domain global group is part of the nt local admins group on the
> server running sql which makes it part of the built\administrators group
> in sql which has dbo access to all the databases on the sql server. The
> default database does exist. Thanks for reponding to my question. Any
> more thoughts?

Well, the error message you get, usually means that the default database
is not accessible. This can be because of several reasons:

o The database does not exist.
o The user does not have permission to the database.
o The database is offline or in single-user mode.

Can they log in through Query Analyzer or OSQL? In such case, change the
registration properties in Enterprise Manager.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Saturday, February 25, 2012

connection error after 15 minutes of restart

I have a problem with ms sql 2000 installed on windows 2000 server.
Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
Last night security update pack for IE 6 with SP1 was installed on the
server (KB867801)
Since morning sql server is working for 15 minutes, then connection is
not available - I got connection error message: msg: 17, level 16, state
1, SQL Server does not exists or access denied
After restarting SQL Server all works fine for about 15 minutes.
any clue ?
regardsMike Epprecht (SQL MVP) wrote:
> Have you checked the SQL event log for errors?
> Using Query Analyzer, run sp_who or sp_who2 when the error occurs and check
> the number of connections.
> Regards
> Mike
>
> "yooyoo" wrote:
>
>>I have a problem with ms sql 2000 installed on windows 2000 server.
>>Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
>>Last night security update pack for IE 6 with SP1 was installed on the
>>server (KB867801)
>>Since morning sql server is working for 15 minutes, then connection is
>>not available - I got connection error message: msg: 17, level 16, state
>>1, SQL Server does not exists or access denied
>>After restarting SQL Server all works fine for about 15 minutes.
>>any clue ?
>>regards
I will do it in some 10 minutes - I restarted server 5 minutes ago.
In SQL Log I have errors:
server SuperSocket Info: Bind failed on TCP port 1433.
server Error: 17882, Severity: 18, State: 1
server Error accepting connection request via Net-Library 'SSNETLIB'.
Execution continuing...
server Error: 17059, Severity: 18, State: 0
server Operating system error 0: The operation completed successfully...|||yooyoo wrote:
> Mike Epprecht (SQL MVP) wrote:
>> Have you checked the SQL event log for errors?
>> Using Query Analyzer, run sp_who or sp_who2 when the error occurs and
>> check the number of connections.
>> Regards
>> Mike
>>
>> "yooyoo" wrote:
>>
>> I have a problem with ms sql 2000 installed on windows 2000 server.
>> Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
>> Last night security update pack for IE 6 with SP1 was installed on
>> the server (KB867801)
>> Since morning sql server is working for 15 minutes, then connection
>> is not available - I got connection error message: msg: 17, level 16,
>> state 1, SQL Server does not exists or access denied
>> After restarting SQL Server all works fine for about 15 minutes.
>> any clue ?
>> regards
> I will do it in some 10 minutes - I restarted server 5 minutes ago.
> In SQL Log I have errors:
> server SuperSocket Info: Bind failed on TCP port 1433.
> server Error: 17882, Severity: 18, State: 1
> server Error accepting connection request via Net-Library 'SSNETLIB'.
> Execution continuing...
> server Error: 17059, Severity: 18, State: 0
> server Operating system error 0: The operation completed successfully...
sp_who returned 31 rows|||yooyoo wrote:
> yooyoo wrote:
>> Mike Epprecht (SQL MVP) wrote:
>> Have you checked the SQL event log for errors?
>> Using Query Analyzer, run sp_who or sp_who2 when the error occurs and
>> check the number of connections.
>> Regards
>> Mike
>>
>> "yooyoo" wrote:
>>
>> I have a problem with ms sql 2000 installed on windows 2000 server.
>> Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
>> Last night security update pack for IE 6 with SP1 was installed on
>> the server (KB867801)
>> Since morning sql server is working for 15 minutes, then connection
>> is not available - I got connection error message: msg: 17, level
>> 16, state 1, SQL Server does not exists or access denied
>> After restarting SQL Server all works fine for about 15 minutes.
>> any clue ?
>> regards
>>
>> I will do it in some 10 minutes - I restarted server 5 minutes ago.
>> In SQL Log I have errors:
>> server SuperSocket Info: Bind failed on TCP port 1433.
>> server Error: 17882, Severity: 18, State: 1
>> server Error accepting connection request via Net-Library 'SSNETLIB'.
>> Execution continuing...
>> server Error: 17059, Severity: 18, State: 0
>> server Operating system error 0: The operation completed successfully...
>
> sp_who returned 31 rows
The problem was another instance running on the server. But why it all
worked ok untill IE pack ?
regards,|||yooyoo wrote:
> yooyoo wrote:
>> yooyoo wrote:
>> Mike Epprecht (SQL MVP) wrote:
>> Have you checked the SQL event log for errors?
>> Using Query Analyzer, run sp_who or sp_who2 when the error occurs
>> and check the number of connections.
>> Regards
>> Mike
>>
>> "yooyoo" wrote:
>>
>> I have a problem with ms sql 2000 installed on windows 2000 server.
>> Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
>> Last night security update pack for IE 6 with SP1 was installed on
>> the server (KB867801)
>> Since morning sql server is working for 15 minutes, then connection
>> is not available - I got connection error message: msg: 17, level
>> 16, state 1, SQL Server does not exists or access denied
>> After restarting SQL Server all works fine for about 15 minutes.
>> any clue ?
>> regards
>>
>> I will do it in some 10 minutes - I restarted server 5 minutes ago.
>> In SQL Log I have errors:
>> server SuperSocket Info: Bind failed on TCP port 1433.
>> server Error: 17882, Severity: 18, State: 1
>> server Error accepting connection request via Net-Library 'SSNETLIB'.
>> Execution continuing...
>> server Error: 17059, Severity: 18, State: 0
>> server Operating system error 0: The operation completed successfully...
>>
>> sp_who returned 31 rows
>
> The problem was another instance running on the server. But why it all
> worked ok untill IE pack ?
> regards,
>
I was too much optimistic. The nightmare started again at 8 a.m. :-(
I try to change port to somethign alse than 1433.
Hope reistall will help
regards|||Mike Epprecht (SQL MVP) wrote:
> Have you checked the SQL event log for errors?
> Using Query Analyzer, run sp_who or sp_who2 when the error occurs and check
> the number of connections.
> Regards
> Mike
>
> "yooyoo" wrote:
>
>>I have a problem with ms sql 2000 installed on windows 2000 server.
>>Sql has sp3 or sp3a installed - I am not sure if sp3a was installed
>>Last night security update pack for IE 6 with SP1 was installed on the
>>server (KB867801)
>>Since morning sql server is working for 15 minutes, then connection is
>>not available - I got connection error message: msg: 17, level 16, state
>>1, SQL Server does not exists or access denied
>>After restarting SQL Server all works fine for about 15 minutes.
>>any clue ?
>>regards
sp_who returns just 31 rows
but there huge list on port mapping like: (10 times like this)
TCP 3095 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3096 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3097 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3098 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3099 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3100 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3101 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3102 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3103 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3104 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3105 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3106 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3107 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3108 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3109 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3110 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3111 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3112 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3113 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3114 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3115 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3116 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3117 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3118 192.168.2.2 TIME WAIT 192.168.2.2:1433
TCP 3119 192.168.2.2 TIME WAIT 192.168.2.2:1433
any clue?
regards|||I have the same problem, sp_who only shows < 50 connections. Any other ideas
please?

connection error after 15 minutes of restart

Sunday, February 19, 2012

Connection between SQL Server 2000 SP3a and ODBC Driver

Database: SQL Server 2000 Developer Edition SP3a
Frontend: MS Access 2000 and Access 2003
A Custm-built Medical Records Database
I am having a problem connecting to my SQL server with certain ODBC drivers
(sqlsrv32.dll). But it only acts up on certain "forms" in the Database, in
particular ones which retrieve from lots of columns. On these forms there is
a long delay, and a little of the data is retrieved, but the rest of fields
arent. And there are no error messages.
I am trying to connect to a MS-SQL Server 2000 SP3a database through Access
2003 (frontend of database) on our only XP machine. All my NT machines
connect
easily, with no problems. A handful of Windows 2000 machines give me
problems with the newer ODBC drivers, but if i would replace the
SQLSRV32.DLL with a copy from the NT machines it would work ok.
I thought upgrading the Service Pack from SP2 to SP3a would help but that
didnt work. I cant figure out what the problem is, but it sounds (to me)
similar to what is described in (FIX 814410 -
http://support.microsoft.com/kb/814410 ) as a "memory leak"...could this be
it? but the SP upgrade didnt fix/help...
Please advise how I can fix it, or where i can look to figure out what the
problem is.
Thank you.
Hi
SQL Profiler will indicate what queries are running slow. Try running it
from Query Analyser and check out their query plan. You may also want to
look at the statistics and how often they are updated. You may also want to
check the
Also you may want to check the version of MDAC you are running on each
machine using the MDAC component checker
http://msdn.microsoft.com/data/mdac/default.aspx
John
"desimaj" <desimaj@.discussions.microsoft.com> wrote in message
news:92716878-DB7C-4479-A96C-892F313C6F6B@.microsoft.com...
> Database: SQL Server 2000 Developer Edition SP3a
> Frontend: MS Access 2000 and Access 2003
> A Custm-built Medical Records Database
> I am having a problem connecting to my SQL server with certain ODBC
> drivers
> (sqlsrv32.dll). But it only acts up on certain "forms" in the Database, in
> particular ones which retrieve from lots of columns. On these forms there
> is
> a long delay, and a little of the data is retrieved, but the rest of
> fields
> arent. And there are no error messages.
> I am trying to connect to a MS-SQL Server 2000 SP3a database through
> Access
> 2003 (frontend of database) on our only XP machine. All my NT machines
> connect
> easily, with no problems. A handful of Windows 2000 machines give me
> problems with the newer ODBC drivers, but if i would replace the
> SQLSRV32.DLL with a copy from the NT machines it would work ok.
> I thought upgrading the Service Pack from SP2 to SP3a would help but that
> didnt work. I cant figure out what the problem is, but it sounds (to me)
> similar to what is described in (FIX 814410 -
> http://support.microsoft.com/kb/814410 ) as a "memory leak"...could this
> be
> it? but the SP upgrade didnt fix/help...
> Please advise how I can fix it, or where i can look to figure out what the
> problem is.
> Thank you.
>

Connection between SQL Server 2000 SP3a and ODBC Driver

Database: SQL Server 2000 Developer Edition SP3a
Frontend: MS Access 2000 and Access 2003
A Custm-built Medical Records Database
I am having a problem connecting to my SQL server with certain ODBC drivers
(sqlsrv32.dll). But it only acts up on certain "forms" in the Database, in
particular ones which retrieve from lots of columns. On these forms there is
a long delay, and a little of the data is retrieved, but the rest of fields
arent. And there are no error messages.
I am trying to connect to a MS-SQL Server 2000 SP3a database through Access
2003 (frontend of database) on our only XP machine. All my NT machines
connect
easily, with no problems. A handful of Windows 2000 machines give me
problems with the newer ODBC drivers, but if i would replace the
SQLSRV32.DLL with a copy from the NT machines it would work ok.
I thought upgrading the Service Pack from SP2 to SP3a would help but that
didnt work. I cant figure out what the problem is, but it sounds (to me)
similar to what is described in (FIX 814410 -
http://support.microsoft.com/kb/814410 ) as a "memory leak"...could this be
it? but the SP upgrade didnt fix/help...
Please advise how I can fix it, or where i can look to figure out what the
problem is.
Thank you.Hi
SQL Profiler will indicate what queries are running slow. Try running it
from Query Analyser and check out their query plan. You may also want to
look at the statistics and how often they are updated. You may also want to
check the
Also you may want to check the version of MDAC you are running on each
machine using the MDAC component checker
http://msdn.microsoft.com/data/mdac/default.aspx
John
"desimaj" <desimaj@.discussions.microsoft.com> wrote in message
news:92716878-DB7C-4479-A96C-892F313C6F6B@.microsoft.com...
> Database: SQL Server 2000 Developer Edition SP3a
> Frontend: MS Access 2000 and Access 2003
> A Custm-built Medical Records Database
> I am having a problem connecting to my SQL server with certain ODBC
> drivers
> (sqlsrv32.dll). But it only acts up on certain "forms" in the Database, in
> particular ones which retrieve from lots of columns. On these forms there
> is
> a long delay, and a little of the data is retrieved, but the rest of
> fields
> arent. And there are no error messages.
> I am trying to connect to a MS-SQL Server 2000 SP3a database through
> Access
> 2003 (frontend of database) on our only XP machine. All my NT machines
> connect
> easily, with no problems. A handful of Windows 2000 machines give me
> problems with the newer ODBC drivers, but if i would replace the
> SQLSRV32.DLL with a copy from the NT machines it would work ok.
> I thought upgrading the Service Pack from SP2 to SP3a would help but that
> didnt work. I cant figure out what the problem is, but it sounds (to me)
> similar to what is described in (FIX 814410 -
> http://support.microsoft.com/kb/814410 ) as a "memory leak"...could this
> be
> it? but the SP upgrade didnt fix/help...
> Please advise how I can fix it, or where i can look to figure out what the
> problem is.
> Thank you.
>

Thursday, March 8, 2012

connection failed from client application

Wednesday, March 7, 2012

Connection Failed

Saturday, February 25, 2012

connection error after 15 minutes of restart

connection error after 15 minutes of restart

Sunday, February 19, 2012

Connection between SQL Server 2000 SP3a and ODBC Driver

Connection between SQL Server 2000 SP3a and ODBC Driver

asp sql server

Blog Archive

About Me