database configuration application
Windows Server Forum Index Windows Server
Server discussion on Windows platform.
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web winserverhelp.com
database configuration application

 
Post new topic   Reply to topic    Windows Server Forum Index -> CMS Server
Author Message
JJ
Guest
Posted: Mon Nov 07, 2005 9:51 am    Post subject: database configuration application Reply with quote
The DCA showed a
failed: sql state: '28000' Sql server error: 18456 login failed XXXX when I
tried using a user with db rights to the DB for connection.

Is there anything which I miss out?
1. I had add a user with rights to write, read and admin the database
2. The database is a local database
3. i used the userID and password to connect to the database

Thanks.
Back to top
Stefan [MSFT]
Guest
Posted: Mon Nov 07, 2005 5:50 pm    Post subject: Re: database configuration application Reply with quote
Hi JJ,

the user running the DCA needs to have DBO rights on the MCMS database and
needs to be able to login to SQL server.
If you are giving credentials (SQL authentication) you need to ensure that
the given user has DBO rights.

Cheers,
Stefan

--
This posting is provided "AS IS" with no warranties, and confers no rights

New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
----------------------


"JJ" <JJ@discussions.microsoft.com> wrote in message
news:B75CA82D-CDAD-4197-8C6F-DD1BDD3715C8@microsoft.com...
Quote:
The DCA showed a
failed: sql state: '28000' Sql server error: 18456 login failed XXXX when
I
tried using a user with db rights to the DB for connection.

Is there anything which I miss out?
1. I had add a user with rights to write, read and admin the database
2. The database is a local database
3. i used the userID and password to connect to the database

Thanks.
Back to top
JJ
Guest
Posted: Tue Nov 08, 2005 1:50 am    Post subject: Re: database configuration application Reply with quote
Hi Stefan,

Thanks for the reply. I know where I got it wrong. It had to be SQL
authentication as you had mentioned to access instead of windows login in
authenication right?

Thanks!

"Stefan [MSFT]" wrote:

Quote:
Hi JJ,

the user running the DCA needs to have DBO rights on the MCMS database and
needs to be able to login to SQL server.
If you are giving credentials (SQL authentication) you need to ensure that
the given user has DBO rights.

Cheers,
Stefan

--
This posting is provided "AS IS" with no warranties, and confers no rights

New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
----------------------


"JJ" <JJ@discussions.microsoft.com> wrote in message
news:B75CA82D-CDAD-4197-8C6F-DD1BDD3715C8@microsoft.com...
The DCA showed a
failed: sql state: '28000' Sql server error: 18456 login failed XXXX when
I
tried using a user with db rights to the DB for connection.

Is there anything which I miss out?
1. I had add a user with rights to write, read and admin the database
2. The database is a local database
3. i used the userID and password to connect to the database

Thanks.


Back to top
Stefan [MSFT]
Guest
Posted: Tue Nov 08, 2005 9:51 am    Post subject: Re: database configuration application Reply with quote
Hi JJ,

as indicated before: it depends if you entered credentials in the DCA or
not. If you entered credentials, then these credentials need to be SQL login
credentials and not windows credentials.

Cheers,
Stefan

--
This posting is provided "AS IS" with no warranties, and confers no rights

New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
----------------------


"JJ" <JJ@discussions.microsoft.com> wrote in message
news:72074075-5BF4-4DC3-AE07-327B14A00D4A@microsoft.com...
Quote:
Hi Stefan,

Thanks for the reply. I know where I got it wrong. It had to be SQL
authentication as you had mentioned to access instead of windows login in
authenication right?

Thanks!

"Stefan [MSFT]" wrote:

Hi JJ,

the user running the DCA needs to have DBO rights on the MCMS database
and
needs to be able to login to SQL server.
If you are giving credentials (SQL authentication) you need to ensure
that
the given user has DBO rights.

Cheers,
Stefan

--
This posting is provided "AS IS" with no warranties, and confers no
rights

New to MCMS?
Check out this book: Building Websites Using MCMS:
http://tinyurl.com/6zj44
----------------------


"JJ" <JJ@discussions.microsoft.com> wrote in message
news:B75CA82D-CDAD-4197-8C6F-DD1BDD3715C8@microsoft.com...
The DCA showed a
failed: sql state: '28000' Sql server error: 18456 login failed XXXX
when
I
tried using a user with db rights to the DB for connection.

Is there anything which I miss out?
1. I had add a user with rights to write, read and admin the database
2. The database is a local database
3. i used the userID and password to connect to the database

Thanks.


Back to top
 
Post new topic   Reply to topic    Windows Server Forum Index -> CMS Server All times are GMT
Page 1 of 1

 
 You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum




New Topics Powered by phpBB