I took over a project and the former developer installed sql server 05 and
all of the sql server services are running as 'Local System' account. Should
they be running under the SA account if so how would I change the services
to run under the SA id and password?

I've been going through the SQL Server documentation (2005), looking for a
way to solve the following problem:
Two ways of accessing SQL server, by multiple clients, viz.,
(1) Using a reporting tool, and access limited to read-only;

i have sql server 2000 Sp3a on a compaq proliant 370 with 3Gb ram.
i found then sqlserver.exe service process seems to never release memory.
When i start the service the memory occupation  was about 120 Mb.
This value increases with time passing up to 1,5 gb .I think this is  not

I am looking for a script, query or utility that can add many user's at a
time to a role assignemnt in reporting services.
In the gui - I have tried space delimited, comma delimited... and always get
an error.

I use Sql server express 2005.
I have two databases: db1 and db2.
I use Studio Management. I connect with my administrator account 'admin'.
1) When i rightclick on db1 (and also on db2) and i take the properties /

If a user is a member of more than one Windows groups, what permissions will
the user be granted upon logging into SQL Server if the different groups
have different access rights?
Michael MacGregor

I had our network guy install VS.NET 2005 and SQL Server 2005 Express on my
computer. He doesn't remember entering an SA password. I can't log into SQL
server using SA password as I don't know what it is. I can't change it either
as my network account does not have admin rights.

I set up a custom role "Finance" and assigned it a combination of some
built-in roles and some specific permissions to specific objects
(securables).  However when I go back into the role and look at the
properties of that role, I do not see a list of the specific object

i've some trouble with a sql server 2000 db.
the db uses sql server auth
i make a backup from the DB and take the backup to an other sqlserver, i had
restored the database at ther new server.

I am trying to avoid the "Permission denied" error message when a proc tries
to select records from one of the system tables in a SQL Server 2005 master
database.
Sepcifically I need to be able to capture the IP address of the calling user

I am trying to set up a Custom Database Role that allows the user to
select, update, insert and delete data.  I created the role by
combining the built-in roles of db_datareader and db_datawriter.
However when I logged with the custom role I was not able to insert a

Yesterday I spent hours searching the groups for a solution to this problem with no luck.
The issue is that a VB6 app I inherited has been running fine for years on SERVER1 (Server 2003 and SQL Server 2000).  We moved the Database to a new SERVER2 (Server 2003 and SQL Server 2000) ...

I am looking for any advices or drafts for a new concept how to handle
all the permission to our DB Servers. We are still using SQL2k and
want migrate to SQL05 till the end of the year. Therefore we want to
improve our security with less complexity.

This might be a bit of a stupid question, but I've never seen this before.  
I've just taken over a new SQL instance from a previous employee (SQL 2005
sp2, on Windows 2003).
There are several logins in this SQL instance that have a $ at the end of

I need to copy a backup file from server to server in seperate domains.
Unfortunately in my company they do not have trusted connections. So I need
to use a seperate logon for the destination server. I have tried a mapped
drive that is mapped as a valid logon in thatdomain with ...