Hi everyone,
Can anyone tell me how I can create a mirror database?
please give me the information step by step.
Thanks,
Nassa
Nassa,
there is a Technet webcast on Mirroring:
http://whitepapers.techrepublic.com.com/thankyou.aspx?&docid=157789&view=157789&load=1
Apart from that, I'd use BOL as the main source of info. If possible, you
might want to get yourself on the 3-day Microsoft Course 2788:
http://www.microsoft.com/learning/syllabi/en-us/2788afinal.mspx
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||You need two SQL Servers - ideally 3. They can be on the same machine or on
different machines.
In SQL Server Management Studio right click on your database and select
Tasks and Mirror, then select Security button. This will launch the
mirroring wizard. Click Next, click no for Witness (for now), click Next,
click Next at the Choose Servers to configure, accept the defaults for the
principal server instance click Next, Accept the defaults for the mirror
server instance you will have to select your mirror server/instance here.
Click Next, for the Enter the Service accounts dialog click next, and click
Finish.
This should get you operational.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Nassa" <nassim.czdashti@.gmail.com> wrote in message
news:1168853360.943120.231280@.38g2000cwa.googlegro ups.com...
> Hi everyone,
> Can anyone tell me how I can create a mirror database?
> please give me the information step by step.
> Thanks,
> Nassa
>
|||Hilary Cotter,
I try to do that before,but by right clicking on the database, and try
Task,then I dont have any menu like MIRRORING.
What should I do?
Thanks,
Nassa
Hilary Cotter wrote:[vbcol=seagreen]
> You need two SQL Servers - ideally 3. They can be on the same machine or on
> different machines.
> In SQL Server Management Studio right click on your database and select
> Tasks and Mirror, then select Security button. This will launch the
> mirroring wizard. Click Next, click no for Witness (for now), click Next,
> click Next at the Choose Servers to configure, accept the defaults for the
> principal server instance click Next, Accept the defaults for the mirror
> server instance you will have to select your mirror server/instance here.
> Click Next, for the Enter the Service accounts dialog click next, and click
> Finish.
> This should get you operational.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Nassa" <nassim.czdashti@.gmail.com> wrote in message
> news:1168853360.943120.231280@.38g2000cwa.googlegro ups.com...
|||This is SQL 2005 right? You are running at the 90 compatibility level? And
it SQL 2005 Standard and above. Workgroup and Express do not support
database mirroring.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Nassa" <nassim.czdashti@.gmail.com> wrote in message
news:1168934654.927792.65420@.11g2000cwr.googlegrou ps.com...
> Hilary Cotter,
> I try to do that before,but by right clicking on the database, and try
> Task,then I dont have any menu like MIRRORING.
> What should I do?
> Thanks,
> Nassa
>
> Hilary Cotter wrote:
>
|||Hilary Cotter,
yes it is SQL 2005 server and I use SQL server management studio
express.
What should I do?Which SQL should I use?
Thanks,
Nassa
Hilary Cotter wrote:[vbcol=seagreen]
> This is SQL 2005 right? You are running at the 90 compatibility level? And
> it SQL 2005 Standard and above. Workgroup and Express do not support
> database mirroring.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Nassa" <nassim.czdashti@.gmail.com> wrote in message
> news:1168934654.927792.65420@.11g2000cwr.googlegrou ps.com...
sql
Showing posts with label step. Show all posts
Showing posts with label step. Show all posts
Monday, March 26, 2012
Monday, March 12, 2012
Problem encountered during the installation of Visual Studio .NET 2005 Professional on a windows
Hi ALL,
I'd tried to install Visual Studio .NET 2005 Professional Edition on a Windows 2000 domain PC, and everything was fine except the last step (i.e. installing SQL Express). I got the error message "Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. ***EndOfSession***". Further investigation on the error in "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG" and found that "Product : SQL Server Database Services Error : SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Cannot alter the login 'sa', because it does not exist or you do not have permission.. Refer to the server error logs and Setup logs for detailed error information." I used a domain account with local administrator privilege to install. I doubt whether my domain policy affect the installation. Could someone tell me what security policy I should set to allow the installation of the Visual Studio .NET 2005 Professional on a domain PC.
TIA.
M Chan
Try the workaround here:
http://blogs.msdn.com/quanto/archive/2005/12/16/504693.aspx
|||
We'd tried (Put the domain account into the local Users group as well) but still failed. As a domain account, how can we list it first in the local administrators group? PS. The domain account is already belonging to the local administrators group.
TIA.
M Chan
|||Moving thread to SQL setup forum.
|||
Hi ALL,
The domain PC is Windows XP Prof. with SP2 _ latest patches installed. The installation is run by a domain account which has local administrator privilege on the domain PC.
M Chan
|||Did you ever get this resolved. I'm having the same issue.|||Not yet. I just wonder why the setup cannot be done if the Windows XP Prof. SP2 had joined to the domain with McAfee v8.0 installed. The problem should be related to some security settings.|||I looked through our bugs and came up with something.
Looks like if SQL Server 2005 RTM is installed in a Domain where a windows Group named 'sa', 'SA', 'Sa' or 'sA' exists, installation fails when Integrated Security is chosen. However, despite having the Windows group in the Domain, installation with Mixed Security work fine. After having installed successfully with Mixed Secuirty, the server properties can be changed to accept Integrated Security connections only. This should work.
Hope this helps.
-Jeffrey
|||Do you know if there are installation options in the Visual Studio .NET 2005 to specify the security mode for SQL Server 2005 RTM. If no, we need to separate out the SQL 2005 Express Edition from the Visual Studio .NET 2005 and install the SQL 2005 Express Edition individually.
TIA.
M Chan
|||No, there isn't an instgall option to specify the security mode separately. You should know, though, that with integrated security, the SA account is disabled.Problem encountered during the installation of Visual Studio .NET 2005 Professional on a windows
Hi ALL,
I'd tried to install Visual Studio .NET 2005 Professional Edition on a Windows 2000 domain PC, and everything was fine except the last step (i.e. installing SQL Express). I got the error message "Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. ***EndOfSession***". Further investigation on the error in "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG" and found that "Product : SQL Server Database Services Error : SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Cannot alter the login 'sa', because it does not exist or you do not have permission.. Refer to the server error logs and Setup logs for detailed error information." I used a domain account with local administrator privilege to install. I doubt whether my domain policy affect the installation. Could someone tell me what security policy I should set to allow the installation of the Visual Studio .NET 2005 Professional on a domain PC.
TIA.
M Chan
Try the workaround here:
http://blogs.msdn.com/quanto/archive/2005/12/16/504693.aspx
|||
We'd tried (Put the domain account into the local Users group as well) but still failed. As a domain account, how can we list it first in the local administrators group? PS. The domain account is already belonging to the local administrators group.
TIA.
M Chan
|||Moving thread to SQL setup forum.
|||
Hi ALL,
The domain PC is Windows XP Prof. with SP2 _ latest patches installed. The installation is run by a domain account which has local administrator privilege on the domain PC.
M Chan
|||Did you ever get this resolved. I'm having the same issue.|||Not yet. I just wonder why the setup cannot be done if the Windows XP Prof. SP2 had joined to the domain with McAfee v8.0 installed. The problem should be related to some security settings.|||
I looked through our bugs and came up with something.
Looks like if SQL Server 2005 RTM is installed in a Domain where a windows Group named 'sa', 'SA', 'Sa' or 'sA' exists, installation fails when Integrated Security is chosen. However, despite having the Windows group in the Domain, installation with Mixed Security work fine. After having installed successfully with Mixed Secuirty, the server properties can be changed to accept Integrated Security connections only. This should work.
Hope this helps.
-Jeffrey
|||Do you know if there are installation options in the Visual Studio .NET 2005 to specify the security mode for SQL Server 2005 RTM. If no, we need to separate out the SQL 2005 Express Edition from the Visual Studio .NET 2005 and install the SQL 2005 Express Edition individually.
TIA.
M Chan
|||No, there isn't an instgall option to specify the security mode separately. You should know, though, that with integrated security, the SA account is disabled.Problem encountered during the installation of Visual Studio .NET 2005 Professional on a windows
Hi ALL,
I'd tried to install Visual Studio .NET 2005 Professional Edition on a Windows 2000 domain PC, and everything was fine except the last step (i.e. installing SQL Express). I got the error message "Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. ***EndOfSession***". Further investigation on the error in "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG" and found that "Product : SQL Server Database Services Error : SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Cannot alter the login 'sa', because it does not exist or you do not have permission.. Refer to the server error logs and Setup logs for detailed error information." I used a domain account with local administrator privilege to install. I doubt whether my domain policy affect the installation. Could someone tell me what security policy I should set to allow the installation of the Visual Studio .NET 2005 Professional on a domain PC.
TIA.
M Chan
Try the workaround here:
http://blogs.msdn.com/quanto/archive/2005/12/16/504693.aspx
|||
We'd tried (Put the domain account into the local Users group as well) but still failed. As a domain account, how can we list it first in the local administrators group? PS. The domain account is already belonging to the local administrators group.
TIA.
M Chan
|||Moving thread to SQL setup forum.
|||
Hi ALL,
The domain PC is Windows XP Prof. with SP2 _ latest patches installed. The installation is run by a domain account which has local administrator privilege on the domain PC.
M Chan
|||Did you ever get this resolved. I'm having the same issue.|||Not yet. I just wonder why the setup cannot be done if the Windows XP Prof. SP2 had joined to the domain with McAfee v8.0 installed. The problem should be related to some security settings.|||
I looked through our bugs and came up with something.
Looks like if SQL Server 2005 RTM is installed in a Domain where a windows Group named 'sa', 'SA', 'Sa' or 'sA' exists, installation fails when Integrated Security is chosen. However, despite having the Windows group in the Domain, installation with Mixed Security work fine. After having installed successfully with Mixed Secuirty, the server properties can be changed to accept Integrated Security connections only. This should work.
Hope this helps.
-Jeffrey
|||Do you know if there are installation options in the Visual Studio .NET 2005 to specify the security mode for SQL Server 2005 RTM. If no, we need to separate out the SQL 2005 Express Edition from the Visual Studio .NET 2005 and install the SQL 2005 Express Edition individually.
TIA.
M Chan
|||No, there isn't an instgall option to specify the security mode separately. You should know, though, that with integrated security, the SA account is disabled.Saturday, February 25, 2012
Problem creating a job step to execute a SSIS package
Hello all,
I am having a problem creating a job step that will run a SSIS package. I go to add a job step (or edit an existing one), but when I select 'SQL Server Integration Services Package' as the type, an error box pops up with the following message:
The specified module could not be found. (Exception from HRESULT: 0x8007007E) (SqlManagerUI)
After I hit OK, it goes back to the 'New Job Step' window and makes me select a different step type.
I am running on a Win2000 Advanced Server with SP4, a default instance of SQL2000 with SP4, and a named instance of SQL2005.
Does anyone know what is wrong or of a workaround?
Thanks in advance for any and all help/comments.
Jarret
You should probably post to the agent forum since this is an agent problem not an SSIS problem.Thanks,
Matt
Problem creating a job step to execute a SSIS package
Hello all,
I am having a problem creating a job step that will run a SSIS package. I go to add a job step (or edit an existing one), but when I select 'SQL Server Integration Services Package' as the type, an error box pops up with the following message:
The specified module could not be found. (Exception from HRESULT: 0x8007007E) (SqlManagerUI)
After I hit OK, it goes back to the 'New Job Step' window and makes me select a different step type.
I am running on a Win2000 Advanced Server with SP4, a default instance of SQL2000 with SP4, and a named instance of SQL2005.
Does anyone know what is wrong or of a workaround?
Thanks in advance for any and all help/comments.
Jarret
Whatever the problem was, restarting the server fixed it. I hadn't restarted the server since I installed SQL2005, because the install didn't require a reboot. I had a chance to do so over the weekend and when I checked on this problem, it was gone.
All is good now.
Thanks!
Jarret
Monday, February 20, 2012
problem connecting to the database
Hi...
I just started to go through the "Microsoft visual c# 2005 step by step" I noticed on page 412 when i try to connect to the database, it says tochoose "Microsoft SQL server" from the Choose datasource menu. But I dont have Microsoft SQL Server. There are only "Microsoft Access Database file" and "Microsoft SQL Server Database File" and not "Microsoft SQL Server".
Please Help
Sunil
Hi,
Do you have the MDAC 2.6 or later installed?
Regards,
Janos
|||Unless you choose to install SQL Server (download the free SQL Server 2005 Express here), you will have to use the Access file connection process.|||thanks for the reply Janos... I'm fairly new to the SQL stuff... What is MDAC?
Thanks
Sunil
|||thanks for the reply arnie.... yes i did install the free sql server 2005 express.... i still cant figure it out... i used the commands at the dos prompt to configure the SQL server like it says in the book and everything was good...
then i used sqlcmd -S yourserver\SQLExpress - E -iinstnwnd.sql
That was also successfull....
still i dont see "microsoft SQL server" in the choose datasource section. But i do see "Microsoft SQL server database file".
Thank you
|||Hi,
Please follow Arnie Rowland's post. You should have SQL Server installed.
Regards,
Janos
|||Seems that you are using Visual Studio Express. If so, the behaviour is by design.http://msdn2.microsoft.com/en-us/vstudio/aa700921.aspx
But you can code against it.
Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||
i'm sorry..i dont follow...what does it mean by design?
thank u
sunil
|||VS Express is not able to connect to SQL Server Express in the GUI (locked down feature) but you can programmtically access the Server.
Jens K. Suessmeyer.
http://www.sqlserver2005.de
Subscribe to:
Posts (Atom)