Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mulhollandm
Starting Member
1 Post |
 Posted - 2008-08-19 : 10:44:43
|
| folksi have sql server 2005 installed on server 2003 and an new application which requires i connect to the dbase - the connection is made from the app to the local serverwhen i try the connection it failsmy application documentation states that i need an account in the dbcreator creator but i can't find this group in local users and groupsis the sql server installed in the right mode - apparently i need a mixed mode or support for sql authenticationthanks to anyone taking the time to help and apologies for the post if its basic but i have little or no sql server knowledgethanks |
|
|
stephenbaer
Yak Posting Veteran
71 Posts |
Posted - 2008-08-19 : 11:53:04
|
| Does the application that makes the connection use Windows Authentication (different for every user) or a single sql login (same for every user)?-----------------Stephen |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-20 : 00:02:49
|
| dbcreator is server role inside sql server. |
|
|
|
|
|
|
SQL server 2005 & user accounts