February 28, 2006 at 3:28 pm
I'm brand new to SQL2005, and trying to get it up & running on our test server. I've installed SQL2005 on my desktop, and have no problem connecting to "database engine" for databases, jobs etc, but when I try to connect to Integration Services from my desktop, I get the error:
Connect to SSIS Service on machine "SQL_TestServer" failed:
Access is denied.
I'm a member of sysadmin within SQL, as well as an administrator on the server. I don't have any problem when I log on to the server directly via Remote Desktop and open IS. Am I missing something obvious ?
February 28, 2006 at 4:18 pm
If you are using the developer, express or evaluation editions you have to enable network access it is not enabled by default on those editions anymore. You can do this through the surface area config tool or sql server configuration manager.
hth
David
March 1, 2006 at 10:33 am
Thanks. I went into the surface area config tool, and I see that Database Engine and Analysis Services both expand and have a sub tabs to enable Services and Remote Connections, but Integration Services does not expand to a Remote Connections option, just Services. We're running MSDN Enterprise edition.
Does it matter if all the SQL services are using "Local System" for the logon ? I use an administrative logon on my SQL2000 boxes, and was fiddling with them on the 2005 box yesterday, but it seemed to cause more problems, so they are all Local System for now.
March 2, 2006 at 12:56 am
I have been using domain logins with no admin privilges at all on my sql server 2005 development box and this seems to have no draw backs at all. It doesn't seem to need admin privileges for some things in the way sql server 2000 did.
I haven't run my development box under local system account so i coudn't tell you if this is the problem.
David
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply