Hi Guys,

I have found and fixed this issue. We use a Powershell script to do unattended installs of our SQL Server environments. In the script, there was...

I have found the issue, it seems that when the logs get cycled, sql server seems to leave a space before the full stop and the number e.g ERRORLOG .1

You can also use replace as below:

UPDATE #Test
SET Dsc = REPLACE(dsc,SUBSTRING(dsc,1,1),'27')
WHERE Dsc LIKE '0%';

Thank you sir, that solved it. I was in the user database, as soon as I switched the to master database I could create the backup.

That is the first place I tried, but no luck. There is only an AgentSigningCertificate. The strange thing is if I search my localhost for a .pvk (for my private...

So any idea what the default path might be?

Hi This is on my local, I am just playing around to see how it works. I have now idea where the private key is, that I what I suspecting...

I got the connection working. The iss was that i was using http://serverip/reports instead of http://serverip/reportserver.

I have switched off the firewall completely and I am still getting the same error.

I have opened port 80 on the firewall. Is there anything else I should open?

This server is newly set up. I would assume all the default settings.

Hi Guys,
TI have resolved this. Seems that the issue was a compatibility issue between 64 bit and 32 bit. I just installed vc++ redistributable 2010 x32 and x64 then I...

That is the exact output from the cmd.

So that shows my a directory that I created originally to insert documents via a stored proc, using the open rowset with single blob, and I know where this...

From xp_cmdshell I get access denied. and from cmd I get:

MSSQLSERVER \\?\GLOBALROOT\Device\RsFx0320\<localmachine>\MSSQLSERVER

...