Rename AD group
Mon, 21 Jul 2008 16:18:51 -0400
Hi,
Our Active Directory team renamed a group name from DOMAIN\GROUP1 to
DOMAIN\GROUP2. Although everything is Ok on Windows side (All references to
DOMAIN\GROUP1 is changed to DOMAIN\GROUP2 for example in local admin), SQL
Server still shows DOMAIN\GROUP1 in its login list and sp_validatelogins
reports D ...
|
Question: How to secure SQL ERP Dtabase on Network
Mon, 21 Jul 2008 13:18:07 -0700
Hello's
We have an ERP app whose data store is SQL. A front end web application has
been created that will write data to this SQL database. From a security
standpoint I'm worried about exposing the ERP database to the front end web
application.
What are the best practices for such situations? I have read a f ...
|
MS08-040
Mon, 21 Jul 2008 12:29:01 -0700
we like to deploy the SQL2000 GDRand QFE fixes to our servers thru silent
mode , is there any way to deterime the buildlevel (either 2039 or 2187) from
the registry so that we can apply the appropriate fix for GDR/QFE ?
we know we can connect to SQL interactivley and check the buildlevel by
select serverprop ...
|
how to find out who has db_owner rights through all the logins
Mon, 21 Jul 2008 09:02:09 -0700
Hi,
I found some of the users who has db_owner right, I'm afraid that more
people have it. Is there a way to find them using a script?
Thanks a lot,
Sarah ...
|
Modify default database of all logins
Sun, 20 Jul 2008 18:01:29 -0300
I need to modify the default database of all logins.
Is there a way to do it using Transact-SQL?
Thanks,
Felipe
...
|
Master database must never be the default database for any login
Sun, 20 Jul 2008 17:59:47 -0300
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?
For example, I would like to have all my logins pointing to MODEL database
by default, unless we change ...
|
Windows Vista Enterprise and SQL Server 2005 Agent
Sat, 19 Jul 2008 18:06:47 -0500
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.
Anyway, to get to my questionn. I ...
|
|
|
[DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security e
Fri, 18 Jul 2008 06:38:04 -0700
Hello,
We recently performed a server migration of a server that functions as both
a web server and database server. The OS is Windows Server 2003. The SQL
Server is running SQL Server 2005. The web site is not configured to use
SSL. Every two days or so on an intermittent basis, users accessing the site
...
|
Microsoft RMS Shopping Cart Integration
Fri, 18 Jul 2008 04:07:37 -0700
RMScart is an eCommerce Cart solution that completely and seamlessly
integrates with Microsoft Retail Management System (RMS).
Our Microsoft RMS integrated Shopping Cart solution?s standard features
far exceed those of any other Retail Management System - compatible Web
Integration and Authoring Application. ...
|
SQL Server Agent - Error 1326
Wed, 16 Jul 2008 13:37:00 -0700
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.
It hangs reporting the error 1326. What do I have to do to resolve this?
...
|
