I have .net app got this error below,
Connection failed: sqlstate:28000 sql server error: 18452 login failed for
user(null). reason: not associated with a trusted SQL server connection
Any ideas

I have a user that belongs to a role.  This role only has select permissions
on 10 views.  When I log in as this user via Management Studio I cannot see
the views however I can execute queries against them.  
On another server that I did not setup, that I'm supposed to be ...

Let's say that you create an instance - and I'd be curious of the answers for
both 2000 and 2005 - in Mixed Mode.  If I remember right, the sa password is
stored on disk but is encrypted.  Is that encryption really that powerful?  
Isn't this a huge security risk?  Given a few ...

Hi database geeks and MVPs!
Using SQL Server 2005 SP2
I have a stored procedure in my database which calls xp_cmdshell to run a
little task. I have done the following to allow this proc to be executed by a

Here is my issue. I installed SQL 2005 on one of my servers. Up until 10 minutes ago I was able to connect to the server remotely using SQL Server Management Studio but I was unable connect to the SQL server from the actual server that the SQL 05 instance resides on. Now, I ...

Hello, I work in a team of 4 dba's. In order to save passing sa passwords
around I'm going to add a Windows group on each server and add this group
into SQL Server as a memeber SysAdmin role. I can also add the service
account into this role (we use the same service account for ...

Google wasn’t cooperating today.
I’m 95% sure the answer is no, maybe I’m just in denial.  SS2000 does not
provide the ability to lock a user account after x number of failed logins,
correct?  I see that I can turn auditing on in the security tab though, but

I would like to find out what are the fields that can be audited by setting
in the SQL 2000 database.  Any GUI screen for doing this audit setting?

I am getting a message that my sa account is locked out, and I can't
connect with SQL Server Management Studio.
Other posts say to log in using Windows auth, but that is not letting
me in either. I am logged into the machine as the administrator and

Good morning,
I am with some questions concerning Backup of SQL Server 2000 and 2005.
I wonder what the databases should be held back, outside the base of the
system itself, the master, you should hold back up any further, for example

I made a package that copies data from one table of a sql server database to
another table of another database sql server.
I use oledb connection for the two connection
I want to store user and password of the two connection to avoid retype them

I need to setup SQL encryption on a remote server running W2k3, SQL2k5 std.
The server doesn't have access to a CA. SQL connections are limited to my
server and  IIS running on the same remote server.
Can I use a SelfSSL certificate created with the IIS 6.0 Toolkit when

Good morning,
I am with some questions concerning Backup of SQL Server 2000 and 2005.
First, I would like to know whether performing the backup Full, it is done
automatically backup of the Transaction Log? And if it is truncate it?

I'm going to implement a standalone solution to my company's partners, which
is a VB.NET application with some $$ calculations.
Some rate data are sensitive and we choose to use sql server express 2005 as
local database engine.

New server running our SQL... upgrade from Advanced 2000 to Enterprise
2003... our SQL Instance normally records all history (View History from Jobs
in SQL Agent).  For some reason, currently unknown, history disappears every
so often.  In this case, all history from 11/24 going ...