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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by grimmy

  1. grimmy

    Replication

    Sounds to me like your SQL server agent service is starting up with an account that doesnt have the correct priveleges. Go to your services and look what user id it is using to logon. Change to a domain admin account and see if this makes any difference.
  2. grimmy

    Replication

    Operating System - W2K SQL Version 6.5 I am experiencing problems in getting replication to work between two servers. I can set the publishing and subscribing up fine but it is failing with the following error:- ODBC SQL Server Error - Login Failed. Not associated with a trusted SQL server...
  3. grimmy

    Urgent Replication Problem

    I am trying to replicate certain tables from one 6.5 SQL Server to another but it is failing with the following error:- 28000[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: Reason: Not associated with a trusted SQL Server connection. I have another two SQL Servers which...
  4. grimmy

    Replication In 6.5

    I am trying to replicate certain tables from one 6.5 SQL Server to another but it is failing with the following error:- 28000[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed- User: Reason: Not associated with a trusted SQL Server connection. I have another two SQL Servers which...
  5. grimmy

    SQL 6.5 with W2K

    Will SQL 6.5 Run OK on Windows 2000? Does anybody have any experience with this. Cheers.....Grimmy
  6. grimmy

    NT Server Administrative Tools

    norEmac1, The best way is to choose one particular server and install a but a realtime clock and install onto that and then run this command using the AT command:- NET TIME \\'SERVERNAME' /SET /Y Cheers....grimmy
  7. grimmy

    my server just went a wee bit tit u

    Try www.eventid.net
  8. grimmy

    BETWEEN Query

    I am trying to find a set of results within two dates and I am using the follwing query which is failing:- select * from Employee where PTW BETWEEN '24/07/2002' AND '24/07/2001' The error I am getting is:- The conversion of CHAR to DATETIME resulted in a DATETIME value out of range. The...
  9. grimmy

    SQL 2000 with Transaction Server

    Hello, I currently have a live system which uses SQL 6.5 with Transaction Server and I am trying to upgrade to SQL 2000. I have built a separate SQL 2000 server and Transaction server and it does not seem to want to play and the application returns an error 5 Invalid Procedure or argument call...
  10. grimmy

    upgrades

    SEANOS, Your problem is that because you installed NT and there was only one processor it does not automatically upgrade to a multi processor operating system. What you need to do is run the command UPTOMP.EXE which can be found in the Resource Kit. The white paper for this is on the...
  11. grimmy

    6.5 to 2000 Data Transfer

    I currently have a Live SQL 6.5 server which I needed to upgrade to 2000. To stop downtime a new server was bought and I created that as a direct copy of the live server and upgraded to 2000 All Databases and objects have be upgraded fine but now i need to copy all the up to date data from the...
  12. grimmy

    Upgrade to 2000

    I am trying to upgrade our SQL 6.5 server to 2000 by using the upgrade wizard and it is coming up with an error that tempdb needs to be 10MB in size. So, I am trying to make tempdb 10MB but cannot find how to go about this. It is currently 2MB and I have tried using the Alter Database command...
  13. grimmy

    Date & Time Synchronization - How?

    When your users logon if you have a Login script running then put the following command in each users script:- net time \\SERVERNAME /set /Y Server name will be a server that you know has the correct time as it may have a Time Synchroniser attached
  14. grimmy

    Install standard tcp/ip port

    CDOVE, Ensure that Microsoft TCP/IP printing service is installed by looking in network services and then:- 1/ GOTO PRINTERS 2/ SELECT MY COMPUTER 3/ ADD PORT 4/ SELECT MICROSOFT TCP/IP PORT AND CLICK NEW PORT 5/ SETUP THE PORT AS REQUIRED. CHEERS....GRIMMY
  15. grimmy

    Database Size Issue

    I am currently running SQL 6.5 and have a database setup with a 1GB data size. At this minute there is only 200MB free but there is not a lot of data in tables in this database that changes so I cannot believe that it is using 800MB. What is the best way of seeing how much data size an...

Part and Inventory Search

Back
Top