Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. calidrake

    GPO not apply on the client

    I am having the same problem when I try to push out the "Trusted Sites" list. I did see that in order to push Group Policy out to clients that do not have Enhanced Security enabled that you have to disable it on the server that you edit the policy from. However, for me it is disabled and it...
  2. calidrake

    Pushing IE zone settings through Group Policy

    Thanks so much, I was looking around Windows Components/Internet Explorer. I was way off. This is exactly what I was looking for.
  3. calidrake

    Pushing IE zone settings through Group Policy

    I have looked everywhere for a way to set IE zone settings with group policy, but I can't find anything. It only takes away access for users to change the current settings. I want to be able to set ActiveX execution, and scripting for each internet "zone" (i.e internet, local intranet, Trusted...
  4. calidrake

    SSPI Error

    I have never gotten that error before, but SSPI is used when you are actually authenticated with a domain. Are you successfuly logged into the network? Also, is this only on a specific program, or just randomly on different programs?
  5. calidrake

    All set for new SQL 2000 server. Next Migration...help please!

    The best you can do is to delete the NT users, and make sql users with the same names.
  6. calidrake

    All set for new SQL 2000 server. Next Migration...help please!

    No...you cannot change NT users into SQL users.
  7. calidrake

    All set for new SQL 2000 server. Next Migration...help please!

    What do you mean "our database and its software say we need all users to stay as SQL users"? If the application only supports SQL server security then that is what you have to use. As for making NT users into SQL users, you cannot change them in the transfer because they are two...
  8. calidrake

    Jet 4.0 Connection

    I do not know why it wouldn't be there if it is in your install. Who made the install file, and is there any way you can get into the source for the install to double check that it is there? I didn't write our install file, but I know that it called the MDAC install in the middle of it...
  9. calidrake

    How to undelete a file on NTFS partition?

    Since it was a DOS command it would've bypassed your "Recycle Bin". So unless you have a backup copy it is gone. You can probably have the data recovered from the shadow on the hard drive, but I doubt you'd want to spend the money. Sorry
  10. calidrake

    Jet 4.0 Connection

    It looks like you need MDAC 2.5 to get the Jet drivers
  11. calidrake

    Jet 4.0 Connection

    No, you have to run the executable to install MDAC. http://www.microsoft.com/data/download.htm The install has to be run, just moving a DLL will not do it.
  12. calidrake

    Jet 4.0 Connection

    If you include the installation of Microsoft Data Access Components (MDAC) in your install program, it should take care of the problem. I believe they are up to 2.7 now but I am not sure.
  13. calidrake

    Problem authenticating Web server in SQL Server

    Did you manually set the IUSR_DOMAINNAME account as the anonymous user in IIS? Also, is the IUSR_DOMAINNAME a local account or a domain account? if it is a local account on a server (which is default) then it will not be able to be authenticated from a remote server. On IIS you actually have...
  14. calidrake

    Backup problems:

    I assume that Veritas is giving you this error. The error looks like it is having problems writing to the backup media which will be a veritas problem. Maybe the platter(s) are bad. Another thing is to make sure you are running the SQL Server backup agent for veritas. You can't backup the...
  15. calidrake

    All set for new SQL 2000 server. Next Migration...help please!

    1. First thing you should always do is make a backup of your information and, if possible, restore your database without overwriting the original so that you are sure you have a good backup. 2. I have never upgraded from 6.5 to 2000, but the upgrade wizard has an export server, and import...
  16. calidrake

    Differential Backups in SQL 7.0

    Unfortunately Database Maintenance Plans only offer to do full or transaction log backups. If you want to automate a differential backup you will have to make a job yourself to do it.
  17. calidrake

    Problem with column

    go into query analyzer and just type in DBCC CHECKDB('databasename') if it finds errors you can either use DBCC CHECKDB('databasename', REPAIR_FAST) or DBCC CHECKDB('databasename', REPAIR_REBUILD) note : make sure to surround your databasename with single quotes the REPAIR_REBUILD will take...
  18. calidrake

    Problem with column

    You might want to try and run DBCC CHECKDB and see if there are any errors on the actual database. Other then that, I have never heard of one column crashing a query. Have you run the same query in query analyzer?? You could probably debug it better from there.
  19. calidrake

    How to select where a column contains a column!

    Is this what you were looking for? SELECT * FROM formatted join path on formatted.path = path.path
  20. calidrake

    SQL explanation

    SQL Server is actually a Relational Database server. You can link into the tables using Access, but SQL Server comes with it's own management tools. As for SQL Server compared to access, it's very different. You can't just "make" an SQL Server database. You have to purchase MS SQL...

Part and Inventory Search

Back
Top