Recent content by kodaksmile

Well I figured out the issue at least in my case - the destination cannot be a unc - only works when it is entered as N:\Prod_db (for example) in the copy tab of the configuration. It does not need to be a share (and it did not work when it was a unc and the folder was a share) I thought this...

As an added note, I even made the sql server service account (same account sas the agent) a local admin and still no luck...

Hi - I ran into an odd issue when configuring log shipping. The transaction log backups work but, the copy job fails with the following error: 2010-08-16 11:19:00.97 Copying log backup file to temporary work file. Source: '\\xxxx\PROD_db\PROD_db_20100816165505.trn', Destination...

I am guessing it's an issue with one of the application's config files because as I said I have successful logins coming from the same server that is generating the failed login attempts. The application only uses one account (which makes the troubleshooting a little challenging). The password...

I am getting a login failure message: Login failed for user 'user'. [CLIENT: xxx.xxx.xxx.xx] Error: 18456, Severity: 14, State: 16 I know this normally means the account does not have permission to the default database however the account is successfully logged in and does have public on...

I am getting a login failure message: Login failed for user 'user'. [CLIENT: xxx.xxx.xxx.xx] Error: 18456, Severity: 14, State: 16 I know this normally means the account does not have permission to the default database however the account is successfully logged in and does have public on...

Quick question.... I have a report with many subreports that prompts for windows credentials and the server and instance against which it is to be run which works great with windows authentication. I need to use SQL authentication on some servers (no trust between domains). The problem I have...

Hi, I've run into an issue when I create a local group on my laptop (32 bit o/s) that is running SSMS 2008 Microsoft SQL Server Management Studio 10.0.2531.0 and export it. I can export the group however when I try to import the group on another server or laptop I receive an error message...

Figured it out... I was going about it the wrong way. I tweaked the query to order by using the cast above and then added a field to my dataset (expression based) that does the conversion and modified report groupings etc to use the new field.

I am trying to create a space usage report and the challenge I have is the date is stored as a varchar in the column in the table. I can convert this easily in sql (so that when you group and order the data it does so correctly when there is data from the prior year) however I cannot get the...

Yeah I was just trying to keep it simple and clean while still having all the code in the job. You're right though - probably time to start learning PowerShell. I was hoping I was just missing something.

I can do that and it works but, I am trying to understand why it doesn't work as one step with 2 lines of code in teh sql job as I may need to know for a future sql job (it works fine in the bat file)

This is the mssqlsystemresource db that came along with sql 2005. You cannot back it up using the normal database backup commands. Per Microsoft (and yes I've tested it) you copy the .mdf and .ldf files while sql is running to a new location. I have done that and am using the move command to...

Is this a cluster?

As far as I know licensing is by Edition not by 32 bit or 64 bit. There is a link to the EULA in the link below: http://www.microsoft.com/sqlserver/2005/en/us/licensing.aspx