Error 15023: User already exists in current database

Dear Group,
Can someone please help me with this problem.
I'm trying to add a new User to a particular database but
keep getting the above error, telling me that the user
already exists in the current database. When I look in
the Permissions in the database Properties, the only
user/role is public.
What can I do?
Maree.You have orphaned users to the syslogins table in the master database (EM doesn't show such). I
assume you did an attach or restore of the database...
Read about sp_change_users_login and/or use a GUI on top of the proc available at www.dbmaint.com,
free utilities.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Maree" <eeramstu@.yahoo.com.au> wrote in message news:0f8001c387b9$7d459ec0$a101280a@.phx.gbl...
> Dear Group,
> Can someone please help me with this problem.
> I'm trying to add a new User to a particular database but
> keep getting the above error, telling me that the user
> already exists in the current database. When I look in
> the Permissions in the database Properties, the only
> user/role is public.
> What can I do?
> Maree.|||Thank you so much Tibor!!
>--Original Message--
>You have orphaned users to the syslogins table in the
master database (EM doesn't show such). I
>assume you did an attach or restore of the database...
>Read about sp_change_users_login and/or use a GUI on top
of the proc available at www.dbmaint.com,
>free utilities.
>--
>Tibor Karaszi, SQL Server MVP
>Archive at: http://groups.google.com/groups?oi=djq&as
ugroup=microsoft.public.sqlserver
>
>"Maree" <eeramstu@.yahoo.com.au> wrote in message
news:0f8001c387b9$7d459ec0$a101280a@.phx.gbl...
>> Dear Group,
>> Can someone please help me with this problem.
>> I'm trying to add a new User to a particular database
but
>> keep getting the above error, telling me that the user
>> already exists in the current database. When I look in
>> the Permissions in the database Properties, the only
>> user/role is public.
>> What can I do?
>> Maree.
>
>.
>sql

Error 1068

Dear friends hi,
I read the articles you mentioned, and as I understood,
the resolution is:
(To resolve the problem, use these steps:
Change the startup account of both the MSSQLSERVER and
SQLServerAgent to use the Local System account.
Restart the computer. )
As I told you before, the problem is that I can not start
the 'SqlServer' and 'SqlServer agent', so I cann't go and
change the startup account. I don't know, I may be
confused, but I just encountered this Error (Error 1068)
while starting up the SQLServer.
Thanks for any suggestion in advance,
Mattew

>--Original Message--
Mattew,
Hmmm. Probably means that something changed. Here is
one KB article. Does
it apply?
http://support.microsoft.com/default.aspx?scid=kb;en-
us;307288
A more general article (non-SQL Server) on the topic:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;827328
Russell Fields
"Mattew" <anonymous@.discussions.microsoft.com> wrote in
message
news:19d5001c44d8c$610cb740$a401280a@.phx
.gbl...
Hi,
I'm getting the following error message:
(
Could not start the SQLServerAgent Serviceon local
computer
Error 1068 : The dependency service or group failed to
start
)
This server is a subscriber in a transactional
replication and it was working until yesterday.
Does anybody have a solution.
Thanks in advance.Hi,
Steps to change the service startup account:-
1. Go to control panel -- Administrative - tools
2. Double click in services icon
3. Select and double click the MSSQL Server Service
4. In the "Log on " tab, Check the this account
5. There you verify the OS user name
6. If the user name is correct , re- enter the password and confrim password
once again
7. CLick OK
8. Start the Service
Do the above steps for SQL Agent Service as well.
Note:
ON each password change you have to do the above steps. The best
recommendation to have a user name for MSSQL server Service startup which do
not chage password frequently or no password expiry is set.
Thanks
Hari
MCDBA
"Mattew" <anonymous@.discussions.microsoft.com> wrote in message
news:1a4a701c44e42$10919180$a401280a@.phx
.gbl...
> Dear friends hi,
> I read the articles you mentioned, and as I understood,
> the resolution is:
> (To resolve the problem, use these steps:
> Change the startup account of both the MSSQLSERVER and
> SQLServerAgent to use the Local System account.
> Restart the computer. )
> As I told you before, the problem is that I can not start
> the 'SqlServer' and 'SqlServer agent', so I cann't go and
> change the startup account. I don't know, I may be
> confused, but I just encountered this Error (Error 1068)
> while starting up the SQLServer.
> Thanks for any suggestion in advance,
> Mattew
>
> Mattew,
> Hmmm. Probably means that something changed. Here is
> one KB article. Does
> it apply?
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;307288
> A more general article (non-SQL Server) on the topic:
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;827328
> Russell Fields
> "Mattew" <anonymous@.discussions.microsoft.com> wrote in
> message
> news:19d5001c44d8c$610cb740$a401280a@.phx
.gbl...
> Hi,
> I'm getting the following error message:
> (
> Could not start the SQLServerAgent Serviceon local
> computer
> Error 1068 : The dependency service or group failed to
> start
> )
> This server is a subscriber in a transactional
> replication and it was working until yesterday.
> Does anybody have a solution.
> Thanks in advance.|||OMG. What a horrible message to come in to work to!
I just read about changing the startup account in CPanel.
The only thing I would want to toss in is that if you
make login changes at the CPanel level, rather then
Enterprise Mgr, you will have a ton o' problems related
to reg entries and internal stuff.
To sidestep that, if you ARE able to get the server
started using a CPanel change, can you then go into EM
and change it in there under your server's
properties/security page? Kind of a "redundant change?"
ML

>--Original Message--
>Hi,
>Steps to change the service startup account:-
>1. Go to control panel -- Administrative - tools
>2. Double click in services icon
>3. Select and double click the MSSQL Server Service
>4. In the "Log on " tab, Check the this account
>5. There you verify the OS user name
>6. If the user name is correct , re- enter the password
and confrim password
>once again
>7. CLick OK
>8. Start the Service
>Do the above steps for SQL Agent Service as well.
>Note:
>ON each password change you have to do the above steps.
The best
>recommendation to have a user name for MSSQL server
Service startup which do
>not chage password frequently or no password expiry is
set.
>Thanks
>Hari
>MCDBA
>
>
>"Mattew" <anonymous@.discussions.microsoft.com> wrote in
message
> news:1a4a701c44e42$10919180$a401280a@.phx
.gbl...
start[vbcol=seagreen]
and[vbcol=seagreen]
1068)[vbcol=seagreen]
>
>.
>

Error 1068

Dear friends hi,
I read the articles you mentioned, and as I understood,
the resolution is:
(To resolve the problem, use these steps:
Change the startup account of both the MSSQLSERVER and
SQLServerAgent to use the Local System account.
Restart the computer. )
As I told you before, the problem is that I can not start
the 'SqlServer' and 'SqlServer agent', so I cann't go and
change the startup account. I don't know, I may be
confused, but I just encountered this Error (Error 1068)
while starting up the SQLServer.
Thanks for any suggestion in advance,
Mattew
>--Original Message--
Mattew,
Hmmm. Probably means that something changed. Here is
one KB article. Does
it apply?
http://support.microsoft.com/default.aspx?scid=kb;en-
us;307288
A more general article (non-SQL Server) on the topic:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;827328
Russell Fields
"Mattew" <anonymous@.discussions.microsoft.com> wrote in
message
news:19d5001c44d8c$610cb740$a401280a@.phx.gbl...
Hi,
I'm getting the following error message:
(
Could not start the SQLServerAgent Serviceon local
computer
Error 1068 : The dependency service or group failed to
start
)
This server is a subscriber in a transactional
replication and it was working until yesterday.
Does anybody have a solution.
Thanks in advance.Hi,
Steps to change the service startup account:-
1. Go to control panel -- Administrative - tools
2. Double click in services icon
3. Select and double click the MSSQL Server Service
4. In the "Log on " tab, Check the this account
5. There you verify the OS user name
6. If the user name is correct , re- enter the password and confrim password
once again
7. CLick OK
8. Start the Service
Do the above steps for SQL Agent Service as well.
Note:
ON each password change you have to do the above steps. The best
recommendation to have a user name for MSSQL server Service startup which do
not chage password frequently or no password expiry is set.
Thanks
Hari
MCDBA
"Mattew" <anonymous@.discussions.microsoft.com> wrote in message
news:1a4a701c44e42$10919180$a401280a@.phx.gbl...
> Dear friends hi,
> I read the articles you mentioned, and as I understood,
> the resolution is:
> (To resolve the problem, use these steps:
> Change the startup account of both the MSSQLSERVER and
> SQLServerAgent to use the Local System account.
> Restart the computer. )
> As I told you before, the problem is that I can not start
> the 'SqlServer' and 'SqlServer agent', so I cann't go and
> change the startup account. I don't know, I may be
> confused, but I just encountered this Error (Error 1068)
> while starting up the SQLServer.
> Thanks for any suggestion in advance,
> Mattew
> >--Original Message--
> Mattew,
> Hmmm. Probably means that something changed. Here is
> one KB article. Does
> it apply?
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;307288
> A more general article (non-SQL Server) on the topic:
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;827328
> Russell Fields
> "Mattew" <anonymous@.discussions.microsoft.com> wrote in
> message
> news:19d5001c44d8c$610cb740$a401280a@.phx.gbl...
> Hi,
> I'm getting the following error message:
> (
> Could not start the SQLServerAgent Serviceon local
> computer
> Error 1068 : The dependency service or group failed to
> start
> )
> This server is a subscriber in a transactional
> replication and it was working until yesterday.
> Does anybody have a solution.
> Thanks in advance.|||OMG. What a horrible message to come in to work to!
I just read about changing the startup account in CPanel.
The only thing I would want to toss in is that if you
make login changes at the CPanel level, rather then
Enterprise Mgr, you will have a ton o' problems related
to reg entries and internal stuff.
To sidestep that, if you ARE able to get the server
started using a CPanel change, can you then go into EM
and change it in there under your server's
properties/security page? Kind of a "redundant change?"
ML
>--Original Message--
>Hi,
>Steps to change the service startup account:-
>1. Go to control panel -- Administrative - tools
>2. Double click in services icon
>3. Select and double click the MSSQL Server Service
>4. In the "Log on " tab, Check the this account
>5. There you verify the OS user name
>6. If the user name is correct , re- enter the password
and confrim password
>once again
>7. CLick OK
>8. Start the Service
>Do the above steps for SQL Agent Service as well.
>Note:
>ON each password change you have to do the above steps.
The best
>recommendation to have a user name for MSSQL server
Service startup which do
>not chage password frequently or no password expiry is
set.
>Thanks
>Hari
>MCDBA
>
>
>"Mattew" <anonymous@.discussions.microsoft.com> wrote in
message
>news:1a4a701c44e42$10919180$a401280a@.phx.gbl...
>> Dear friends hi,
>> I read the articles you mentioned, and as I understood,
>> the resolution is:
>> (To resolve the problem, use these steps:
>> Change the startup account of both the MSSQLSERVER and
>> SQLServerAgent to use the Local System account.
>> Restart the computer. )
>> As I told you before, the problem is that I can not
start
>> the 'SqlServer' and 'SqlServer agent', so I cann't go
and
>> change the startup account. I don't know, I may be
>> confused, but I just encountered this Error (Error
1068)
>> while starting up the SQLServer.
>> Thanks for any suggestion in advance,
>> Mattew
>> >--Original Message--
>> Mattew,
>> Hmmm. Probably means that something changed. Here is
>> one KB article. Does
>> it apply?
>> http://support.microsoft.com/default.aspx?scid=kb;en-
>> us;307288
>> A more general article (non-SQL Server) on the topic:
>> http://support.microsoft.com/default.aspx?scid=kb;en-
>> us;827328
>> Russell Fields
>> "Mattew" <anonymous@.discussions.microsoft.com> wrote in
>> message
>> news:19d5001c44d8c$610cb740$a401280a@.phx.gbl...
>> Hi,
>> I'm getting the following error message:
>> (
>> Could not start the SQLServerAgent Serviceon local
>> computer
>> Error 1068 : The dependency service or group failed to
>> start
>> )
>> This server is a subscriber in a transactional
>> replication and it was working until yesterday.
>> Does anybody have a solution.
>> Thanks in advance.
>
>.
>

Error 1068

Dear friends hi,
I read the articles you mentioned, and as I understood,
the resolution is:
(To resolve the problem, use these steps:
Change the startup account of both the MSSQLSERVER and
SQLServerAgent to use the Local System account.
Restart the computer. )
As I told you before, the problem is that I can not start
the 'SqlServer' and 'SqlServer agent', so I cann't go and
change the startup account. I don't know, I may be
confused, but I just encountered this Error (Error 1068)
while starting up the SQLServer.
Thanks for any suggestion in advance,
Mattew

>--Original Message--
Mattew,
Hmmm. Probably means that something changed. Here is
one KB article. Does
it apply?
http://support.microsoft.com/default.aspx?scid=kb;en-
us;307288
A more general article (non-SQL Server) on the topic:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;827328
Russell Fields
"Mattew" <anonymous@.discussions.microsoft.com> wrote in
message
news:19d5001c44d8c$610cb740$a401280a@.phx.gbl...
Hi,
I'm getting the following error message:
(
Could not start the SQLServerAgent Serviceon local
computer
Error 1068 : The dependency service or group failed to
start
)
This server is a subscriber in a transactional
replication and it was working until yesterday.
Does anybody have a solution.
Thanks in advance.
Hi,
Steps to change the service startup account:-
1. Go to control panel -- Administrative - tools
2. Double click in services icon
3. Select and double click the MSSQL Server Service
4. In the "Log on " tab, Check the this account
5. There you verify the OS user name
6. If the user name is correct , re- enter the password and confrim password
once again
7. CLick OK
8. Start the Service
Do the above steps for SQL Agent Service as well.
Note:
ON each password change you have to do the above steps. The best
recommendation to have a user name for MSSQL server Service startup which do
not chage password frequently or no password expiry is set.
Thanks
Hari
MCDBA
"Mattew" <anonymous@.discussions.microsoft.com> wrote in message
news:1a4a701c44e42$10919180$a401280a@.phx.gbl...
> Dear friends hi,
> I read the articles you mentioned, and as I understood,
> the resolution is:
> (To resolve the problem, use these steps:
> Change the startup account of both the MSSQLSERVER and
> SQLServerAgent to use the Local System account.
> Restart the computer. )
> As I told you before, the problem is that I can not start
> the 'SqlServer' and 'SqlServer agent', so I cann't go and
> change the startup account. I don't know, I may be
> confused, but I just encountered this Error (Error 1068)
> while starting up the SQLServer.
> Thanks for any suggestion in advance,
> Mattew
> Mattew,
> Hmmm. Probably means that something changed. Here is
> one KB article. Does
> it apply?
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;307288
> A more general article (non-SQL Server) on the topic:
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;827328
> Russell Fields
> "Mattew" <anonymous@.discussions.microsoft.com> wrote in
> message
> news:19d5001c44d8c$610cb740$a401280a@.phx.gbl...
> Hi,
> I'm getting the following error message:
> (
> Could not start the SQLServerAgent Serviceon local
> computer
> Error 1068 : The dependency service or group failed to
> start
> )
> This server is a subscriber in a transactional
> replication and it was working until yesterday.
> Does anybody have a solution.
> Thanks in advance.
|||OMG. What a horrible message to come in to work to!
I just read about changing the startup account in CPanel.
The only thing I would want to toss in is that if you
make login changes at the CPanel level, rather then
Enterprise Mgr, you will have a ton o' problems related
to reg entries and internal stuff.
To sidestep that, if you ARE able to get the server
started using a CPanel change, can you then go into EM
and change it in there under your server's
properties/security page? Kind of a "redundant change?"
ML

>--Original Message--
>Hi,
>Steps to change the service startup account:-
>1. Go to control panel -- Administrative - tools
>2. Double click in services icon
>3. Select and double click the MSSQL Server Service
>4. In the "Log on " tab, Check the this account
>5. There you verify the OS user name
>6. If the user name is correct , re- enter the password
and confrim password
>once again
>7. CLick OK
>8. Start the Service
>Do the above steps for SQL Agent Service as well.
>Note:
>ON each password change you have to do the above steps.
The best
>recommendation to have a user name for MSSQL server
Service startup which do
>not chage password frequently or no password expiry is
set.
>Thanks
>Hari
>MCDBA
>
>
>"Mattew" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:1a4a701c44e42$10919180$a401280a@.phx.gbl...
start[vbcol=seagreen]
and[vbcol=seagreen]
1068)
>
>.
>

Error : 15457

Dear USer,
I am getting Error 15457 in my production server. I
have SQL Server 2000 install in production
Please do needful
Regards,
Deepak
Hi,
It is just an informational message, not really an error message. If you
change your server properties or if you view them in Enterprise Manager, you
will see this message in the SQL Server Error log.
So dont worry.
Thanks
Hari
MCDBA
"Deepak Sharma" <anonymous@.discussions.microsoft.com> wrote in message
news:2500001c45ffc$83889460$a401280a@.phx.gbl...
> Dear USer,
> I am getting Error 15457 in my production server. I
> have SQL Server 2000 install in production
> Please do needful
> Regards,
> Deepak

Error : 15457

Dear USer,
I am getting Error 15457 in my production server. I
have SQL Server 2000 install in production
Please do needful
Regards,
DeepakHi,
It is just an informational message, not really an error message. If you
change your server properties or if you view them in Enterprise Manager, you
will see this message in the SQL Server Error log.
So dont worry.
--
Thanks
Hari
MCDBA
"Deepak Sharma" <anonymous@.discussions.microsoft.com> wrote in message
news:2500001c45ffc$83889460$a401280a@.phx.gbl...
> Dear USer,
> I am getting Error 15457 in my production server. I
> have SQL Server 2000 install in production
> Please do needful
> Regards,
> Deepak

Error : 15457

Dear USer,
I am getting Error 15457 in my production server. I
have SQL Server 2000 install in production
Please do needful
Regards,
DeepakHi,
It is just an informational message, not really an error message. If you
change your server properties or if you view them in Enterprise Manager, you
will see this message in the SQL Server Error log.
So dont worry.
Thanks
Hari
MCDBA
"Deepak Sharma" <anonymous@.discussions.microsoft.com> wrote in message
news:2500001c45ffc$83889460$a401280a@.phx
.gbl...
> Dear USer,
> I am getting Error 15457 in my production server. I
> have SQL Server 2000 install in production
> Please do needful
> Regards,
> Deepak

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