473,320 Members | 1,814 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Added users to a logged shipped database

I have 2 sql server 2000 database that participate in log shipping.
Server A is the source database, which log ships to a database on
Server B. The database on Server B is in a warm stand by/read only
mode. Is there a way that I can add users to the database on Server
B, without having to add the users to the database in server A? I am
trying to use the database on Server B as a reporting only database
and add more users to have permissions to run reports.

Please let me know if anyone has any suggestions. Thank you.
Dec 20 '07 #1
2 1552
"Justin" <ju*************@hotmail.comwrote in message
news:b5**********************************@i29g2000 prf.googlegroups.com...
>I have 2 sql server 2000 database that participate in log shipping.
Server A is the source database, which log ships to a database on
Server B. The database on Server B is in a warm stand by/read only
mode. Is there a way that I can add users to the database on Server
B, without having to add the users to the database in server A? I am
trying to use the database on Server B as a reporting only database
and add more users to have permissions to run reports.

Please let me know if anyone has any suggestions. Thank you.
Add the users on Server A.


--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
Dec 20 '07 #2
Justin (ju*************@hotmail.com) writes:
I have 2 sql server 2000 database that participate in log shipping.
Server A is the source database, which log ships to a database on
Server B. The database on Server B is in a warm stand by/read only
mode. Is there a way that I can add users to the database on Server
B, without having to add the users to the database in server A? I am
trying to use the database on Server B as a reporting only database
and add more users to have permissions to run reports.
No, that is not possible. If you were to make modifications to the
database on server B, then it would not be possible to apply the logs from
server A. What it the changes in the log are not consistent with the
changes you made on server B.

I can think of two options to achieve what you are looking for:

1) Create the logins on both servers, and create the database users on
server A. Then drop the logins on server A to leave the database users
orphaned on server A, but functional on server B. This works best
with Windows logins. And it presumes that the users in question does
not need access to other databases on server A.

2) Create a second database on ServerB with views on all tables in
serverA. Make sure that the second database has the same owner as
the log-ship database. Enable cross-database ownership chaining on
server B, or at least for the two databases. Add the users to
this second database, and grant them SELECT permissions on the views.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Dec 20 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Hollek | last post by:
Before users can use my asp-site, they have to login. The username is stored in a session variable "USR". I need a list of all users that are active in my site. I tried to store the logged...
8
by: gil | last post by:
I'm trying to track how many users are visiting a site and how may are logged in, using application sessions like so: Sub Session_OnStart Session.Timeout = 20 Session("Start") = Now...
1
by: Marcin Zmyslowski | last post by:
Hello all! I want to create a page in ASP language which gives me information about currently logged users. I thought to do it by this way: when somebody will log in to page, there will be a...
1
by: Shannon Rotz | last post by:
I have a database split into front-end, back-end, on a machine running Windows XP professional (no network, just a single machine). I just upgraded the database from Access 97 to Access 2000. The...
3
by: mgPA | last post by:
Short: How can I limit the number of concurrent logins to Access (2000) DB? Long: I seem to be having the problem discussed in previous postings of having more than 9 or 10 concurrent logins. ...
1
by: Smalley | last post by:
Need some help please. Have this code and for some reason it is not working correctly. I am not receiving errors, just the table is not being populated at all. I have created the tbl and the frm...
8
by: Mike P | last post by:
What would be the best way of counting the number of users who are currently logged on to a website? I am making the users login against a database of valid users. Would the best way be to add a...
3
by: RogueIT | last post by:
Is there a way in 2005 to tell what user is logged into what database on the SQL Server? thanks, Scott
13
by: snowinfo | last post by:
Hi all, any way to count the number of users i have logged into my site? any help/code appreciated, craig
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.