| Author |
Message |
Pete G
Guest
|
 Posted:
Wed Oct 26, 2005 8:51 pm Post subject:
connecting to CMS database |
|
|
I created a table in the CMS database as I need a repository for some user
data. I need to connect to the database, do a select or insert query from a
web page. When I tried I get a login user failed error. I know I have the
correct user and password and the user is a dbowner in the database. I'm
wondering if there's a restriction in the CMS DB set-up to do this. Pls
advise. Thanks. |
|
| Back to top |
|
 |
Mark Mahacek
Guest
|
| Posted:
Wed Oct 26, 2005 8:51 pm Post subject:
Re: connecting to CMS database |
|
|
You should just create a new database on the SQL server just for your data.
If you start modifying the CMS database, Microsoft will not support any
problems that may (and probably will) occur.
--
Mark Mahacek
Merced County Office of Education
"Pete G" <PeteG@discussions.microsoft.com> wrote in message
news:17FCD42B-994A-434E-B219-DA40C4D1075B@microsoft.com...
| Quote: | I created a table in the CMS database as I need a repository for some user
data. I need to connect to the database, do a select or insert query from
a
web page. When I tried I get a login user failed error. I know I have the
correct user and password and the user is a dbowner in the database. I'm
wondering if there's a restriction in the CMS DB set-up to do this. Pls
advise. Thanks. |
|
|
| Back to top |
|
|
Stefan [MSFT]
Guest
|
| Posted:
Thu Oct 27, 2005 8:51 am Post subject:
Re: connecting to CMS database |
|
|
Hi Pete,
never touch the MCMS database! That would break the Microsoft Support
Boundaries for MCMS.
You need to keep your tables in a separate database.
See here:
http://blogs.technet.com/stefan_gossner/archive/2005/03/16/396647.aspx
Thanks,
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
----------------------
"Pete G" <PeteG@discussions.microsoft.com> wrote in message
news:17FCD42B-994A-434E-B219-DA40C4D1075B@microsoft.com...
| Quote: | I created a table in the CMS database as I need a repository for some user
data. I need to connect to the database, do a select or insert query from
a
web page. When I tried I get a login user failed error. I know I have the
correct user and password and the user is a dbowner in the database. I'm
wondering if there's a restriction in the CMS DB set-up to do this. Pls
advise. Thanks. |
|
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in