Blocking SQL server by machine name?

Hello,
I've Windows 2000 server with SQL 2000 server running.
I have a SQL user (let's call miniSa) which is mostly "sa" on one SQL box.
And that account is used to all over the places (VB apps,Web app, DTS
connection). Now I know that a person shouldn't be access to the SQL box bu
t
he does using the account. Only way I can track down him is from SQL profil
e
with his machine name.
Is there a way that I can block the SQL box only from a specific machine nam
e?
Thank you in advance.
SangHun"SangHunJung" <SangHunJung@.discussions.microsoft.com> wrote in message
news:F23A84F9-6350-4BE8-B002-62A9BD320BCB@.microsoft.com...
> I've Windows 2000 server with SQL 2000 server running.
> I have a SQL user (let's call miniSa) which is mostly "sa" on one SQL box.
> And that account is used to all over the places (VB apps,Web app, DTS
> connection). Now I know that a person shouldn't be access to the SQL box
but
> he does using the account. Only way I can track down him is from SQL
profile
> with his machine name.
> Is there a way that I can block the SQL box only from a specific machine
name?
It's kind of ugly, but you could do TCP/IP filtering on the server level and
block the IP address of the computer that your "SQL user" uses. A better way
would be a review of the security implementation, eliminate this commonly
used account and implement Windows Authentication with nt group membership.
Steve|||Thanks for the reply Steve.
Using TCP/IP Filtering is not an option because of DHCP server. I may use
MAC address but that way that user may not use all the apps in the server.
I
don't want that happen either. I want just SQL server databases access
denied from the PC.
I will work on the whole problem but I need some time and ofcourse runing
several projects, support developers, and admin issues......tough.
Any other suggestions?
SangHun
"Steve Thompson" wrote:

> "SangHunJung" <SangHunJung@.discussions.microsoft.com> wrote in message
> news:F23A84F9-6350-4BE8-B002-62A9BD320BCB@.microsoft.com...
> but
> profile
> name?
> It's kind of ugly, but you could do TCP/IP filtering on the server level a
nd
> block the IP address of the computer that your "SQL user" uses. A better w
ay
> would be a review of the security implementation, eliminate this commonly
> used account and implement Windows Authentication with nt group membership
.
> Steve
>
>|||
> I will work on the whole problem but I need some time and ofcourse runing
> several projects, support developers, and admin issues......tough.
> Any other suggestions?
Yes, I still recommend my previous suggestion, some times there are no
+easy+ solutions. Sorry.
Steve
[vbcol=seagreen]
commonly[vbcol=seagreen]
membership.|||You can use IPSec to block a particular machine from contacting another
machine on the network.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Blob data

Can someone please give me an example in C# on how to retrieve an Image from a Table and store i into a Picture box on a windows form? In addition, how to insert a blob record into a table as well.Reading BLOBs from SQL Server and display it inaWindows FormPictureBox
http://www.akadia.com/services/dotnet_load_blob.html|||Does any one have an example that they have used and written themselves? This example is very confusing.|||Check the code in the following article. It is from the Microsoft Knowledge base article.
http://www.kbalertz.com/Feedback_326502.aspx|||Just in case the above article doesn't suffice your requirement, let me know and I shall post the code written by me.

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin
|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...
|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Error Messagebox Displayed at startup

When I start SQL Server Management Studio an error message box with no text is displayed with the Exclamation ICON. Everything seems to be working after clicking OK though. Anyone else experienced this. Also... Why is it that I can't repair the installation from Add and Uninstall? Do I have to uninstall it to repair it?

The SQL 2005 is the Developer Addition with a new install...I haven't seen the empty error message box problem. Does it still do that when you start Management Studio, or was it a one-time thing?

You should be able to repair your installation by clicking on the "Change" button rather than "Uninstall" and then walking through the setup wizard.|||Steven,

Actually when I select change from the Add/Remove menu the install starts, but after it checks prerequisets it tells me it's already installed and then tells me there is no maintenance mode and suggests that I do it from Add/Remove Programs ;o).

I don't know why, but beginning Friday the dialog box is gone (go figure). I think the system must be saying, "Wait until Otis logs on and if it's the third Thursday of the month and the moon is not full, throw up that blank message box before you open the Management Studio." |||

You are going to Add/Remove Programs and clicking the Change button there, right? That should get you into maintenance mode for SQL Setup.

|||Yes, that's where I'm going and it does say that it's going into maintenance mode, but after checking the previous install it says there is no maintenance mode for the product.

I'll check it again tomorrow and let you know exactly what I see, rather than what I recall ;-) It's late here in Tejas.|||I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>
I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.|||

dubstar wrote:

I've just started receiving the same blank error message. The only thing I recall doing since it ran without the error message is running windows updates with the 2 most recent suggested updates for XP + the 1.1 .NET framework. I also installed an application which uses the 1.1 framework. I had all of the same components (minus the two most recent suggested updates) running on the same machine while SQL 2005 was still in beta and never ran into this problem.<br><br>

I'm working on the machine from remote right now so I am not going to bother messing with it while it appears to still be working.

I don't know why, but my installation just stopped didplaying the blank messagebox a couple of days after the anomally presented itself (see my post above).

I would be interested in knowing if yours goes away too.|||Oddly enough, it has!
I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)|||

dubstar wrote:

Oddly enough, it has!

I did what work I had to do and when I was finished I was going to try the suggested maintenance from Add/Remove Programs, but it no longer shows up. I did get a screenshot for a friend's 'collection' though.. so it wasn't a total loss. ;)

Ha, ha...

The Phantom strikes again |||I have since run into this problem again. It seems to be related to Crystal Reports. I run an application that appears to use an older version of some Crystal Reports dll than VS 2005 provides. It's a bit of an ongoing saga in that I repair VS 2005, it breaks the other app - I run the other app, it breaks VS 2005. It also appears to have an effect on the documentation browser - when it's VS 2005's turn to be broken many of the tables in the help render text improperly - it will show up half outside of the cells in any table and is mostly unreadable.

The other app is a CRM tool that I am not awfully fond of though. In all honesty, I'm kind of glad to have a reason to uninstall it. :)

...Kevin
|||I'm getting the same blank error message box after installing the 1.1 .net framework.|||well my error box just turned from a yeild sign !, to a Stop sign X, now for the problem. if i press either yes or no it reboots to the login page|||I am also getting this problem. I'm not sure but it may have started after installing the .NET Framework 1.1. I don't do anything with Crystal Reports.|||I too am getting the blank dialog, with an exclamation, although it seems to be benign and everything else is working fine. No Crystal Reports here...
|||

Does repairing .NET Framework 2.0 fix this problem?

You can do that by going to Control Panel > Add or Remove Programs and clicking on the Change/Remove button for Microsoft .NET Framework 2.0. When the setup dialog appears, select Repair and click Next.

Thanks,
Steve

Blank Dialog Box When Starting SQL

When I start SQL Server Management Studio (Sql 2005), a blank dialog box pops up with nothing in it. The title in the dialog box is "Microsoft SQL Server Management Studio" and it has a yellow triangle with an explanation point in it but there is no message just an OK button. I have to click the OK button to continue on to connect to the Sql databases. It does this everytime I open it. Anyone else getting this and how can I get rid of it?In case anyone else has this problem, I got it to go away by repairing .NET Framework 2.0. Control Panel > Add or Remove Programs and click on the Change/Remove button for Microsoft .NET Framework 2.0. Then select Repair and click on Next.|||

Hi, you can take a look at this post

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=132699&SiteID=1

bizarre performance issue

Ive got a box that is having bizarre performance behavior. There is plenty of
CPU and RAM available. There is no blocking. I cannot find any table scans,
(other than - - 120 row temp table scans) nor does the Index Tuning Wizrd
recommend that I add anything. No software other than SQL Server and some
CommVault backup software are on the box. But still, performance is all over
the place. Sometimes everything is humming right along between 3 and 5
seconds, but later on it will be between 40 and 50 seconds. Of course I see
all of these Procs in Profiler, but everything appears to be OK with them.
Ive been on this all day and am really at a loss as to what to do from here.
Any ideas?
--
TIA,
ChrisRThat is not much to go on. What is it you are doing? 3 to 5 seconds isn't
humming along in my book but it is hard to say without seeing what you are
trying to do. No that it should make that much of a difference but maybe
you are getting a lot of recompiles due to the temp table populations. Have
you tried replacing them with table vars? They sound like the optimal size
for table vars over temp tables.
--
Andrew J. Kelly SQL MVP
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:594022ED-21B3-44F6-84A3-803F877D243D@.microsoft.com...
> Ive got a box that is having bizarre performance behavior. There is plenty
> of
> CPU and RAM available. There is no blocking. I cannot find any table
> scans,
> (other than - - 120 row temp table scans) nor does the Index Tuning Wizrd
> recommend that I add anything. No software other than SQL Server and some
> CommVault backup software are on the box. But still, performance is all
> over
> the place. Sometimes everything is humming right along between 3 and 5
> seconds, but later on it will be between 40 and 50 seconds. Of course I
> see
> all of these Procs in Profiler, but everything appears to be OK with them.
> Ive been on this all day and am really at a loss as to what to do from
> here.
> Any ideas?
> --
> TIA,
> ChrisR|||ChrisR wrote:
> Ive got a box that is having bizarre performance behavior. There is
> plenty of CPU and RAM available. There is no blocking. I cannot find
> any table scans, (other than - - 120 row temp table scans) nor does
> the Index Tuning Wizrd recommend that I add anything. No software
> other than SQL Server and some CommVault backup software are on the
> box. But still, performance is all over the place. Sometimes
> everything is humming right along between 3 and 5 seconds, but later
> on it will be between 40 and 50 seconds. Of course I see all of these
> Procs in Profiler, but everything appears to be OK with them. Ive
> been on this all day and am really at a loss as to what to do from
> here. Any ideas?
When you say the procs, as they appear in Profiler, appear ok, what do
you mean? If they are in fact appearing within your expected performance
parameters, you should see CPU, Reads, and Duration figures that are
normal. Duration should be in the 3,000 - 5,000ms range as you mentioned
and in all likelyhood, performance at the client should be good as well.
If OTOH you are seeing a Duration of 30,000ms or elevated CPU or Read
activity, then I'm guessing that Profiler is showing you there is a
problem.
Can you be more specific about any differences in the Profiler output
between good and bad performance.
David Gugick
Quest Software
www.imceda.com
www.quest.com

bizarre performance issue

Ive got a box that is having bizarre performance behavior. There is plenty o
f
CPU and RAM available. There is no blocking. I cannot find any table scans,
(other than - - 120 row temp table scans) nor does the Index Tuning Wizrd
recommend that I add anything. No software other than SQL Server and some
CommVault backup software are on the box. But still, performance is all over
the place. Sometimes everything is humming right along between 3 and 5
seconds, but later on it will be between 40 and 50 seconds. Of course I see
all of these Procs in Profiler, but everything appears to be OK with them.
Ive been on this all day and am really at a loss as to what to do from here.
Any ideas?
TIA,
ChrisRThat is not much to go on. What is it you are doing? 3 to 5 seconds isn't
humming along in my book but it is hard to say without seeing what you are
trying to do. No that it should make that much of a difference but maybe
you are getting a lot of recompiles due to the temp table populations. Have
you tried replacing them with table vars? They sound like the optimal size
for table vars over temp tables.
Andrew J. Kelly SQL MVP
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:594022ED-21B3-44F6-84A3-803F877D243D@.microsoft.com...
> Ive got a box that is having bizarre performance behavior. There is plenty
> of
> CPU and RAM available. There is no blocking. I cannot find any table
> scans,
> (other than - - 120 row temp table scans) nor does the Index Tuning Wizrd
> recommend that I add anything. No software other than SQL Server and some
> CommVault backup software are on the box. But still, performance is all
> over
> the place. Sometimes everything is humming right along between 3 and 5
> seconds, but later on it will be between 40 and 50 seconds. Of course I
> see
> all of these Procs in Profiler, but everything appears to be OK with them.
> Ive been on this all day and am really at a loss as to what to do from
> here.
> Any ideas?
> --
> TIA,
> ChrisR|||ChrisR wrote:
> Ive got a box that is having bizarre performance behavior. There is
> plenty of CPU and RAM available. There is no blocking. I cannot find
> any table scans, (other than - - 120 row temp table scans) nor does
> the Index Tuning Wizrd recommend that I add anything. No software
> other than SQL Server and some CommVault backup software are on the
> box. But still, performance is all over the place. Sometimes
> everything is humming right along between 3 and 5 seconds, but later
> on it will be between 40 and 50 seconds. Of course I see all of these
> Procs in Profiler, but everything appears to be OK with them. Ive
> been on this all day and am really at a loss as to what to do from
> here. Any ideas?
When you say the procs, as they appear in Profiler, appear ok, what do
you mean? If they are in fact appearing within your expected performance
parameters, you should see CPU, Reads, and Duration figures that are
normal. Duration should be in the 3,000 - 5,000ms range as you mentioned
and in all likelyhood, performance at the client should be good as well.
If OTOH you are seeing a Duration of 30,000ms or elevated CPU or Read
activity, then I'm guessing that Profiler is showing you there is a
problem.
Can you be more specific about any differences in the Profiler output
between good and bad performance.
David Gugick
Quest Software
www.imceda.com
www.quest.com

bizarre performance issue

Ive got a box that is having bizarre performance behavior. There is plenty of
CPU and RAM available. There is no blocking. I cannot find any table scans,
(other than - - 120 row temp table scans) nor does the Index Tuning Wizrd
recommend that I add anything. No software other than SQL Server and some
CommVault backup software are on the box. But still, performance is all over
the place. Sometimes everything is humming right along between 3 and 5
seconds, but later on it will be between 40 and 50 seconds. Of course I see
all of these Procs in Profiler, but everything appears to be OK with them.
Ive been on this all day and am really at a loss as to what to do from here.
Any ideas?
TIA,
ChrisR
That is not much to go on. What is it you are doing? 3 to 5 seconds isn't
humming along in my book but it is hard to say without seeing what you are
trying to do. No that it should make that much of a difference but maybe
you are getting a lot of recompiles due to the temp table populations. Have
you tried replacing them with table vars? They sound like the optimal size
for table vars over temp tables.
Andrew J. Kelly SQL MVP
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:594022ED-21B3-44F6-84A3-803F877D243D@.microsoft.com...
> Ive got a box that is having bizarre performance behavior. There is plenty
> of
> CPU and RAM available. There is no blocking. I cannot find any table
> scans,
> (other than - - 120 row temp table scans) nor does the Index Tuning Wizrd
> recommend that I add anything. No software other than SQL Server and some
> CommVault backup software are on the box. But still, performance is all
> over
> the place. Sometimes everything is humming right along between 3 and 5
> seconds, but later on it will be between 40 and 50 seconds. Of course I
> see
> all of these Procs in Profiler, but everything appears to be OK with them.
> Ive been on this all day and am really at a loss as to what to do from
> here.
> Any ideas?
> --
> TIA,
> ChrisR
|||ChrisR wrote:
> Ive got a box that is having bizarre performance behavior. There is
> plenty of CPU and RAM available. There is no blocking. I cannot find
> any table scans, (other than - - 120 row temp table scans) nor does
> the Index Tuning Wizrd recommend that I add anything. No software
> other than SQL Server and some CommVault backup software are on the
> box. But still, performance is all over the place. Sometimes
> everything is humming right along between 3 and 5 seconds, but later
> on it will be between 40 and 50 seconds. Of course I see all of these
> Procs in Profiler, but everything appears to be OK with them. Ive
> been on this all day and am really at a loss as to what to do from
> here. Any ideas?
When you say the procs, as they appear in Profiler, appear ok, what do
you mean? If they are in fact appearing within your expected performance
parameters, you should see CPU, Reads, and Duration figures that are
normal. Duration should be in the 3,000 - 5,000ms range as you mentioned
and in all likelyhood, performance at the client should be good as well.
If OTOH you are seeing a Duration of 30,000ms or elevated CPU or Read
activity, then I'm guessing that Profiler is showing you there is a
problem.
Can you be more specific about any differences in the Profiler output
between good and bad performance.
David Gugick
Quest Software
www.imceda.com
www.quest.com