Showing posts with label properties. Show all posts
Showing posts with label properties. Show all posts

Tuesday, March 27, 2012

Can't close IDE, modal dialog, anyone know what's causing this?

I've only seen this happen when using the report designer, and I think only
when working with Dundas chart properties. I don't have a modal dialog
open, or at least not that I can find. I use alt-esc to loop through the
dialogs on the OS, nothing. Microsoft has an entry in support, it says it
usually happens when I try to shut down and have left a modal dialog
open...only there is no dialog to close. I end up ending the IDE process
tree. Anyone else getting this and/or know the cause?
Microsoft Visual Studio cannot shut down because a modal dialog is active.
Close the active dialog and try again.
Yes it's Friday the 13th :)
Steve MunLeeuwhttp://geekswithblogs.net/geekusconlivus/archive/2006/02/28/70918.aspx
This is a lot better description, sorry for posting.
Steve MunLeeuw
"Steve MunLeeuw" <smunson@.clearwire.net> wrote in message
news:u6iO0Qy7GHA.940@.TK2MSFTNGP03.phx.gbl...
> I've only seen this happen when using the report designer, and I think
> only when working with Dundas chart properties. I don't have a modal
> dialog open, or at least not that I can find. I use alt-esc to loop
> through the dialogs on the OS, nothing. Microsoft has an entry in
> support, it says it usually happens when I try to shut down and have left
> a modal dialog open...only there is no dialog to close. I end up ending
> the IDE process tree. Anyone else getting this and/or know the cause?
> Microsoft Visual Studio cannot shut down because a modal dialog is active.
> Close the active dialog and try again.
> Yes it's Friday the 13th :)
> Steve MunLeeuw
>|||If I've been working with the code view of reports, my VS 2005 doesn't close
like normal. I usually have to close it by killing the DevEnv.exe service in
Task Manager...
Not a very elegant solution, but it will close. ;)
Kaisa M. Lindahl Lervik
"Steve MunLeeuw" <smunson@.clearwire.net> wrote in message
news:ekQn5Ty7GHA.3740@.TK2MSFTNGP05.phx.gbl...
> http://geekswithblogs.net/geekusconlivus/archive/2006/02/28/70918.aspx
> This is a lot better description, sorry for posting.
> Steve MunLeeuw
> "Steve MunLeeuw" <smunson@.clearwire.net> wrote in message
> news:u6iO0Qy7GHA.940@.TK2MSFTNGP03.phx.gbl...
>> I've only seen this happen when using the report designer, and I think
>> only when working with Dundas chart properties. I don't have a modal
>> dialog open, or at least not that I can find. I use alt-esc to loop
>> through the dialogs on the OS, nothing. Microsoft has an entry in
>> support, it says it usually happens when I try to shut down and have left
>> a modal dialog open...only there is no dialog to close. I end up ending
>> the IDE process tree. Anyone else getting this and/or know the cause?
>> Microsoft Visual Studio cannot shut down because a modal dialog is
>> active. Close the active dialog and try again.
>> Yes it's Friday the 13th :)
>> Steve MunLeeuw
>|||Kaisa M. Lindahl Lervik wrote:
> If I've been working with the code view of reports, my VS 2005 doesn't close
> like normal. I usually have to close it by killing the DevEnv.exe service in
> Task Manager...
> Not a very elegant solution, but it will close. ;)
> Kaisa M. Lindahl Lervik
>
> "Steve MunLeeuw" <smunson@.clearwire.net> wrote in message
> news:ekQn5Ty7GHA.3740@.TK2MSFTNGP05.phx.gbl...
> > http://geekswithblogs.net/geekusconlivus/archive/2006/02/28/70918.aspx
> >
> > This is a lot better description, sorry for posting.
> >
> > Steve MunLeeuw
> >
> > "Steve MunLeeuw" <smunson@.clearwire.net> wrote in message
> > news:u6iO0Qy7GHA.940@.TK2MSFTNGP03.phx.gbl...
> >> I've only seen this happen when using the report designer, and I think
> >> only when working with Dundas chart properties. I don't have a modal
> >> dialog open, or at least not that I can find. I use alt-esc to loop
> >> through the dialogs on the OS, nothing. Microsoft has an entry in
> >> support, it says it usually happens when I try to shut down and have left
> >> a modal dialog open...only there is no dialog to close. I end up ending
> >> the IDE process tree. Anyone else getting this and/or know the cause?
> >>
> >> Microsoft Visual Studio cannot shut down because a modal dialog is
> >> active. Close the active dialog and try again.
> >>
> >> Yes it's Friday the 13th :)
> >> Steve MunLeeuw
> >>
> >
> >
yes..this is happening to me quie a bit when writing a lot of reports
and changing a lot of charts...save soon save often....it looks like
the dundas dialogs and the vs dialogs get a bit confused...that is
all...
Peter
www.peternolan.com

Can't change Memory in SQL 2K

When I right click on my SQL Server, go to Properties and click on the
Memory tab. I can't change my memory settings. The Slide Bar won't move.
Can't anyone help.Hello,
Not sure what the issue. Instead use SP_CONFIGURE system procedure from
query analyzer to change the memory configuration.
Script:-
USE master
EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
Set the maximum amount of memory to 1 GB: (CHnage it based on your
requirement)
USE master
EXEC sp_configure 'max server memory (MB)', 1024
RECONFIGURE WITH OVERRIDE
Display the newly set configuration:
USE master
EXEC sp_configure 'max server memory (MB)'
Set 'show advanced options' back to default:
USE master
EXEC sp_configure 'show advanced options', 0
RECONFIGURE WITH OVERRIDE
Thanks
Hari
"John" <bechtj@.co.delaware.pa.us> wrote in message
news:ef8vJ%23wIHHA.1044@.TK2MSFTNGP02.phx.gbl...
> When I right click on my SQL Server, go to Properties and click on the
> Memory tab. I can't change my memory settings. The Slide Bar won't move.
> Can't anyone help.
>|||Strange thing.
Right now it is set to Fixed Memory at 16 Meg. It won't let me slide the bar
over. So I choose Dynamically and hit ok. I went back in and it is back on
fixed memory again. Why would it change back?
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%239ogVMxIHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Hello,
> Not sure what the issue. Instead use SP_CONFIGURE system procedure from
> query analyzer to change the memory configuration.
> Script:-
> USE master
> EXEC sp_configure 'show advanced options', 1
> RECONFIGURE WITH OVERRIDE
>
> Set the maximum amount of memory to 1 GB: (CHnage it based on your
> requirement)
> USE master
> EXEC sp_configure 'max server memory (MB)', 1024
> RECONFIGURE WITH OVERRIDE
>
> Display the newly set configuration:
> USE master
> EXEC sp_configure 'max server memory (MB)'
>
> Set 'show advanced options' back to default:
> USE master
> EXEC sp_configure 'show advanced options', 0
> RECONFIGURE WITH OVERRIDE
>
> Thanks
> Hari
> "John" <bechtj@.co.delaware.pa.us> wrote in message
> news:ef8vJ%23wIHHA.1044@.TK2MSFTNGP02.phx.gbl...
>|||Another thing thats strange. If I go to another Server with Enterprise
Manager, I can configure the memory from there with no troubles.but from the
Server itself I cannot.
And even odder, on the General Tab, it is blank for OS, for Platform,
Processors etc... strange!!
Then even stranger under Processors it has nothing. Should it show the
processors under that tab or do I need to add them?
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%239ogVMxIHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Hello,
> Not sure what the issue. Instead use SP_CONFIGURE system procedure from
> query analyzer to change the memory configuration.
> Script:-
> USE master
> EXEC sp_configure 'show advanced options', 1
> RECONFIGURE WITH OVERRIDE
>
> Set the maximum amount of memory to 1 GB: (CHnage it based on your
> requirement)
> USE master
> EXEC sp_configure 'max server memory (MB)', 1024
> RECONFIGURE WITH OVERRIDE
>
> Display the newly set configuration:
> USE master
> EXEC sp_configure 'max server memory (MB)'
>
> Set 'show advanced options' back to default:
> USE master
> EXEC sp_configure 'show advanced options', 0
> RECONFIGURE WITH OVERRIDE
>
> Thanks
> Hari
> "John" <bechtj@.co.delaware.pa.us> wrote in message
> news:ef8vJ%23wIHHA.1044@.TK2MSFTNGP02.phx.gbl...
>

Can't change Memory in SQL 2K

When I right click on my SQL Server, go to Properties and click on the
Memory tab. I can't change my memory settings. The Slide Bar won't move.
Can't anyone help.
Hello,
Not sure what the issue. Instead use SP_CONFIGURE system procedure from
query analyzer to change the memory configuration.
Script:-
USE master
EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
Set the maximum amount of memory to 1 GB: (CHnage it based on your
requirement)
USE master
EXEC sp_configure 'max server memory (MB)', 1024
RECONFIGURE WITH OVERRIDE
Display the newly set configuration:
USE master
EXEC sp_configure 'max server memory (MB)'
Set 'show advanced options' back to default:
USE master
EXEC sp_configure 'show advanced options', 0
RECONFIGURE WITH OVERRIDE
Thanks
Hari
"John" <bechtj@.co.delaware.pa.us> wrote in message
news:ef8vJ%23wIHHA.1044@.TK2MSFTNGP02.phx.gbl...
> When I right click on my SQL Server, go to Properties and click on the
> Memory tab. I can't change my memory settings. The Slide Bar won't move.
> Can't anyone help.
>
|||Strange thing.
Right now it is set to Fixed Memory at 16 Meg. It won't let me slide the bar
over. So I choose Dynamically and hit ok. I went back in and it is back on
fixed memory again. Why would it change back?
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%239ogVMxIHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Hello,
> Not sure what the issue. Instead use SP_CONFIGURE system procedure from
> query analyzer to change the memory configuration.
> Script:-
> USE master
> EXEC sp_configure 'show advanced options', 1
> RECONFIGURE WITH OVERRIDE
>
> Set the maximum amount of memory to 1 GB: (CHnage it based on your
> requirement)
> USE master
> EXEC sp_configure 'max server memory (MB)', 1024
> RECONFIGURE WITH OVERRIDE
>
> Display the newly set configuration:
> USE master
> EXEC sp_configure 'max server memory (MB)'
>
> Set 'show advanced options' back to default:
> USE master
> EXEC sp_configure 'show advanced options', 0
> RECONFIGURE WITH OVERRIDE
>
> Thanks
> Hari
> "John" <bechtj@.co.delaware.pa.us> wrote in message
> news:ef8vJ%23wIHHA.1044@.TK2MSFTNGP02.phx.gbl...
>
|||Another thing thats strange. If I go to another Server with Enterprise
Manager, I can configure the memory from there with no troubles.but from the
Server itself I cannot.
And even odder, on the General Tab, it is blank for OS, for Platform,
Processors etc... strange!!
Then even stranger under Processors it has nothing. Should it show the
processors under that tab or do I need to add them?
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%239ogVMxIHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Hello,
> Not sure what the issue. Instead use SP_CONFIGURE system procedure from
> query analyzer to change the memory configuration.
> Script:-
> USE master
> EXEC sp_configure 'show advanced options', 1
> RECONFIGURE WITH OVERRIDE
>
> Set the maximum amount of memory to 1 GB: (CHnage it based on your
> requirement)
> USE master
> EXEC sp_configure 'max server memory (MB)', 1024
> RECONFIGURE WITH OVERRIDE
>
> Display the newly set configuration:
> USE master
> EXEC sp_configure 'max server memory (MB)'
>
> Set 'show advanced options' back to default:
> USE master
> EXEC sp_configure 'show advanced options', 0
> RECONFIGURE WITH OVERRIDE
>
> Thanks
> Hari
> "John" <bechtj@.co.delaware.pa.us> wrote in message
> news:ef8vJ%23wIHHA.1044@.TK2MSFTNGP02.phx.gbl...
>

Can't change Memory in SQL 2K

When I right click on my SQL Server, go to Properties and click on the
Memory tab. I can't change my memory settings. The Slide Bar won't move.
Can't anyone help.Hello,
Not sure what the issue. Instead use SP_CONFIGURE system procedure from
query analyzer to change the memory configuration.
Script:-
USE master
EXEC sp_configure 'show advanced options', 1
RECONFIGURE WITH OVERRIDE
Set the maximum amount of memory to 1 GB: (CHnage it based on your
requirement)
USE master
EXEC sp_configure 'max server memory (MB)', 1024
RECONFIGURE WITH OVERRIDE
Display the newly set configuration:
USE master
EXEC sp_configure 'max server memory (MB)'
Set 'show advanced options' back to default:
USE master
EXEC sp_configure 'show advanced options', 0
RECONFIGURE WITH OVERRIDE
Thanks
Hari
"John" <bechtj@.co.delaware.pa.us> wrote in message
news:ef8vJ%23wIHHA.1044@.TK2MSFTNGP02.phx.gbl...
> When I right click on my SQL Server, go to Properties and click on the
> Memory tab. I can't change my memory settings. The Slide Bar won't move.
> Can't anyone help.
>|||Strange thing.
Right now it is set to Fixed Memory at 16 Meg. It won't let me slide the bar
over. So I choose Dynamically and hit ok. I went back in and it is back on
fixed memory again. Why would it change back?
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%239ogVMxIHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Hello,
> Not sure what the issue. Instead use SP_CONFIGURE system procedure from
> query analyzer to change the memory configuration.
> Script:-
> USE master
> EXEC sp_configure 'show advanced options', 1
> RECONFIGURE WITH OVERRIDE
>
> Set the maximum amount of memory to 1 GB: (CHnage it based on your
> requirement)
> USE master
> EXEC sp_configure 'max server memory (MB)', 1024
> RECONFIGURE WITH OVERRIDE
>
> Display the newly set configuration:
> USE master
> EXEC sp_configure 'max server memory (MB)'
>
> Set 'show advanced options' back to default:
> USE master
> EXEC sp_configure 'show advanced options', 0
> RECONFIGURE WITH OVERRIDE
>
> Thanks
> Hari
> "John" <bechtj@.co.delaware.pa.us> wrote in message
> news:ef8vJ%23wIHHA.1044@.TK2MSFTNGP02.phx.gbl...
>> When I right click on my SQL Server, go to Properties and click on the
>> Memory tab. I can't change my memory settings. The Slide Bar won't move.
>> Can't anyone help.
>>
>|||Another thing thats strange. If I go to another Server with Enterprise
Manager, I can configure the memory from there with no troubles.but from the
Server itself I cannot.
And even odder, on the General Tab, it is blank for OS, for Platform,
Processors etc... strange!!
Then even stranger under Processors it has nothing. Should it show the
processors under that tab or do I need to add them?
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:%239ogVMxIHHA.2456@.TK2MSFTNGP06.phx.gbl...
> Hello,
> Not sure what the issue. Instead use SP_CONFIGURE system procedure from
> query analyzer to change the memory configuration.
> Script:-
> USE master
> EXEC sp_configure 'show advanced options', 1
> RECONFIGURE WITH OVERRIDE
>
> Set the maximum amount of memory to 1 GB: (CHnage it based on your
> requirement)
> USE master
> EXEC sp_configure 'max server memory (MB)', 1024
> RECONFIGURE WITH OVERRIDE
>
> Display the newly set configuration:
> USE master
> EXEC sp_configure 'max server memory (MB)'
>
> Set 'show advanced options' back to default:
> USE master
> EXEC sp_configure 'show advanced options', 0
> RECONFIGURE WITH OVERRIDE
>
> Thanks
> Hari
> "John" <bechtj@.co.delaware.pa.us> wrote in message
> news:ef8vJ%23wIHHA.1044@.TK2MSFTNGP02.phx.gbl...
>> When I right click on my SQL Server, go to Properties and click on the
>> Memory tab. I can't change my memory settings. The Slide Bar won't move.
>> Can't anyone help.
>>
>

Can't change language in server properties

Hi

I'm running SQL Server 2005 Express SP1 on a Danish PC, and I need to have the server language set to Danish.

However, when I want to change the language in server properties (the current language is English (US) using Management Studio Express, I can't - all of the properties on the General page are greyed out.

I know that the SQL Server Express SP1 download is available in several languages (Danish not being one of them) - does that mean that I can't get my SQL Server Express SP1 installation to "speak" Danish at all?

Please help - it's driving me up the wall.

It depends on what you mean by "speak" Danish.

If you mean you want your error messages in Danish, that won't happen. We only support a limited number of localized versions of SQL Server.

If you mean you want to have SQL to store Danish language data, we support that through unicode data types and collation order. You can read more about SQL Collation in BOL; try starting at http://msdn2.microsoft.com/en-US/library/ms143503(SQL.90).aspx for a quick overview and move on from there.

Regards,

Mike Wachal

|||

I have a similar problem, my client and server use the brazilian language but the SQL Server 2005 uses English-US.

How I change the language to brazilian?

I have problems using datetime send from a application developped in Delphi.

The program woks fine dates in the months Jan, Mar, Jun, Jul, Nov and Dec

|||

I have a similar problem, my client and server use the brazilian language but the SQL Server 2005 uses English-US.

How I change the language to brazilian?

I have problems using datetime send from a application developped in Delphi.

The program woks fine dates in the months Jan, Mar, Jun, Jul, Nov and Dec

procedure TForm1.BitBtn1Click(Sender: TObject);
var
i:Integer;
begin
Table1.EmptyTable;
Table1.open;
for I := 1 to 500 do
begin
Table1.Append;
Table1Teste.value:= 'Testando '+Inttostr(I);
Table1Data.Value:= Date+I;
Table1.post;
end;
ShowMessage('Terminei');
Table1.close;
end;

end.

sql

Can't change language in server properties

Hi

I'm running SQL Server 2005 Express SP1 on a Danish PC, and I need to have the server language set to Danish.

However, when I want to change the language in server properties (the current language is English (US) using Management Studio Express, I can't - all of the properties on the General page are greyed out.

I know that the SQL Server Express SP1 download is available in several languages (Danish not being one of them) - does that mean that I can't get my SQL Server Express SP1 installation to "speak" Danish at all?

Please help - it's driving me up the wall.

It depends on what you mean by "speak" Danish.

If you mean you want your error messages in Danish, that won't happen. We only support a limited number of localized versions of SQL Server.

If you mean you want to have SQL to store Danish language data, we support that through unicode data types and collation order. You can read more about SQL Collation in BOL; try starting at http://msdn2.microsoft.com/en-US/library/ms143503(SQL.90).aspx for a quick overview and move on from there.

Regards,

Mike Wachal

|||

I have a similar problem, my client and server use the brazilian language but the SQL Server 2005 uses English-US.

How I change the language to brazilian?

I have problems using datetime send from a application developped in Delphi.

The program woks fine dates in the months Jan, Mar, Jun, Jul, Nov and Dec

|||

I have a similar problem, my client and server use the brazilian language but the SQL Server 2005 uses English-US.

How I change the language to brazilian?

I have problems using datetime send from a application developped in Delphi.

The program woks fine dates in the months Jan, Mar, Jun, Jul, Nov and Dec

procedure TForm1.BitBtn1Click(Sender: TObject);
var
i:Integer;
begin
Table1.EmptyTable;
Table1.open;
for I := 1 to 500 do
begin
Table1.Append;
Table1Teste.value:= 'Testando '+Inttostr(I);
Table1Data.Value:= Date+I;
Table1.post;
end;
ShowMessage('Terminei');
Table1.close;
end;

end.

Cant Auto-Start Agent

I have a SQL Server 2000 that failed to start after a Windows reboot.
Agent properties are checked to auto start if stopped. Under the Agent
Error Log, I have the following data:

Information:
SQL Agent stopping because of Windows shutdown.
SQL Agent terminated normally.

Error:
SQL Server Error: 1115, cannot generate SSPI context SQLState HY000.
Logon to server(local) failed.

Help apprecaited. Thanks
Frank

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Frank Py <fpy@.proactnet.com> wrote in message news:<3f843998$0$202$75868355@.news.frii.net>...
> I have a SQL Server 2000 that failed to start after a Windows reboot.
> Agent properties are checked to auto start if stopped. Under the Agent
> Error Log, I have the following data:
> Information:
> SQL Agent stopping because of Windows shutdown.
> SQL Agent terminated normally.
> Error:
> SQL Server Error: 1115, cannot generate SSPI context SQLState HY000.
> Logon to server(local) failed.
> Help apprecaited. Thanks
> Frank
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

You might find these KB articles helpful:

http://support.microsoft.com/defaul...9&Product=sql2k
http://support.microsoft.com/defaul...4&Product=sql2k

Simon|||I am having this problem, too. Have you found a solution?

Thursday, March 22, 2012

Can't Add or Delete new role for new users

I've tried to add or delete a user to read report by using report manager.
User Home -> Properties -> New Role Assignment
Then enter user's doman and id information and check the role. However, it
shows ERROR.
The error message:
"Can't find the role '?' (rsRoleNotFound).
When i tried to delete one of the current user, it shows the same error
message.
The error message:
"Can't find the role '?' (rsRoleNotFound).
However, in my roles table, all roles information are all complete and
correct.
Can anyone tell me what's wrong?"roles" here refers to active directory user. You must add user you want to
the active directory (using control panel->management tools->computer
management->users)
than you can use the user you have added in the service now
"Lisa" wrote:
> I've tried to add or delete a user to read report by using report manager.
> User Home -> Properties -> New Role Assignment
> Then enter user's doman and id information and check the role. However, it
> shows ERROR.
> The error message:
> "Can't find the role '?' (rsRoleNotFound).
> When i tried to delete one of the current user, it shows the same error
> message.
> The error message:
> "Can't find the role '?' (rsRoleNotFound).
> However, in my roles table, all roles information are all complete and
> correct.
> Can anyone tell me what's wrong?
>
>
>|||Hi,
The user i want to add has already added in the management tools.
Is there anyother possiblie way to fix this?
"yuanxm" <yuanxm@.discussions.microsoft.com> ¦b¶l¥ó
news:95A7D902-5815-4F26-8A75-FFB17C05C974@.microsoft.com ¤¤¼¶¼g...
> "roles" here refers to active directory user. You must add user you want
to
> the active directory (using control panel->management tools->computer
> management->users)
> than you can use the user you have added in the service now
> "Lisa" wrote:
> > I've tried to add or delete a user to read report by using report
manager.
> > User Home -> Properties -> New Role Assignment
> > Then enter user's doman and id information and check the role. However,
it
> > shows ERROR.
> > The error message:
> > "Can't find the role '?' (rsRoleNotFound).
> > When i tried to delete one of the current user, it shows the same error
> > message.
> > The error message:
> > "Can't find the role '?' (rsRoleNotFound).
> >
> > However, in my roles table, all roles information are all complete and
> > correct.
> >
> > Can anyone tell me what's wrong?
> >
> >
> >
> >
> >

Tuesday, March 20, 2012

Can't access properties on Stored Procedures

Hi. I have set up an instance of SQL 2005 on my local computer. I use MS SQL Server Management Studio to login into my 2005 instance via Windows login. When I expand "Stored Procedures" under "Programmability" of the Database I want and go to a stored procedure and right click, I don't see the "properities" selection.

I know it's there because I can get to it on other instances but I can't get to it on my local instance. I added my windows user to my Logins and then to my database users but it didn't help.

Can anyone please tell me what I need to do so I can access the properties of the stored procedures?

Thanks

Your procedure was created with encryption option. Because this you can′t see the contents.

|||Its either an encryption problem (like already mentioned by the other poster) or you don′t have the appropiate permissions viewing the properties. Which access level does the account you are using have ? Is there a pas lock on the stored procedure symbol ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Can't access merge agent properties

Hi,
I'm having a problem trying to access merge agent's properties. I have
a SqlServer publication that synchronizes with diferent PDA devices.
These devices register themselfes as subscribers to synchronize with
the database and create a merge agent for each of them.
The problem is that I can't access the agent's properties. If I go to
Replication Monitor -> Agents -> Merge Agents in sql server's
administrative console, right click one of the agent (e.g subscription
name 21F:-460) and then select "Agent Properties..." i get a login
screen "Connect to Sql Server: 21F" and asks for user & password.
What is this account ? I can't understand how this works, could
somebody explain it please ? Is it possible to access merge agent
properties ?
Any help would be appreciated,
thx in advance.
ori
That's the problem with the ActiveX controls used by replication, you can't view the properties in EM.
I normally don't get this error message however when I right click on the agents.
To administer these activeX agents you need to make changes in your code, not through EM.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"ORi" wrote:

> Hi,
> I'm having a problem trying to access merge agent's properties. I have
> a SqlServer publication that synchronizes with diferent PDA devices.
> These devices register themselfes as subscribers to synchronize with
> the database and create a merge agent for each of them.
> The problem is that I can't access the agent's properties. If I go to
> Replication Monitor -> Agents -> Merge Agents in sql server's
> administrative console, right click one of the agent (e.g subscription
> name 21F:-460) and then select "Agent Properties..." i get a login
> screen "Connect to Sql Server: 21F" and asks for user & password.
> What is this account ? I can't understand how this works, could
> somebody explain it please ? Is it possible to access merge agent
> properties ?
> Any help would be appreciated,
> thx in advance.
> ori
>

Can't access merge agent properties

I'm trying to set the logging level on a merge agent. I've read
KB312292. When I right click on the agent and select properties some
text flashes in the status bar but no dialog is displayed. I'm using
SQL 2K SP4.
TIA
Is this for pulls configure through ActiveX scripts/programming? or WSM
pulls?
You can't do it for these.
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
"Darren" <darren@.nospam.com> wrote in message
news:eiaIuotFGHA.3120@.TK2MSFTNGP10.phx.gbl...
> I'm trying to set the logging level on a merge agent. I've read KB312292.
> When I right click on the agent and select properties some text flashes in
> the status bar but no dialog is displayed. I'm using SQL 2K SP4.
> TIA
|||Hilary Cotter wrote:
> Is this for pulls configure through ActiveX scripts/programming? or WSM
> pulls?
> You can't do it for these.
>
It was created from a C# app using the merge object. So how can I
change the logging level for that agent without using what is described
in the KB article?
|||use the status event to get messages. You will probably have to configure
the agent to use the verbose profile to see these messages. I would restart
on failure to use the new profile; running with the verbose profile does not
perform well.
Let me know if you need code for this.
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
"Darren" <Darren@.nospam.nospam> wrote in message
news:elcSkBvFGHA.3200@.tk2msftngp13.phx.gbl...
> Hilary Cotter wrote:
> It was created from a C# app using the merge object. So how can I change
> the logging level for that agent without using what is described in the KB
> article?
|||Thanks.
I don't this the status event callback provides enough detail.
I'm trying to get the equivalent of the following options
-output c:\log.txt -outverboselevel 3
I don't see either in the merge profile options.
Hilary Cotter wrote:
> use the status event to get messages. You will probably have to configure
> the agent to use the verbose profile to see these messages. I would restart
> on failure to use the new profile; running with the verbose profile does not
> perform well.
> Let me know if you need code for this.
>

Monday, March 19, 2012

Cannot view sql server object properties in vstudio .net 2003

Hi!

Sudenly I stoped being able to view sql server object properties in the visual studio properties window . When I selected an sql server object in the server explorer i could see its properties in the prop. window . Now I can't see them anymore, the properties window apears blank.

Can anyone tell what do I need to do to be able to view them again.

Thanks & Best Regards
Pedro CostaHey-

I'm having this exact same problem. I'm researching to see if I can find anything, so if you beat me to it, please post the fix here. I'll do the same.|||What has changed between the time you COULD see them and right now? Did you install something? Apply a service pack? Remove something?|||I uninstalled VS.NET and installed VS.NET 2003. I'm using MSDE, BTW. I'm currently uninstalling and reinstalling MSDE, just for kicks. We'll see if it makes any difference. I'm wondering if the issue is permissions related somehow? But I'm logged in as a user with full admin rights on this machine, and I was under the impression that the IDE uses windows auth to connect to the database. Is this correct?
I've poked throught the environment preferences and I don't see anything that looks pertinent.

Sunday, March 11, 2012

cannot view job properties. i keep getting "new job" dialog box.

In my installation of sql server 2005, i cannot view any job properties. when i doubble click on a job, i just get the "new job" dialog box. when i right click on a job and select properties, i also get the "new job" dialog box. i have reinstalled sql server workstation components and restarted but it did not fix the issue. anyone ever have this issue

post back the Service Pack in this box

Madhu

|||

i reinstalled sql server completely and it works now. pitty i had to waste so much time doing that. have no idea why it would do what it done. no updates or serivce packs added in weeks and it has worked fine for the last ages.|||

I've seen this error a few times. It has to do with one of the Visual Studio installs or service packs on the PC you are using to view the job properties. Applying SQL Server service pack 2 fixes the problem.

-Sue

|||

Also it may be issue with client tools on this machine, see whether you can reproduce from another machine with similar tools.

|||

Exact same scenario here. I was hoping for a nice clean fix but I guess this one is going to be painful.

|||What service pack of the tools do you have? Did it just start happening or is it an ongoing problem? Did anything change on the server or client?

|||It just started happening. I did install sp2 for sql but that was many weeks ago and it had been working fine. it was just a sudden thing. i was using it one morning and it was fine, and that afternoon it all went pear shaped.
|||Hmmm, nothing in the error log for the machine? And re-applying sp2 to the tools didn't fix it? (i.e. it wasn't a broken DLL somewhere)?

|||

I have the same problem:

SQL Server 2005 sp2 X64 clustered. There are no messages in any of the error logs. I did find this when I traced the server when I tired to view the properties of a job.

Cannot drop the table '#tmp_sp_db_vardecimal_storage_format', because it does not exist or you do not have permission.

I am a sysadmin. I just set this server up.

Thanks,

|||I reinstalled SQL Server SP 2 twice and it seemed to fix the problem Smile

|||

You need to reapply SP2. Just having SP2 installed doesn't mean it's protected from this issue. I've dealt with this one a few times - One of the dlls gets overwritten. I've seen it when SP2 was already installed and reapplying the service pack fixes the issue.

-Sue

|||

I had this same problem and I had to install SQL Server 2005 SP 2 twice and that seem to fix the problem.

Cannot view DB properties

Upgraded from SQL 2000 to SQL 2005. I am using Domain User with admin rights
to view the DB properties and its failing with "Property Owner is not
available for Database '[DB_name]'. This property may not exist for this
object, or may not be retrievable due to insufficient access rights.
(Microsoft.SqlServer.Smo)"
I was able to view the properties of the same database using same domain
user when we were in SQL 2000.
How to solve this issue? Any input is appreciated..
ThanksIT (IT@.discussions.microsoft.com) writes:
> Upgraded from SQL 2000 to SQL 2005. I am using Domain User with admin
> rights to view the DB properties and its failing with "Property Owner is
> not available for Database '[DB_name]'. This property may not exist fo
r
> this object, or may not be retrievable due to insufficient access
> rights. (Microsoft.SqlServer.Smo)"
> I was able to view the properties of the same database using same domain
> user when we were in SQL 2000.
> How to solve this issue? Any input is appreciated..
How did you upgrade? Did you upgrade the server in place, to did you
reattach the database?
It sounds as the latter. The SID for the database user, does not seem to
match any login on the server. Use
ALTER AUTHORIZATION ON DATABASE:db TO [domain\user]
and if necessary, create a login for the domain user first.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||I did In-Place Upgrade, I have like 20 databases and when I checked using
sp_helpdb for all databases, found NULL for 5 databases.
I followed the command
ALTER AUTHORIZATION ON DATABASE::database_name TO sa
Failed with:
Msg 15110, Level 16, State 1, Line 1
The proposed new database owner is already a user or aliased in the database
.
Any other workarounds? Is this a Bug...in SQL 2005...
"Erland Sommarskog" wrote:

> IT (IT@.discussions.microsoft.com) writes:
> How did you upgrade? Did you upgrade the server in place, to did you
> reattach the database?
> It sounds as the latter. The SID for the database user, does not seem to
> match any login on the server. Use
> ALTER AUTHORIZATION ON DATABASE:db TO [domain\user]
> and if necessary, create a login for the domain user first.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
>|||IT
Sorry, I don't understand , what do you mean by "In-Place Upgrade"?
I just did testing and it worked fine.
1) BACKUP DATABASE command on SQL Server 2000
2) RESTORE DATABASE command on SQL Server 2005
3) Drop user in the database after restoring
4) CREATE LOGIN on SQL Server 2005
5) CREATE USER in the database and mapped it to the new created LOGIN
If it does not help, please privide with steps you did so far.
"IT" <IT@.discussions.microsoft.com> wrote in message
news:A8BF2B36-4223-49A6-948B-E5097FC52082@.microsoft.com...[vbcol=seagreen]
>I did In-Place Upgrade, I have like 20 databases and when I checked using
> sp_helpdb for all databases, found NULL for 5 databases.
> I followed the command
> ALTER AUTHORIZATION ON DATABASE::database_name TO sa
> Failed with:
> Msg 15110, Level 16, State 1, Line 1
> The proposed new database owner is already a user or aliased in the
> database.
>
> Any other workarounds? Is this a Bug...in SQL 2005...
>
> "Erland Sommarskog" wrote:
>|||Here are the steps I followed:
# Ran the setup and upgraded the existing SQL Server 8.00.818 to SQL Server
2005.
# I have like 20 databases and only for 5 databases I noticed that database
owner was NULL after the UPgraded finished successfully.
# I checked that by using sp_helpdb...IN the OWNER filed found NULL for
those 5 databases.
# Ran sp_changedbowner 'sa' and it updated the OWNER to SA
# If I want to change the owner to any existing user in the database it
gives me
following error.
Msg 15110, Level 16, State 1, Line 1
The proposed new database owner is already a user or aliased in the
database.
I can only change the Owner to sa and for any other USER if throws me the
error I mentioned above.My question here is , Even though I upgraded the
existing instance of 2000 to 2005, why is that only for 5 databases I am
seeing this kind of behaviour.
Every thing was fine when it was in sql 2000.I was able to change the DB
Owner...
Thanks
"Uri Dimant" wrote:

> IT
> Sorry, I don't understand , what do you mean by "In-Place Upgrade"?
> I just did testing and it worked fine.
> 1) BACKUP DATABASE command on SQL Server 2000
> 2) RESTORE DATABASE command on SQL Server 2005
> 3) Drop user in the database after restoring
> 4) CREATE LOGIN on SQL Server 2005
> 5) CREATE USER in the database and mapped it to the new created LOGIN
>
> If it does not help, please privide with steps you did so far.
>
>
> "IT" <IT@.discussions.microsoft.com> wrote in message
> news:A8BF2B36-4223-49A6-948B-E5097FC52082@.microsoft.com...
>
>|||Sounds like a phantom user situation which is causing your error to be
thrown.
Check out http://sta.c64.org/sqlprg.html
And download http://sta.c64.org/sqlprg/fixusers.zip
Before you run the script be sure and read what it does.
Good luck to ya.
IT wrote:[vbcol=seagreen]
> Here are the steps I followed:
> # Ran the setup and upgraded the existing SQL Server 8.00.818 to SQL Serve
r
> 2005.
> # I have like 20 databases and only for 5 databases I noticed that databas
e
> owner was NULL after the UPgraded finished successfully.
> # I checked that by using sp_helpdb...IN the OWNER filed found NULL for
> those 5 databases.
> # Ran sp_changedbowner 'sa' and it updated the OWNER to SA
> # If I want to change the owner to any existing user in the database it
> gives me
> following error.
> Msg 15110, Level 16, State 1, Line 1
> The proposed new database owner is already a user or aliased in the
> database.
> I can only change the Owner to sa and for any other USER if throws me the
> error I mentioned above.My question here is , Even though I upgraded the
> existing instance of 2000 to 2005, why is that only for 5 databases I am
> seeing this kind of behaviour.
> Every thing was fine when it was in sql 2000.I was able to change the DB
> Owner...
>
> Thanks
> "Uri Dimant" wrote:
>|||The users in the databases have respective logins on the server. There are n
o
orphaned users on the database. The issue is we cannot change the DB owner t
o
the existing users in the database except for SA.
"jebuskrust@.gmail.com" wrote:

> Sounds like a phantom user situation which is causing your error to be
> thrown.
> Check out http://sta.c64.org/sqlprg.html
> And download http://sta.c64.org/sqlprg/fixusers.zip
> Before you run the script be sure and read what it does.
> Good luck to ya.
>
> IT wrote:
>|||IT (IT@.discussions.microsoft.com) writes:
> The users in the databases have respective logins on the server. There
> are no orphaned users on the database. The issue is we cannot change the
> DB owner to the existing users in the database except for SA.
That is not possible on SQL 2000 either.
The login that owns the database always maps to the dbo user. If the login
already maps to a user in the database, the login can't become the database
owner, because he would then map to two users.
Thus you need to explicitly drop the users that you want to own the
databases.
I can't answer why you only got a problem with 5 of 20 databases. The
answer for that may be hidden in their previous history.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Cannot View Database Properties (Express 2005)

It's always great to run into problems on a Friday afternoon before a
holiday weekend, but here I am.
I'm not sure when this started happening, but if I try to get
properties on any of the databases on my SQL Server Express 2005 server
(using the Management Studio GUI), it fails with the following error:
--
TITLE: Microsoft SQL Server Management Studio Express
Cannot show requested dialog.
ADDITIONAL INFORMATION:
Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
An exception occurred while executing a Transact-SQL statement or
batch. (Microsoft.SqlServer.Express.ConnectionInfo)
Invalid object name 'master.dbo.spt_values'. (Microsoft SQL Server,
Error: 208)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=208&LinkId=20476
--
The help link, while not the slightest bit helpful, is at least polite
and apologetic:
--
We're sorry
There is no additional information about this issue in the Error and
Event Log Messages or Knowledge Base databases at this time. You can
use the links in the Support area to determine whether any additional
information might be available elsewhere.
--
Anyone have any clue what's going on? Where oh where is my spt_values
table?
Thanks very much,
-DanIt looks like this system table was accidentally deleted. Spt_values is a
strange beast because it's has type 'U' instead of the normal 'S' like most
system tables.
You'll need to restore or rebuild master from backup to get it back. I'm
not sure exactly what impact this missing table might have on a 2005
instance but it's probably better to fix it sooner than later.
--
Happy Holidays
Dan Guzman
SQL Server MVP
"Daniel Manes" <danthman@.cox.net> wrote in message
news:1166832805.577147.242380@.h40g2000cwb.googlegroups.com...
> It's always great to run into problems on a Friday afternoon before a
> holiday weekend, but here I am.
> I'm not sure when this started happening, but if I try to get
> properties on any of the databases on my SQL Server Express 2005 server
> (using the Management Studio GUI), it fails with the following error:
> --
> TITLE: Microsoft SQL Server Management Studio Express
> Cannot show requested dialog.
> ADDITIONAL INFORMATION:
> Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
> An exception occurred while executing a Transact-SQL statement or
> batch. (Microsoft.SqlServer.Express.ConnectionInfo)
> Invalid object name 'master.dbo.spt_values'. (Microsoft SQL Server,
> Error: 208)
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.2047&EvtSrc=MSSQLServer&EvtID=208&LinkId=20476
> --
> The help link, while not the slightest bit helpful, is at least polite
> and apologetic:
> --
> We're sorry
> There is no additional information about this issue in the Error and
> Event Log Messages or Knowledge Base databases at this time. You can
> use the links in the Support area to determine whether any additional
> information might be available elsewhere.
> --
> Anyone have any clue what's going on? Where oh where is my spt_values
> table?
> Thanks very much,
> -Dan
>

Cannot view database properties

Hello all....

I am in the process of changing all of the collation to SQL_Latin1_General_CP1_CI_AS.

I have backed up all databases, and uninstalled SQL Server 2005. I then reinstalled SQL Server 2005, setting the server collation to SQL_Latin1_General_CP1_CI_AS.

The user databases have been restored and are accessible by all applications.

If I try to view the properties of any database (system or user), I get the following error:

*********************************************************************************************************************************

TITLE: Microsoft SQL Server Management Studio

Cannot show requested dialog.


ADDITIONAL INFORMATION:

Cannot show requested dialog. (SqlMgmt)

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation. (Microsoft SQL Server, Error: 468)

****************************************************************************************************************************************

I have tried executing the "Alter Database [dbname] Collate SQL_Latin1_General_CP1_CI_AS" procedure, but that does seem to help. Does anyone have any ideas?

Thanks,

Forch

What is the collation or all the databases?

run select * from sys.databases.

How did you restore the databases, backup/restore, attach/dettach?

|||

Master is SQL_Latin1_General_CP_C1_AS, and the rest of the system dbs is Latin1_General_CI_AI. The user dbs are evenly divided between the 2.

I can't remember how I restored.... it was probably backup / restore.

Thanks,

Forch

|||

Hi Forch,

Probably the backed up databases have the old collation, but the SQL server system databases have the new collation.

You can do:

ALTER RESTORED_DATABASE { COLLATE SQL_Latin1_General_CP1_CI_AScollation_name }

to change the collation of the restored databases to the new collation

Cheers

|||Have you tried to access the database from the query analyzer too?

Cannot view database properties

Hello all....

I am in the process of changing all of the collation to SQL_Latin1_General_CP1_CI_AS.

I have backed up all databases, and uninstalled SQL Server 2005. I then reinstalled SQL Server 2005, setting the server collation to SQL_Latin1_General_CP1_CI_AS.

The user databases have been restored and are accessible by all applications.

If I try to view the properties of any database (system or user), I get the following error:

*********************************************************************************************************************************

TITLE: Microsoft SQL Server Management Studio

Cannot show requested dialog.


ADDITIONAL INFORMATION:

Cannot show requested dialog. (SqlMgmt)

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AI" in the equal to operation. (Microsoft SQL Server, Error: 468)

****************************************************************************************************************************************

I have tried executing the "Alter Database [dbname] Collate SQL_Latin1_General_CP1_CI_AS" procedure, but that does seem to help. Does anyone have any ideas?

Thanks,

Forch

What is the collation or all the databases?

run select * from sys.databases.

How did you restore the databases, backup/restore, attach/dettach?

|||

Master is SQL_Latin1_General_CP_C1_AS, and the rest of the system dbs is Latin1_General_CI_AI. The user dbs are evenly divided between the 2.

I can't remember how I restored.... it was probably backup / restore.

Thanks,

Forch

|||

Hi Forch,

Probably the backed up databases have the old collation, but the SQL server system databases have the new collation.

You can do:

ALTER RESTORED_DATABASE { COLLATE SQL_Latin1_General_CP1_CI_AScollation_name }

to change the collation of the restored databases to the new collation

Cheers

|||Have you tried to access the database from the query analyzer too?

Wednesday, March 7, 2012

cannot start trace

After going through all the configurations in Trace Properties, I clicked
Run, then I got this error back:
Failed to start a trace. SQL server does not exist or access denied.
The user I'm connecting to the server has full privileges on the databases.
Where should I check?
Thanks for any help,
Bingbing wrote:
> After going through all the configurations in Trace Properties, I
> clicked Run, then I got this error back:
> Failed to start a trace. SQL server does not exist or access denied.
> The user I'm connecting to the server has full privileges on the
> databases. Where should I check?
> Thanks for any help,
> Bing
You're not even getting to the server. Either the server name is
mistyped or your login name/password is incorrect.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Oh? In SQL Profiler, clicking File->New->Trace, then a window with title
'Connect to Server' pops up, in this window, SQL Server is set to local,
Connecting using Windows authentication. Clicking Ok in this window brings
up another window Trace Properties.
I think at this point I've already connected to the server fine. No?
Anyway, I tried changing server name from local to its hostname, it worked.
Odd, I was doing all this on the database server, how doesn't 'local' work?
Bing
"David Gugick" wrote:
> bing wrote:
> > After going through all the configurations in Trace Properties, I
> > clicked Run, then I got this error back:
> >
> > Failed to start a trace. SQL server does not exist or access denied.
> >
> > The user I'm connecting to the server has full privileges on the
> > databases. Where should I check?
> >
> > Thanks for any help,
> >
> > Bing
> You're not even getting to the server. Either the server name is
> mistyped or your login name/password is incorrect.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>|||bing wrote:
> Oh? In SQL Profiler, clicking File->New->Trace, then a window with
> title 'Connect to Server' pops up, in this window, SQL Server is set
> to local, Connecting using Windows authentication. Clicking Ok in
> this window brings up another window Trace Properties.
> I think at this point I've already connected to the server fine. No?
> Anyway, I tried changing server name from local to its hostname, it
> worked. Odd, I was doing all this on the database server, how doesn't
> 'local' work?
"(local)" not "local". I prefer using the real server name just as you
ended up doing. I'm not exacly sure what the problem was. The error
message you posted indicated you never made it to the server (my
username/pwd comment aside). But if what you're saying is you get past
the login screen, then you are in fact logging in successfully to the
server. It's just that at that point the trace has not started. You have
only verified with Profiler that you have a valid admin login to the
server. Just stick with the real server name and you should be fine.
--
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Sorry about not being precise. It's my typo. Yes, it is '(local)' rather
than 'local'.
Bing
"David Gugick" wrote:
> bing wrote:
> > Oh? In SQL Profiler, clicking File->New->Trace, then a window with
> > title 'Connect to Server' pops up, in this window, SQL Server is set
> > to local, Connecting using Windows authentication. Clicking Ok in
> > this window brings up another window Trace Properties.
> >
> > I think at this point I've already connected to the server fine. No?
> >
> > Anyway, I tried changing server name from local to its hostname, it
> > worked. Odd, I was doing all this on the database server, how doesn't
> > 'local' work?
> "(local)" not "local". I prefer using the real server name just as you
> ended up doing. I'm not exacly sure what the problem was. The error
> message you posted indicated you never made it to the server (my
> username/pwd comment aside). But if what you're saying is you get past
> the login screen, then you are in fact logging in successfully to the
> server. It's just that at that point the trace has not started. You have
> only verified with Profiler that you have a valid admin login to the
> server. Just stick with the real server name and you should be fine.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>

cannot start trace

After going through all the configurations in Trace Properties, I clicked
Run, then I got this error back:
Failed to start a trace. SQL server does not exist or access denied.
The user I'm connecting to the server has full privileges on the databases.
Where should I check?
Thanks for any help,
Bing
bing wrote:
> After going through all the configurations in Trace Properties, I
> clicked Run, then I got this error back:
> Failed to start a trace. SQL server does not exist or access denied.
> The user I'm connecting to the server has full privileges on the
> databases. Where should I check?
> Thanks for any help,
> Bing
You're not even getting to the server. Either the server name is
mistyped or your login name/password is incorrect.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Oh? In SQL Profiler, clicking File->New->Trace, then a window with title
'Connect to Server' pops up, in this window, SQL Server is set to local,
Connecting using Windows authentication. Clicking Ok in this window brings
up another window Trace Properties.
I think at this point I've already connected to the server fine. No?
Anyway, I tried changing server name from local to its hostname, it worked.
Odd, I was doing all this on the database server, how doesn't 'local' work?
Bing
"David Gugick" wrote:

> bing wrote:
> You're not even getting to the server. Either the server name is
> mistyped or your login name/password is incorrect.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>
|||bing wrote:
> Oh? In SQL Profiler, clicking File->New->Trace, then a window with
> title 'Connect to Server' pops up, in this window, SQL Server is set
> to local, Connecting using Windows authentication. Clicking Ok in
> this window brings up another window Trace Properties.
> I think at this point I've already connected to the server fine. No?
> Anyway, I tried changing server name from local to its hostname, it
> worked. Odd, I was doing all this on the database server, how doesn't
> 'local' work?
"(local)" not "local". I prefer using the real server name just as you
ended up doing. I'm not exacly sure what the problem was. The error
message you posted indicated you never made it to the server (my
username/pwd comment aside). But if what you're saying is you get past
the login screen, then you are in fact logging in successfully to the
server. It's just that at that point the trace has not started. You have
only verified with Profiler that you have a valid admin login to the
server. Just stick with the real server name and you should be fine.
David Gugick
Quest Software
www.imceda.com
www.quest.com
|||Sorry about not being precise. It's my typo. Yes, it is '(local)' rather
than 'local'.
Bing
"David Gugick" wrote:

> bing wrote:
> "(local)" not "local". I prefer using the real server name just as you
> ended up doing. I'm not exacly sure what the problem was. The error
> message you posted indicated you never made it to the server (my
> username/pwd comment aside). But if what you're saying is you get past
> the login screen, then you are in fact logging in successfully to the
> server. It's just that at that point the trace has not started. You have
> only verified with Profiler that you have a valid admin login to the
> server. Just stick with the real server name and you should be fine.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>

cannot start trace

After going through all the configurations in Trace Properties, I clicked
Run, then I got this error back:
Failed to start a trace. SQL server does not exist or access denied.
The user I'm connecting to the server has full privileges on the databases.
Where should I check?
Thanks for any help,
Bingbing wrote:
> After going through all the configurations in Trace Properties, I
> clicked Run, then I got this error back:
> Failed to start a trace. SQL server does not exist or access denied.
> The user I'm connecting to the server has full privileges on the
> databases. Where should I check?
> Thanks for any help,
> Bing
You're not even getting to the server. Either the server name is
mistyped or your login name/password is incorrect.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Oh? In SQL Profiler, clicking File->New->Trace, then a window with title
'Connect to Server' pops up, in this window, SQL Server is set to local,
Connecting using Windows authentication. Clicking Ok in this window brings
up another window Trace Properties.
I think at this point I've already connected to the server fine. No?
Anyway, I tried changing server name from local to its hostname, it worked.
Odd, I was doing all this on the database server, how doesn't 'local' work?
Bing
"David Gugick" wrote:

> bing wrote:
> You're not even getting to the server. Either the server name is
> mistyped or your login name/password is incorrect.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>|||bing wrote:
> Oh? In SQL Profiler, clicking File->New->Trace, then a window with
> title 'Connect to Server' pops up, in this window, SQL Server is set
> to local, Connecting using Windows authentication. Clicking Ok in
> this window brings up another window Trace Properties.
> I think at this point I've already connected to the server fine. No?
> Anyway, I tried changing server name from local to its hostname, it
> worked. Odd, I was doing all this on the database server, how doesn't
> 'local' work?
"(local)" not "local". I prefer using the real server name just as you
ended up doing. I'm not exacly sure what the problem was. The error
message you posted indicated you never made it to the server (my
username/pwd comment aside). But if what you're saying is you get past
the login screen, then you are in fact logging in successfully to the
server. It's just that at that point the trace has not started. You have
only verified with Profiler that you have a valid admin login to the
server. Just stick with the real server name and you should be fine.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Sorry about not being precise. It's my typo. Yes, it is '(local)' rather
than 'local'.
Bing
"David Gugick" wrote:

> bing wrote:
> "(local)" not "local". I prefer using the real server name just as you
> ended up doing. I'm not exacly sure what the problem was. The error
> message you posted indicated you never made it to the server (my
> username/pwd comment aside). But if what you're saying is you get past
> the login screen, then you are in fact logging in successfully to the
> server. It's just that at that point the trace has not started. You have
> only verified with Profiler that you have a valid admin login to the
> server. Just stick with the real server name and you should be fine.
> --
> David Gugick
> Quest Software
> www.imceda.com
> www.quest.com
>