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!

Register Log in
  • Congratulations IamaSherpa 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. DBA2RELOADED

    2 different Unicode Collation

    I'm trying combined 2 sql servers (7.0) to 1 sql servers (2000). However, the 2 sql servers have two different unicode collations: One Server: SQL Server's Unicode collation is: 'English' (ID = 1033). Second server: SQL Server's Unicode collation is: 'English' (ID = 2057). Is it possible...
  2. DBA2RELOADED

    Transaction Log Backup Job for DB Maintenance Plan Failed

    SQLBill - Thanks for the info.
  3. DBA2RELOADED

    Transaction Log Backup Job for DB Maintenance Plan Failed

    I recently upgraded SQL 7.0 to SQL 2000, and after the upgrade, I'm getting this failed run on Transaction Log Backup Job for DB Maintenance Plan. The errors are logged in Windows Application Event Log, as well as, in the Maintainance Plan Log File. The error on the Windows Application Event...
  4. DBA2RELOADED

    DATABASE BACKUP ON SEPARATE SERVER

    Thanks a lot. It's working now. I changed the SQL Server startup account to startup on the domain account. Again, THANKS!
  5. DBA2RELOADED

    DATABASE BACKUP ON SEPARATE SERVER

    I'm getting this error, any advise? BackupDiskFile::CreateMedia: Backup device '\\servername\d$\MSSQL7\BACKUP\DBname.BAK' failed to create. Operating system error = 5(Access is denied.). Access Denied -> Don't know why, because when I Start/RUN/Open \\servername\d$ I have full control...
  6. DBA2RELOADED

    DATABASE BACKUP ON SEPARATE SERVER

    Great! Thanks. I have a follow up question. If I were given a user access and not an administrator access to the remote server, how can I backup my database to the remote server. Thanks.
  7. DBA2RELOADED

    DATABASE BACKUP ON SEPARATE SERVER

    How can I backup a database on a separate server? I mapped the drive on the current Server, but it won't give me that option when selecting the drive on where I want to backup the files. Thanks!
  8. DBA2RELOADED

    SQL Server Error: 18452 - Default Login

    Your link was very helpful. Thank You! RAG [2thumbsup] [medal] [smarty] [smile] [thumbsup] [thumbsup2]
  9. DBA2RELOADED

    SQL Server Error: 18452 - Login failed

    I have a simple question. I have an ODBC connection from MS Access to SQL Server through a valid System DSN. My problem is that when I try to connect to SQL Server, I get this error "SQL Server Error: 18452 - Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server...
  10. DBA2RELOADED

    SQL Server Error: 18452 - Default Login

    I have a simple question. I have an ODBC connection from MS Access to SQL Server through a valid System DSN. My problem is that when I try to connect to SQL Server, I get this error "SQL Server Error: 18452 - Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server...
  11. DBA2RELOADED

    ODBC Login Failed

    I have a similar question. I'm getting the same error 'SQL Server Error 18456' on my Access Database. The reason I'm getting this is because it's using a trusted connection, instead of prompting for the username/password. I want to skip this part about using trusted connection. Thanks RAG

Part and Inventory Search

Back
Top