Last Login
Thu, 18 Mar 2010 10:58:12 -0700
I am trying to clean up a long list of old logins on in SQL Server 2005. Is
there a way that I can determine the last time a login was used?
In syslogins I see an accdate, but the documentation says that it is not
supported. ...
|
linked server security
Wed, 17 Mar 2010 20:50:01 -0700
SQL 2005 STD edition sp3 both servers
Non domain server = Server #1 = home of linked server
Server in domain using Mixed Auth. = Server #2 = linked server defined on 1.
Want to use NT auth to logon to server #2 via linked server with logon from
server #1. Have tried impersonate but only seems to work if serv ...
|
Stored Procedure with Encryption is clear text in backup
Thu, 18 Mar 2010 11:50:17 +0800
Hi,
All my stored procedures have With Encryption in place but I realise that if
I open the database backup in any text editor, these encrypted stored
procedures are in clear text!
I am using SQL Server 2008 Express. Any advice to overcome this problem,
otherwise I have to zip the backup file with passwo ...
|
Stored Procedure Security
Wed, 17 Mar 2010 18:10:01 -0700
I was under the impression that granting execute security on a stored
procedure would allow a user to run the procedure. My experience, however,
is that security must also be granted to all the tables, functions, etc...
that are used by the stored procedure. Why isn't granting execute authority
enough? ...
|
using certificate on tables
Wed, 17 Mar 2010 18:25:17 +0200
Hello there
I have database which i had to grant select on some tables for specific
users. In order to use these tables on dinamic sql.
I just found out that i can use certificate on sql 2005-2008 to allow select
on these tables from specific procedures without grant the select on that
table.
It sound ...
|
Configure SQL 2005 for Kerberos Authentication
Wed, 17 Mar 2010 00:46:01 -0700
Hi,
I'm currently trying to setup SCCM 2007 with the SCCM database on a remote
SQL 2005 SP3 server (not in the default instance)
I've configured the SPN as per this guide:
http://support.microsoft.com/kb/909801
and followed the steps in this guide for the SCCM side:
http://technet.microsoft.com/en-us/ ...
|
Backing up permissions for SQL Server 2000
Fri, 12 Mar 2010 09:56:08 -0800 (PST)
Is there a method to back up all permissions in SQL Server 2000? I am
looking for a way to get all the permissions for all of the databases,
then be able to run a query to re-populate the permissions. This is a
work around for a migration to a new domain. The tool that is used to
populate new users into SQL S ...
|
|
|
Moving Encrypted data from server to server
Tue, 9 Mar 2010 13:19:02 -0800
I have successfully restored a db from Server A to server B and then
1. OPen Master
2. Open Symmetric Key
3. Read Data ... GOOD!
The above, proved to me that I have encryption working.
I then tried and failed to move JUST a table with encrypted data into a new
database... Can someone tell me if i am ...
|
Mixed auth, but Login failed for user 'testlogin'. Not assoc with trusted sql server connection.
Mon, 8 Mar 2010 15:20:46 -0800
I have a sql server 2005 express installation which allows mixed
authentication. I created a sql server login 'testlogin' and used that
as the login for a new user 'testuser' on 'testdb'. testuser has
dataread and datawrite role on testdb.
I'm attempting to create an odbc connection to testdb with the testl ...
|
What permissions/role is required to read SQL Logs
Mon, 8 Mar 2010 09:14:01 -0800
Hello,
In our SQL Server environment, both SQL Server and the SQL agent are
configured to run under their own domain accounts. This being the case, what
permissions or roles are required to see the SQL Logs in SSMS (SQL 2K5)?
TIA,
Rich ...
|