Connecting to SSIS
Mon, 14 Jul 2008 12:41:44 -0700
For one of our servers, I am unable to connect to the SSIS instance. I have
sysadmin rights on the database server itself but connot connect to it in
SSMS. I can connect to other SSIS servers but not this one.
Any ideas?
TIA
--
Todd C ...
|
sql permission - database level
Mon, 14 Jul 2008 07:04:00 -0700
Hello,
I'm reorganizing users in database db1. Just simple question, however it
always confuses me.
When I chose a few permission groups, would final effective rights be AND or
OR combination of those permission? In other word, would it be most and least
combination?
I hope I explained my question clearly ...
|
error 0x2B33
Sat, 12 Jul 2008 08:34:01 -0700
i get a security update for SQL server 2000 service package 4 and when i go
to download it it wont install it and the error is 0x2B33. How can i fix this ...
|
error applying KB948109
Fri, 11 Jul 2008 14:56:00 -0700
I'm trying to apply KB948109, but get the following error (Windows Update)
Error Code: 0x2B22
Try to install the update again, or request help from one of the following
resources.
Event viewer:
Installation Failure: Windows failed to install the following update with
error 0x80070643: Security Up ...
|
Trying to patch SQL 2005 Developer SP2 Build 3033 - failing
Fri, 11 Jul 2008 10:15:01 -0700
db2040 @ 2005 SP2 CTP (December) - Fix List 9.00.3033
I am an administrator on the box. I ran the installation packages as
follows:
SQLServer2005-KB934458-x86-ENU.exe 2005 SP2+Q934458 9.00.3054
hotfix_3.log
The product instance MSSQLSERVER has had update 3033 applied. You cannot
install ...
|
sql 2005 login thru an external web app
Wed, 9 Jul 2008 13:13:01 -0700
Hi
We have an sql 2k5 box setup in windows authentication. Users are all
defined in pur global company domain.
Is it possbile to create a external webapp, with login and password inputs
and then use these inputs to login to the sql server database using the sql
connection string at web.config file:
...
|
MS08-040 won't install on Windows Vista SP1
Tue, 8 Jul 2008 21:56:00 -0700
Hi Everyone,
I have SQL Server 2000 Developer installed on Windows Vista SP1. It is build
2187. I went and grabbed the update that came out today (buy the guidelines
for version number, I needed the QFE relelase for SQL 2000 SP4). When I try
to install it, the extracring to C:\<some guid> goes OK, then I ge ...
|
|
|
SQL Server Login and CRM Roles
Tue, 8 Jul 2008 15:38:03 -0700
I'm trying to link to SQLServer instance that is hosting CRM database. I
need a login that allows me to access the 'filtered' CRM views. CRM needs to
be able to associate the SQL Login with an Active Directory entry for a CRM
user with appropriate role.
--
Lolt Proegler ...
|
SQL Server w/ Redundant Domain Controllers
Mon, 7 Jul 2008 07:44:01 -0700
We have an application that connects to SQL Server using Windows
authentication, and we have two AD Domain Controllers. Both DCs also run DNS,
and the SQL server is configured to point to both. However, if one of the
domain controllers becomes unavailable (the one configured first in the DNS
order), then aut ...
|
Revoke Table, Grant Execute on Proc, but still get Permission Deni
Mon, 7 Jul 2008 07:19:01 -0700
All,
I'm using SQL 2000 and have:
* created a role
* granted execute to my procs for that role
* revoked on tables being accessed via the procs
* added my db user to the role
When I try to exec the procs, I get problems accessing the underlying
tables. I don't want any db user to have direct access to the ...
|
