This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Can I use drag and drop from sql 2000 database and the security is not trusted to the model (security is standard). |
|
|
|
|
I'm not sure what you mean by "security is standard." When using a native SQL Server connection, I believe we would support both integrated (Windows) authentication and SQL Server (username/password) authentication. However VS2010 does not support native SQL Server connections to SQL Server 2000, only OLE DB connections, and in this case we currently support only integrated security. If your problem is SQL Server authentication in VS2010, we can investigate how easy that would be to add -- let us know! |
|
|
|
|
That was my question if you only support integrated security for SQL Server 2000, but only for the model, not for runtime right? |
|
|
|
|
Right. When dragging and dropping from Server Explorer in VS2010, we support only integrated security. At all other times, we support both integrated and SQL Server security. |
|
|
|
