Moving Users From One Server To Another Help
Feb 6, 2001
We are about to migrate SQL 7 databases from one SQL7 server to another SQL7 server, but we've run into an issue with transferring users/logins/passwords.
The problem is that one server is case-sensitive, and the other is not case-sensitive. This causes each server to encrypt passwords differently from the other.
Has anyone else experienced this before? Is there a workaround? Microsoft acknowledges this as an issue with SQL 7 (with case-sensitive to case-insensitive transfers), but offers no workaround.
Dan Tan
dan.tan@tekelec.com
www.Tekelec.com
View 1 Replies
ADVERTISEMENT
Oct 18, 2004
Is there an easy way of just moving users from another db along with all it's permissions?
Constraint = Sorry, working with SQL Server 6.5.
Thanks in advance!
View 1 Replies
View Related
Oct 23, 2006
What is the best way to move users from a 2000 sql server to a 2005 server? I have a bunch of issues with the passwords etc...
thanks for your time.
View 5 Replies
View Related
Nov 15, 2000
Is there any easy way to move users between SQL Servers for a particular database?
We have tests and development servers I would like to make sure the user lists are in sync for that db.
Thanks
View 1 Replies
View Related
Jul 28, 2015
We have an existing SSRS server, and have just created a new child domain. We'll be migrating users from the parent to the child, and want to add the users of that new domain with access to SSRS. In the parent domain they are able to access, but after migration with the child domain account, they cannot.
I have added the group CHILDDomain Users with a system user role on SSRS, and PARENTDomain Users was already there.
Is there any additional step I should/could take to get this active?
View 5 Replies
View Related
Mar 6, 2008
I have had this issue just pop up. I have local users who can connect fine, but my users that require connection by VPN cannot connect. I get the server not available or access denied error. I did confirm that the VPN'ers are connected to the network correctly and can see that their shares and mappings are correct. Any ideas? Thanking you all in advance!!
View 6 Replies
View Related
Sep 28, 2015
I am trying to revert back to Windows 7 after upgrading to Windows 10, however it will not let me and the following message occurs: "Remove new accounts.Before you can go back to a previous version of Windows, you'll need to remove any user accounts you added after the most recent upgrade. The accounts need to be completely removed, including their profiles.You created one account (NT SERVICEMSSQLSERVER) Go to Settings> Accounts> Other users to remove these accounts and then try again".However I did not create any new users and there are no other users listed in the Accounts section.
View 2 Replies
View Related
Apr 30, 2008
hi alli've got two tables called "webusers" (id, name, fk_country) and "countries" (id, name)
at the meantime, i've a search-page where i can fill a form to search users. in the dropdown to select the country i included an option which is called "all countries".
now the problem is: how can i make a stored procedure that makes a restriction to the fk_country depending on the submitted fk_country parameter?it should be something like
SELECT * FROM webusers(if @fk_country > 0, which is the value for "all countries"){ WHERE fk_country = @fk_country}
who has an idea how to solve this problem?
View 9 Replies
View Related
Nov 10, 2015
I trying to get the moving total (juts as moving average). It always sum up the current record plus previous two records as well and grouped by EmpId.For example, attaching a image of excel calculation.
View 3 Replies
View Related
Nov 28, 2006
Hi Team,
In SQL Enterprise Manager, when we expand "Database -->Users", we see the
users there. When we expand "Security --> logins" we see the same users there.
Can you differentiate these two.
Thanks
Santhosh
View 1 Replies
View Related
Jun 4, 2008
I want to be able to list all users connected/logged in a specific database and disconnect them all or a certain user.
can this be done in SQL and if so how?
View 1 Replies
View Related
Sep 26, 2007
We are using Navision with SQL server 2003.
What kind of methods is there out there to reduce hwo often this happens?
View 10 Replies
View Related
Mar 7, 2006
Hi All, first post.
I have done a bit of searching around and cant find a clear answer to this question.
Current Setup
Desktop application (c#) that connects to a SQL Server 2005 express database on the same local network as the application (currently 3 users)
It is only a very small company and has just taken on their first remote worker, but expects to take on another 6-8 over the next few months. They have asked for the database to be moved online.
The application was written in such a way that everything has been done using no stored procs, or views, it is all native SQL.
This will be my first DB hosted online and before I go ahead and do anything I just wanted to make sure what I have to do is correct, sorry if this is a very basic question, although I have been programming for a long time, I have never had the chance to do any online databases before.
Will this work.
1.Find a SQL Server 2005 Hosting company.
2.Move the database to the server.
3.Setup the users permissions.
3.Alter the connection string in the application to point to the new location.
So the only thing that would change would be a new connection string in the application preferences?
Or am I living in a dream world, because nothing is ever that simple.
One thing I am worried about is the security/visiblity of the database and data as it travels from the server to the client and back.
Thanks for any advise you can give.
Mark
View 2 Replies
View Related
Feb 9, 2007
hi, does anyone know how I can make a connection to a 2000 db thru ssis?
View 8 Replies
View Related
Dec 28, 2003
Hi I'm very new to this but what I'm looking to do should'nt be too difficult although I've tried to no avail.
I'm looking to deploy a web site that uses SQL2000 to another server. Im trying to find out how to move the database to that server. Ideally I would like to be able to save it to CD for safety but its not like old access where you save the mdb file. I need to save the whole 'DTS' package, is that what its called? stored procedures, triggers the lot.
I tried the wizards but just got in a mess.
Thanks
View 4 Replies
View Related
Jul 28, 2000
I have serveral jobs set up on my current SQL Server, and I am not sure how to move the jobs to my new SQL server. What is the best way to do this?
Thanks,
John
View 2 Replies
View Related
Jul 23, 2004
Hi -
At my work, we have a SQL Server 2K DB on a server. This server is being replaced and the DB needs to be copied from the old server to the new server and I've been asked to perform this task. What I was planning on doing was:
1. Making a copy of the database on the current server
2. Taking the .BAK file created and coping it to the new server via a mapped drive
3. Restoring the database from the .BAK file on the new server
The only concern is moving the .BAK file across the network due to size.
Is this the best method to do this or is there a more preferred way? By doing this, what potential issues could be encountered?
Any help/advice is greatly appreciated!
Thanks!
View 3 Replies
View Related
Aug 17, 2007
Our SQL server, Report Server and IIS server are all on 1 physical server but that's going to change. We're moving the IIS/web server to a new box but the database server & report server will be on the old box.
Are there available documentation on how to move the Report Server service and IIS configuration of the Report Server?
View 5 Replies
View Related
Jun 25, 2001
I am hoping somebody can tell me in detail what is the quickest and fastest way to move SQL 6.5 to a new server. The server it is on is out of resources and space, and I have a new server to move everything over to. I assume I can just install SQL 6.5, copy the DATA database and MSSQL directories over, and rename the new server to the original name and take the old server offline?
Please give me as much detailed directions if you can.
Thank you
--Lance Johnson
View 2 Replies
View Related
Jul 2, 2002
Hi Team
We are moving our production SQL server(EE) box to new box. Also, we
need to change the server name with new name. Currently, we have lots of
DTS, Transactional Replication and many jobs running.
What are the precautions / DOs and DONTs to make successful transfer to
the new server? Apart from restoring msdb on the new server, is there
anything we need to concentrate?
We use DTS to transfer logins and objects.
Thanks in Advance
View 2 Replies
View Related
Jun 7, 1999
Hi Everbody,
I've got a client that set up their own SQL server. It is
currently installed on NT4 on the system volume. It needs to be moved
to a directory. I was wondering if anybody has ever done
anything like this or can offer some good advice on the
best place to start.
Thanks,
Dan
View 3 Replies
View Related
Feb 15, 2006
I'm currently working on a project, with development at my location and production at another. My question is what is the best way to copy database changes, ie adding/removing fields, without having to copy over the existing data. I have been just noting what fields I add and remove, and going to the production server and doing it by hand, but this obviously isnt the fastest way to do it. Essentially when I add a new module to the system on production, I have to manipulate existing database tables. I want to copy the schema of those tables to production, but I dont want to lose any existing data on production. Thanks in advance.
View 3 Replies
View Related
Feb 20, 2007
I'm doing a remote deployemnt of an asp.net app using Sql Express from my local dev machine to the ISP.
Moving the database to the new machine is one thing, but how do you move the users?
Just adding the same username and pwds as logins is still going to throw you out of the db isn't it?
I've run the Database Publishing Wizard on the target machine, but the t-sql falls over whenever it encounters an unknown user.
View 1 Replies
View Related
Jul 20, 2005
Hi all,I have been given the task of moving an sql database from one serverto another. These servers are not on the same network. I know I candetach the database, copy it to a new location, then FTP it to the newserver and re-attach it.My question is, is this the best way to do this? Or is there anotherway? I have access to both servers through Enterprise Manager.TIA
View 1 Replies
View Related
Mar 31, 2008
My searches have come up blank, so I'm hoping someone else can point me in the right direction.
I'm done some development in SQL Server Express, working on tables and procedures. I've now got to move those tables/procedures into SQL Server and I don't know of an easy way to do this. Are there any tools I can take advantage of that would allow me to get all these objects moved? The only way I can see to do it is to move objects over one-by-one. This would be really time-consuming, and I'd like to avoid it if possible.
I'm positive I'm not the first one to try this, but what should I be searching for? Are there tools/procedures I should be looking for?
Appreciate any help I can get.
Thanks.
View 2 Replies
View Related
Feb 28, 2000
We have both a production SQL 7 server, QA, and Development. From time to time, I want to move just the data from the production server to the other 2 servers without modifing the objects that may have been changed such as stored procedures and rights. Is there a way using the SQL tools provided that we can just move the data. Becuase also what happens is that the rights to the objects change which means my developers no longer have access to the tables for selects in QA since the changes where overwritten by production where they do not have the rights.
Thanks
Ricky Kelley
View 3 Replies
View Related
Mar 18, 2008
I have two databases on two different servers (an old hosting solution and a new). I need to get all the data from one server to the other but I have no clue as how to do it with MS SQL Server Management Studio Express.
I can easily make the create table scripts that will allow me to create the tables on the new server but what about all the data. I wondered if there is some way to export and import data from one server to another?
With the old SQL Enterprise Manager I was able to import or export as I saw fit but I can't seem to find anything like this with the express manager.
Anyone has any advise as I would like to avoid coding somekind of export program myself,
Many kind regards
Weinreich
View 3 Replies
View Related
May 22, 2007
We have a new server (SRV63) and I followed the instructions at http://msdn2.microsoft.com/en-us/library/ms156421.aspx to move the report server database from our old server (SRV38). Everything appeared OK, however, when I went to initialize the instance in the Reporting Services Configuration tool, it shows an initialized instance (checkbox is checked) for SRV38 and and uninitialized instance for SRV63 (checkbox is not checked). Please note that I am not trying to create a scale-out deployment. I tried to initialize SRV63 but received the error below.
--------------------
ReportServicesConfigUI.WMIProvider.WMIProviderException: The report server installation is not initialized. (rsReportServerNotActivated)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ThrowOnError(ManagementBaseObject mo)
at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.InitializeReportServer(String installationId)
------------------
This is the only thing stopping me from shutting down SRV38 and bringing SRV63 into production. Can someone assist me with this issue?
View 4 Replies
View Related
May 23, 2006
Hi, i was after some advice on moving a SQL Server 2000 database from one server to another.
Usually i would do this by backing up the database on the original server the copying it accross the LAN to the new server and restoring it there. This database is 10Gb in size and copying it accross the LAN will take some time and i would like to minimise downtime if possible. The database is at a customer site where i am not responsible for the network or Hardware.
Thanks in advance for your help
Nick
View 4 Replies
View Related
Aug 17, 2006
Hello,
I am new to this forum, and ASP .NET 2.0. I watched the tutorial on how to use the login control with SQL Server 2005 Express, and was able to duplicate it easily. However, I tried to see if I could do the same thing with SQL Server 2005 that is hosted by my hosting company, and I was unable to get it to work. I am using Visual Web Developer 2005 Express, at least until I get VS 2005 in a few weeks, and I am able to connect to the SQL Server. I tried following the tutorial on this site step by step, and some of the things they used to set it up I could not use. In the tutorial VWD creates the table automatically. If I use the hosted database, do I need to create the table, or is there a way for VWD to do it that I haven't figured out yet.
Any help and additional information that I might need to know would be great.
Thank you for your help.
Ben
View 2 Replies
View Related
May 3, 2007
Hi there,
When conecting to a MS SQL Server 2005, I could define in my connection string Windows Authentication.
What account it will be used? The one used by IIS (I still don't know the user ASP.net runs, if it is independent of IIS or not)?
And if I whant that some aspx pages have diferente acess rights? I need to use SQL Server Authentication with diferent users created in MS SQL Server right?
In ASP.net, what is best practice: Have one SQL account, and make users access rights in Business Logic, or have different SQL Accounts por the diferent access rights I whant in every page?
Sorry if this are basic questions, but In the find's I made, I saw very confusion ideas.
Thanks in advance, and sorry my english.
Alberto Ferreira
View 1 Replies
View Related
Sep 10, 2007
I am looking for the stored proceedure to get all of the users and their rights on a server. I have tried sp_helpuser and this isn't giving me all of the users on the server, just per database, it doesn't tell me the username if the user isn't assigned to a database (for instance SA) I don't think. Also, sp_helprotect gives me way too much data. What I am looking for is a listing of all of the users on the server with their DB level permissions, e.g. datareader, datawriter, dbo. I need this to work on both SQL Server 2000 and 2005 and thus the desired use of a stored proceedure.
-Kyle
View 4 Replies
View Related
Aug 11, 2006
Hello Everyone and thanks for your help in advance. I am setting up a new testing and development machine. My previous machine had VS 2003 and SQL Server 2000 installed on it. The new machine is going to be VS 2005 and SQL Server 2005 Standard. I have approximately 12 databases on the old machine in SQL 2000 that I want to bring over onto the new machine and convert to 2005. What is the best way to go aobut this. I'm sure I'm not the first to do this, but I'm having trouble finding documentation on this topic. Any help would be greatly appreciated. Thanks.
View 4 Replies
View Related
