Just to clarify.. It is SSIS not SSAS..

3. The SSIS step is being run under Windows Authentication. I figured that was fine as the owner of the SSAS job...

shusta (11/3/2009)

---

These are my questions/concerns:

1.During the install will the default SQL services restart?

a.Or will there be a second set of services for the new instance?

2.Where will this...

I'm with GSquared on this, doing it in a trigger is likely to cause unforseen issues.

You are aware that triggers are synchronous, meaning that they have to complete before whatever...

I have to agree with all of this. Talk to your server folks and ask them what they install to support the SAN and then make SQL dependent on...

I have to take exception to that. You...

I think we need to get terminology fixed befwe go further:

DTS = Data Transformation Services (SQL 2000)

SSAS = SQL Server Analysis Services (SQL 2000+)

SSIS = SQL Server Integration Services (SQL...

Boy you are the opposite of everything I'm thinking..

Why don't you screen print the security tab on the linked server properties and using your favorite paint type program blur out...

First I want to compliment you on your well written summary of what you have and what you want, and the way it is setup. We rarely get anything...

Processor affinity should probably be tested carefully. But if you have pretty fast machines with lots of cores, I would think that your bottleneck would probably NOT end up...

How do you have the linked server security mapped?

Also, when you are logging into the SQL server are you using a windows account or a SQL server account?

CEWII

From the sites that can't connect can you ping the server name? does it resolve correctly. Do you even have named pipes turned on (I don't).

My...

I think your SQL server is running as localsystem (the one you are trying to connect FROM). Make sure it is using a windows user account, yuo can change...

I have to admit I wouldn't do the hashing IN the application, I would pass the clear-text password to a stored procedure that would pass back an indicator and any...

Markus (10/30/2009)

---

Problem is we have a lot of purchased apps that REQUIRE to install you use the sa login to install it. In that install process it will create...

You know they say about assumptions..

Also I think the statement:

It seemed to me to be probable that you were a DBA - after all, most of the articles posted on...