Users And Login Restoration
Jul 24, 2002
SQL Server 7 or 2000.
I restore a database on a different server from a device file. This database has a user defined for it. In this case, 'privuser' is the name. No login has been defined.
I can add the privuser login but cannot grant db access because privuser already exists in the db. I cannot drop 'privuser' because the user owns all the user objects in the db.
How can I make the privuser login I create access the db using the privuser username in the db? Would having the login created before restoring the db as a new db work?
View 4 Replies
ADVERTISEMENT
Jun 5, 2015
I have a server that has 20 databases . I have tested with few users with different level of access and all of them were able to connect to the server and also see, select, update , delete from a particular database which is kind of weird because they do not have a user login associated or mapped to that database. I checked and no user is part of any group in AD that would give them permission to connect . I need a query that would find the permission path of a user. I already queried with xp_logininfo but I am not getting any thing.
View 9 Replies
View Related
May 27, 2008
can there be multiple users on one single sql login?
I keep getting errors from my users randomly about the server timing out and i am wondering if they are trying to submit append queries at the same time.
View 5 Replies
View Related
Apr 9, 2008
I am new to this, so, I will be greatful to anyone who can clarify the following:
qn 1:
In login properties under Logins of Security, what does creating mapping to the different databases mean ?
For a given login, I notice that I can login / execute DDL statements alike for the databases which are checked and also for the ones that are not checked.
Then, what does
Security -> Logins - > Login Properties -> User mapping -> Users mapped to this login -> checking the database - accomplish?
qn 2:
For a perticular login, say 'Bob' which has server admin rights, I wish to include two more databases. For this I 'checked' the databases, which I wish to include, in the
Security -> Logins - > Login Properties -> User mapping -> Users mapped to this login
When I clicked 'OK', I get the following error and the two databases are left unchecked.
User, group, or role 'SQL1AGENT' already exists in the current database. (.Net SqlClient Data Provider)
How can I include the databases ?
View 5 Replies
View Related
Jul 22, 2002
I made a backup of a production database and copied that backup over to a development server and restored the database. Now I have users saying that the application is failing on development. I have users that have NT authentication and some with SQL authentication.
What is the best way to get everything to sync up again?????
View 1 Replies
View Related
Apr 11, 2007
Hi,
I have a few db's that I am backing up from an old sql2000 system and moving them to the new sql2005 server. The first db's restored without any problems but now I am getting some problems with users and logins.
I am restoring in the following order
1.) Creating empty db "123"
2.) Restoring database from file to database "123"
3.) Creating Login to this database (error happens when linking it to the database, "user exists")
When connecting thru QA I get "Cannot open user default database login failed"
I only have 1 login per database and I don't mind manually deleting and recreating them all but it doesnt seem to be working :S
Any suggestions much appreciated!! :)
Thanks!
mike123
View 4 Replies
View Related
Oct 22, 2007
I'm trying to set up my reports with parameters, to select the paramater by the users login. For example, if someone from the Northwest Region accesses Report mangers and then a report. Instead of them clicking the drop down, for the report parameter. The report automatically generates from the login that gave them access to report manager. So it diplays the information for the Northwest Region.
I know how to do this for Data Driven subscriptions.Such as creating a table , with Region, login, email, and all the information relevant. But how do i do this for users accessing the site theirselves? Is this possible?
View 4 Replies
View Related
Apr 3, 2008
I am in a situation where I would like to use a SQL login instead of adding individuals windows login to the server. Is there a way to force a login instead of having the report server not give rights at all??
I hope that makes sense...
Thanks
View 3 Replies
View Related
Oct 28, 2015
I have to give three users read access to a database.  My manager told me to map them to a User called "zxDatabase.Read.ug". I scripted the User and got this...
CREATE
USER[zxDatabase.Read.ug]
FORLOGIN[zxDatabase.Read.ug]
I don't see a Login at the server level named zxDatabase.Read.ug, so this is confusing. Where is this login in SSMS?
How do I map my three users to user zxDatabase.Read.ug. Or am I not understanding correctly? Do I just add there windows login to the database as Users and configure them the same as zxDatabase.Read.ug
View 4 Replies
View Related
Feb 21, 2014
We build up a new website in .net mvc 4.0 on a w2012 server with MSSQL 2012 database.We use windows autentification and normal anonymous access through NT AUTHORITYIUSR who is also a login in the database.But we make extra login possibility for users who are registered and they can insert and modify data in some tables in the database. And I'am afraid of giving NT AUTHORITYIUSR insert and update for some column in tables.I think of set up a new login for the database. Run a new connection string on login and set up special permission for that extra user on the database, and let the user become a member of the ordinary user on the database.
View 0 Replies
View Related
Jun 12, 2015
Is SQL Server sensitive to Domain group name? Like "Domain Admin"?
I have user that belong to "myDomainDomain Admin" group. Group is in SQL as sysadmin but user cannot login using domain credentials. When I move that user to a different domain group which that group is in SQL again as sysadmin my user is able to login.Â
Environment: SQL 2008 Standard Edition.Â
View 12 Replies
View Related
Mar 10, 2014
I am migrating a database TESTDB from SQL 2008R2 to a new server running SQL Server 2012.
Management has decided the current sql users should have "better" user names. So the login and username "BadUsername" on the old server should be called "GoodUserName". Goodusername should have the same permissions as Badusername.
I have now restored a backup from the old server to the new server.
I used the following script for creating the login:
CREATE LOGIN [GoodUserName] WITH PASSWORD=N'difficultpassword', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
Then I run the following script:
ALTER USER Badusername WITH LOGIN = GoodUserName, NAME = GoodUserName
But the results are not what I wanted. I now have two database users: Badusername and GoodUserName. I would have preferred if BadUserName was "replaced" by GoodUserName, but it won't be a problem if I have to delete badusername manually. Worser is that GoodUserName have NOT "inherited" any permissions from Badusername.
Is there an easy way to transfer permissions or do I need to loop through the permissions of badusername and apply those to badusername?
View 4 Replies
View Related
Jun 9, 2015
we have an application which lets users connect to production database with windows credentials, They are able access the sql tables too with windows login. I want to restrict them from accessing the sql tables. How do I do that.?I tried a db_deny but that prevented them from accessing the application too.
View 10 Replies
View Related
Feb 2, 2007
Hi. I have a DetailsView with Bound Fields "Login" and "Password". This informations are stored in SQL database. How to solve such authorization? How to compare password stored in database against passowrd typed by user? Is this a good idea to use CustomValidator control to write some checking procedure?. Regards. Pawel.
View 1 Replies
View Related
Dec 20, 2000
I have jsut started using SQL server 7 and am having problems with accounts permissions, users,roles, groups, owners etc what are the differences?
View 1 Replies
View Related
Dec 12, 2007
Hello Everyone
How do you generate a script for all the current sql server logins and generate a script for database users for each database.? You can script operaoers, tables, databases, and a lot of other objects by using the “All Tasks” shortcut menu option, but I haven’t figured out to script logins and database users. Any help would be greatly appreciated.
I’m using sql server 2000 and Enterprise Manager.
Thanks
GEM
View 2 Replies
View Related
May 7, 2001
i am restoring newdatabase(test) with the backup from other server.
The problem is the restoring process is hanging and its not restoring the
database .when i stopped and refreshed the databases the database is not showing up
could some body Give patch for this problem
Thanks
Prasad
View 2 Replies
View Related
May 16, 2000
Please excuse my lack of understanding as I am not a SQL DBA.
I have just received a database backup: "myDB_20005034400.bak" and have been
asked to put a copy on my server. I am told that this was made from the Enterprise Manager's DB Maintenance Utility. The backup Administrator has left the company with the server in a crashed condition.
How can I find out what "myDB_20005034400.bak" pertains to? (No msdb, etc. available). I am RESTORING TO A NEW SERVER.
MAIN: HOW DO I RESTORE THIS FILE TO A NEW DATABASE; ie TestDB (TestDB.mdf;
TestDB.ldf)?
Thanks a trillion.
Shelly
View 2 Replies
View Related
Jan 11, 2000
Hi,
Please give the retoration procedure:
I have a production server and I want test it on the other machine to check whether my backups are working or not?(Please give me step by step so that I can do easily)
Your answer will be highly appreciated.
Thanks,
dindu
View 1 Replies
View Related
Dec 7, 2000
Hi !
when i am trying to restore MSDB database from a disk backup it is giving an error saying
"Database in use.System administrator must have exclusive use of the databse to run the restore operation".
But i am not using msdb anywhere.when i see the processes under current activities i see an application named sqlagent-alert engine using the database.even after killing this process it reppaears and stops the restore operation.
so i stopped sql server agent and did the restore operation.It worked.
so is it necessary to stop sql server agent while restoring msdb?may i know the logical reason for it?
View 1 Replies
View Related
Apr 21, 2008
Hi Gurus,
While one of my DB through job i got following error message.
Failed to uncompressing data block. RESTORE DATABASE is terminating abnormally. Read on "VDI_2A04E518-0B70-41F8-BA22-48A63F9AC65C_0" failed: 1223(The operation was canceled by the user.) [SQLSTATE HY000] (Error 52008). The step failed.
Can someone help in this.
Thanks,
ServerTeam
View 5 Replies
View Related
May 7, 2008
Hi Gurus,
Every time when i want to restore database Iam going with SqlLight restoration scripts.
Here iam unable to get estimation time while restoration time.
How can i get time to complete restoration when database is in middle of restoration.
Please advice...
Thanks,
ServerTeam
View 3 Replies
View Related
Feb 14, 2006
VijayaKumar writes "We have SQL Server 7.0 & that machine was crahesd out. We took the .ndf & .ldf files and restore the DB in onther machine.
In that machine I am able to Login but during the time of retrival (select query or stored procedure) it gives the following error....
Server: Msg 823, Level 24, State 1, Line 1
I/O error (bad page ID) detected during read of BUF pointer = 0x1174f100, page ptr = 0x217f8000, pageid = (0x1:0x55b1), dbid = 12, status = 0x801, file = E:MYSTS_CWS_DB_PRIMARY.ndf.
Connection Broken"
View 1 Replies
View Related
Mar 29, 2007
Problem in restoring new database with the backup file stored in tape drive
tape doesnnot contain sql server backup set
View 2 Replies
View Related
Oct 16, 2007
Hello all,
I operate a website which runs on Server 2003 and SQL 2005 Express. Unfortunately my server experienced a hard drive failure, however fortunately I have a full backup using 2003's NT Backup.
My new server is slightly different specification wise to my last server - but my question is, what are my options for restoring the database and how would I go about this? I do administor 2003 servers, but I'm not a database administrator.
My initial thoughts are to update Windows and its components (such as IE) and SQL 2005 to the same equivalent versions, and to perform a full restore, but what if it breaks Windows?
My second thought is to somehow extract the database from my backup file, but then I wouldn't know where to start how to re-import everything.
All comments would be welcome! Many thanks, Mike
View 5 Replies
View Related
Nov 6, 2007
Hi all,
Please find the following details and give me appropriate solution.
Full backup: everyday :00:30 hrs
Differential backup: everyday 20:00 hrs
Transction log backup: every 30 mins
Database size is 150+ GB
Lastday one of our disk got crashed which had contains data and log file of the database at 22:25. Now my client wants all of the data till 22:25.
I can recover data till 22:00 but how can I recover last 25 minutes data.
Please help ASAP
View 5 Replies
View Related
Jun 5, 2006
I am working on a site redesign which attaches to an MS SQL backend. The hosting company sent me a backup copy of the DB. I am trying to restore the db into my SQL Server but keep getting an error. I created an empty DB and then backed up that DB. I then replaced the .bak from my db with the .bak file he sent to me in a zip document. I then tried to do a DB restore through enterprise manager and recieved this error:
Device activation error. The physical file name 'd:sqldatabasemssqldatastklaweb_db_data.mdf' may be incorrect. File 'stklaweb_db_data' cannot be restored to 'd:sqldatabasemssqldatastklaweb_db_data.mdf'. Use With Move to identify a valid location for the file. Device activation err. The physical file name 'd:sqldatabasemssqldatastklaweb_db_data.ldf' may be incorrect. File 'stklaweb_db_data' cannot be restored to 'd:sqldatabasemssqldatastklaweb_db_data.ldf'. Use With Move to identify a valid location for the file. RESTORE DATABASE is terminating abnormally.
I need to get this db restored asap. Any suggestions/help would be GREATLY appriciated!!!
Jason
View 12 Replies
View Related
Oct 27, 2004
Hi,
Im getting this error when attempting to retrieve data from an sql database.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot open database requested in login 'projectAllocations'. Login fails. Login failed for user 'sa'.
Source Error:
Line 13: objConn = New SqlConnection( "Server=LAB303-066NETSDK; Database=projectAllocations; User ID=sa;Password=mypassword")
Line 14: objCmd = New SqlCommand("SELECT * FROM project_descriptions", objConn)
Line 15: objConn.Open()
Line 16: objRdr = objCmd.ExecuteReader()
Line 17: While objRdr.Read()
Source File: C:finalyearproject2sample.aspx Line: 15
Please Help!! Im a beginner to this, so if anyone knows the answer, take baby steps when explaining. Thanks
View 3 Replies
View Related
Jul 27, 2005
Been looking through the forums for a solution to this problem.I already tried granting access through statements such as:exec sp_grantloginaccess N1'machineNameASPNET'But they don't seem to work.. i vaguely remember seeing somewhere a DOS command line statement that grants access to the ASPNET_WP and that fixed my problem before on another computer.. but this is a new computer and i forgot to write down the command.Can anyone help explain and propose a solution to my problem. Many thanxs.
View 9 Replies
View Related
Sep 22, 2000
Hi Folks:
This seems like a pretty straightforward question, but since I've been trying to find this in BOL and not having any luck, I thought I'd ask some folks more experienced than I.
How much room do I need on a SQL box to restore a 6.45 gig database? (it's
going from a huge machine to a backup tape, then from the backup tape to a
much smaller machine for testing an app, and we're trying to find out what we need to do to make it all work out.)
I'm assuming that I would need significantly more than the 6 gigs of the db for the work of actually doing the restore, but can't find out how much more...
Any ideas would be most appreciated.
Many thanks in advance,
Tom
View 1 Replies
View Related
Dec 5, 2000
Hi,
This is the problem which we face now and then. There is an automated job that run everyday night to restore the Database for reporting purposes. Before running that job an NT Task Schedular stop starts the sql server. This is to make sure that all the connections are closed. Nobody uses it at Night. But some times the job fails with bellow error message...
"Database in use. The system administrator must have exclusive use of the database to run the restore operation. [SQLSTATE 42000] (Error 3101) Backup or restore operation terminating abnormally. [SQLSTATE 42000] (Error 3013) Associated statement is not prepared [SQLSTATE HY007] (Error 0). The step failed."
Should I make the DB option set to single user mode. I don't think that is the problem.. because it runs fine most of the time..but sometime it fails.
Please help.. Thanks in advance :-)
Shyam.
View 2 Replies
View Related
Dec 16, 2005
Hello friends,
Kindly guide, if you are aware of any mechanism for restoring the differential backup only.
This can save a lot of time other than restoring complete database.
Thanks in advance.
Shrirang
View 2 Replies
View Related
