We have an application that connects to SQL Server using Windows
authentication, and we have two AD Domain Controllers. Both DCs also run DNS,
and the SQL server is configured to point to both. However, if one of the
domain controllers becomes unavailable (the one configured ...

I am new to Windows Vista and have installed SQL Server 2005 on my machine.
One thing I have noticed is getting prompted all the time to do things I
used to be able to do without being prompt. It all seems to be related to
security things, even though I am an administrator.

By default, MASTER is the default database for any login created, unless we
change it.
Is it possible I configure SQL Server to set a default database other than
MASTER to any logins created automatically?

I have SQL Server 2000 Developer installed on Windows Vista SP1. It is build
2187. I went and grabbed the update that came out today (buy the guidelines
for version number, I needed the QFE relelase for SQL 2000 SP4). When I try
to install it, the extracring to C:\<some guid> ...

I need to modify the default database of all logins.
Is there a way to do it using Transact-SQL?
Thanks,
Felipe

I'm trying to apply KB948109, but get the following error (Windows Update)
Error Code: 0x2B22  
Try to install the update again, or request help from one of the following
resources.

Without having to recreate this processing in SSIS, I have an Access Program
which I can run by commandline.  The batch file runs Access executing a
macro.
I created a job in SQL Server 2005 with a step to Exec the MS batch file.

SQL Server 2005:
I have some Crystal Reports XI reports that prompt the user with a full database login screen (server, database, username, password). The login shows Integrated Security as turned off and the database field is blank (that is where I think the problem lies).
* The ...

For one of our servers, I am unable to connect to the SSIS instance. I have
sysadmin rights on the database server itself but connot connect to it in
SSMS. I can connect to other SSIS servers but not this one.
Any ideas?

How do you turn off the sharing to a SQL Server 2000 database.  I want to
remove the symbol of the hand holding the database(yellow cylinder) when I
view my databases.  I can't find the option.  So I am mainly looking at how
to get to that option.

I'm reorganizing users in database db1. Just simple question, however it
always confuses me.
When I chose a few permission groups, would final effective rights be AND or
OR combination of those permission? In other word, would it be most and least

I am writing a script to create a database for out application. Currently
the app attaches an mdf and ldf, but I don't like that solution.
I have a script that creates a database using sqlcmd.exe and I pass
variables to it using the -v option. It works fine.

We are in the process of attempting to issue certificates from our
Enterprise CA to use in SQL encryption.  I can not find documented anywhere
what the key attribute requirements are (Key Usage and Application Policies,
etc.) for the Certificates.  I understand that SQL Server ...

I've installed SQL Server 2005 Developer edition and SQL SP2 on a PC running
Windows Vista Business SP1.  The installation went okay (no error message
other than remind me to install SP2).  However, after installation and reboot
the PC, I can't find the SQL Server Management ...

Yesterday's Security Bulletin Advanced Notice
http://www.microsoft.com/technet/security/bulletin/ms08-jul.mspx talks about
a patch coming for SQL 7/2000/2005. Wonder if this will be in CU9 for
SQL2005? If it is extra to CU7 for SQL2005 it will make my life more