LogShipping question

Hi guys
I am about to create a logshipping plan to keep a db updated in Server2 from
Server1.
I know that Server1 must run the Enerprise edition in order to enable the
logshipping. Does server2 need to be Enterprise edition too or standard
edition is sufficient.
thanks
Standard is sufficient.
"aolxp" <sa@.anonymous.com> wrote in message
news:ugSubz0rFHA.2212@.TK2MSFTNGP15.phx.gbl...
> Hi guys
> I am about to create a logshipping plan to keep a db updated in Server2
> from Server1.
> I know that Server1 must run the Enerprise edition in order to enable the
> logshipping. Does server2 need to be Enterprise edition too or standard
> edition is sufficient.
> thanks
>
|||Both need to be EE. If you want to involve SE in log shipping, use your own scripts. You can Google
and you will probably find examples of home-grown log shipping.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"aolxp" <sa@.anonymous.com> wrote in message news:ugSubz0rFHA.2212@.TK2MSFTNGP15.phx.gbl...
> Hi guys
> I am about to create a logshipping plan to keep a db updated in Server2 from Server1.
> I know that Server1 must run the Enerprise edition in order to enable the logshipping. Does
> server2 need to be Enterprise edition too or standard edition is sufficient.
> thanks
>

LogShipping question

Hi guys
I am about to create a logshipping plan to keep a db updated in Server2 from
Server1.
I know that Server1 must run the Enerprise edition in order to enable the
logshipping. Does server2 need to be Enterprise edition too or standard
edition is sufficient.
thanksStandard is sufficient.
"aolxp" <sa@.anonymous.com> wrote in message
news:ugSubz0rFHA.2212@.TK2MSFTNGP15.phx.gbl...
> Hi guys
> I am about to create a logshipping plan to keep a db updated in Server2
> from Server1.
> I know that Server1 must run the Enerprise edition in order to enable the
> logshipping. Does server2 need to be Enterprise edition too or standard
> edition is sufficient.
> thanks
>|||Both need to be EE. If you want to involve SE in log shipping, use your own scripts. You can Google
and you will probably find examples of home-grown log shipping.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"aolxp" <sa@.anonymous.com> wrote in message news:ugSubz0rFHA.2212@.TK2MSFTNGP15.phx.gbl...
> Hi guys
> I am about to create a logshipping plan to keep a db updated in Server2 from Server1.
> I know that Server1 must run the Enerprise edition in order to enable the logshipping. Does
> server2 need to be Enterprise edition too or standard edition is sufficient.
> thanks
>sql

LogShipping question

Hi guys
I am about to create a logshipping plan to keep a db updated in Server2 from
Server1.
I know that Server1 must run the Enerprise edition in order to enable the
logshipping. Does server2 need to be Enterprise edition too or standard
edition is sufficient.
thanksStandard is sufficient.
"aolxp" <sa@.anonymous.com> wrote in message
news:ugSubz0rFHA.2212@.TK2MSFTNGP15.phx.gbl...
> Hi guys
> I am about to create a logshipping plan to keep a db updated in Server2
> from Server1.
> I know that Server1 must run the Enerprise edition in order to enable the
> logshipping. Does server2 need to be Enterprise edition too or standard
> edition is sufficient.
> thanks
>|||Both need to be EE. If you want to involve SE in log shipping, use your own
scripts. You can Google
and you will probably find examples of home-grown log shipping.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"aolxp" <sa@.anonymous.com> wrote in message news:ugSubz0rFHA.2212@.TK2MSFTNGP15.phx.gbl...[vb
col=seagreen]
> Hi guys
> I am about to create a logshipping plan to keep a db updated in Server2 fr
om Server1.
> I know that Server1 must run the Enerprise edition in order to enable the
logshipping. Does
> server2 need to be Enterprise edition too or standard edition is sufficien
t.
> thanks
>[/vbcol]

Login problems on Vista before and after SP2

Hi:

I have recently updated my Sony Vaio and installed Windows Vista. After installing I could not access my SQL databases because of the NT Authorisation / sysadmin problem.

I have since installed SQLServer SP2 (Nov CTP) but the problem persists. If I run SQL Management Studio under the administrative account I can login just fine. I have also made sure the 'NT AUTHORITY\SYSTEM' is marked for sysadmin access (which it is).

The eror I get is Error 18456.

What else can I do to gain access via Windows Authorisation?

TIA,

MartinH.

Hello Martin,

Are you are logging into the Vista under any domain credentials? If so please add the domain user as the local system administrator and try.

Thanks,

Prakash P [MSFT]

|||

Prakash:

Sorry to be so dense, but I'm not quite sure what you are asking.

I am using Vista on a portable that does not connect to any Domain Server. The locally created user belongs to the Administrators group.

Is this what you meant by 'please add the domain user as the local system administrator'?

Thanks for your reply.

Martin.

|||

Here is a workaround for resolving this issue:

1. Run SSMS “As an Administrator”, by right clicking the SSMS icon and clicking “Run As Administrator” option and select Windows Authentication and login to SQL Server.

2. In the Object Explorer node select the Security node and then select Logins node. Add a new login for your windows account and select Windows Authentication. Also go the Server Roles pane in the same window and select sysadmin role for it.

3. Close SSMS and start it normally and give your domain account and select Windows Authentication and you will not have any issues thereafter.

|||

Rajesh:

That did the trick!!

Thanks very much for your help.

Regards,

Martin.