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 |
|
cidr
Posting Yak Master
207 Posts |
 Posted - 2009-01-07 : 06:22:02
|
| Hi there, I've got a problem I hope someone can help me with...The most important part is the error message which relates to SQL Server, please bare with me:)I'm using InfoPath forms with a SQLI've published a InfoPath template to a SharePoint Library. The form uses data from a SQL Server database. These forms are for 2009. There are forms for 2008 which are identical, the only difference is that it's a new form library. The form library is still in the same site so I'm assuming it's inherited the same permissions that the 2008 forms have.When users open the 2008 forms, there's no problems, when users open the 2009 forms they receive this error.**********The following DataObject either cannot be created or cannot be initialized: vTRSdataAllAuditsThe query cannot be run for the following DataObject: vTRSdataAllAuditsInfoPath cannot run the specified query.[0x80004005][Microsoft OLE DB Provider for SQL Server] The server principal "ServerName\UserName" is not able to access the database "DatabaseName" under the current security context.********** I don't really know what to do as they can access the other forms which use the same data sources.Does anyone know why this is happening? Thanks in advance for any help I receive. Paul |
|
|
|
|
|
SQL Error from frontend forms