When restoring DBs to other environments the SIDS don't transfer causing access problems, and when I use a SID scripting method and deploy on the target environment SQL says the login already exists.
I usually end up with the cumbersome process of explicitly removing the logins and re-applying - how to other DBA's get round this?
Is it possible for a clustered instance of SQL2012 to have 2 network names ?
Reason: I need to segregate admin access to a clustered instance so that the admins and SSMS connect via a different IP address than the application. I know I can block SSMS access via application-level firewalls, but ideally the application would connect to CLUSTER1INSTANCE01 on , say, 10.192.5.5, and the admins would connect to CLUSTER1ADMININSTANCE01 on 172.168.2.2, and they'd be the same instance, just using different names and IPs
I am in the process of evaluating the use of Service broker for messaging in a load balanced configuration, and am not having any success. My configuration is as follows. 1) Master database on Box #1 which is the initiator of all dialogs 2) Target database on Box #2 3) Target database on Box #3 One of my goals is that the databases on Box #2 and #3 are as close to identical as possible. My routing table on Box #1 looks something like the following Name remote_service_name broker_instance address TargetOne TargetService
E96DC67E-F696-4D93-8545-C2E92157E32D tcp://server1:4022/ TargetTwo TargetService
56607120-26AA-4AAA-B9E4-F14689C40E41 tcp://server2:4022/ My messaging process begins with a dialog initiated from the master database (Box #1) to each of the target services. At this time, only the first server "tcp://server1:4022/" is receiving messages. The sys.transmission_queue shows a message outbound to "tcp://server2:4022/" with a blank status. I believe that my delivery problem has something to do with the resolution of the dialog certificate need for the conversation. The MSDN documentation states that: "Service Broker uses a remote service binding to locate the certificate to use for a new conversation...The certificate for user_name must correspond to the certificate for a user in the database that hosts the remote service." I am confused as to how I would configure remote service binding if one can not create more than one binding for the same remote_service_name. The following throws an exception on the last creation of the binding.
---CODE SNIP---
CREATE CERTIFICATE UFEDlgCertTargetPublic
We're moving several Version 7 databases to a SQL Server
2000 box.
How can I grant SQL Server 2000 security for three
"Named Instances"?
Thanks
Benny
When I am in Visual Studio 2005, and I try to add an SQL database, I get the following error "generating user instances in sql server is disabled. use sp_configure user instances enabled to generate user instances." I am currently using SQL server 2005 Express. What do I need to do, to create an SQL database? Thanks in advance.
View 4 Replies View RelatedI had a server with SQL Server 7.0
I installed a named instance of SQL Server 2000 and then i passed all my DB
of the 7.0 instance to the 2000 instance.
Then i removed the 7.0 instance, that was the default instance.
So at the moment there is only the 2000 version, but it isn't the default
instance
Can the 2000 instance become the default instance? (So that clients can
connect to it simply through computer name, and not creating an alias)
thanks
Fede
here's my prediciment, I need to transfer my SQL DB to another SQL Server, but I don't have access to the server, I get the login through a third party company.
So what do I need to do to transfer the database to another server as an EXACT copy of my original database, IDENTITY Fields and all.
Thanks
Hi all,
How do I transfer a database from a SQLEXPRESS instance on my PC to another SQLEXPRESS instance on my laptop? I tried backing it up and restoring it on the laptop but it comes up with errors. This is the error
Restore failed for Server 'DOUGYDOESQLEXPRESS'
System.Data.SqlClient.SqlError: CREATE DATABASE permission denied in database 'master' (Microsoft.SqlServer.Express.Smo).
Do I need to perform some configuration somewhere? Any leads will be most appreciated.
Thanks
How will I be able to transfer table that have stored procedured specifc to them to another server? This is from sql server 7 to another sql server 7.
Would this be possible without losing any data or procedure or which ever may be attached to the tables?
Thank you
Paul Tudor
Is there a utility to transfer the logins for a database for one server to another without setting the login passwords to null as the SQL transfer utility does?
View 4 Replies View RelatedHi all,
Really easy question I think. I've been working on a website using a back end SQL database. All the tables, views etc have been designed and built. There is some data in the tables. Now that I have developed it I want to move the whole database onto the live Server which resides on another machine. How can i transfer a database from my development server to the live one?
Thanks
Wheelz
I have two SQL servers I am dealing with. I have some tables in one databaseon one SQL server that I want to transfer into a database on the other SQLserver. I want to xerox copy the tables including all primary keys,identities, defaults etc. I used the export/import feature in EnterpriseManger, but when I do it, and view the tables that got imported, all of mydefaults are gone and all the primary keys are gone. What is the best way tojust copy a few tables from one database to another. I do NOT want to copythe entire database from one SQL server to the other, only a few tables. Ijust want to make sure that when they are imported they are exactly the sameas where they came from. THANKS
View 1 Replies View RelatedIs there any way the i can write query in sql statment and transfer the result set into csv file with header info and one row option.
Thanks,
I am having Access database in my local system . Values in the access database will be updated for every 5 min . I am also having Sqlserver database online with the same structure database of Access in my local system . What i want is my Access database values must be updated in my online sqlserver at every 5 min automatically .How to do that ?
View 3 Replies View RelatedHi,
I've a problem that I haven't experienced before and need some help. I've developed an app that works fine locally and have uploaded via FTP to my host provider - .NET 2 and SQL2005 Express.
I'm now getting problems accessing the site. In the application load event I load a couple of application state items from the database. When it hits the default aspx page, it throws an Object reference not set to an instance of an object. error because the application state items haven't been loaded. The host then tried to load the database using SQL Management Express to ensure there wasn't a problem with the database and this is where I get confused.....
When they try to attach it, the message column n the "Attach Databases" screen says the file cannot be found. In the "Current File Path" column, it points to the path of my local machine, i.e. H:SourceClubApp_Dataclub.mdf. This leads me to believe that somewhere in the database the original file path is noted and used. I can't find this and wondered if anyone has come accross this issue before?? The log file has been deleted.
Any help and advice appreciated.
Terry.
I need to create a stored procedure that copies records with DeptID = 'S' from Table1 into Table2.Is there anywhere i can check up information on how to go about doing this or the SQL syntax for this?
View 6 Replies View RelatedHi
I need to copy all the jobs from one server to another server. How i have to do. I tried to take script of MSDB database, but it is not scripting all the jobs. PLs anyone suggest me what i have to do with scheduled jobs in 65.
it is very urgent pls.
thank u
--Rk
I've read about using starsql odbc and sql server 7.0 DTS utility to transfer the database or data from a DB2 to SQL Server.
I have a SQL Server 6.5 and need to transfer data from a DB2. Is the operation the same? Is there a utility in sql server 6.5 that allows this?
hi everybody,
i ave transfered all the users from one of my sql server to another sql server but what the problem is that all the users that are on new sql server having a NULL password.....
so that means that when u transfer users from one sql servers to another the passwords will be remain as null for all users......
or any sql server patch is required for that.....
thanks in adv.
Hello all
I have a SQL Server 2000 database in a remote host and I want to move all my data to another remote (virtual) host, where on both machines I do not have direct access.
Can you advise me what is the best way to make this transition?
Thank You in advance
Nick
I have an application that runs off an sql server 2000 sp3 database. I have taken a backup (.bak file) of the production database and restored it to another server for testing purposes. the users cannot login to the new server because the logins have not been transfered to the new server. I am looking to transfer the logins using the procedure outlined at the following link: http://support.microsoft.com/kb/246133/ under the header "Create and Run Stored Procedures in the Master Database". what I need to know is will this procedure affect the production server in any way? (I can't have that) and is there anything else I need to do after this to let the users login to the test server with the same name and passwords?
thanks for any help
Hi
I have created two SSIS packages one is development and another is test. I used near about 15 global variables in my test SSIS package.Both development and test package working on transfering data from database and put into text files now i want to implement all these variables into development package
how i will do that wheather i have to create all these variables in development package also or there is way to transfer these variables from one package to another
Please help me out
I am a IT Manager.I have question:
There is a database was created on SQL Server.
I want to learn if I restore the database to SQL 2005 then I want to get backup then I want to restore to SQL 2000.
shortly: SQL 2000 sever-> SQL 2005->SQL 2000 SERVER
Can I do that?
If I do that is there someting missed?
http://www.narcv.com/
HELLO.
I have two similar tables at different databases. Their ID columns are same. I want to update one of them like:
Table A
ID Name
Table B
ID Name
UPDATE DB1.dbo.TableA SET Name = (SELECT Name FROM @DB2.dbo.TableB)...
I have problem with WHERE clauses. Can't figure it out. Can you help me?
Thanks in advance.
I have a database that I have created and I would like to transfer it to an Sql Express instance I am not sure how to do it... Can anyone help?
View 1 Replies View RelatedHello all,I am currently working on upgrading the old website to an asp.net website.Current website uses flat-files as its database, so I need to convert a few files into SQL tables.The file that I am having difficulties with has the following structure (tab and coma separated):OrderID CustomerID ItemNO1 1 1,2,3,42 1 5,6,73 1 4,5,67,4576A,234 2 4,56,678,DF23,75 2 78,2,567,4556,3,45,FG456 3 2,45, F35 etc.... and I need my table to be structured like this: OrderID CustomerID ItemNO1 1 11 1 21 1 3 1 1 42 1 52 1 62 1 7.......................The import function in SQL database will not do this. Is it possible to automate this somehow? Thanks
View 4 Replies View RelatedHas anyone had a problem transfering a database to a server.
This is the first time I have done this.
I have a site and sqldatabase hosted by a hosting company and I am supposed to transfer my database
This is what I'm doing
From the Start Menu, select "Programs" -> "Microsoft SQL Server" -> "Import and Export Data" then click "Next".
In the "Server" field, type in the Name or IP of the source server (your server), choose "Use SQL Server Authentication," type in your username and password, choose your database from the "Database" field, click "Next".
Note: You can also use Windows Authentication if the SQL server is a local server.
In the "Server" field, type in the hostname of the DiscountASP SQL Server (this is listed in your hosting control panel), choose "Use SQL Server Authentication," type in your DiscountASP database username and password (this was sent in your database order confirmation email), choose your database from the "Database" field, click "Next".
Choose "Copy objects…", click "Next".
Uncheck Use Default Option.
Click Options, uncheck "Copy Database users and database roles", "Copy SQL Server logins", "Copy object-level Permissions".
Leave next window as is, click "Next".
Click "Finish".
It seems to work ok untill it gets to about 90% done then a message says "There has been an error" and gives no more info.
Can anyone help me out
I Completely new to SQL, can anyone give me a URL to find this information.?
Thanks
hello
how can i transfer my already user created tables from primary group to newly created file group.
Dear all DBA,
i really need some help from all of you.
I currently have some DTS package which will transfer data from
text file to the SQL 7.0
This transformation is schedule using the Sql Agent.
The problem is the transfering data which have the Date datatype.
the Date format is in the dd/mm/yyyy. But the default language i set in my
sql server is english which suppose will use the date format mm/dd/yyyy.
therefore, the Sql server will treat my data which in dd/mm/yyyy as mm/dd/yyyy. so, the data like '08/09/2000' (in dd/mm/yyyy) become '08/09/2000'
(in mm/dd/yyyy)
i already set my user'language who will login in the sql agent as 'british english'. I also the OLE connection in the DTS package that i built using 'british english'.
when i run the agent in the Sql Enterprice Manager, it use the dd/mm/yyyy format which is correct. BUt when i log out and let it run as services which mean let the agent excute the DTS. it use back the mm/dd/yyyy fromat which cause the data become wrongs.
i hope someone can give me some advice on this.
Thanks for your help
from
samuel yeong
We are having problems finding out how to transfer user permissions and passwords to a new server when we copy a database.
We have tried sp_helprotect and looked at system tables to try and retrieve the details to no avail.
The reason for this is that we are trying to write an application to automate this as we have many databases to transfer.
Thanks in advance.
Ian Webb
We have transfered some jobs to new server using DTS 'export jobs' task, but they are failing when trying to execute DTS packages in them saying 'login failed for user----though everything is correct with the user!
Any help is appreicated..
I need to transfer seven tables from Informix DB to SQL Server every night. Any suggestions for the best way of doing it? Is DTS the best way? How about through replication?
Thanks in advance.