Microsoft SQL Transaction Log

Can any one recommend a good Transaction Log viewer / analyzer for
Microsoft SQL?Check out www.lumigent.com.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<matthew.mccarty@.foxtg.com> wrote in message
news:1144852551.532336.105040@.j33g2000cwa.googlegroups.com...
Can any one recommend a good Transaction Log viewer / analyzer for
Microsoft SQL?|||Thanks for the link.
Can LogExplorer view logs that where created before the software is
installed on the server?
Thanks,
Matt|||I believe so. You may want to contact them directly.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Traxs" <matthew.mccarty@.foxtg.com> wrote in message
news:1144854286.523969.275510@.v46g2000cwv.googlegroups.com...
Thanks for the link.
Can LogExplorer view logs that where created before the software is
installed on the server?
Thanks,
Matt|||<matthew.mccarty@.foxtg.com> wrote in message
news:1144852551.532336.105040@.j33g2000cwa.googlegroups.com...
> Can any one recommend a good Transaction Log viewer / analyzer for
> Microsoft SQL?
>
Here is a FREE one:
SELECT * FROM ::fn_dblog(NULL, NULL)
The params are Start LSN and End LSN respectivly.

Microsoft SQL Transaction Log

Can any one recommend a good Transaction Log viewer / analyzer for
Microsoft SQL?Check out www.lumigent.com.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<matthew.mccarty@.foxtg.com> wrote in message
news:1144852551.532336.105040@.j33g2000cwa.googlegroups.com...
Can any one recommend a good Transaction Log viewer / analyzer for
Microsoft SQL?|||Thanks for the link.
Can LogExplorer view logs that where created before the software is
installed on the server?
Thanks,
Matt|||I believe so. You may want to contact them directly.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Traxs" <matthew.mccarty@.foxtg.com> wrote in message
news:1144854286.523969.275510@.v46g2000cwv.googlegroups.com...
Thanks for the link.
Can LogExplorer view logs that where created before the software is
installed on the server?
Thanks,
Matt|||<matthew.mccarty@.foxtg.com> wrote in message
news:1144852551.532336.105040@.j33g2000cwa.googlegroups.com...
> Can any one recommend a good Transaction Log viewer / analyzer for
> Microsoft SQL?
>
Here is a FREE one:
SELECT * FROM ::fn_dblog(NULL, NULL)
The params are Start LSN and End LSN respectivly.

Microsoft SQL Sever management Studio: Failed to open connection dialog

Does anyone encount the following problem before? When I tried to connect to Microsoft SQL server 2005 with MS SQL Server Management Studio, I received: "Failed to open connection dialog" message with additional information is "Package 'Mircrosoft SQL Server Object Explorer' failed to load.

This's just happened recently. Although I am receiving that message, I still able access into database with different types of connection.

Can someone shred some light?

Thanks

Tommy.

Have you attempted to connect the server using another client's machine.|||

This looks like some of your .NET components have corrupted. Reinstalling the same should help.

Thanks,
Kuntal

|||

The most likely cause of this is if a file has been deleted or corrupted. Does repairing the SQL Server management tools fix the problem?

Repairing SQL Server is a command-line operation. You can repair by inserting the installation media into the disk drive and typing the following:

start /wait <CD or DVD Drive>\setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS

You can find more information on installing SQL Server from the command line here: http://msdn2.microsoft.com/en-us/library/ms144259.aspx

|||

Good morning ( or afternoon for me )

Goo and helpful answer whether you have the cd disk but if you have downloaded from Microsoft (for example Express Edition or School version ), i think i must contact Microsoft to have the agreement to downloa and validate again

Have a nice day

Microsoft SQL Sever management Studio: Failed to open connection dialog

Does anyone encount the following problem before? When I tried to connect to Microsoft SQL server 2005 with MS SQL Server Management Studio, I received: "Failed to open connection dialog" message with additional information is "Package 'Mircrosoft SQL Server Object Explorer' failed to load.

This's just happened recently. Although I am receiving that message, I still able access into database with different types of connection.

Can someone shred some light?

Thanks

Tommy.

Have you attempted to connect the server using another client's machine.|||

This looks like some of your .NET components have corrupted. Reinstalling the same should help.

Thanks,
Kuntal

|||

The most likely cause of this is if a file has been deleted or corrupted. Does repairing the SQL Server management tools fix the problem?

Repairing SQL Server is a command-line operation. You can repair by inserting the installation media into the disk drive and typing the following:

start /wait <CD or DVD Drive>\setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS

You can find more information on installing SQL Server from the command line here: http://msdn2.microsoft.com/en-us/library/ms144259.aspx

|||

Good morning ( or afternoon for me )

Goo and helpful answer whether you have the cd disk but if you have downloaded from Microsoft (for example Express Edition or School version ), i think i must contact Microsoft to have the agreement to downloa and validate again

Have a nice day

Microsoft SQL Sever 2005 Express <> Mixed authentication.

Hello dear all,
I'm not sure if I'm posting to the right newsgroup,
if not please direct me to the right one.
I've installed "Microsoft SQL Server 2005 Express",
and now I can log on only with windows authentication,
I tried to follow : http://support.microsoft.com/kb/269587/en-us
instructions, which says it's indeed for all versions of SQL Server,
but first I don't have Enterprise Manager, I have "SQL Server Configuration
Manager",
and in there I don't find "Server" group as it says to expand it.
so basically I cannot set authentication to mixed.
I need to log on with sql authentication not with windows one.
Help much appreciated.
Thanks
Hi George,
http://support.microsoft.com/default...;EN-US;q285097
INF: How to Change the Default Login Authentication Mode to SQL While
Installing SQL Server 2000 Desktop Engine by Using Windows Installer
<snip>
Another way to change the security mode after installation is to stop
SQL Server and set the appropriate registry key for your installation:
Default instance:
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
Named instance:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Name\MSSQLServer\LoginMode
to 2 for mixed-mode or 1 for integrated. (Integrated is the default
setup for the SQL Server 2000 Data Engine.)
</snip>
Restart the service after this procedure.
HTH, jens Suessmeyer.
|||Hello Jens,
thank you very much for answering.
I don't have the registry keys that you mentioned.
1) HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
I don't have this.
in my registry it goes till:
HKLM\Software\Microsoft\MSSqlserver\ "here I've got only one entry" \Client
2)HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Name\MSSQLServer\LoginMode
I don't have this neither.
in my registry it goes till:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Names\ "and here I have just one entry" \SQL
Regards.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1139301968.599548.102040@.g43g2000cwa.googlegr oups.com...
> Hi George,
> http://support.microsoft.com/default...;EN-US;q285097
> INF: How to Change the Default Login Authentication Mode to SQL While
> Installing SQL Server 2000 Desktop Engine by Using Windows Installer
> <snip>
> Another way to change the security mode after installation is to stop
> SQL Server and set the appropriate registry key for your installation:
>
> Default instance:
> HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
>
> Named instance:
> HKLM\Software\Microsoft\Microsoft SQL Server\Instance
> Name\MSSQLServer\LoginMode
>
> to 2 for mixed-mode or 1 for integrated. (Integrated is the default
> setup for the SQL Server 2000 Data Engine.)
> </snip>
> Restart the service after this procedure.
>
> HTH, jens Suessmeyer.
>
|||Are you sure that you installe a instance of SQL Server Express on your
computer ?
|||Have you checked for LoginMode under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.2\MSSQLServer
Note: the MSSQL.2 can be any number based on logic that normally starts
at 1 as in
MSSQL.1
Tim S
|||Hello there,
thanks a lot,
I just found that key.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.1\MSSQLServer
I have it here.
I'll go try right now... and tell then if it worked...
"Tim" <stahta01@.juno.com> wrote in message
news:1139346215.000850.4360@.o13g2000cwo.googlegrou ps.com...
> Have you checked for LoginMode under
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
> Server\MSSQL.2\MSSQLServer
> Note: the MSSQL.2 can be any number based on logic that normally starts
> at 1 as in
> MSSQL.1
> Tim S
>
|||worked as a charm ))
thank you very much Jens.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1139329297.715620.178700@.g44g2000cwa.googlegr oups.com...
> Are you sure that you installe a instance of SQL Server Express on your
> computer ?
>

Microsoft SQL Sever 2005 Express <> Mixed authentication.

Hello dear all,
I'm not sure if I'm posting to the right newsgroup,
if not please direct me to the right one.
I've installed "Microsoft SQL Server 2005 Express",
and now I can log on only with windows authentication,
I tried to follow : http://support.microsoft.com/kb/269587/en-us
instructions, which says it's indeed for all versions of SQL Server,
but first I don't have Enterprise Manager, I have "SQL Server Configuration
Manager",
and in there I don't find "Server" group as it says to expand it.
so basically I cannot set authentication to mixed.
I need to log on with sql authentication not with windows one.
Help much appreciated.
ThanksHi George,
---
http://support.microsoft.com/defaul...b;EN-US;q285097
---
INF: How to Change the Default Login Authentication Mode to SQL While
Installing SQL Server 2000 Desktop Engine by Using Windows Installer
---
<snip>
Another way to change the security mode after installation is to stop
SQL Server and set the appropriate registry key for your installation:
Default instance:
HKLM\Software\Microsoft\MSSqlserver\MSSq
lServer\LoginMode
Named instance:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Name\MSSQLServer\LoginMode
to 2 for mixed-mode or 1 for integrated. (Integrated is the default
setup for the SQL Server 2000 Data Engine.)
</snip>
Restart the service after this procedure.
HTH, jens Suessmeyer.|||Hello Jens,
thank you very much for answering.
I don't have the registry keys that you mentioned.
1) HKLM\Software\Microsoft\MSSqlserver\MSSq
lServer\LoginMode
I don't have this.
in my registry it goes till:
HKLM\Software\Microsoft\MSSqlserver\ "here I've got only one entry" \Client
2)HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Name\MSSQLServer\LoginMode
I don't have this neither.
in my registry it goes till:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Names\ "and here I have just one entry" \SQL
Regards.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1139301968.599548.102040@.g43g2000cwa.googlegroups.com...
> Hi George,
> ---
> http://support.microsoft.com/defaul...b;EN-US;q285097
> ---
> INF: How to Change the Default Login Authentication Mode to SQL While
> Installing SQL Server 2000 Desktop Engine by Using Windows Installer
> ---
> <snip>
> Another way to change the security mode after installation is to stop
> SQL Server and set the appropriate registry key for your installation:
>
> Default instance:
> HKLM\Software\Microsoft\MSSqlserver\MSSq
lServer\LoginMode
>
> Named instance:
> HKLM\Software\Microsoft\Microsoft SQL Server\Instance
> Name\MSSQLServer\LoginMode
>
> to 2 for mixed-mode or 1 for integrated. (Integrated is the default
> setup for the SQL Server 2000 Data Engine.)
> </snip>
> Restart the service after this procedure.
>
> HTH, jens Suessmeyer.
>|||Are you sure that you installe a instance of SQL Server Express on your
computer ?|||Have you checked for LoginMode under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
Server\MSSQL.2\MSSQLServer
Note: the MSSQL.2 can be any number based on logic that normally starts
at 1 as in
MSSQL.1
Tim S|||Hello there,
thanks a lot,
I just found that key.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
Server\MSSQL.1\MSSQLServer
I have it here.
I'll go try right now... and tell then if it worked...
"Tim" <stahta01@.juno.com> wrote in message
news:1139346215.000850.4360@.o13g2000cwo.googlegroups.com...
> Have you checked for LoginMode under
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
> Server\MSSQL.2\MSSQLServer
> Note: the MSSQL.2 can be any number based on logic that normally starts
> at 1 as in
> MSSQL.1
> Tim S
>|||worked as a charm ))
thank you very much Jens.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1139329297.715620.178700@.g44g2000cwa.googlegroups.com...
> Are you sure that you installe a instance of SQL Server Express on your
> computer ?
>

Microsoft SQL Server, Error: 87 17march

Source computer: SQL server 2005 SP1
Remote computer : SQLEXPRESS
When I try to register/connect with remote server (named instance) using sql
server management studio I am getting following error:
TITLE: New Server Registration
--
Testing the registered server failed. Verify the server name, login
credentials, and database, and then click Test again.
--
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: SQL Network Interfaces, error: 25 - Connection string is not
valid) (Microsoft SQL Server, Error: 87)
Thanks
Ontario, canadaSource computer: SQL server 2005 SP1 (Microsoft windows nt 5.1)
Remote computer : Microsoft SQL server express edition (Microsoft windows
nt 5.1)
-
ontario, canada
"db" wrote:
> Source computer: SQL server 2005 SP1
> Remote computer : SQLEXPRESS
>
> When I try to register/connect with remote server (named instance) using sql
> server management studio I am getting following error:
> TITLE: New Server Registration
> --
> Testing the registered server failed. Verify the server name, login
> credentials, and database, and then click Test again.
> --
> ADDITIONAL INFORMATION:
> An error has occurred while establishing a connection to the server. When
> connecting to SQL Server 2005, this failure may be caused by the fact that
> under the default settings SQL Server does not allow remote connections.
> (provider: SQL Network Interfaces, error: 25 - Connection string is not
> valid) (Microsoft SQL Server, Error: 87)
>
> Thanks
> Ontario, canada