Synchronising Logins(Urgent)
Nov 19, 2001
Hello,
I've installed development server and created the databases, and restore the ddatabase from backups of production server, There the users in the databases which are not in sysxlogins in master, Please guide me how I can synchronise the logins? Can I bcp out sysxlogins from development and then bcp in in development server? Is there any way there even groups in the database and do I have to corncern about any other tables in master db
Thanks in Advance
Alpa
View 3 Replies
ADVERTISEMENT
Jan 21, 2007
ok, first, I know... I forgot to run a backup of the master database, and I forgot to run a script to caputure logins. Not that that is out of the way... I need to recreate the logins under the Securities tab below the databases. All the company databases have the user names and passwords assigned to them, but they are not able to login, because they are not able to authenticate to the SQL server first.
Is there a script that someone has that will copy the company database security info for the users and recreate them in the SQL security tab?
I know that I can rebuild them manually, but I need to delete them first in the application software, then delete them from the databases, and then recreate them in the application software... and as simple as that sounds... it is a slow moving process.
Any assistance would be greatly appreciated.
Thanks,
John
View 3 Replies
View Related
Apr 28, 2008
Hey folks,
I'm looking to gather ideas on this before I start the project; so what better way to start than to ask here? ;)
The situation is this: we are in the process of replacing a large data driven application with a new one. Before turning the old'un off (that's not for a minimum of 6 months), we need to migrate data between the two entirely different schemas, and I've been tasked with writing the interfaces.
Now, here comes the kicker; they don't just want a "straight-forward data conversion", they want to run a period where they can still update both databases and any changes in the old one are to be pushed into the new db.
Because the schemas are not the same, I believe replication is out of the question so I was looking for advice as to what possibilies I have ahead of me to achieve this.
I fear I may not have expained this well enough; so as always if there are holes in the detail let me know and I'll do my best to fill them in :)
Old db = SQL Server 2000
New db = 2005
Thanks,
George
View 13 Replies
View Related
Dec 25, 2005
HiWe have an internal ms access database which we need to synchronise with ourwebsite with sql server 2005 backend which is hosted on a public host. Myquestion is; is there a way to keep the two databases synchronised using thetechnologies built in sql server 2005 and/or access? We also have thepossibility of an in-house sql server 2000. Can this be used in anyway tohelp, perhaps by moving data from in house access to in house sql server2000 and then synching sql server 2000 and remote sql server 2005?ThanksRegards
View 1 Replies
View Related
Jun 27, 2007
Hello guys,
I'm stumped. Is there a way to get a compact edition client (running on a standard PC) to automatically sync. (using merge replication) with a server on a schedule?
I can quite happily pull up SQL Managerment Studio and sync. on the client, but I want to have something running in the background basically doing this for me (again, on the client). I know I can do it in code, but we've not yet received our Visual Studio package, so for the moment, I want something already written to do it for me.
Surely this must be possible?
Thanks in advance!
View 8 Replies
View Related
Jan 23, 2008
I have a problem synching my xda mini s with my pc using vista. A previous thread was unhelpfully closed by Ilya as being off topic; well it isn't on topic anywhere else. At least not according to microsoft's own search engine. Ilya, why not try giving a helpful answer instead of 'not my problem'? My xda will not synch using vista; XP and ActivSync has been perfect. I've tried installing mobile device centre version 6.1 but I suspect vista isn't compatible with Windows mobile version 5.1. Should it be? If not, is there a patch or is upgrading to vista going to cost another couple of hundred pounds to get a compatible mobile device? If so, I'm off to a different operating system. Perhaps, like many others, back to XP and let Microsoft continue to dither around and experiment on others.
View 1 Replies
View Related
Oct 4, 2001
Hi, can anyone point me in the right direction of how to sync an in-house SQL Server 7 with a remote SQL server 7.
We are a development house. We build website using SQL server 7 databases then move them up to an entirely different SQL server 7 database in a remote location.
Now, please don't laugh, currently we export all the data from the development server into a csv and import it back into the live server. As you can imagine, it's clunky, time consuming and unreliable.
Is there a way to automatically sync the two? I tried desperately to find any information but even the MicroSoft MCSE training manual on SQL doesn't say how to do this.
Any help would be greatly appreciated.
Thanks in advance.
Chris
View 1 Replies
View Related
Dec 28, 2005
HiIs there a way to synchronise/replicate an access db with sql server 2000db, short of writing the code oneself?ThanksRegards
View 1 Replies
View Related
Nov 17, 2006
Hi
I have a production system running sql 2000 server 32 bit
Now i am planning to move to SQL server 2005 64 bit setup .
I need to have a set up of both SQL 2000 and sql 2005 in parallel for some time until it is sure that the sytem can completly move .
The problem is how do i synchronize the data in the two servers when they are operating parallely.....
Please advice.
Thanks in advance......
View 1 Replies
View Related
Feb 8, 2007
HI ,
I Created one database named login.sdf in sql Ce ,i created one table login having two fields (username and password).it is working well.I trying to synchronise these with SQL2000 using Active sync.it is not working ..And one more things ,i tried to connect the default pocket PC 2002 emulator with Active sync.it is also not working.can anybody give some solution for these problem
Thanks in Advance
Regards
Ihsan
View 8 Replies
View Related
Jul 17, 2001
Hello,
I would move a Database to another server. I try to use DTS but I have problems with this process because DB have big tables, I think. I try to use DETACH and ATTACH procedures but logins doesn't export. And more, in new server there are already logins from another DBs.
What's the best way to solve this problem?
Please, help
Thanks
View 3 Replies
View Related
Apr 3, 2007
I am a systems analyst and work with an app that runs against 2 SQL Server DBs. Though I have some familiarity with SQL Server and SQL, I am not a DBA.
The app executable is tied to a Windows service.
When we install the app, we run a process that builds 2 dbs to include:
Tables, indexes, stored procedures, views and user accounts.
SQL Server is set up for mixed mode authentication.
Normally, the dbs run off the local db user accounts which are tied to local logins with the same names.
We have a client that wants to remove our standard logins so that they can run on only a Windows login.
I know I should be able to tie the db users to a Windows login.
And I can do the same for the service.
But I am at a loss as to how to get this done.
How do you associate db users with a Windows login?
When I have tried sp_change_users_login I get an error that the Windows login does not exist. (Though I have added the Windows account to the DB.)
Hope this all makes sense.
View 2 Replies
View Related
Sep 27, 2000
This morning I can not connect to our SQL Server 7.0 whatever from client or server. The error message which I list below:
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++
A connection could not be estabished to server--Timeout expired
Please verfy SQL Server is running and check your SQL Server registration properties and try again.
++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++
We use windows NT authentication. We did not do any change on NT. The SQL Server daily schedule job usally stoped at 10:00AM, but today from the Window NT Task Manager, we can see that the SQL Server is still running untill now.
Please help!!!
View 3 Replies
View Related
Oct 26, 2000
hi, I have settup up sql mail and did the following:
1. created an E-mail account and configured Out look by creating a pop3 mail profile. tested it by sending and receiving mail, that is ook
2. I Created one domain account for MSsqlserver and Sql Agent service. both services use same account and start automatically in the control panel-services
3. I used the profile that I created in outlook to test the sql mail but got an error:
Error 22030 : A MAPI error ( error number:273) occurred: MapiLogon Ex Failed due to MAPI
Error 273: MAPI Logon Failed
I really do not know what went wrong. I followed the steps from bol and still having a problem. Am I missing something.
I do have a valid email account
I do have a valid domain account
I tested outlook using the email account and it worked. so why sql server does not recognise MAPI.
My next question, How to configure MAPI in Sql server if what I did was wrong.
View 1 Replies
View Related
Mar 23, 2001
Hi, I have 2 windows 2000 server in cluster with sql server 2000 enterprise edition installed.
I have activated the Server-Requested Encryption by using the sql server network utility (Force Protocol Encryption). After this, I have stoped sql server service. But I can't start it at this moment.
The error is:
19015: The encrypton is required but no available certificat has been found.
Please help me to start sql server.
Thanks.
Michel
View 4 Replies
View Related
Jul 6, 2000
Hello,
I am facing a huge problem in my sql server database using access as a front end.The main problem is trying to execute queries "views" ,since they reside on sql server now,and using variables or parameters in reports and forms to filter on this query.
Ex.
how can the following be implemented using the same query but in sql server?
Access
------
SELECT MAT_Charts.YYYYMM
FROM MAT_Charts
WHERE ((([Area_Code] & "-" & [GROUP_CODE])=[Reports]![MAT_Chart_C1].[MAT_Key]))
GROUP BY MAT_Charts.YYYYMM;
It is specifically this statement in which I am interested:
[GROUP_CODE])=[Reports]![MAT_Chart_C1].[MAT_Key]))
Thank you very much for your concern.
View 2 Replies
View Related
Apr 12, 2004
How do you make Asp.net use something other than the local ASPNET user for data access in sql server
View 3 Replies
View Related
Jul 10, 2001
I need to copy 80 logins within the same SQL Server (7.0 SP1) from 80 "old" logins that I'll delete later.
I clearly need to maintain all the security options for the new logins.
Is there a way to do this, adding the logins with the new name and granting all security options? Is there a script that will do this task or can somebody help me in doing that?
Thank you.
View 2 Replies
View Related
Dec 21, 2000
Hi,
I have two servers (server1, server2). I was trying to access the data from server1 to server2. I linked the servers and set up the option for data access.
when I run the following command from server1: sp_remoteoption 'server2', 'sa', 'sa', TRUSTED, TRUE
It gives me the following error. How to handle this.
Server: Msg 15185, Level 16, State 1, Line 0
There is no remote user 'sa' mapped to local user 'sa' from the remote server 'server2'.
I appreciate your help.
Thank you.
Eric s.
View 1 Replies
View Related
Apr 13, 2000
I have a server that was recently upgraded from SQL 6.5 to 7.0 that contains almost 700 logins using standard security. Is there a limit to the number of logins that SQL will host? The logins/users have all been added using a GUI within an application and does not support NT authentication. Does this cause any known problems in SQL 7? When I right click on the database and go to properties / permissions MMC gets hung up. Also one of the systems analysts is convinced that SQL is dropping permissions (I disagree to this). Any one have any thoughts or experience with large numbers of logins / users?
Linda
View 3 Replies
View Related
Jun 19, 2000
Does anyone know of any 3rd party software applications that will make users change their SQL
logins every 3 months?
Thanks,
Heather
View 1 Replies
View Related
Mar 14, 2000
Hi!
How can I copy all logins from one SQL server 6.5 to
another one.
Thank you.
Anny.
View 1 Replies
View Related
Sep 30, 2004
How can I determine which users are using the database??
Thanks
View 2 Replies
View Related
Feb 28, 2008
I am new in sql and have problems about logins.
with sql 2005
1)I create a windows login in my home pc (win xp home sp2) and i can connect server with ssms this new user
but in my office (win xp pro sp2) create a windows login (it is a windows user also) and when try to connect with ssms take error 18456 (user name and pass is true!!!)
2)in my office pc i create a sql login which has no role. but this user can create users and dbs. but in my home pc, user has no role cant do thats...:eek:
View 1 Replies
View Related
May 15, 2008
Hi everyone,I am new to this forum.I hope some body will help me in this,I am trying this for the past 6hrs.
on my server there are some hundreds of sql logins are there,I need to identify the logins which doesn't associated with either any databases or dbroles,server roles.Later i need to delete those logins.Can any body help me in this.
Thanks in advance.
View 13 Replies
View Related
May 22, 2008
y r u doing like dis guys?
View 4 Replies
View Related
Jun 12, 2008
Hi All,
I want to generate script for users and their associated permissions on the xyz database and at the same time I want to generate script for associated logins and their roles over the xyz database.
I am using SQL 2005 environment.
Needs urgent help.
Regards,
Austin
View 2 Replies
View Related
Apr 19, 2007
2 issues
i login using windows authentication. looks like i cant create a new sql server authentication login. what can i do?
and when i try to login with my sa login it pops the errror 18452. does this mean i didnt install mixed mode? i cant remeber.
View 6 Replies
View Related
Jun 13, 2007
After installing 2005 I have these 5 logins. Do I need them or should i wipe them out? What are they?
YPGA-SQL2005-DEVSQLServer2005MSFTEUser$IPG-SQL2005-DEV$MSSQLSERVER
YPGA-SQL2005-DEVSQLServer2005MSSQLUser$IPG-SQL2005-DEV$MSSQLSERVER
YPGA-SQL2005-DEVSQLServer2005SQLAgentUser$IPG-SQL2005-DEV$MSSQLSERVER
BUILTINAdministrators
NT AUTHORITYSYSTEM
=============================
http://www.sqlserverstudy.com
View 2 Replies
View Related
Aug 7, 2007
We created web site which has NT Authentication....
Using service account
SERVICE ACCOUNT
WEBGROUP
This has WEBGROUP_USERS
WEBGROUP_USERS
Tracey
John
When myself logs in...
Connect To SQL i see
in sysprocesses WEBGROUP
Is there a way to pass TRACEY to the process rather than having
SQL Login set up..
Reason is if someone adds themselves to this group in AD they could have access to our applications im trying to figure out
how to not make AD drive the access to SQL.
Thanks
View 2 Replies
View Related
Jul 23, 2005
Hello,I'm currently developing an access application which uses sql server as abackend.What i'm uncertain about, is how i should setup security without creatingtoo many sql server logins. I'm convinced that i should limit access to sqlserver, otherwise people can get in with other means than my application(e.g. odbc, sem, etc.).I've setup sql server in mixed mode and created a login for my applicationto connect to a database.So, what is the best way to implement tight security, but still be able tolog the current user and hostname? If a separate table is needed to createdusers and passwords, please tell me how to use it, i've never done thatapproach.Thnx------------------------------------------------------This mailbox protected from junk email by MailFrontier Desktopfrom MailFrontier, Inc. http://info.mailfrontier.com
View 1 Replies
View Related
Jul 20, 2005
On a huge Sql-Server 7 installation, we have various client applicationsdistributed along the Lan, accessing one main database.Each application accesses the db using one out of around ten logins. Most ofthem, have only DBDataReader right on the db, as they are consultationconsolles only.In order to monitor db usage, the customer requires some kind of log of useraccess.My need, mainly, is to INSERT a record into a log table, recording Date,Time, Login, Host of each access.But, and this is the problem, the job has to be done by the server itself,not by each client, because of various reasons:1) we don't like to increase rights of logins2) we don't plan to change anything in our custom client application3) few of those client applications have been developed by foreignsuppliers, so we cannot change them.My question is: does it exist any kind of authentication LOG, which I canwork on?Or, is it possible to activate a kind of TRIGGER, reacting on loginauthentication?Thanks in advanceAlberto
View 2 Replies
View Related
