Can't start SSIS

Hello,

Our enterprise have bought a sql server 2005 standard edition.
Before installing it i have installed the beta version.
And after I desinstalled this beta version (with difficulties).
But the problem is that I can't start SSIS.

I have the following message:
"The request failed or the service did not respond in a timely fashion.
Consult event log or other applicable error logs for details."

Please can you help me.
Thanks.

You should really format the machine and reinstall the OS, especially if you had an early beta. The fact that you had problems cleaning it up would be a clear indication to me that you should do that more than ever.

Are there any errors in the event log, as the message directs?

Have you applied SP1? There is an issue with starting the service with that.

|||If you have installed SP1, please review this KB article
http://support.microsoft.com/kb/918644|||

Thanks!!!
In fact I haven't installed the SP1 because the SP1 I have seen is only for express edition (I have the standard edition)!!
For the event log I haven't seen it yet!! I'll try to do it Monday.

PS:
One thing I remembered during the installation is that all the system requirements were not OK.I didn't have errors but there were 2 warnings(i don't remember them)!! .

May be it will be that!!Or it will be because I haven't installed SP1 (if you know where I can download it please indicate me ).

Thanks for comments!!!

|||

taze wrote:

if you know where I can download it please indicate me

The SP1 can be downloaded http://www.microsoft.com/sql/sp1.mspx, but I don't think it will fix this particular issue.

I join Darren's advice to reinstall the OS if earlier it had any beta builds.

|||Thank U very much for your advice!!!
I will try reinstall SQL Server 2005 in a new machine wirhout any SQL 2005 beta version!!!
Thanks!!!

Can't Start SS Business Intelligence installed from SS 2005 Express Edition Toolkit

I downloaded and installed Microsoft SQL Server 2005 Express Edition with Advanced Services and Microsoft SQL Server 2005 Express Edition Toolkit. Installs completed successfully, and I can launch the SS Management Studio, but when I launch SS Business Intelligence Development Studio, I get message saying "Windows is searching for devenv.exe". When I search for this file I don't find it on my hard drive.

I thought I'd reinstall the SS Express Edition Toolkit, but I can't find this application in the Control Panel Installed Programs list, so I can't uninstall it.

Any ideas as to how I can get SS Business Intelligence Studio working?

Hey Probie,

Individual SQL components are all listed in Add/Remove Programs under Microsoft SQL Server 2005. You have to launch the main app maintenance mode and then select the component you want to remove, in this case the Workstation Tools, an go from there.

It does look like something went wrong with the installation of the VS shell that BIDS uses, so uninstall is a likely first step.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

|||

Probie,

Do you have visual studio 2003 installed?

I had the same problem and it seemed related to VS2003:

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

|||

Thanks for this information Lacan. Probie, let us know if this works for you.

- Mike

|||

Hello,

I am having the same problem as probie. Although BIDS shows in my programs menu, it does not appear as a component in Add/Remove programs neither will it run when accessed via the start menu.

Does anyone know if there is a way to resolve this issue?

Cheers,

sfx

|||

sfx1,

Did you already try what I had suggested via the link above?

(unzip the files from the SQLEXPR_TOOLKIT.EXE and launch the vs_setup.msi directly under the exposed \setup folder)?

When you say that it won't run, do you mean that the devenv.exe is not found? If so, please try what I suggested and see if it installs the devenv for you. If it doesn't work, try running that package vs_setup.msi with logging and see what the log says.

Regards,

Lacan

|||

Hi Lacan,

Thank you for your reply. Did you happen to install the SQLEXPR_TOOLKIT.EXE prior to running the vs_setup.msi or did you just install the vs_setup.msi by itself?

Thanks again,

sfx1

|||

I believe the last time, I had tried to install everything gtom sqlexpr_toolkit.exe FIRST, and when the shortcut to BIDS did not work, I started exploring and found the vs_setup.msi and ran that.

It installed BIDS correctly, then I was able to start designing reports. Good question, and I should have been more explicit about the order. Thanks

Regards,

-Lacan

|||

Hi Lacan,

Thanks for getting back to me, I appreciate it. I will give your suggestions a go. :)

Cheers,

sfx1

|||

Lacan,

I found the vs_Setup.msi in the setup folder of SQLxpress Tools.exe. Ran the setup

(there is no indication that the vs_setup is running, but when I checked Processes in task manager, msiexec.exe was using CPU) ,

after setup ended, voila! devene.exe was in the IDE folder, and BIDS opened successfully.

Thanks for your help.

probie

|||

I didn't get any indication that setup was running either. The package just seemed to sound like it was responsible for the devenv part of it so I ran it as an experiment and the same occurred for me.

I'm glad it worked out.

Regards,

-Lacan

sql

can't start sql 2005 service

Hi guys, I have sql 2005 beta 2 installed.. It used to work before, toda
y I try to start the service, it said following messages.
I use local system account, my other instance sql 2000 can start, I think
it's only YUKON problem, I do not know how to troubleshoot this error.
Can you guys help? Thanks a lot!!Have you checked the SQL Server 2005 error log?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Britney" <britneychen_2001@.yahoo.com> wrote in message news:urW5U81oFHA.303
6@.TK2MSFTNGP14.phx.gbl...
Hi guys, I have sql 2005 beta 2 installed.. It used to work before, today
I try to start the service, it said following messages.
I use local system account, my other instance sql 2000 can start, I think
it's only YUKON problem, I do not know how to troubleshoot this error.
Can you guys help? Thanks a lot!!|||where do I look for the log?
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message news:%23F
eit92oFHA.3304@.tk2msftngp13.phx.gbl...
Have you checked the SQL Server 2005 error log?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Britney" <britneychen_2001@.yahoo.com> wrote in message news:urW5U81oFHA.303
6@.TK2MSFTNGP14.phx.gbl...
Hi guys, I have sql 2005 beta 2 installed.. It used to work before, toda
y I try to start the service, it said following messages.
I use local system account, my other instance sql 2000 can start, I think
it's only YUKON problem, I do not know how to troubleshoot this error.
Can you guys help? Thanks a lot!!

Can't start SQL 2000 after MS Update

Hi,
I recently installed several Windows Updates and security
patches. Now the SQL Server on my XP Pro development
machine won't start. The only message box that I get
when trying to restart is a message box:
SQL Server does not exist or access denied.
Any clues on how to fix this? I can't seem to find any
other references to this problem.
Regards,
DougSQL Server does not exist or access denied is a generic error message for a
failed connection.
If the MSSQLServer service is not started, then this makes sense.
Try running : Net start MSSQLServer
Check the account you're using to start MSSQLServer.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||I do have the SQLServer icon in the tray, stopped of
course.
I am logged in to the box as Doug with administrator
privledges, SQLServer is set to logon using Local System
account.
The exact message I get when trying to start from
Computer Management console is:
--
A connection could not be established to (local).
Reason: SQL Server does not exist or access denied.
ConnectionOpen (Connect())...
Please verify SQL Server is running and check your SQL
Server registration properties (by right-clicking on the
(local) node) and try again.
--
This had been working fine for months. Nothing that I
know of changed, other than these Windows Updates two or
three days ago when the problem started.
This is my development machine and I'm right in the
middle of a project, so I REALLY appreciate your help
here.
Doug

>--Original Message--
>SQL Server does not exist or access denied is a generic
error message for a
>failed connection.
>If the MSSQLServer service is not started, then this
makes sense.
>Try running : Net start MSSQLServer
>Check the account you're using to start MSSQLServer.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>|||Doug,
The MSSQLServer service needs to be running in order to connect.
Verify that the MSSQLServer service is running / started.
If you continue to have problems connecting, you should open a support case
with SQL Server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Kevin,
Please don't keep telling me that I need to start before
I can connect. I know that. As I mentioned before, I
CAN'T start or connect. THAT IS the problem.
Something happened, probably during an Update. I don't
know what else could have happened.
HELP. Please! Anyone!!!!
Doug

>--Original Message--
>Doug,
> The MSSQLServer service needs to be running in order
to connect.
>Verify that the MSSQLServer service is running / started.
>If you continue to have problems connecting, you should
open a support case
>with SQL Server.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>|||Doug,
Go into Control Panel to services and try to start the service from
there. If it doesn't start, check the event logs and your SQL Server
error log (the errorlog file in the SQL Server installation path \Log
folder).
-Sue
On Fri, 21 May 2004 13:42:27 -0700,
<anonymous@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Kevin,
>Please don't keep telling me that I need to start before
>I can connect. I know that. As I mentioned before, I
>CAN'T start or connect. THAT IS the problem.
>Something happened, probably during an Update. I don't
>know what else could have happened.
>HELP. Please! Anyone!!!!
>Doug
>
>to connect.
>open a support case
>confers no rights.|||Hi! If you haven't solved your problem yet, try:
restoring your Windows XP to a previous state prior to the installation of
Windows patches. You can do this using System Restore of Windows XP.
Or, you can uninstall the patch(es) you had installed.
Or, try running sqlservr.exe from the command line and see if it generates a
more detailed error message.
HTH. =)
Ricky
<anonymous@.discussions.microsoft.com> wrote in message
news:105bb01c43f74$20bb2b70$a301280a@.phx
.gbl...[vbcol=seagreen]
> Kevin,
> Please don't keep telling me that I need to start before
> I can connect. I know that. As I mentioned before, I
> CAN'T start or connect. THAT IS the problem.
> Something happened, probably during an Update. I don't
> know what else could have happened.
> HELP. Please! Anyone!!!!
> Doug
>
> to connect.
> open a support case
> confers no rights.
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 5/18/2004

cant start services

Sorry for the newbie question here:

I've just installed VS.NET and have installed MSDE. All has gone well so far. I followed the instructions for setting a db password during install and the installer seemed to do its job. The SQL Server Service Manager runs in the taskbar when I reboot but the status icon is a white circle... The status bar indicates that it is not connected.

How do I connect to the server?Sorry guys... I found the answer to my own question...

had to set the server to <myComputerName>\VSDOTNET

Like I said... NEWBIE question!

Can't start RS2005

Hi,
I am new and just installed SS2005 Developer Edition on a server.
I can see the following services on Configuration Manager -> Services
Integration Services - Running
FullText Search - Running
SQL Server - Running
Analysis Service - Running
Reporting Service - Stopped
Browser - Running
Agent - Running
I tried to start RS, it ends up with error:
The request failed or the service did not respond in a timely fashion.
Consult the event log or other applicable error logs for details.
Checked the event log:
- The Remote Procedure Call (RPC) service failed to start
- Service cannot be started.
Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException:
=E7=84=A1=E6=B3=95=E8=BE=A8=E8=AD=98=E4=BD=BF=E7=94=A8=E8=80=85=E6=88=96=E7= =BE=A4=E7=B5=84=E5=90=8D=E7=A8=B1 'TPEW2KDM\ASPNET'=E3=80=82
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at
Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServ= er(Boolean
firstTime)
at
Microsoft.ReportingServices.Library.ServiceAppDomainController.Start(Boolean
firstTime)
at
Microsoft.ReportingServices.NTService.ReportService.OnStart(String[]
args)
at
System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object
state)
- The report server database is an invalid version.
I am wondering why reporting service is the only service that's not
running.
Any comments are highly appreciated.Still waiting for advice anyone? tks|||did you find a solution to this problem ?
From http://www.developmentnow.com/g/115_2006_1_0_0_679705/Cant-start-RS2005.ht
Posted via DevelopmentNow.com Group
http://www.developmentnow.com

Cant start report server

Hey all. I'm using SQL server Express and I've installed the Report service. When I go into the reporting services configuration manager and I want to start the service, the system won't let me. Here is the error

System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed.
at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout)
at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)

I just can't seem to be able to start the service.

Can you plz help?

Thanks

Hi,

Based on my understanding, this error message is caused by the permission issue. You should take a look at the Report Server logs, and make sure you are configuring locally and you are administrator on the machine. And re-modify your reporting service configuration in the following way:

1. Created ReportService database using Report Service Configuration
2. Edited your personal account to Web Service Account in rsreportserver.config
3. Used rsconfig utility to encrypt the connection and account information
4. Edited your personal account to <processModel userName=" " >

If the problem still exists, you should try the following methods.

Set the Report Server Web service and Report Manager to use the same application pool.

|||

Thank you for your answer. But how can I create a reportservice database if I can't connect to the service?

++ Where do I go to

Set the Report Server Web service and Report Manager to use the same application pool.

Add the security account to the SQLServer2005ReportingServicesWebServiceUser$InstanceName group that you use for the application pool identity.

|||

Hi,

Set the Report Server Web service and Report Manager to use the same application pool.

Add the security account to the SQLServer2005ReportingServicesWebServiceUser$InstanceName group that you use for the application pool identity.

can't start mssqlserver

I installed a copy of SQL server 2005 on a Win 2003 machine. I connected remotely from another machine and started Sql Server Configuration manager. The MSSQLServer is stopped. So, I click to start and it failed. The error it gave me was that it time out. I am new to SQL 2005 and I thought the next step after installing was to configure. Can anyone help me please.

Check in the SQL Server log file for any info. If SQL received the startup request, the log will show why the timeout occurred. Presumably there was a configuration problem that caused startup to fail.

Also check the network configuration. I believe local connections require shared memory to be enabled.

|||Hi, in addition to the aother post, try to make a snapshot of your event log if you can't figure out the problem and send the appropiate parts (like starting the service which breaks) to this forum again.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Can't Send mail using MultiServer Admin

Hi,

I have a Master server which I want to use to handle jobs for our Production Servers. the master server has Outlook installed but the Target servers do not. I need to find a way to get the job to send a mail confirming whether the job has succeeded or failed but without having a mail client installed on any of the target servers. Currently the actual backups do run but the send mail section fails with the following error.

xp_sendmail: Procedure expects parameter @.user, which was not supplied. [SQLSTATE 42000] (Error 17985). The step failed.

I can't see any parameter @.User on BOL, it may be that using sendmail is not the best way foward here

Any ideas anyone?

Hi, I had this problem when I migrated my server to new hardware. I had not yet set up the Outlook account which SQL Server uses to send the mail on the new hardware. You have to login to your box with the same account that you use for the SQL Server startup service and create an outlook profile on that account before you can send the mail using xp_sendmail. Hope this helps!|||

Hi Jason,

Thanks for the response, we don't want to install an Outlook client on the target servers which was cauing the problem, I managed to resolve the issue by using smtp instead

Regards

Lisa

|||

how do you set up the smtp on your target server? I'd like to do the same but have not any idea, I am a newbie in both SQL and network. Thanks.

|||Try using http://www.sqldev.net/xp/sp_smtp_sendmail.htm

Can't Send mail using MultiServer Admin

Hi,

I have a Master server which I want to use to handle jobs for our Production Servers. the master server has Outlook installed but the Target servers do not. I need to find a way to get the job to send a mail confirming whether the job has succeeded or failed but without having a mail client installed on any of the target servers. Currently the actual backups do run but the send mail section fails with the following error.

xp_sendmail: Procedure expects parameter @.user, which was not supplied. [SQLSTATE 42000] (Error 17985). The step failed.

I can't see any parameter @.User on BOL, it may be that using sendmail is not the best way foward here

Any ideas anyone?

Hi, I had this problem when I migrated my server to new hardware. I had not yet set up the Outlook account which SQL Server uses to send the mail on the new hardware. You have to login to your box with the same account that you use for the SQL Server startup service and create an outlook profile on that account before you can send the mail using xp_sendmail. Hope this helps!|||

Hi Jason,

Thanks for the response, we don't want to install an Outlook client on the target servers which was cauing the problem, I managed to resolve the issue by using smtp instead

Regards

Lisa

|||

how do you set up the smtp on your target server? I'd like to do the same but have not any idea, I am a newbie in both SQL and network. Thanks.

|||Try using http://www.sqldev.net/xp/sp_smtp_sendmail.htm

Can't Send mail using MultiServer Admin

Hi,

I have a Master server which I want to use to handle jobs for our Production Servers. the master server has Outlook installed but the Target servers do not. I need to find a way to get the job to send a mail confirming whether the job has succeeded or failed but without having a mail client installed on any of the target servers. Currently the actual backups do run but the send mail section fails with the following error.

xp_sendmail: Procedure expects parameter @.user, which was not supplied. [SQLSTATE 42000] (Error 17985). The step failed.

I can't see any parameter @.User on BOL, it may be that using sendmail is not the best way foward here

Any ideas anyone?

Hi, I had this problem when I migrated my server to new hardware. I had not yet set up the Outlook account which SQL Server uses to send the mail on the new hardware. You have to login to your box with the same account that you use for the SQL Server startup service and create an outlook profile on that account before you can send the mail using xp_sendmail. Hope this helps!|||

Hi Jason,

Thanks for the response, we don't want to install an Outlook client on the target servers which was cauing the problem, I managed to resolve the issue by using smtp instead

Regards

Lisa

|||

how do you set up the smtp on your target server? I'd like to do the same but have not any idea, I am a newbie in both SQL and network. Thanks.

|||Try using http://www.sqldev.net/xp/sp_smtp_sendmail.htm

Can't see the Report Manager page

Hi There,

I have installed the Sql Server 2005 reporting services and I see that two default directories being created in IIS (Report and ReportServer..). For some reason, if I type http://localhost/reports, I am unable to see the report manager homepage. Can anybody suggest me if I need to configure any more stuff to see the report manager?

I enabled the anonymous authentication and still cannot see....

I can see the webservice however by typing http://localhost/reportserver...

Any suggestions are greatly apprecaited...

Thanks.

Sam.

I got it. I had to set up the reportserver to be accessible anonymous along with Reports.

Thanks.

sql

can't see SQL server objects and counters on performance monitor

I installed SQL server 2005 on Windows XP sp2, but I can't see SQL counters
on performance monitor.
does anybody have the same situation?
ThanksHi
Do you mean that if you click on Performance object's combobox you don't see
SQL Server counters?
"chacha" <lichangang@.hotmail.com> wrote in message
news:FF74189B-EDFD-4C8A-96AF-260F11BD49CE@.microsoft.com...
>I installed SQL server 2005 on Windows XP sp2, but I can't see SQL counters
> on performance monitor.
> does anybody have the same situation?
> Thanks|||This can happen sometimes. The main reason that it causes it is that
by the time that you run perfmon with SQL Server's counters, you stop
the server's service. Few years ago I found the procedure bellow to
get the counters back (Sorry that I don't give credit, but I don't
remember where I got it from). I always start from step 4. I never
needed to run the first 3 steps.
1. You have full permission to access the local folder: C:\Program
Files\Microsoft SQL Server\MSSQL
Make sure that you can access this folder or your current account is
located in local administrator group.
2. Make sure there is no third-party application which add keys in
Register to disable the performance counters.
You can open the registry to check if there is a key named "Disable
Performance Counters" valued "1" in:
& #91;HKEY_LOCAL_MACHINE\SYSTEM\CurrentCon
trolSet\Services\MSSQLSERVER\Perfor
mance]
If it exists, please delete it
3. Under the register key:
& #91;HKEY_LOCAL_MACHINE\SYSTEM\CurrentCon
trolSet\Services\MSSQLSERVER\Perfor
mance]
Make sure the following keys with the value DO EXIST. If not, please
create
a new one and add the value.
# Note # : The "Last Counter", "Last Help", "First Help",
"WbemAdapFileSignature",
"WbemAdapFileTime", and "First Counter" values can vary between SQL
Server
installations.
"Library"=" C:\PROGRA~1\MICROS~3\MSSQL$~1\BINN\SQLCT
R80.DLL "
"Collect"="CollectSQLPerformanceData"
"Open"="OpenSQLPerformanceData"
"Close"="CloseSQLPerformanceData"
"Last Counter"=dword:000016ce
"Last Help"=dword:000016cf
"First Help"=dword:000015bb
"WbemAdapFileSignature" =hex:d1,70,dc,f8,a7,75,5e,e4,9e,e6,dd,91
,9e,cd,06,65
"WbemAdapFileTime"=hex:d6,34,9d,95,64,0d,c2,01
"WbemAdapFileSize"=dword:00008238
"WbemAdapStatus"=dword:00000000
"First Counter"=dword:000015ba
4. Unload the SQL Server Counters
In command line, execute "unlodctr MSSQLServer" (Without quotation, the
same as below)
5. Reloading the SQL Server Counters
(1) In command line, locate the current folder to C:\Program
Files\Microsoft SQL Server\MSSQL\BINN
(2) Execute "lodctr sqlctr.ini"
6. Stop SQL Server Services and Restart the Services
(1) In command line, execute "net stop mssqlserver"
(2) Execute "net start mssqlserver"
(Or you can perform it in Service Manager or in System Services)
7. Open Perforam Monitor to check if the counters appear
(1) In command line, execute "perfmon"
(2) Add and check if the counter appear
Adi
chacha wrote:
> I installed SQL server 2005 on Windows XP sp2, but I can't see SQL counter
s
> on performance monitor.
> does anybody have the same situation?
> Thanks

can't see SQL server objects and counters on performance monitor

I installed SQL server 2005 on windows Xp sp2, but I can't see SQL counters
on performance monitor.
does anybody have the same situation?
ThanksHi
Do you mean that if you click on Performance object's combobox you don't see
SQL Server counters?
"chacha" <lichangang@.hotmail.com> wrote in message
news:FF74189B-EDFD-4C8A-96AF-260F11BD49CE@.microsoft.com...
>I installed SQL server 2005 on windows Xp sp2, but I can't see SQL counters
> on performance monitor.
> does anybody have the same situation?
> Thanks|||This can happen sometimes. The main reason that it causes it is that
by the time that you run perfmon with SQL Server's counters, you stop
the server's service. Few years ago I found the procedure bellow to
get the counters back (Sorry that I don't give credit, but I don't
remember where I got it from). I always start from step 4. I never
needed to run the first 3 steps.
1. You have full permission to access the local folder: C:\Program
Files\Microsoft SQL Server\MSSQL
Make sure that you can access this folder or your current account is
located in local administrator group.
2. Make sure there is no third-party application which add keys in
Register to disable the performance counters.
You can open the registry to check if there is a key named "Disable
Performance Counters" valued "1" in:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER\Performance]
If it exists, please delete it
3. Under the register key:
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER\Performance]
Make sure the following keys with the value DO EXIST. If not, please
create
a new one and add the value.
# Note # : The "Last Counter", "Last Help", "First Help",
"WbemAdapFileSignature",
"WbemAdapFileTime", and "First Counter" values can vary between SQL
Server
installations.
"Library"=" C:\PROGRA~1\MICROS~3\MSSQL$~1\BINN\SQLCTR80.DLL "
"Collect"="CollectSQLPerformanceData"
"Open"="OpenSQLPerformanceData"
"Close"="CloseSQLPerformanceData"
"Last Counter"=dword:000016ce
"Last Help"=dword:000016cf
"First Help"=dword:000015bb
"WbemAdapFileSignature"=hex:d1,70,dc,f8,a7,75,5e,e4,9e,e6,dd,91,9e,cd,06,65
"WbemAdapFileTime"=hex:d6,34,9d,95,64,0d,c2,01
"WbemAdapFileSize"=dword:00008238
"WbemAdapStatus"=dword:00000000
"First Counter"=dword:000015ba
4. Unload the SQL Server Counters
In command line, execute "unlodctr MSSQLServer" (Without quotation, the
same as below)
5. Reloading the SQL Server Counters
(1) In command line, locate the current folder to C:\Program
Files\Microsoft SQL Server\MSSQL\BINN
(2) Execute "lodctr sqlctr.ini"
6. Stop SQL Server Services and Restart the Services
(1) In command line, execute "net stop mssqlserver"
(2) Execute "net start mssqlserver"
(Or you can perform it in Service Manager or in System Services)
7. Open Perforam Monitor to check if the counters appear
(1) In command line, execute "perfmon"
(2) Add and check if the counter appear
Adi
chacha wrote:
> I installed SQL server 2005 on windows Xp sp2, but I can't see SQL counters
> on performance monitor.
> does anybody have the same situation?
> Thankssql

Cant see sql express in vwd2005

I've installed vwd2005 and sql express, I'm trying to setup a database connection but the sql server doesnt appear in the drop down list. I've checked that the service is running and that the browser service is running too.

Anyone any ideas?

just type name of you server in the list and it should work

|||

just type name of you server in the list and it should work

Janusz

Can't see new objects created in SQL Server from C#

We have just installed SQL and C# Express. We have lots of experience with SQL, but none with C#. With both the SQL and C# apps running; if we create a new table, view etc, we cannot see that new object from C# only the objects that existed when we opened the apps for the first time (each time).

If we close everything and re-open everything from scratch, the new objects show..!?!?

Thank you for any information on this difficult problem.

Hard to tell without knowing which technique youuse to display the objects and if there is eventually somehow a caching mechanism involved. Could you post some code which does the retrieval ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

Cant See Network Server

Hi, I just installed SQL Server 2005 on Windows Server 2003 (Act as DNS and DHCP server for the network). When I tried to access it from my workstation (Windows XP Pro), using SQL Server Management Studio, theres no list of Network Server available. Anything that I should configure first?

Hi,

is SQL Server Browser started on the server ?

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||Did you enable it for network listening? By default it is not in certain SKUs(IIRC developer and express do not listen by default).|||How to enable network listening? And.. Wheres SQL Server Browser?
Its Enterprise Edition..

|||Use the Surface Area Configuration Tool|||Yay!!! Thanks guys..

Can't see D partition

I have SQL 2000 and SQL 2005 installed on a XP machine. The machine has one
physical drive divided into 5 partitions. When I choose to backup or restor
e
I can only see C and E partitions but not the D partition. All three are
NTFS partitions.
Thanks in advance.
JohnI found the problem, but don't understand why. The D partition did not have
the Everyone group define to read the drive, however other groups as well as
myself specifically have rights to it. Why does the group Everyone need to
have read in order to see it?
"John" wrote:

> I have SQL 2000 and SQL 2005 installed on a XP machine. The machine has o
ne
> physical drive divided into 5 partitions. When I choose to backup or rest
ore
> I can only see C and E partitions but not the D partition. All three are
> NTFS partitions.
> Thanks in advance.
> John|||John wrote:
> I have SQL 2000 and SQL 2005 installed on a XP machine. The machine has o
ne
> physical drive divided into 5 partitions. When I choose to backup or rest
ore
> I can only see C and E partitions but not the D partition. All three are
> NTFS partitions.
> Thanks in advance.
> John
Probably a permissions issue. What happens if you use the BACKUP
DATABASE command to send a backup to that volume?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||John wrote:
> I found the problem, but don't understand why. The D partition did not ha
ve
> the Everyone group define to read the drive, however other groups as well
as
> myself specifically have rights to it. Why does the group Everyone need t
o
> have read in order to see it?
>
When you run a backup, it's going to be run within the context of the
user that SQL Server is running under, NOT your personal login. Check
the service account for the SQL Server service, if that user doesn't
have rights to see the D: partition, then it's not going to show up in
your GUI.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Playing some more and comparing to a collegues setup, it appers to be the
local group system was missing.
Thanks so much for the quick responses.
"Tracy McKibben" wrote:

> John wrote:
> Probably a permissions issue. What happens if you use the BACKUP
> DATABASE command to send a backup to that volume?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>

Can't see D partition

I have SQL 2000 and SQL 2005 installed on a XP machine. The machine has one
physical drive divided into 5 partitions. When I choose to backup or restore
I can only see C and E partitions but not the D partition. All three are
NTFS partitions.
Thanks in advance.
JohnI found the problem, but don't understand why. The D partition did not have
the Everyone group define to read the drive, however other groups as well as
myself specifically have rights to it. Why does the group Everyone need to
have read in order to see it?
"John" wrote:
> I have SQL 2000 and SQL 2005 installed on a XP machine. The machine has one
> physical drive divided into 5 partitions. When I choose to backup or restore
> I can only see C and E partitions but not the D partition. All three are
> NTFS partitions.
> Thanks in advance.
> John|||John wrote:
> I have SQL 2000 and SQL 2005 installed on a XP machine. The machine has one
> physical drive divided into 5 partitions. When I choose to backup or restore
> I can only see C and E partitions but not the D partition. All three are
> NTFS partitions.
> Thanks in advance.
> John
Probably a permissions issue. What happens if you use the BACKUP
DATABASE command to send a backup to that volume?
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||John wrote:
> I found the problem, but don't understand why. The D partition did not have
> the Everyone group define to read the drive, however other groups as well as
> myself specifically have rights to it. Why does the group Everyone need to
> have read in order to see it?
>
When you run a backup, it's going to be run within the context of the
user that SQL Server is running under, NOT your personal login. Check
the service account for the SQL Server service, if that user doesn't
have rights to see the D: partition, then it's not going to show up in
your GUI.
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Playing some more and comparing to a collegues setup, it appers to be the
local group system was missing.
Thanks so much for the quick responses.
"Tracy McKibben" wrote:
> John wrote:
> > I have SQL 2000 and SQL 2005 installed on a XP machine. The machine has one
> > physical drive divided into 5 partitions. When I choose to backup or restore
> > I can only see C and E partitions but not the D partition. All three are
> > NTFS partitions.
> >
> > Thanks in advance.
> > John
> Probably a permissions issue. What happens if you use the BACKUP
> DATABASE command to send a backup to that volume?
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com
>

Can't see content tab or properties tab.

An administrator installed reporting services. I went to the url to the
report manager, I cannot see anything on the home page, no tabs at all. How
do I set it up to show me these tabs?
Thanks,
Rick.Log into the machine locally as a member of the local administartor's group.
You'll be able to assign permissions either using the SiteSettings-->Manage
site wide security or through the properties tab
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Rick" <noodle@.noodle.com> wrote in message
news:%23cSbAlPaEHA.644@.tk2msftngp13.phx.gbl...
> An administrator installed reporting services. I went to the url to the
> report manager, I cannot see anything on the home page, no tabs at all.
> How
> do I set it up to show me these tabs?
> Thanks,
> Rick.
>