Obtain Client IP for Login Failures (SQL 2000)
Tue, 26 Aug 2008 16:18:41 -0400
Hi All,
I have been trying to find a way to obtain the IP address of a login failure
against our SQL 2000 servers, but I have been unsuccessful. SQL Profiler
gives the HostName, but not the IP address.
SQL 2000 reports only a login failure, but doesn't give a Client IP address.
Sample: Logi ...
|
User table updates are recorded as dbo instead of userid
Tue, 26 Aug 2008 12:19:03 -0700
I am working on a vb.net app that connects to a SQL Server 2005 database.
The app uses "Trusted Connection" to connect to the db and no userid/password
is passed. I am a member of a security group called "Developers". Up until
last week, when I updated a row in a database table from the app, an Audit
tabl ...
|
Windows User, Multiple group memberships, different default languages
Tue, 26 Aug 2008 05:34:31 -0700 (PDT)
Hi all,
I'm trying to fathom out whether the default language of a user is
well defined, and if so what the definition would be:
DOMAIN\User is a member of DOMAIN\Group1 and DOMAIN\Group2.
DOMAIN\Group1 and DOMAIN\Group2 are logins on the SQL Server. DOMAIN
\User is not.
DOMAIN\Group1's default language is ...
|
SSL on SQL Server
Tue, 26 Aug 2008 00:31:50 +0800
Hi,
I have read this article "http://support.microsoft.com/kb/276553/" to enable
SSL encryption for the SQL2000 server in my company, but I get a bit
confused about below point mentioned in the articles,
"when you enable Force Protocol Encryption from the server, it encrypts the
logins and data. However, ...
|
"No Mapping between account names and security IDs..."
Mon, 25 Aug 2008 10:12:49 -0400
Hi All: I had a standalone 2003 server sp2 in a domain running IIS/SQL2005,
and I decided to promote it to a DC without doing too much research. After
promotion/reboot, SQL did not start and I saw pretty quickly that it had
been running under a local account that no longer existed.
I created a domain user t ...
|
SQL Server 2000 Vulnerablities
Fri, 22 Aug 2008 10:25:01 -0700
A scan was performed on our Database Servers by AppSec Inc. One vulnerability
is Permissions to execute the registry extended stored procedures have been
grated to a user or group. The user in question is Public, their
recommendation is to revoke excecute on xp_regread from public.
I am yet to find any docume ...
|
RE: Setuser failed?
Fri, 22 Aug 2008 09:30:04 GMT
You not answered the question. You said nothing...
i have 2 sql2005 with sp2
on the first i can use setuser 'sa' on the second can't, with the same error.
why need it?
because i use With execute as owner in procedures and i have another problme with xp_cmdshell
if i run xp_cmdshell its works, but in the SP ...
|
|
|
sp_revoke login is not working as expected.
Thu, 21 Aug 2008 13:48:00 -0700
1. I have many windows users, for whom access has been given for individual
domain accounts (SQL2K5)
2. All of them are also a part of a windows group which has required access
3. I want to remove the individual domain logins (because a group is already
in place), so that things will be bit neat
I used sp_ ...
|
how to find out if a domain user is in the sysadmin server role?
Thu, 21 Aug 2008 08:38:21 -0700
hi,
i am trying to find out using T-SQL if a domain user has sysdmin permssions.
i can use IS_SRVROLEMEMEBR, but if the user is not a login and directly
under the sysadmin role, this function will not help.
i need to know even if one of the domain or local groups the user is member
of has the sysadmin server ...
|
SQL Server 2005 Windows Authentication - logon failure
Thu, 21 Aug 2008 07:53:03 -0700 (PDT)
Hi all,
I have a problem with SQL Server 2005. The application (written in
VB.NET) connects to SQL Server 2005 using Windows Authentication. When
a user's domain account had been locked out, the user - after it has
been made active again - cannot connect to the DB (with a message
"login failed for user (...)" ...
|
