Error 18456

I got an error of login "sa" with Error 18456 Level 14 . Server A is the MSSQL Server where the database sit and the other Server B is just with MSSQL Server tool which act as a Terminal Service and have the Accounting applications.The Accounting applicat
ion unable to perform its database transfer to another application on the Terminal Service. We use Window 2003 Server. The application programs are fine. The ODBC, MSSQL and application "sa" password are identical. Any idea? Thanks
Hi
Please enable security Audit, and check the detailed error in the security
event log.
To me it looks like a double hop issue, please check the link mentioned
below
http://msdn.microsoft.com/library/de...urity_2gmm.htm
HTH
Regards
Sadeesh
This posting is provided AS IS with no warranties, and confers no rights.
"Li" <Li@.discussions.microsoft.com> wrote in message
news:391C4119-F467-4017-8D97-960644E93B91@.microsoft.com...
>I got an error of login "sa" with Error 18456 Level 14 . Server A is the
>MSSQL Server where the database sit and the other Server B is just with
>MSSQL Server tool which act as a Terminal Service and have the Accounting
>applications.The Accounting application unable to perform its database
>transfer to another application on the Terminal Service. We use Window 2003
>Server. The application programs are fine. The ODBC, MSSQL and application
>"sa" password are identical. Any idea? Thanks
>

Error 18456

I got an error of login "sa" with Error 18456 Level 14 . Server A is the MSSQL Server where the database sit and the other Server B is just with MSSQL Server tool which act as a Terminal Service and have the Accounting applications.The Accounting application unable to perform its database transfer to another application on the Terminal Service. We use Window 2003 Server. The application programs are fine. The ODBC, MSSQL and application "sa" password are identical. Any idea? ThanksHi
Please enable security Audit, and check the detailed error in the security
event log.
To me it looks like a double hop issue, please check the link mentioned
below
http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/sql/ad_security_2gmm.htm
HTH
Regards
Sadeesh
--
This posting is provided AS IS with no warranties, and confers no rights.
"Li" <Li@.discussions.microsoft.com> wrote in message
news:391C4119-F467-4017-8D97-960644E93B91@.microsoft.com...
>I got an error of login "sa" with Error 18456 Level 14 . Server A is the
>MSSQL Server where the database sit and the other Server B is just with
>MSSQL Server tool which act as a Terminal Service and have the Accounting
>applications.The Accounting application unable to perform its database
>transfer to another application on the Terminal Service. We use Window 2003
>Server. The application programs are fine. The ODBC, MSSQL and application
>"sa" password are identical. Any idea? Thanks
>sql

Error 18456

I got an error of login "sa" with Error 18456 Level 14 . Server A is the MSS
QL Server where the database sit and the other Server B is just with MSSQL S
erver tool which act as a Terminal Service and have the Accounting applicati
ons.The Accounting applicat
ion unable to perform its database transfer to another application on the Te
rminal Service. We use Window 2003 Server. The application programs are fine
. The ODBC, MSSQL and application "sa" password are identical. Any idea? Tha
nksHi
Please enable security Audit, and check the detailed error in the security
event log.
To me it looks like a double hop issue, please check the link mentioned
below
mm.htm" target="_blank">http://msdn.microsoft.com/library/d...g
mm.htm
HTH
Regards
Sadeesh
--
This posting is provided AS IS with no warranties, and confers no rights.
"Li" <Li@.discussions.microsoft.com> wrote in message
news:391C4119-F467-4017-8D97-960644E93B91@.microsoft.com...
>I got an error of login "sa" with Error 18456 Level 14 . Server A is the
>MSSQL Server where the database sit and the other Server B is just with
>MSSQL Server tool which act as a Terminal Service and have the Accounting
>applications.The Accounting application unable to perform its database
>transfer to another application on the Terminal Service. We use Window 2003
>Server. The application programs are fine. The ODBC, MSSQL and application
>"sa" password are identical. Any idea? Thanks
>

Error 1385

I do the following on my contingency boxes
exec master..xp_cmdshell 'Dir D:\*.*'
and I get
Msg 50001, Level 1, State 50001
xpsql.cpp: Error 1385 from LogonUserW on line 488
What doe sthat mean?
Not much on Google...I'd bet that the NT login being used by xp_cmdshell when you invoke it does not have permission to see what is on that drive.

-PatP|||Found this..

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=110&messageid=14962

Error !

I am using the following command but it gave me an error
dbcc checktable ('testing') with REPAIR_REBUILD
Server: Msg 195, Level 15, State 4, Line 1
'REPAIR_REBUILD' is not a recognized option.
Thanks
Noor
Hi,
I think you are executing this option (DBCC CHECKDB with REPAIR_REBUILD) in
a SQL Server
version prior to SQL 2000.
Thanks
Hari
MCDBA
"Noor" <noor@.ngsol.com> wrote in message
news:eDUdWjZXEHA.2520@.TK2MSFTNGP12.phx.gbl...
> I am using the following command but it gave me an error
> dbcc checktable ('testing') with REPAIR_REBUILD
> Server: Msg 195, Level 15, State 4, Line 1
> 'REPAIR_REBUILD' is not a recognized option.
> Thanks
> Noor
>
|||Hi,
I think you are executing this option (DBCC CHECKDB with REPAIR_REBUILD) in
a SQL Server
version prior to SQL 2000.
Thanks
Hari
MCDBA
"Noor" <noor@.ngsol.com> wrote in message
news:eDUdWjZXEHA.2520@.TK2MSFTNGP12.phx.gbl...
> I am using the following command but it gave me an error
> dbcc checktable ('testing') with REPAIR_REBUILD
> Server: Msg 195, Level 15, State 4, Line 1
> 'REPAIR_REBUILD' is not a recognized option.
> Thanks
> Noor
>
|||IN SQL 2000, you'd want to do
dbcc checktable ('mytable',REPAIR_REBUILD)
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Error

Dear All
I am getting this error during indexing on the table. What should i do to
solve this problem
Server: Msg 8946, Level 16, State 12, Line 2
Table error: Allocation page (1:48528) has invalid PFS_PAGE page header
values. Type is 0. Check type, object ID and page ID on the page.
Server: Msg 8939, Level 16, State 1, Line 1
Table error: Object ID -1, index ID 65535, page (1:48528). Test (IS_ON
(BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057 and -1.
Server: Msg 8921, Level 16, State 1, Line 1
CHECKTABLE terminated. A failure was detected while collecting facts.
Possibly tempdb out of space or a system table is inconsistent. Check
previous errors.
Server: Msg 8998, Level 16, State 1, Line 1
Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify
database ID 15 pages from (1:48528) to (1:56615). See other errors for cause
.
The repair level on the DBCC statement caused this repair to be
bypassed.
CHECKDB found 1 allocation errors and 0 consistency errors in table '(Object
ID -1)' (object ID -1).
DBCC results for 'infodrive_query'.
The repair level on the DBCC statement caused this repair to be
bypassed.
CHECKDB found 1 allocation errors and 0 consistency errors not associated
with any single object.
DBCC results for 'sysobjects'.
There are 87 rows in 1 pages for object 'sysobjects'.
CHECKDB found 2 allocation errors and 0 consistency errors in database
'Infodrive_Query'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
Thanks & regards
Manoj kumarManoj
> CHECKTABLE terminated. A failure was detected while collecting facts.
> Possibly tempdb out of space or a system table is inconsistent. Check
> previous errors.
Check these above options. I assume you don't create an index on system
table.
Identify what is the object that has corrupted index. Drop this index and
try re-create again
"Manoj" <Manoj@.discussions.microsoft.com> wrote in message
news:6C43A8D4-4FE3-4303-8E51-64D436CB33CE@.microsoft.com...
> Dear All
> I am getting this error during indexing on the table. What should i do to
> solve this problem
>
> Server: Msg 8946, Level 16, State 12, Line 2
> Table error: Allocation page (1:48528) has invalid PFS_PAGE page header
> values. Type is 0. Check type, object ID and page ID on the page.
> Server: Msg 8939, Level 16, State 1, Line 1
> Table error: Object ID -1, index ID 65535, page (1:48528). Test (IS_ON
> (BUF_IOERR, bp->bstat) && bp->berrcode) failed. Values are 2057
> and -1.
> Server: Msg 8921, Level 16, State 1, Line 1
> CHECKTABLE terminated. A failure was detected while collecting facts.
> Possibly tempdb out of space or a system table is inconsistent. Check
> previous errors.
> Server: Msg 8998, Level 16, State 1, Line 1
> Page errors on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to
> verify
> database ID 15 pages from (1:48528) to (1:56615). See other errors for
> cause.
> The repair level on the DBCC statement caused this repair to be
> bypassed.
> CHECKDB found 1 allocation errors and 0 consistency errors in table
> '(Object
> ID -1)' (object ID -1).
> DBCC results for 'infodrive_query'.
> The repair level on the DBCC statement caused this repair to be
> bypassed.
> CHECKDB found 1 allocation errors and 0 consistency errors not associated
> with any single object.
> DBCC results for 'sysobjects'.
> There are 87 rows in 1 pages for object 'sysobjects'.
> CHECKDB found 2 allocation errors and 0 consistency errors in database
> 'Infodrive_Query'.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
>
> Thanks & regards
> Manoj kumar

erron handling

Hey Gang, got one for you.
error message:
Server: Msg 137, Level 15, State 2, Line 19
Must declare the variable '@.EFFECTIVE_DATE'.
Code:
SELECT LOG_PK,
LOG_REQUESTOR,
LOG_REQ_PHONE,
LOG_CHAR_60_1,
LOG_CHAR_30_4,
LOG_CN_FK,
LOG_CREATE_DATE,
LOG_REQUEST,
(LOG_STATUS),
(LOG_TYPE),
LOG_FU_FK,
LOG_FB_PK,
LOG_LT_FK,
LOG_CREATE_DATE
FROM f_Requests
WHERE LOG_RQ_FK IS NOT NULL AND
LOG_LT_FK <> 10174 AND
LOG_RC_CODE = S
AND (LOG_MOD_DATE > @.EFFECTIVE_DATE OR
LOG_CREATE_DATE > @.EFFECTIVE_DATE)Hi Garry

Is that all the code? If so then - the error message is a good clue - you need to declare (and set) a variable called @.EFFECTIVE_DATE - probably of SmallDateTime or DateTime type (check the schema you are comparing it against).

HTH|||Gary, I gotta ask...
Almost all your previous posts have been in the recruitment forum. Why are you suddenly asking basic TSQL questions?|||You really wont to know. Almost 5 months ago I was working as with both oracle and Sql server as a dba. I've been doing this for a long time but know since the accident my memory is almost 50%. I litterly had people come to see me in the hospital and did'nt know who they are. The Dr. says it will get better. Why do you think my post stop. That's the story. I need al the help I can get to get back to were I was. This is the starting point.|||Hi Garry,
Thanks for the reply through pm.
Check this out...

declare @.EFFECTIVE_DATE datetime

set @.EFFECTIVE_DATE ='GIVE YOUR DATE HERE' -- or pass your date using
-- this variable

SELECT LOG_PK,
LOG_REQUESTOR,
LOG_REQ_PHONE,
LOG_CHAR_60_1,
LOG_CHAR_30_4,
LOG_CN_FK,
LOG_CREATE_DATE,
LOG_REQUEST,
(LOG_STATUS),
(LOG_TYPE),
LOG_FU_FK,
LOG_FB_PK,
LOG_LT_FK,
LOG_CREATE_DATE
FROM f_Requests
WHERE LOG_RQ_FK IS NOT NULL AND
LOG_LT_FK <> 10174 AND
LOG_RC_CODE = S
AND (LOG_MOD_DATE > @.EFFECTIVE_DATE OR
LOG_CREATE_DATE > @.EFFECTIVE_DATE)

Thanks again for the pm :)|||You really wont to know. Almost 5 months ago I was working as with both oracle and Sql server as a dba. I've been doing this for a long time but know since the accident my memory is almost 50%. I litterly had people come to see me in the hospital and did'nt know who they are. The Dr. says it will get better. Why do you think my post stop. That's the story. I need al the help I can get to get back to were I was. This is the starting point.
If you're being straight with us, you'll get a lot of support here. If you're not, well, gloves come off.|||yeah, it's the truth. Who want to put that out there|||Okey-doke. Post away.

Erro 15138

I have this error message while trying to remove a user.
What should I do now?
Msg 15138, Level 16, State 1, Line 2
The database principal owns a schema in the database, and cannot be dropped.
TIA,
GunRemove the schema first (DROP SCHEMA), or change the owner of the schema (ALTER AUTHORIZATION).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Gunawan" <jgun98.milis@.gmail.com> wrote in message news:u8M%23kNIXHHA.3948@.TK2MSFTNGP05.phx.gbl...
>I have this error message while trying to remove a user.
> What should I do now?
> Msg 15138, Level 16, State 1, Line 2
> The database principal owns a schema in the database, and cannot be dropped.
> TIA,
> Gun
>

Erro 15138

I have this error message while trying to remove a user.
What should I do now?
Msg 15138, Level 16, State 1, Line 2
The database principal owns a schema in the database, and cannot be dropped.
TIA,
GunRemove the schema first (DROP SCHEMA), or change the owner of the schema (AL
TER AUTHORIZATION).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Gunawan" <jgun98.milis@.gmail.com> wrote in message news:u8M%23kNIXHHA.3948@.TK2MSFTNGP05.phx
.gbl...
>I have this error message while trying to remove a user.
> What should I do now?
> Msg 15138, Level 16, State 1, Line 2
> The database principal owns a schema in the database, and cannot be droppe
d.
> TIA,
> Gun
>