I’m a third party developer and my database gets installed on all types of
network setups.  I can’t control the active directory settings for the users
so I want to protect my database by only allowing SQL Server Authentication.
I’m using MSDE 2000.

Our Database is ignores the authentication method that is chosen in the
database connection under ODBC. Everyone is getting a log on dialog.
Can any one help! Thanks

How can you troubleshoot why it is taking so long for the databases to
display after selecting Databases? It's for ever - - - - --  -
Thanks for your help!

1. I denied some user the select permissions on some columns in a table.
However, this user is able to see these columns through the views (SQL
Server 2000). Is there a way to automatically deny the permissions on the
same columns in all the views or it's necessary to set the ...

I have a 2 node cluster that I recently installed. During the installation,
node 2 was active. After the installation of SQL 2005 and the SP1, I added
some linked servers that use SQL authentication. When I fail over to node 1,
I get the following error:

Hello,
I have problems backing up the Master key.  The message is cannot write into
file 'file path' verify that you have the write permissions.  I don't
understand why because I am using user dbo and defaul schema dbo on the

According to SQL Server 2000 Books Online, this command requires membership
in the sysadmin or db_owner role.  We have added the user to the db_owner
role of database 'master', yet the command fails and reports error 2571.  Is
this the correct database?  (The command succeeds so ...

I understand the basic difference (I think), but there's something that
doesn't make sense. Our SQL Servers are set to mixed mode
authentication. All of the third-party apps have their own logins,
which were created during install, by the vendor or per the vendor's

I have a MSSQL 2000 SP4 server.
I need to disable ability to create database diagrams for users.
How can I do this?

I configured SQL Server 2005 Express to use Windows authentication.  I want
to give ordinary users  sysadmin privileges.  How do you map Windows groups
to SQL Server logins?  There appears to be one Login, BUILTIN\Users.  Members
of the Administrators group of the machine have ...

I have a MSSQL 2000 SP4 with ~200 databases of our clients.
Each client can access only his own database, but in Enterprise Manager
he able to view all databases on server.
How can I hide all other databases from client?

I have a server login Jans_Test.
This maps to a databaseuser Jans_Test in a database
In this database I have a schema AT. Default schema for Jans_Test is AT.
I also have a Database role db_dealer created in SQL with

I have a question.
How can I use 'sp_grantlogin' with full domain name?
I tried use sp_grantlogin 'KAROLINA.CZ\pavel' but I get this error message:
Windows NT user or group 'KAROLINA.CZ\pavel' not found. Check the name

I have a new software package that is running on SQL 2005 Standard. I am
attempting to install a webportal module to the software.
When granting the webportal module access to the SQL DB should I use Windows
Authentication or SQL Server Authentication? I am interested in the ...

I have problem with respect to "alter login" on Windows user groups (created
via Active Directory).
If I execute the statement "alter login [domain\groupname] enable" I get an
exception saying (the exception also occurs with "alter login