sql-authentication

SQL 2005 User Instances and SQL Authentication

Can I use SQL Authentication with User Instances? ...

How to Suppress SQL Authentication

Hello, I am really stumped on this, I am not sure if someone can at least point me in the right direction? I have an MS Access Reporting Application. It has a few local tables in it but predominantly relies on tables from a SQL Server 2005 database that it links to. It links to the SQL DB via a System DSN. I have built a function th...

Attaching catalog with SQL Authentication credentials attaches it as Read-Only

Hello, As part of our product's installation process, a database is attached to the server. We use EXEC sp_attach_db in order to attach it to MSSQL. The problem occures when we try to attach it with "SQL Authentication" connection string - the database is attached to the server as read-only, thus preventing any write access from being ...

SQL Server 2005 Remote Login Permissions

I have a user Sql Authentication account that has remote access to my database server. The user has a default database, and is only able to access or modify that DB. So far so good. However, I'd like to prevent the user from viewing the other databases that he doesn't have access to anyway. Inside server permissions, I can deny the u...

C# connect to domain SQL Server 2005 from non-domain machine

Hi, I asked a question a few days ago (http://stackoverflow.com/questions/2795723/access-to-sql-server-2005-from-a-non-domain-machine-using-windows-authentication) which got some interesting, but not usable suggestions. I'd like to ask the question again, but make clear what my constraints are: I have a Windows domain within which a mac...