sometimes the easiest things...

do you have checked if the database engine service is running?

Do you have changed the TCP Port?

Have you changed any configuration in db Config?

Windows Firewall /...

Hi,

I'm not really comfortable with licensing (and please correct me if i'm wrong) BUT you have to license all cores that might be available to sql server and not only...

That might be interesting... what other thinks.

We're doing it the same way... works perfect for us.

Where does the report service run? same server/localhost? ist Shared Memory enabled?

What should be your target/goal to be reach if you go with PDW?

What are your actual problems with sql server in scaleout that you're thinking about a PDW?

From what you've written it sounds like orphaned user...

http://www.fileformat.info/tip/microsoft/sql_orphan_user.htm

and don't forget to check the connection... How do you connect to sql server from your app?

Do you use any connectors/ODBC/drivers etc?

You can find the log file here (or like this)

C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log

For each installation attemp you'll find a folder named with date and time

There you can find a...

What is written in the log file ?

Any more details?

lusmgr is the user/group manager of windows and had nothing (really) to do with user management in sql server (here SSMS)

First you have to create your user group in windows,...

For example PC1 is logged on with user "sql_dba_dev" and PC2 is logged on with "sql_dba_exp"

Now if you try to logon with SSMS from PC2 to PC1 the SSMS tries...

From your given informations... I don't know why this should not work...

But you have to consider that an Express Edition has its limitations and also doesn't have a real support.

So...

There is actually no better way of doing regular maintance on statistics !

Use the Maintance Solution of Ola Hallengren

I would suggest to use more drives for mdf depending on database size.

You've said that it is big online store... so database might be bigger than 100GB or 200GB

So if...

Have a look into my blog post:

http://www.sql-aus-hamburg.de/en/tsql-66-monitoring-backup-solution-backup-history/

It might be something like a hint to your solution...

Give it try...

You might change this part to fit your requirement:

CASE WHEN bs.backup_start_date > DATEADD(dd,-1,getdate())

...