No announcements
Filter
:
All threads
All threads
Answered
Unanswered
Proposed answers
General discussion
No replies
Helpful
Has code
All languages
-
Unanswered0Votes
Connection String issue
I am a sql server DBA. I am not completely aware of how IIS recognizes a sql server windows login credentials. This is for our testing only and doesnt reflect any prod or ... -
Unanswered0Votes
Visual Studio components installed with SQL 2008r2 causing security hit
Good day. We are currently getting pushback from the security folks regarding Visual Studio components being installed on our SQL servers. SQL servers, according to our ... -
Unanswered0Votes
While restoring the backup newly created usernames are not replicating
Friends, Server OS: Win2k3 Local OS: Win XP SP2 Server DB: Sql Server 2000 EE Local DB: Sql Server Developer ...3 Replies | 51 Views | Created by sathyguy1 - 9 hours 57 minutes ago | Last reply by anuragsh - 6 hours 2 minutes ago -
Unanswered0Votes
How can I sign a text by certificate in SQL Server and provide PKCS#7 signature?
Hello! In my app i need to implement digital signature of some text, extracted from DB data (customer bill, for example), to send a text by e-mail together ... -
Answered0Votes
How to Grant an access to particular database without Server level Login in SQLServer 2012 ?????
Hi everyone , Can anyone please help me to advise below new concept on SQLServer 2012 .it will be really helpful for me . Question : How We can able ...5 Replies | 150 Views | Created by Pravat M - Friday, August 02, 2013 6:58 AM | Last reply by Pravat M - Tuesday, August 20, 2013 4:04 PM -
Answered0Votes
Commvault for SQL Server database backup
Dear All, I want to backup SQL database through commvault, and also restore it to test instance. How i can do this can anyone explain me ...4 Replies | 83 Views | Created by Raghvendra Bhanap - Tuesday, August 20, 2013 10:50 AM | Last reply by Raghvendra Bhanap - Tuesday, August 20, 2013 11:53 AM -
Answered0Votes
AD group as SQL login
Alter any linked server NTFS permissions> C:\Users\Sql_server_account\app_data\local\temp To make my life easier in the future and keep things neater I ...2 Replies | 179 Views | Created by Charles__Toray - Monday, August 05, 2013 1:56 PM | Last reply by Sofiya Li - Monday, August 19, 2013 1:21 PM -
Answered0Votes
Remove users and roles from security
Hi, I recently had an issue with an application and in attempting to resolve it I made some changes to the SQL user. What I did was add 'Chris' to the 'Users or roles' on the ...2 Replies | 81 Views | Created by runnerpaul - Monday, August 19, 2013 8:26 AM | Last reply by Andreas.Wolter - Monday, August 19, 2013 9:07 AM -
Answered1Votes
xp_cmdshell "Access is denied" on network resource
I start receiving error 'Access is denied' executing following command: exec xp_cmdshell 'dir \\IP-ADDRESS\SHARE_NAME\*.*' The ...11 Replies | 10802 Views | Created by Igor.K - Wednesday, June 27, 2007 2:22 PM | Last reply by Rohaan - Monday, August 19, 2013 5:14 AM -
Answered0Votes
sql server 2008 error code 18456 state 28000
When I try to log into sql 2008 from my delphi application I get sql error code 18456 state 28000. I can connect using and ADO connection no problem, I get this error when I try to use ...6 Replies | 15903 Views | Created by Lewis_harris - Thursday, January 14, 2010 8:19 PM | Last reply by Eng. Juan C. Sánchez - Friday, August 16, 2013 7:18 PM -
Answered0Votes
Mapped Credentials
Sorry if it's a dumb question, maybe I misunderstood something, but I have a strange problem: "To associate the login with a security credential, select the Mapped to ...1 Replies | 82 Views | Created by Levente Nagy - Friday, August 16, 2013 8:08 AM | Last reply by Andrew Bainbridge - Friday, August 16, 2013 8:24 AM -
Answered0Votes
Adomd ConnectionString ignore User ID
Hi all. I must use Windows Authentication and I want that my application connects to MS SQL Server (Database Engine) with authenticated user. So I used ASP.NET impersonation in ...13 Replies | 151 Views | Created by PetrovSerega - Tuesday, August 13, 2013 6:34 PM | Last reply by PetrovSerega - Thursday, August 15, 2013 7:24 AM -
Unanswered0Votes
Linked Server Login Using SQL Login Impersonation Does Not Work from SQL Agent Job
• I created a pair of SQL Server logins on two instances of SQL Server (10.0, 10.5) that have the same name and password. • On the 10.0 server (local) I created a linked ...13 Replies | 263 Views | Created by JediSQL - Wednesday, August 07, 2013 8:52 PM | Last reply by Andreas.Wolter - Tuesday, August 13, 2013 7:34 PM -
Answered0Votes
Authentication failure - can't find domain accounts
We're getting an error where we can't add a login with the full dns name of a user - domain.xyz\user, for example. Get an error 15401, "Windows NT user or group domain.xyz\user' not found". ...2 Replies | 5055 Views | Created by JFRANCIS1 - Wednesday, May 30, 2007 3:58 PM | Last reply by Tony Ortiz (MCITP) - Tuesday, August 13, 2013 5:18 PM -
Answered1Votes
ALTER the Expiration date of my CERTIFICATE (TDE SQL2008)
Hello , after i created a DMK & CERTIficate and enabled TDE , i noticed my certificate will expire after one year , and i know that won't enforce any expiration for my ...5 Replies | 2303 Views | Created by SQL Kitchen - Tuesday, September 11, 2012 10:45 AM | Last reply by mysticdba - Tuesday, August 13, 2013 2:37 PM -
Answered4Votes
password in sys.syslogins
Hello , select password,* from sys.syslogins Default language setting is English , but seeing chinese like characters in password column . How ...5 Replies | 210 Views | Created by Madhubala18 - Tuesday, August 06, 2013 8:22 AM | Last reply by Sofiya Li - Tuesday, August 13, 2013 12:47 PM -
Answered5Votes
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (p
I've just installed sql server 2008 r2 and i restored my DB, and i receive this error: I have got the above ERROR.., A network-related or instance-specific ...18 Replies | 57271 Views | Created by d.Harish - Thursday, December 13, 2012 1:51 PM | Last reply by Rinesh Rajan - Monday, August 12, 2013 12:18 PM -
Answered0Votes
How to capture Trancate Command in SQL Server 2008
I can capture truncate command in SQL SERVER 2008(Enterprise Edition) through Database Audit Specification tool. But Database Audit Specification feature is not available in ...9 Replies | 219 Views | Created by ran05021981 - Tuesday, August 06, 2013 10:08 AM | Last reply by Andreas.Wolter - Monday, August 12, 2013 9:58 AM -
Answered0Votes
BUG or what? sys.dm_exec_connections
Hi Im trying to Identify client IP address using sys.dm_exec_connections inside a trigger but with no sucess. SQL Server returns the ...4 Replies | 215 Views | Created by Jose Marcelo - Thursday, August 08, 2013 5:59 PM | Last reply by Andreas.Wolter - Sunday, August 11, 2013 6:37 PM -
Answered3Votes
Grant execute on SP that accesses Change Tracking tables
Hi, According to this article, granting 'Execute' on a stored procedure to a user/role will allow them to access any tables or views that the procedure can access ...9 Replies | 205 Views | Created by dylbud - Monday, August 05, 2013 9:09 PM | Last reply by Dan Guzman - Friday, August 09, 2013 12:15 AM - Items 1 to 20 of 6333 Next ›