• Capture SQL Server logged in db User name in Access 2007 Accdb

    I have a SQL Server 2005 backend with an Access 2007 Accdb front-end application.  Security has been established via SQL Server database user groups with associated table-level permissions. I would like to disable certain form functionality based on the logged in user.  Is there a way...

    Ppeterso15 pointsBadges:
  • Changing the sql server service and agent windows account password

    Hello, we are considering changing the sql server service and agent's password. What all should be considered prior to doing this? This will include doing this on 2000, 2005, and on clusters. Thanks!

    Rob35 pointsBadges:
  • Encrypt the password in SQL 2000

    How to pass encrypted passwords in connection string in asp/vb using sql server 2000. Im trying to create a new user login for the applications using SQL server 2000. However want the end users to avoid viewing the login credentails for sql server 2000 in the connection string part. Hence prefer to...

    S09875 pointsBadges:
  • Prevent unauthorized users from accessing SQL Server 2000

    One of the SQL Server 2000 databases that I administer is configured for Windows authentication. I added an integrated logon for the domain user group. However, 20 of those in the domain user group who should not have access to the server are still able to access it. How can I prevent these...

    SQL Server Ask the Experts2,585 pointsBadges:
  • SQL Server Linked Server Security Context

    Hey everyone, I'm working on some scripts that will run on a monitoring server and connect to several data servers to return information such as job status, etc. We also use linked servers for replication, etc. We use mixed authentication, however, I would like to change our linked servers to use...

    Lvance16115 pointsBadges:
  • How do I avoid a security exposure using XP_SendMail

    I'm using XP_Sendmail in a trigger on my database. In order to run the trigger, I have to give database access to the "guest" user. I'm concerned about security. I've tried a Stored Proc called SP_Sendmail that calls XP_Sendmail, but I still have to grant db access to the "guest". Any help here...

    Arlin70 pointsBadges:
  • SQL Server security bulletin MS09-004

    Has anyone dealt with issues related to this security bulletin ?

    Rik5 pointsBadges:
  • SQL “NOT CONNECTED” icon in my taskbar

    there is an icon in my taskbar and when i highlight it it says NOT CONNECTED. when i right click it it pops up a menu with OPEN SQL SERVER SERVICE MANAGER on the top...what is this and why is the icon in my taskbar?

    Pennymae10195 pointsBadges:
  • Password Policy for SQL Server 2000

    Is there any way to set Password expiration Policies on SQL Standard Users in SQL 2000?

    Rickmcd1,720 pointsBadges:
  • Securing a SQL Server 2008 database

    I am on SQL Server 2000, and to secure my database, I want the user to be prompted for a user ID and password before the database is expanded. How might I do this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • securing sql server database object

    I connect my access project to sql server. Is there as simple way to secure sql server object such as table, view, stored proc from editing or deletion since access let us to edit sql server object directly

    Ipong40 pointsBadges:
  • Implementing row level security in SQL 2000

    Is there a way to implement row level security in SQL Server 2000?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Looking for best way to have SQL Server data security, replication as well as security maintenance

    I joined a production environment recently, and I’m the key person here. We have 2 servers: one production server and a replication server. Data from the application goes to the production server every second and that is replicated to the replication server. We fetch the data from replication...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Suspect DB

    Hi, I am using sql server 2000 and recently found 2 of the DBs are marked as Suspect and I don't have access to them any more.Would you please help me with this? Thanks, Ellie

    Ellie145 pointsBadges:
  • Potential over & under security issues with SQLNative Client ?

    Hello, I've been unable to find any reports of these two problem when using the SQL Native Client driver (9.00.3042.00), so I'm hoping else has seen these. Firstly check constraint definitions accessed by the following TSQL only returns data with the SQL Server driver, ie nothing with SQL Native...

    WarwickW5 pointsBadges:
  • Is firewall preventing SQL Server from showing up in the EM?

    I have a corporate Dell Image laptop running SQL server 2000. Enterprise manager (EM) shows up without my registered SQL server (local or remote). When I try to re-register I see the other registered servers, however, they are grayed out. When I use the MMC Snap-In from computer management, I can...

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can I set the database password by the SQL Server Enterprise Manager?

    How can I set the database password by the SQL Server Enterprise Manager?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How to transfer encrypted data between SQL Server 2005 and SQL Server 2000

    We are a retail/web/phone order store. We process credit cards for all three stores at our retail location. We have our web data stored offsite on the web server, using SQL Server 2005. We have our retail/phone order data stored onsite in SQL Server 2000. I'd like to add a function to our MS Access...

    SQL Server Ask the Experts2,585 pointsBadges:
  • sql 2005 db security for public

    I have databases that were converted (by restore) from sql 2000 to sql 2005. I found a script to move the logins (all using nt/sql auth) to the 2005 box. All the users on the sql 2000 box belonged to public on the old box. If i loook at the users inside the db's on the 2005 box (no public) they are...

    tcstl95 pointsBadges:
  • Securing dynamic file uploads to a SQL 2005 Server database

    I need to determine what is the best (practices) method for scanning of files/documents (.DOC, .XLS, .JPG, .TIF, .PDF) before they are dynamically uploaded into an SQL 2005 db as BLOBs..Thanks

    RJpoorvin0 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.