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 |
|
fuxing
Starting Member
3 Posts |
 Posted - 2008-04-01 : 16:30:10
|
| Hi All,Now i am using window authentication to login to SQL2005 Express. Everything is fine when I logged with administrator.But if I use normal user to log in, then I can not connect to SQL database, even I am using user instance. I got the error message is:Microsoft SQL Native Client (0x80004005)Invalid connection string attributeMy connection String is:Provider=SQLNCLI;Initial Catalog=***;Data Source=***;Persist Security Info=False;User Instance=True;Integrated Security=SSPI;AttachDBFileName=directory\***.mdf;"Any idea? Thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-01 : 22:51:50
|
| Did you grant db permission to that account yet? |
 |
|
|
fuxing
Starting Member
3 Posts |
Posted - 2008-04-02 : 16:14:59
|
| Yes, I did. But if I only give the user db_owner, db_datareader, db_datawriter, it still doesn't work. The way it works is that I give that user sysadmin which my customer doesn't like to do it. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-02 : 22:34:50
|
| May need in db creator server role. |
|
|
|
|
|
|
Invalid connection string attribute