I have rebuiled a failed  SQl server 2005 on a different server ( restored
all system and userdatabases. After this everything is working OK (No error
in event viewer) with the exeption of my SQl accounts since no user is able
to login into there applications until I reset there ...

We have SQL 2005.
Say our SQL servers are in Domain 'ABC' and our clients are in Domain 'XYZ'
where the domains dont trust one another.
Theres more details but in short,I want to add Windows accounts i.e.

This is variant/continuation of a problem I've discussed on the
sqlserver.programming group (Thanks to Erland for a lot of help over there).
I thought it might benefit me to raise the issue here as well.
In a nutshell:

I've installed SQLExpress under terminal server, and everything worked
great.
Except, when the terminal server users don't have admin access, my program
crashes.

My company has a web-based application that currently uses one SQL
Server login account to connect to a SQL Server 2005 database.  We
have quite a few application-based security controls in place to
ensure that when a user logs into the site, they will only see there

We have SQL Server 2005 Developer Edition with SP2 installed on Windows
Server 2003 Standard Edition SP1. When one of our programmers tries to
connect to the SQL instance he receives the 'Error: 18456, Severity: 14,
State: 11' error.

Hi every one, i am a new SQL server DBA and i want to know the Roles
of SQL Server Production DBA as i am having Interview  for  another
position. I would appreciate if you could send me the information   of
Roles and  Responsibilites of Production DBA.

I am trying to make use of a proxy account.
I have a 2003 server with SQL 2005. My domain ID is on the server O/S in a
normal user group (not admin). I am an admin on the SQL Server. I have
created a proxy for a job I want to execute. The proxy is connected to my

The company I am working for have had a very lax attitude to security. I am
slowly trying to tighten this up as I go along and most servers now have
strong sa passwords and restricted use of databases.
However for various reasons I am unable at this point to change the password

Hi. Can you please help me with three simple Transact SQL Statements that do
set up configurations? I'm having trouble with the specifics:
1. CREATE A USER "WebUser" in current database which uses a Windows Login,
"SERVER\IUSR_XYZ"

We use a Cisco point-to-point VPN to allow employees to connect to the
corporate network from their remote computers that are not members of the
corporate Active Directory domain.
When VPN connected from my non-domain member computer, I open the Windows'

Is there a role that I can assign to a user that will give them the ability
to change password for specific group of database users?
Thanks

We have a couple of vendor applications that create standard accounts.
These accounts have the same format as our domain accounts. For
example, my Windows account would be <domain>\<user_name>. The SQL
standard account would be <user_name>.

We are implementing profit 21 and rather than go in and give individuals
access to the databases I would rather use AD Security Groups...
Will the users be able to log on as them selves if I do this?
thanks,

Hi. I'm hoping sometone can help me with a problem I'm having linking from
SQL Server 2000 or 2005 to Oracle. I've spent pretty much an entire day
trying to get a working Link but to no avail.
After installing the ODBC and OLE DB drivers from an Oracle 9i Client CD I