Showing posts with label box. Show all posts
Showing posts with label box. Show all posts

Thursday, March 29, 2012

Can't connect from a vista client to SQL 2005 box,other machines work fine

Hey. I've a windows vista machine which can't connect to SQL 2005 box. Other machines which are lower than vista work fine. Also, vista box can connect to other SQL 2005 instances but can't connect to only one instance. But, I can connect to the instance fine from my XP box. Also, it's not a permissions issue. This user is an SA and can connect form some other machine. SQL 2005 box is at 2047 version right now. And, the user is able to connect to some other boxes which are also at 2047. Please help. Thank you

Add the account sepcifically to the SQL Server. When you connect from Vista (because of the UAC) it strips out your group SID from local admins, so SQL Server doesn't know who you are, and that's probably what is causing your issue. Add the user's account by name to the box.

If this post answers your question, make sure you mark it "answered" so others can find it quickly.

Thanks -

Buck Woody
http://www.buckwoody.com

Cant Connect - SQL Server does not exist

Hi
We recently had a SQL Server 2K, Win2K box crash on us, and we had to
reinstall Windows.
Sql Server was also damaged (I think the registry got corrupted), and
so I reinstalled that too (couldnt start the Services). The server is
now up and running, but from any other computers (such as my desktop)
I can't connect to the server. If I open QA, for example, I can locate
the server name using the ... button (so it's there), but when I put
in a UID & PWD I get the "SQL Server does not exist or access denied"
error.
If I start QA on the server itself, though, and connect using the same
UID & PWD, there's no problem.
any ideas?
Thanks
SeanEnsure that both the server and client share a network protocol in common.
Try to ping the server name and IP from the client to ensure connectivity.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sean" <plugwalsh@.yahoo.com> wrote in message
news:3698af3c.0408100316.2596d560@.posting.google.com...
> Hi
> We recently had a SQL Server 2K, Win2K box crash on us, and we had to
> reinstall Windows.
> Sql Server was also damaged (I think the registry got corrupted), and
> so I reinstalled that too (couldnt start the Services). The server is
> now up and running, but from any other computers (such as my desktop)
> I can't connect to the server. If I open QA, for example, I can locate
> the server name using the ... button (so it's there), but when I put
> in a UID & PWD I get the "SQL Server does not exist or access denied"
> error.
> If I start QA on the server itself, though, and connect using the same
> UID & PWD, there's no problem.
> any ideas?
> Thanks
> Sean|||Sorry - had the wrong IP in the hosts file... doh!
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message news:<uIsqD7sfEHA.396@.
TK2MSFTNGP12.phx.gbl>...[vbcol=seagreen]
> Ensure that both the server and client share a network protocol in common.
> Try to ping the server name and IP from the client to ensure connectivity.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Sean" <plugwalsh@.yahoo.com> wrote in message
> news:3698af3c.0408100316.2596d560@.posting.google.com...

Cant Connect - SQL Server does not exist

Hi
We recently had a SQL Server 2K, Win2K box crash on us, and we had to
reinstall Windows.
Sql Server was also damaged (I think the registry got corrupted), and
so I reinstalled that too (couldnt start the Services). The server is
now up and running, but from any other computers (such as my desktop)
I can't connect to the server. If I open QA, for example, I can locate
the server name using the ... button (so it's there), but when I put
in a UID & PWD I get the "SQL Server does not exist or access denied"
error.
If I start QA on the server itself, though, and connect using the same
UID & PWD, there's no problem.
any ideas?
Thanks
Sean
Ensure that both the server and client share a network protocol in common.
Try to ping the server name and IP from the client to ensure connectivity.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sean" <plugwalsh@.yahoo.com> wrote in message
news:3698af3c.0408100316.2596d560@.posting.google.c om...
> Hi
> We recently had a SQL Server 2K, Win2K box crash on us, and we had to
> reinstall Windows.
> Sql Server was also damaged (I think the registry got corrupted), and
> so I reinstalled that too (couldnt start the Services). The server is
> now up and running, but from any other computers (such as my desktop)
> I can't connect to the server. If I open QA, for example, I can locate
> the server name using the ... button (so it's there), but when I put
> in a UID & PWD I get the "SQL Server does not exist or access denied"
> error.
> If I start QA on the server itself, though, and connect using the same
> UID & PWD, there's no problem.
> any ideas?
> Thanks
> Sean
|||Sorry - had the wrong IP in the hosts file... doh!
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message news:<uIsqD7sfEHA.396@.TK2MSFTNGP12.phx.gbl>...[vbcol=seagreen]
> Ensure that both the server and client share a network protocol in common.
> Try to ping the server name and IP from the client to ensure connectivity.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Sean" <plugwalsh@.yahoo.com> wrote in message
> news:3698af3c.0408100316.2596d560@.posting.google.c om...

Cant Connect - SQL Server does not exist

Hi
We recently had a SQL Server 2K, Win2K box crash on us, and we had to
reinstall Windows.
Sql Server was also damaged (I think the registry got corrupted), and
so I reinstalled that too (couldnt start the Services). The server is
now up and running, but from any other computers (such as my desktop)
I can't connect to the server. If I open QA, for example, I can locate
the server name using the ... button (so it's there), but when I put
in a UID & PWD I get the "SQL Server does not exist or access denied"
error.
If I start QA on the server itself, though, and connect using the same
UID & PWD, there's no problem.
any ideas?
Thanks
SeanEnsure that both the server and client share a network protocol in common.
Try to ping the server name and IP from the client to ensure connectivity.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Sean" <plugwalsh@.yahoo.com> wrote in message
news:3698af3c.0408100316.2596d560@.posting.google.com...
> Hi
> We recently had a SQL Server 2K, Win2K box crash on us, and we had to
> reinstall Windows.
> Sql Server was also damaged (I think the registry got corrupted), and
> so I reinstalled that too (couldnt start the Services). The server is
> now up and running, but from any other computers (such as my desktop)
> I can't connect to the server. If I open QA, for example, I can locate
> the server name using the ... button (so it's there), but when I put
> in a UID & PWD I get the "SQL Server does not exist or access denied"
> error.
> If I start QA on the server itself, though, and connect using the same
> UID & PWD, there's no problem.
> any ideas?
> Thanks
> Sean|||Sorry - had the wrong IP in the hosts file... doh!
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message news:<uIsqD7sfEHA.396@.TK2MSFTNGP12.phx.gbl>...
> Ensure that both the server and client share a network protocol in common.
> Try to ping the server name and IP from the client to ensure connectivity.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Sean" <plugwalsh@.yahoo.com> wrote in message
> news:3698af3c.0408100316.2596d560@.posting.google.com...
> > Hi
> >
> > We recently had a SQL Server 2K, Win2K box crash on us, and we had to
> > reinstall Windows.
> >
> > Sql Server was also damaged (I think the registry got corrupted), and
> > so I reinstalled that too (couldnt start the Services). The server is
> > now up and running, but from any other computers (such as my desktop)
> > I can't connect to the server. If I open QA, for example, I can locate
> > the server name using the ... button (so it's there), but when I put
> > in a UID & PWD I get the "SQL Server does not exist or access denied"
> > error.
> >
> > If I start QA on the server itself, though, and connect using the same
> > UID & PWD, there's no problem.
> >
> > any ideas?
> > Thanks
> > Sean

Can't Connect

I can't connect to this new box via sql server 2000, every time I try to
register sql server to this new server, I get this message:" SQL Server does
not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
running on the new box when I connect via remote access to the box. How can
I connect? They also created a DNS, but still can't connect via sql server.
Thanks.
--
New SQL Server DBAWhat account or login are you using when you try to register sql? I'm
guessing you are trying to register the new SQL server to your Enterprise
Manager?
JD
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:910795E9-3EB7-4DD2-89D3-E2FBA95100E4@.microsoft.com...
>I can't connect to this new box via sql server 2000, every time I try to
> register sql server to this new server, I get this message:" SQL Server
> does
> not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
> running on the new box when I connect via remote access to the box. How
> can
> I connect? They also created a DNS, but still can't connect via sql
> server.
> Thanks.
> --
> New SQL Server DBA|||I am using the sa account. Yes i am using EM. Thanks.
--
New SQL Server DBA
"Joe D" wrote:

> What account or login are you using when you try to register sql? I'm
> guessing you are trying to register the new SQL server to your Enterprise
> Manager?
> JD
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:910795E9-3EB7-4DD2-89D3-E2FBA95100E4@.microsoft.com...
>
>

Can't Connect

I can't connect to this new box via sql server 2000, every time I try to
register sql server to this new server, I get this message:" SQL Server does
not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
running on the new box when I connect via remote access to the box. How can
I connect? They also created a DNS, but still can't connect via sql server.
Thanks.
New SQL Server DBA
What account or login are you using when you try to register sql? I'm
guessing you are trying to register the new SQL server to your Enterprise
Manager?
JD
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:910795E9-3EB7-4DD2-89D3-E2FBA95100E4@.microsoft.com...
>I can't connect to this new box via sql server 2000, every time I try to
> register sql server to this new server, I get this message:" SQL Server
> does
> not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
> running on the new box when I connect via remote access to the box. How
> can
> I connect? They also created a DNS, but still can't connect via sql
> server.
> Thanks.
> --
> New SQL Server DBA
|||I am using the sa account. Yes i am using EM. Thanks.
New SQL Server DBA
"Joe D" wrote:

> What account or login are you using when you try to register sql? I'm
> guessing you are trying to register the new SQL server to your Enterprise
> Manager?
> JD
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:910795E9-3EB7-4DD2-89D3-E2FBA95100E4@.microsoft.com...
>
>

Can't Connect

I can't connect to this new box via sql server 2000, every time I try to
register sql server to this new server, I get this message:" SQL Server does
not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
running on the new box when I connect via remote access to the box. How can
I connect? They also created a DNS, but still can't connect via sql server.
Thanks.
--
New SQL Server DBAWhat account or login are you using when you try to register sql? I'm
guessing you are trying to register the new SQL server to your Enterprise
Manager?
JD
"Newbie" <Newbie@.discussions.microsoft.com> wrote in message
news:910795E9-3EB7-4DD2-89D3-E2FBA95100E4@.microsoft.com...
>I can't connect to this new box via sql server 2000, every time I try to
> register sql server to this new server, I get this message:" SQL Server
> does
> not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
> running on the new box when I connect via remote access to the box. How
> can
> I connect? They also created a DNS, but still can't connect via sql
> server.
> Thanks.
> --
> New SQL Server DBA|||I am using the sa account. Yes i am using EM. Thanks.
--
New SQL Server DBA
"Joe D" wrote:
> What account or login are you using when you try to register sql? I'm
> guessing you are trying to register the new SQL server to your Enterprise
> Manager?
> JD
>
> "Newbie" <Newbie@.discussions.microsoft.com> wrote in message
> news:910795E9-3EB7-4DD2-89D3-E2FBA95100E4@.microsoft.com...
> >I can't connect to this new box via sql server 2000, every time I try to
> > register sql server to this new server, I get this message:" SQL Server
> > does
> > not exist or access denied. ConnectionOpen. Connect. " SQL Server 2000 is
> > running on the new box when I connect via remote access to the box. How
> > can
> > I connect? They also created a DNS, but still can't connect via sql
> > server.
> > Thanks.
> > --
> > New SQL Server DBA
>
>

Tuesday, March 20, 2012

can't access server - lost sa password

We have what we think is msde running on a box. No one knows the sa password.
I am in the domain admin group on Windows and the Windows admin group but
when I right click on BUILTIN\administrator, I don't get the "properties"
menu selection. I also can't create a new login.
A few weeks ago I was able to create a new login and a new database. I'm not
sure what happened. My windows login is not there anymore but I would have
thought I could use the BUILTIN\administrator login to admin the server.
Any ideas on how I can get control of the server?
Thanks,
Dan D.
Although I hate tools like these but try this tool if it works for you ...
http://www.nextgenss.com/sqlcrack.htm
Harman Sahni
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:E449D233-29E8-4ED0-AC95-2B4BF0FDC6D3@.microsoft.com...
> We have what we think is msde running on a box. No one knows the sa
password.
> I am in the domain admin group on Windows and the Windows admin group but
> when I right click on BUILTIN\administrator, I don't get the "properties"
> menu selection. I also can't create a new login.
> A few weeks ago I was able to create a new login and a new database. I'm
not
> sure what happened. My windows login is not there anymore but I would have
> thought I could use the BUILTIN\administrator login to admin the server.
> Any ideas on how I can get control of the server?
> Thanks,
> --
> Dan D.
|||Thanks but I figured out the sa password. I'll keep this for future reference.
"Harman Sahni" wrote:

> Although I hate tools like these but try this tool if it works for you ...
> http://www.nextgenss.com/sqlcrack.htm
> Harman Sahni
>
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:E449D233-29E8-4ED0-AC95-2B4BF0FDC6D3@.microsoft.com...
> password.
> not
>
>
|||Dan
Log in SQL Server with Windows Authentication and run EXEC sp_password NULL,
'NewPass', 'MyUser
'
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:2264F204-A7B6-422A-95AC-0517B560C27C@.microsoft.com...
> Thanks but I figured out the sa password. I'll keep this for future
reference.[vbcol=seagreen]
> "Harman Sahni" wrote:
...[vbcol=seagreen]
but[vbcol=seagreen]
"properties"[vbcol=seagreen]
I'm[vbcol=seagreen]
have[vbcol=seagreen]
server.[vbcol=seagreen]

Can't access an instance installed on same server

About 2 months ago I loaded a new instance on my SQL Server 200 box. I have
been working with the database in that instance. However, now I try to
access the other instance on the server and I get connection failed check
server registration properties. When I check them I get "login failed." I
switch the registration back to SQL and windows - same issue. All services
are running on server and users are able to get to database.
I checked whitepapers and KB but can't find what to do. Any assistance is
greatly appreciated.
Hi
If you login is failing how can your "users are able to get to database"?
If you can access the server using the given login though query analyser
(from the failing client), then check the connection string and check the
network libraries/protocols.
John
"Multitasker" wrote:

> About 2 months ago I loaded a new instance on my SQL Server 200 box. I have
> been working with the database in that instance. However, now I try to
> access the other instance on the server and I get connection failed check
> server registration properties. When I check them I get "login failed." I
> switch the registration back to SQL and windows - same issue. All services
> are running on server and users are able to get to database.
> I checked whitepapers and KB but can't find what to do. Any assistance is
> greatly appreciated.
sql

Can't access an instance installed on same server

About 2 months ago I loaded a new instance on my SQL Server 200 box. I have
been working with the database in that instance. However, now I try to
access the other instance on the server and I get connection failed check
server registration properties. When I check them I get "login failed." I
switch the registration back to SQL and windows - same issue. All services
are running on server and users are able to get to database.
I checked whitepapers and KB but can't find what to do. Any assistance is
greatly appreciated.Hi
If you login is failing how can your "users are able to get to database"?
If you can access the server using the given login though query analyser
(from the failing client), then check the connection string and check the
network libraries/protocols.
John
"Multitasker" wrote:

> About 2 months ago I loaded a new instance on my SQL Server 200 box. I hav
e
> been working with the database in that instance. However, now I try to
> access the other instance on the server and I get connection failed check
> server registration properties. When I check them I get "login failed." I
> switch the registration back to SQL and windows - same issue. All services
> are running on server and users are able to get to database.
> I checked whitepapers and KB but can't find what to do. Any assistance is
> greatly appreciated.

Can't access an instance installed on same server

About 2 months ago I loaded a new instance on my SQL Server 200 box. I have
been working with the database in that instance. However, now I try to
access the other instance on the server and I get connection failed check
server registration properties. When I check them I get "login failed." I
switch the registration back to SQL and windows - same issue. All services
are running on server and users are able to get to database.
I checked whitepapers and KB but can't find what to do. Any assistance is
greatly appreciated.Hi
If you login is failing how can your "users are able to get to database"?
If you can access the server using the given login though query analyser
(from the failing client), then check the connection string and check the
network libraries/protocols.
John
"Multitasker" wrote:
> About 2 months ago I loaded a new instance on my SQL Server 200 box. I have
> been working with the database in that instance. However, now I try to
> access the other instance on the server and I get connection failed check
> server registration properties. When I check them I get "login failed." I
> switch the registration back to SQL and windows - same issue. All services
> are running on server and users are able to get to database.
> I checked whitepapers and KB but can't find what to do. Any assistance is
> greatly appreciated.

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.

Thursday, March 8, 2012

cannot upload reports: pls help

Hi,
I just installed reporting service on a new box and it contains SQL server
2000 also. But, when I get into the manager screen, the options such as New
folder, Upload files etc are all disabled. The hyperlink appears but nothing
happens when i click on them..
Any suggestions?
Thanks in advance for your help.
-sDid you ever figure this out? I too have the same problem.
Thanks.
"San" wrote:
> Hi,
> I just installed reporting service on a new box and it contains SQL server
> 2000 also. But, when I get into the manager screen, the options such as New
> folder, Upload files etc are all disabled. The hyperlink appears but nothing
> happens when i click on them..
> Any suggestions?
> Thanks in advance for your help.
> -s
>
>

Wednesday, March 7, 2012

Cannot subscribe via email

When I go to the subscription page, in the delivered by drop down box, i only get "File Share" as an option. Is there a setting on the report server configuration file that is making the "Email Delivery" option not viewable?

Thanks.

silly question, but did you specify an email server (smtp)?

Also, what version are you using (2000, 2005)?

|||

That is correct, RS will only display the extensions which are configured and ready to use. In order to use the email extension, you need to provide a SMTP server name at least - via the RS configuration tool in RS 2005 or manually editing RsReportServer.config in RS 2000.

Thanks

Tudor

Cannot start up local server

Recently I cannot start up my local SQL 2000.
I goto services panel, select MSSQLSEREVR, right click select 'Start', got
a message box:
"The MSSQKSERVER service on Local Computer started and then stopped. Some
services stop automatically if they have no work to do, for example, the
Performance Logs and Alerts server"
I tried to start 'Performance Logs and Alerts server' and still get the same
message box.Alan
Any errors in Event Viewer
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> Recently I cannot start up my local SQL 2000.
> I goto services panel, select MSSQLSEREVR, right click select 'Start',
> got a message box:
> "The MSSQKSERVER service on Local Computer started and then stopped. Some
> services stop automatically if they have no work to do, for example, the
> Performance Logs and Alerts server"
> I tried to start 'Performance Logs and Alerts server' and still get the
> same message box.
>|||Uri Dimant wrote:
> Alan
> Any errors in Event Viewer
>
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> > Recently I cannot start up my local SQL 2000.
> > I goto services panel, select MSSQLSEREVR, right click select 'Start',
> > got a message box:
> > "The MSSQKSERVER service on Local Computer started and then stopped. Some
> > services stop automatically if they have no work to do, for example, the
> > Performance Logs and Alerts server"
> >
> > I tried to start 'Performance Logs and Alerts server' and still get the
> > same message box.
> >
Try to find out errors in Event Viewer or SQL Server Errorlog.
Regards
Amish Shah
http://shahamishm.tripod.com|||Sorry, how do I open the EventViewer ?
"amish" <shahamishm@.gmail.com> wrote in message
news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
> Uri Dimant wrote:
>> Alan
>> Any errors in Event Viewer
>>
>>
>> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
>> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
>> > Recently I cannot start up my local SQL 2000.
>> > I goto services panel, select MSSQLSEREVR, right click select 'Start',
>> > got a message box:
>> > "The MSSQKSERVER service on Local Computer started and then stopped.
>> > Some
>> > services stop automatically if they have no work to do, for example,
>> > the
>> > Performance Logs and Alerts server"
>> >
>> > I tried to start 'Performance Logs and Alerts server' and still get the
>> > same message box.
>> >
> Try to find out errors in Event Viewer or SQL Server Errorlog.
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>|||Alan T wrote:
> Sorry, how do I open the EventViewer ?
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
> >
> > Uri Dimant wrote:
> >
> >> Alan
> >>
> >> Any errors in Event Viewer
> >>
> >>
> >>
> >>
> >> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> >> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> >> > Recently I cannot start up my local SQL 2000.
> >> > I goto services panel, select MSSQLSEREVR, right click select 'Start',
> >> > got a message box:
> >> > "The MSSQKSERVER service on Local Computer started and then stopped.
> >> > Some
> >> > services stop automatically if they have no work to do, for example,
> >> > the
> >> > Performance Logs and Alerts server"
> >> >
> >> > I tried to start 'Performance Logs and Alerts server' and still get the
> >> > same message box.
> >> >
> >
> > Try to find out errors in Event Viewer or SQL Server Errorlog.
> >
> > Regards
> > Amish Shah
> > http://shahamishm.tripod.com
> >
go to start--> run
type eventvwr
Regards
Amish Shah
http://shahamishm.tripod.com|||Hi,
Yes I opened the eventviewer and knowing my evaluation copy of SQL 2000
Enterprise has expired.
Can I install the SQL 2000 Developer Edition on the top of it?
"amish" <shahamishm@.gmail.com> wrote in message
news:1161240339.590000.279530@.m7g2000cwm.googlegroups.com...
> Alan T wrote:
>> Sorry, how do I open the EventViewer ?
>> "amish" <shahamishm@.gmail.com> wrote in message
>> news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
>> >
>> > Uri Dimant wrote:
>> >
>> >> Alan
>> >>
>> >> Any errors in Event Viewer
>> >>
>> >>
>> >>
>> >>
>> >> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
>> >> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
>> >> > Recently I cannot start up my local SQL 2000.
>> >> > I goto services panel, select MSSQLSEREVR, right click select
>> >> > 'Start',
>> >> > got a message box:
>> >> > "The MSSQKSERVER service on Local Computer started and then stopped.
>> >> > Some
>> >> > services stop automatically if they have no work to do, for example,
>> >> > the
>> >> > Performance Logs and Alerts server"
>> >> >
>> >> > I tried to start 'Performance Logs and Alerts server' and still get
>> >> > the
>> >> > same message box.
>> >> >
>> >
>> > Try to find out errors in Event Viewer or SQL Server Errorlog.
>> >
>> > Regards
>> > Amish Shah
>> > http://shahamishm.tripod.com
>> >
> go to start--> run
> type eventvwr
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>

Cannot start up local server

Recently I cannot start up my local SQL 2000.
I goto services panel, select MSSQLSEREVR, right click select 'Start', got
a message box:
"The MSSQKSERVER service on Local Computer started and then stopped. Some
services stop automatically if they have no work to do, for example, the
Performance Logs and Alerts server"
I tried to start 'Performance Logs and Alerts server' and still get the same
message box.
Alan
Any errors in Event Viewer
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> Recently I cannot start up my local SQL 2000.
> I goto services panel, select MSSQLSEREVR, right click select 'Start',
> got a message box:
> "The MSSQKSERVER service on Local Computer started and then stopped. Some
> services stop automatically if they have no work to do, for example, the
> Performance Logs and Alerts server"
> I tried to start 'Performance Logs and Alerts server' and still get the
> same message box.
>
|||Uri Dimant wrote:
[vbcol=seagreen]
> Alan
> Any errors in Event Viewer
>
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
Try to find out errors in Event Viewer or SQL Server Errorlog.
Regards
Amish Shah
http://shahamishm.tripod.com
|||Sorry, how do I open the EventViewer ?
"amish" <shahamishm@.gmail.com> wrote in message
news:1161168035.474752.181820@.e3g2000cwe.googlegro ups.com...
> Uri Dimant wrote:
>
> Try to find out errors in Event Viewer or SQL Server Errorlog.
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>
|||Alan T wrote:
[vbcol=seagreen]
> Sorry, how do I open the EventViewer ?
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1161168035.474752.181820@.e3g2000cwe.googlegro ups.com...
go to start--> run
type eventvwr
Regards
Amish Shah
http://shahamishm.tripod.com

Cannot start up local server

Recently I cannot start up my local SQL 2000.
I goto services panel, select MSSQLSEREVR, right click select 'Start', got
a message box:
"The MSSQKSERVER service on Local Computer started and then stopped. Some
services stop automatically if they have no work to do, for example, the
Performance Logs and Alerts server"
I tried to start 'Performance Logs and Alerts server' and still get the same
message box.Alan
Any errors in Event Viewer
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> Recently I cannot start up my local SQL 2000.
> I goto services panel, select MSSQLSEREVR, right click select 'Start',
> got a message box:
> "The MSSQKSERVER service on Local Computer started and then stopped. Some
> services stop automatically if they have no work to do, for example, the
> Performance Logs and Alerts server"
> I tried to start 'Performance Logs and Alerts server' and still get the
> same message box.
>|||Uri Dimant wrote:
[vbcol=seagreen]
> Alan
> Any errors in Event Viewer
>
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
Try to find out errors in Event Viewer or SQL Server Errorlog.
Regards
Amish Shah
http://shahamishm.tripod.com|||Sorry, how do I open the EventViewer ?
"amish" <shahamishm@.gmail.com> wrote in message
news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
> Uri Dimant wrote:
>
> Try to find out errors in Event Viewer or SQL Server Errorlog.
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>|||Alan T wrote:
[vbcol=seagreen]
> Sorry, how do I open the EventViewer ?
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
go to start--> run
type eventvwr
Regards
Amish Shah
http://shahamishm.tripod.com|||Hi,
Yes I opened the eventviewer and knowing my evaluation copy of SQL 2000
Enterprise has expired.
Can I install the SQL 2000 Developer Edition on the top of it?
"amish" <shahamishm@.gmail.com> wrote in message
news:1161240339.590000.279530@.m7g2000cwm.googlegroups.com...
> Alan T wrote:
>
> go to start--> run
> type eventvwr
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>

Saturday, February 25, 2012

Cannot shut down VS after using report designer

Routinely when I use BIDS to work on a report design, I cannot close BIDS because I get a message box that says:

Microsoft Visual Studio cannot shut down because a modal dialog is active. Close the active dialog and try again.

Of course, there is no visible dialog open. I actually have to terminate the process from task manager.

I do not get this problem when using SSIS or SSAS. Only SSRS.

Any Ideas?

Thanks!
BobP

any luck on this? This is pretty annoying.|||

Myself and a number of colleagues are having the same error

come up.

We are only able to shutdown the visual studio by going to task manager. Still

trying to find the cause, but if anyone else knows anything more?

|||

Still using task manager here. Can't find anyone that has an answer... I'll keep looking... the truth must be out there.

BobP

|||

Same bug here, but when a Infragistics control (Windocker) breaks at design time.

Grrrrr...

There is an open bug track on this at:

http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=c6519d93-581a-4eea-85f5-143e9d790d4e

|||The problem normally occurs with me when I had used the query designer an has run an query.

When continuing the work at some time sql server ask the question whether to keep the result set or not.

When VS is not the active window this message is stuck behind the VS screen and you can not stop it.

It is quite anoying and my only solution at this time is to save frequently.

Sander van der Hoeff|||

I too ran into this today. After having a look at the bug in the product feedback centre, I noticed the bug is resolved as not reproduced.

Is it me, or does it seem unproductive to resolve a bug as not reproduced when there's 9 Can Validate and 13 voters with the average rating 4.69? Clearly this should continue to be investigated.

Maybe look at the code that checks for modal dialogs and see what dialogs could cause this message and work backward from there?

|||

BTW, my situation was dragging code from one source file to another. E.g. while in one file, clicking selected text and dragging it to a tab to activate another file and dropped on that file. That file was just added to the project (C#) as a New Item (class).

Of course, I can't reproduce it...

If it matters, I recently came out of Stand By... and I'm not using BIDS or SQL Server with this project.

|||

FYI...

I encountered this problem today for the first time. I was creating a new report in a project by selecting an existing report, right-clicking on it and selected COPY. I then did a CTRL-V to paste it into my project. The new report name was "Copy of...". I renamed the report and then I encountered the problem. I was able to close the IDE via the task manager.

I am unable to reproduce the problem.

Lawrence

|||I get this every time I design report (SQL Reporting services). I cannot shut down Visual Studio. It complains of a modal dialog being open but I can't find it.|||I have the same problem quite often. I am not sure why they are not able to reproduce it.|||

Are you running any plugins to Visual Studio?

What are you doing when it happens? Is there a particular report you're working on? Or does it happen after switching tabs, etc?

These kinds of things are pretty difficult to reproduce without detailed knowledge of what you're actually doing. If there's a bug here, it probably is in an obscure code path that just doesn't get all that much traction when we run through it on our computers. Usually, the exact order of operations makes is the clincher in getting a repro in house.

So, any detail you can provide will help us look at this.

Thanks!

-Lukasz

|||I do not remember off hand what produces this, but I will note it the next time that it happens. Although I can say that it happens quite often for me.|||

For me, the only constant is that I am working in report designer. I can start from a wizard, or start from "new item" (Someone has mentioned that the wizard caused some flakey behavior)

Some days I can open an existing report, change a label and everything will be fine, i can open another report and change a label and then it wont close.

I dont know if it is tied to the other weird behavior in the designer:

Hover over the data field toolbox tab and it wont open, I have to hover over tools, and then slide down to data.|||

I know I have experienced slowness in VS when I have multiple projects running in the background. Especially if one of the other projects is connected to a server.

However I can't reproduce these either. I'll pass along your comments to the folks that work on Report Designer.

-Lukasz

Cannot shut down VS after using report designer

Routinely when I use BIDS to work on a report design, I cannot close BIDS because I get a message box that says:

Microsoft Visual Studio cannot shut down because a modal dialog is active. Close the active dialog and try again.

Of course, there is no visible dialog open. I actually have to terminate the process from task manager.

I do not get this problem when using SSIS or SSAS. Only SSRS.

Any Ideas?

Thanks!
BobP

any luck on this? This is pretty annoying.|||

Myself and a number of colleagues are having the same error come up.
We are only able to shutdown the visual studio by going to task manager. Still trying to find the cause, but if anyone else knows anything more?

|||

Still using task manager here. Can't find anyone that has an answer... I'll keep looking... the truth must be out there.

BobP

|||

Same bug here, but when a Infragistics control (Windocker) breaks at design time.

Grrrrr...

There is an open bug track on this at:

http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=c6519d93-581a-4eea-85f5-143e9d790d4e

|||The problem normally occurs with me when I had used the query designer an has run an query.

When continuing the work at some time sql server ask the question whether to keep the result set or not.

When VS is not the active window this message is stuck behind the VS screen and you can not stop it.

It is quite anoying and my only solution at this time is to save frequently.

Sander van der Hoeff
|||

I too ran into this today. After having a look at the bug in the product feedback centre, I noticed the bug is resolved as not reproduced.

Is it me, or does it seem unproductive to resolve a bug as not reproduced when there's 9 Can Validate and 13 voters with the average rating 4.69? Clearly this should continue to be investigated.

Maybe look at the code that checks for modal dialogs and see what dialogs could cause this message and work backward from there?

|||

BTW, my situation was dragging code from one source file to another. E.g. while in one file, clicking selected text and dragging it to a tab to activate another file and dropped on that file. That file was just added to the project (C#) as a New Item (class).

Of course, I can't reproduce it...

If it matters, I recently came out of Stand By... and I'm not using BIDS or SQL Server with this project.

|||

FYI...

I encountered this problem today for the first time. I was creating a new report in a project by selecting an existing report, right-clicking on it and selected COPY. I then did a CTRL-V to paste it into my project. The new report name was "Copy of...". I renamed the report and then I encountered the problem. I was able to close the IDE via the task manager.

I am unable to reproduce the problem.

Lawrence

|||I get this every time I design report (SQL Reporting services). I cannot shut down Visual Studio. It complains of a modal dialog being open but I can't find it.|||I have the same problem quite often. I am not sure why they are not able to reproduce it.|||

Are you running any plugins to Visual Studio?

What are you doing when it happens? Is there a particular report you're working on? Or does it happen after switching tabs, etc?

These kinds of things are pretty difficult to reproduce without detailed knowledge of what you're actually doing. If there's a bug here, it probably is in an obscure code path that just doesn't get all that much traction when we run through it on our computers. Usually, the exact order of operations makes is the clincher in getting a repro in house.

So, any detail you can provide will help us look at this.

Thanks!

-Lukasz

|||I do not remember off hand what produces this, but I will note it the next time that it happens. Although I can say that it happens quite often for me.|||

For me, the only constant is that I am working in report designer. I can start from a wizard, or start from "new item" (Someone has mentioned that the wizard caused some flakey behavior)

Some days I can open an existing report, change a label and everything will be fine, i can open another report and change a label and then it wont close.

I dont know if it is tied to the other weird behavior in the designer:

Hover over the data field toolbox tab and it wont open, I have to hover over tools, and then slide down to data.|||

I know I have experienced slowness in VS when I have multiple projects running in the background. Especially if one of the other projects is connected to a server.

However I can't reproduce these either. I'll pass along your comments to the folks that work on Report Designer.

-Lukasz

Cannot shut down VS after using report designer

Routinely when I use BIDS to work on a report design, I cannot close BIDS because I get a message box that says:

Microsoft Visual Studio cannot shut down because a modal dialog is active. Close the active dialog and try again.

Of course, there is no visible dialog open. I actually have to terminate the process from task manager.

I do not get this problem when using SSIS or SSAS. Only SSRS.

Any Ideas?

Thanks!
BobP

any luck on this? This is pretty annoying.|||

Myself and a number of colleagues are having the same error come up.
We are only able to shutdown the visual studio by going to task manager. Still trying to find the cause, but if anyone else knows anything more?

|||

Still using task manager here. Can't find anyone that has an answer... I'll keep looking... the truth must be out there.

BobP

|||

Same bug here, but when a Infragistics control (Windocker) breaks at design time.

Grrrrr...

There is an open bug track on this at:

http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=c6519d93-581a-4eea-85f5-143e9d790d4e

|||The problem normally occurs with me when I had used the query designer an has run an query.

When continuing the work at some time sql server ask the question whether to keep the result set or not.

When VS is not the active window this message is stuck behind the VS screen and you can not stop it.

It is quite anoying and my only solution at this time is to save frequently.

Sander van der Hoeff
|||

I too ran into this today. After having a look at the bug in the product feedback centre, I noticed the bug is resolved as not reproduced.

Is it me, or does it seem unproductive to resolve a bug as not reproduced when there's 9 Can Validate and 13 voters with the average rating 4.69? Clearly this should continue to be investigated.

Maybe look at the code that checks for modal dialogs and see what dialogs could cause this message and work backward from there?

|||

BTW, my situation was dragging code from one source file to another. E.g. while in one file, clicking selected text and dragging it to a tab to activate another file and dropped on that file. That file was just added to the project (C#) as a New Item (class).

Of course, I can't reproduce it...

If it matters, I recently came out of Stand By... and I'm not using BIDS or SQL Server with this project.

|||

FYI...

I encountered this problem today for the first time. I was creating a new report in a project by selecting an existing report, right-clicking on it and selected COPY. I then did a CTRL-V to paste it into my project. The new report name was "Copy of...". I renamed the report and then I encountered the problem. I was able to close the IDE via the task manager.

I am unable to reproduce the problem.

Lawrence

|||I get this every time I design report (SQL Reporting services). I cannot shut down Visual Studio. It complains of a modal dialog being open but I can't find it.|||I have the same problem quite often. I am not sure why they are not able to reproduce it.|||

Are you running any plugins to Visual Studio?

What are you doing when it happens? Is there a particular report you're working on? Or does it happen after switching tabs, etc?

These kinds of things are pretty difficult to reproduce without detailed knowledge of what you're actually doing. If there's a bug here, it probably is in an obscure code path that just doesn't get all that much traction when we run through it on our computers. Usually, the exact order of operations makes is the clincher in getting a repro in house.

So, any detail you can provide will help us look at this.

Thanks!

-Lukasz

|||I do not remember off hand what produces this, but I will note it the next time that it happens. Although I can say that it happens quite often for me.|||

For me, the only constant is that I am working in report designer. I can start from a wizard, or start from "new item" (Someone has mentioned that the wizard caused some flakey behavior)

Some days I can open an existing report, change a label and everything will be fine, i can open another report and change a label and then it wont close.

I dont know if it is tied to the other weird behavior in the designer:

Hover over the data field toolbox tab and it wont open, I have to hover over tools, and then slide down to data.|||

I know I have experienced slowness in VS when I have multiple projects running in the background. Especially if one of the other projects is connected to a server.

However I can't reproduce these either. I'll pass along your comments to the folks that work on Report Designer.

-Lukasz