Apart from SQL Server Management Studio's "configure security" button on the database mirroring tab of the database properties dialog - are there any other tools or scripts that can be used to configure mirroring?
If I can't find one, I'd like to write a script / tool that:
0. paramterizes all the variables involved in database mirroring
a. configures connections to the primary and mirrored SQL Servers
b. does the backup / restore between servers
c. configures endpoints / security
d. checks possible pitfalls (can't connect, firewall, etc.)
e. starts mirroring
f. does all the above for a list of the databases I'd like to mirror (anywhere from 6 to 30 databases)
SSMS wizards get me through most the above - it's just tiresome to repeat for each database.
Using SQL Server 2008, we would like propose mirroring between two servers of a critical database. Since we initiate, may require to clarify on its purpose and also required changes from application end.Any changes required from OS Level? (I believe both servers IP or Host name should be added in host entries. Mirroring ports should be allowed/open including Principal and mirror server IP Addresses): Windows Team.Any changes required from Application? (Instance name, authentication: user name and its password should be added in web config files): Application Team.Any changes required from Network Team?Also for mirroring both the principal and mirror servers should be with same version, does it only mean SQL Server 2008 versions are enough or does it also mean to say build numbers 10.00.4000 should also be same.URL....
I need to set up asyncronous data replication across two clustered instances of SQL 2012 across 2 Datacenters. Both the datacenters have a common domain however the vlans are different. There are only 3 small databases on the primary instance.
any issue in setting up mirroring in this case as vlans are different.
Hi all.I'm looking for a tool which should act like some kind of middleware/logical layer bewtween the SQL server and the webbased user interface.- It should be possible to easily create simple web forms (only datainput and output) without programming effort by "clicking" the fieldsand their order on the web mask within an admnistrative interface.- It should also be bossible to add "new fields" to the database,including field type, permissions, value lists etc. (excluding anybusiness logic) without programming effort by administration.I know, that most workflow tools or "Trouble Ticket Tools", based ondatabases have this feature to easily configure new masks and add newfields to the database, but i need it as an tool-unspecific layer forthe MS SQL Server.Thank you very much for your feedback, any ideas are welcome!Best regards, Heiko.
Guys , I have a dedicated server ... I've installed SQL SERVER 2005 and I have a problem to connect to SQL from local machines in the office ... Remote connections are on , server BRowser starts automatically ... for example from remote machinne I mean from Server where SQL is installed I can connect to SQL ... FireWall i've turned off.... What can be the problem ????
Hi, I got a website and everything works fine with SQL Server 2000, but now I modified the way of authentication using Forms and when I enter in a protected area I got this error: An error has occurred while establishing a connection to the server.When connecting to SQL Server 2005, this failure may be caused by thefact that under the default settings SQL Server does not allow remoteconnections. (provider: Named Pipes Provider, error: 40 - Could notopen a connection to SQL Server) The problem is that I don´t have SQL Server 2005 installed so I don´t know why my webapp is trying to contact it, where I can configure this settings so it will look for the Server that exists? Thanks.
In my DAL, I have 3 tables - Footballer (FootballerID = Primary Key) Aspnet Membership Table (UserID=Primary Key) Favourite Footballers (Junction Table with 2 Primary Keys FootballerID and UserID - both with foreign relationships to their respective data table)
On my sports site, visitors can view various footballers and store their favourites in th FavouriteFootballers Table by clicking on a button. This stores the Logged in UserID and FootballerID in the junction table. I now need to write a select query that allows users to click a link and view their favourites which they stored - lets say in a data list on another aspx page. This would include other columns from the Footballer Table such as Name, Age, Profile ect I think I am right in that I need to use a Select clause as I am using SQl data adapters in the DAL. Be very pleased if someone knows how to contruct the query and give me an example how to code a method in the BLL Some code is below
Method that Stores FootballerID and UserIDprotected void DataList1_ItemCommand(object source, DataListCommandEventArgs e) {
// Assuming only have one button in the item templateInt32 fid = Int32.Parse(e.CommandArgument.ToString());Guid userid = (Guid)Membership.GetUser().ProviderUserKey;
// Connect to the db and insert the recordusing (SqlConnection con = new SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\MyDatabase.mdf;Integrated Security=True;User Instance=True")) {
string query = string.Format("INSERT INTO FavouriteFootballer(UserID, ArtistID) VALUES('{0}',{1})", userid, fid); SqlCommand cmd = new SqlCommand(query, con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
Code in FavouriteFootballersBLL Its not complete -withotu parameter - i think maybe I also need to reference the Footballer Table and not the Junction one [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]public DataSet1.FavouriteFootballerDataTable GetFootballerFavourites() { return Adapter.GetFootballerFavourites(); }
Hi, I am really having a hard time creating a parameter for the RadioButtonList radSearchField. I want to type 's' in the text the choose the column for the query to execute the Select statement. I was able to create a parameter for the txtSearchText but can't get the radSearchField working. My form contains four objects.
Textbox to perform the query. (name: txtSearchText)
We've A2k db which we plan to migrate to SQL 7.0 very soon. Though am familiar with upsizing wizard BUT don't know how to configure Access forms, reports etc. to talk to SQL back end tables. So that information entered via Access forms can be stored in sql and reports can be generated using sql tables..
Hi, I'm using Exchange server for our mail communication. If wanted to config SQL Mail in SQL Server 2000 is Ok 1. Insall outlook in sql server 2. US Exchange mail server name in sql mail or any procedure I need to do? Thanks, Ravi
What are the steps in configuring sql server 6.5 to have excellent performance? what are the items that I should think of and based on what condition I can set up the configuration?
Hello, I run a small homw office. I am planning to purchase a dell powerdge 1750 server to install SQL server on that. I am confused here about which RAID should I install on this server RAID 1 or RAID 5. The dell customer rep could not tell me the advantages of installing only RAID 1 or only RAID 5 or installing both RAID 1 and RAID 5
I cannot create a Distribution Server on SQL Server 2005 SP1. When I right click on Replication and click "Configure Distribution" and hour glass appears for a minute, and then nothing happens.
I get the same result if I try to create a publication.
Hi All,Here is my questionWhat might you configure on a SQL Server so that a Web server runningon the same machine, with limited memory, will continue to performoptimally?Thank youRaju
I have installed SP2 on my SQL 2005 instance which also houses RS of course. Additionally I installed WSS3.0 without configuring it so it has the Object Model installed (should be enough?)
I am running WSS 3.0 on a seperate Server and have the Add-in installed on there.
Following the installation instructions I am going to Application Management to configure WSS, but there is no section called "Reporting Services". Looking on the Report Server, in the Configuration I see the following error under the SharePoint Integration Setting:
The report server cannot access settings in the SharePoint configuration database. Most likely, the Windows SharePoint Services object model is not installed or the Report Server Web Service and Windows service accounts do not have access to SharePoint databases. To configure service account access, use SharePoint Central Administration.
In my SharePoint Site I do see a SharePoint section under the "Site Settings" for managing shared schedules but I think the main issue is, that I don't see that section in Central Administration.
Hi every1, I have problem about configuration in Merge Replication. First, I configure for SQL Server 2000, expand Replication> Publication>New Publication>Choose Publication Database, I choose pubs>Select Publication Type, choose Merge Replication>Specify Subscribers Type, choose Servers running SQL Server 2000 and Devices running SQL Server CE>Specify article (ex. authors)€¦>Finish. I configure succeeded (A snapshot of 1 article(s) is generated). Snapshot folder reference to path: \server_nameC$Program FilesMicrosoft SQL Server 2005 Mobile EditionServerReplication Next, I configure for SQL Server Mobile Agent, Subscriber Type, choose SQL Server Mobile Edition>Web server, choose Create a new virtual directory>Alias: Replication (reference to the path: C:Program FilesMicrosoft SQL Server 2005 Mobile EditionServerReplication)..>Client Authentication, choose Client will connect anonymously€¦.>Snapshot share access, enter \server_nameReplication =>error: The share '\server_nameReplication' cannot be accessed. Please specify a new share. Why that? I want to ask u I configure that correctly? If Subscriber is Pocket PC Emulator, what is subscriber €™s property of SqlCeReplication (Windows PocketPC Emulator?)? Plz help me. Thanks so much.
We have an 8gb SQL server running Windows Server 2003 Enterprise Edition that simply will not get above 3gb of memory usage. We are using SQL 2000 Enterprise edition, version 2040 - SP4. My boot.ini has been configured with /3gb /PAE. System Properties does list Physical Address Extension as being enabled. AWE is enabled, and has been verified in the SQL server logs. Lock pages in memory access has been given to the account SQL is started under. Under task manager, the process sqlservr.exe does not grow above 2,762,428 ish. Does anyone know why this is occuring?
I've been working on a WinForm application (C#) that connects to a database on an external server. My connection string has always been the following and has always worked:
The specified credentials are actually the physical server's only and local windows account - admin. Contrary to the fact that specifying a user id and password in the connection string uses SQL Authentication, this is practically Windows Authentication as I haven't configured any roles, logins or users in the database or SQL server instance.
Recently there was a power outage and the server was offline. After going back online, my application can no longer communicate with the server. I even modified the connection string to the following and ran the application on the server itself and it still won't work:
There's obviously something wrong with the server that prevents it from accepting any incoming SQL connections; even those originating from it. I am able to ping the server and even remotely access it from a different network but no SQL connections are being established.
When i try to configure web synchronization, I get the following err " success Hresult 0x8007000"(!!!) for the step : setting the snapshot share permission
I really don't understand : my folder have all the rights for the user agent...
I don't know what to do.
Config . SQL Server SP4,Microsoft SQL Server 2005 Mobile Edition
It had worked but I had to reinstall the system and now, it does not work anymore
.. the Membership ProviderUserKey value as the parameter of a stored procedure ?It seems obvious to me that you would want to do this, but I can only see that it allows you to pass Profile parameters.
When configuring the SqlDataSource, what source do I need to specify for getting the ID passing through the URL? I tried Form but it's not getting the ID through the URL. Help is appreciated.
I'm having a problem configuring one of my SQL servers as a distributor. I've done it successfully on another server, so I know that it's nothing procedural and there must be an issue with the way the server is set up. When I click 'finish' on the Configure Publication and Distribution Wizard, I get the following error message:
Enterprise Manager could not configure 'ABEL' as the distributor for 'ABEL'.
Error 20017: Cannot add the remote distributor at this time. Make sure that the local server is configured as a Distribution Publisher at the Distributor.
Can anyone point me in the right direction? I'm fairly new to SQL Server, so feel free to explain things in a condescending manner. ;-)
I have a SQL Server version 7.0 and want to configure IBM DB2 on OS 390 as a linked server on it . I installed DB2 clients on the SQL Server and thru DB2 Connect ,I am able to access the mainframe data using the clients . However I am having problems configuting the Mainframe server using IBM DB2 OLE DB Driver .I am not sure if we need to use Microsoft OLE DB Driver .
Our company is going to use SAN (HP or EMC or Fuji) for SQL Server failover rather than MSCS. So far, DBA has no knowledge of SAN.
Would you please to tell me, how does SAN depend on SQL Server? I assume SAN software can make disk failover if there is a network, disk or OS failure in primary node. If SQL Server or SQL Agent is failure, can SAN software detect it? (or can SAN disk failover depend on SQL Server or SQL Agent services?)
Please let me know where can I find any configuration document regarding SAN for SQL Server failure. I had spent 2 days in HP and EMC wrbsite and found nothing.
