0
votes
2answers
159 views

SQL Server: best account for dbo user?

What is the best account for dbo user? I mean that if I use personal AD account for database owner, and if this account is removed from AD (e.g if I leave my job), these databases are not accessible. ...
0
votes
3answers
761 views

What happens to my SQL Server logins if I change a windows domain username

My question is very similar to this question Changing Windows Domain UserName but the original question doesn't explicitly answer my slight variation. If I change a windows users username (if they ...
0
votes
1answer
42 views

Setting up individual accounts to a SQL Server

I am attempting to setup a MS 2008 sql server that would allow many users access to there own private databases. I would like the adventure works databases installed on all of these as well. My ...
1
vote
2answers
88 views

How to install the same user on two different servers?

I have two Windows Server 2008 servers. 1) Is a web server 2) is a db server I need to use Windows authentication to access the db server, therefore I need to create a new user on both machines. ...
1
vote
1answer
985 views

SQL Server 2005 Accidentally removed a user from public role, can't add user back into role

I'm trying to crearte a DB user account that only has access to a specific database, and can't read or change other databases, and can't alter credentials for any other accounts. I accidentally ...
1
vote
1answer
2k views

Limit Concurrent Database Connections by SQL Server User Account

I would like to create a SQL Server 2005 user account but limit that user to only allow them to have two concurrent connections to the database at once. Is there any way to do this through SQL Server ...
2
votes
2answers
424 views

Secure user setup in Sql Server 2000

I'm looking to setup a user account in Sql Server 2000 in the most secure manner. The criteria is as follows: No access to the master database (db_denydatareader & db_denydatawriter on master) ...
1
vote
1answer
2k views

What permissions might be missing on error 229 from 'tables' node on SSMS object explorer

I have just added a login to test an ETL process on a database and I get the error described below when connect using the account I click on the 'Tables' tab on the object explorer on SSMS on a ...
2
votes
3answers
778 views

How can I tell what user account is being used to perform an action (in context of SQL Server)?

For example, when installing SQL Server 2008, I had to pick an account for the database engine to run as. When I went to attach a 2005 database file with SQL Server Management Studio, there was a ...