I assigned the default port to the named instance and disabled SQL Express. I took it's identity. 🙂 So now the developers just use the same connection...

Ok so I've learned named instances use a dynamically assigned port.

Before learning this I assigned a port in configuration manager adding a port under IPALL. I turned off the...

I found the product key and am now experimenting with the upgrade vs new install option.

I can't find my developer product key and I'm not sure if I can upgrade Enterprise Evaluation to Developer.

So I'm still not sure what I should do. Is there a chance to 'upgrade' enterprise evaluation to developer? I can't find the receipt and product..... doh!!!

Gianluca,

Thanks for replying. The response to your query is 1

I recall selecting 'enter a product key' as opposed to trial version but I can't be sure. I did not recall...

Ok, Thanks for the tip on not renaming but disabling. As to changing the default port. This should have little impact as we only have two applications; blog engine and...

Erand, (and others)

I am not seeing in the error log what port these attack are coming in on. I'm using windows server 2012 and SQL Server 2012 Standard. To be...

Thanks everyone for the help on this issue. I've been off for a few weeks. In the meantime the business, on my recommendation, has secured a dedicated VPS with a...

To be honest, I'm not totally sure all the uses of this SQL instance. I'll have to find out (that's why its call work right) I'm actually volunteering... ...

So this is where I should be bumped over to newbie. This is not a dedicated SQL server and hosts web sites as well. Can I assume there in no...

Alex, do you mean the manufacturer of the VM where when you say 'depends on the environment' or other? Do I need to become a VM expert to DBA in...

This is a permissions issue. I can read the file from both servers if I add the 'everyone' group to the permissions. But I cont and wont do...

No I'm talking about the the what BOL referes to as the SQL Server Logs not the transaction logs. The logs I want to know more about are located...

Wait, I dont understand at all. What does xp_cmdshell have to do with a SET operation for bulk inserting? Can you explain the relationship please?