If a user is not authorized to see a database canÃÂ I exclude that database from even appearing inÃÂ Management Studio for that user
View Complete Post
I would like to know how to hide certain documents (eg. Word, Excel, PPT, PDF) in a document libraries from unauthorized users? I tried implement Target Audience, but it doesn't work. If anyone know, i really appreciate for the guidance.
p/s: If my posting is not relevnt to the thread, please kindly move it to the appropriate places. Thanks!
I have a several large Visual Sourcesafe (VSS) databases with scripts of all objects of several SQL server databases. They were integrated into VSS using Visual Studio. But the Solution file in VSS can not be opened from SQL Server Management Studio 2008
(SSMS). (Its a .sln file, and I need a .ssmssln file). If I try I get an error saying that the solution file was created with a newer version ...
My question is : How do I create a new SSMS project and connect it to one of the
existing VSS databases to make it possible to view/check in/check out all the procedures, functions, tables etc. already stored in VSS from within SSMS.
We are trying to restore a SQL Server 2005 (all the databases). We have failed with the restore for a couple of times and the vendor says that we have to ensure that all database users are logged off the database. A restore will fail if other users
try to use the database while the restore operation is in
How could this be acomplished. There is no way that we can control if any user or app access the server while we are restoring.
The problem is that when when we are restoring the databases if someone access any of them while the restore is taking place the process fails.
The question is how should the restore be performed? Is there any way to change the state of the database so that the databases can be restored?
Installed MSSQL Express 2008 R2 64-bit on my Toshiba Satellite netbook running Windows 7 (Home).
During the installation I named the local instance 'SQLEXPRESS_XXX' the XXX is a placeholder for my initials, which I don't want to say on the forum.
I checked the config manager and it sees the services for the named instance and corresponding SQL Server Agent service, both are stopped. I noticed both TCP/IP and named pipes were disabled, I enabled named pipes.
But when I start SSMS there is no database engine shown, when I type the instance name it can't connect. I tried registering it, started it from the config mgr, and it could not connect using window auth.
Not sure how to fix this issue, when I have installed earlier version couple years ago (MSDE) as soon as I brought up SSMS the first time the local instance appeared in the list.
I have the following implementation and I'm sure there is an easy way to do what I want to do but I can't figure it out.
1. I use forms based authentication to authenticate to my site
2. I use active directory to authenticate the users
3. I use the Allow Users="xxx" tag to authorize the users limited to the list that can access my site. (e.g.. even though Mary is an AD user she can't access my site unless I put her credentials in the allow users tag in the web.config file)
All is working well but I want to move the users access list (e.g.. <allow users="john" />" from the web.config to a database table so that I can create a user maintenance page for my admins to add and delete user access. For the life of me I can't figure out how to do this and I can't seem to find an article on it either. I'm sure I'm just not looking for the right thing, so help is greatly appreciated.
Here is my web.config file..
<configuration> <connectionStrings> <add name="DBConnectionString" connectionString="Data Source=PRIMSRV;Initial Catalog=MAINDB;Persist Security Info=True;User ID=svc.Test;Password=password