Missing dll file: service

Showing posts with label service. Show all posts

Monday, March 26, 2012

model database locked

I receive the following message in the Event log when
trying to start SQLSERVER service...
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17055
Date: 11/06/2004
Time: 17:45:05
User: N/A
Computer: NWK-S-SQL
Description:
17052 :
Database 'model' cannot be opened. It is in the middle of
a restore.
Data:
0000: 9c 42 00 00 0a 00 00 00 œB.....
0008: 0a 00 00 00 4e 00 57 00 ...N.W.
0010: 4b 00 2d 00 53 00 2d 00 K.-.S.-.
0018: 53 00 51 00 4c 00 00 00 S.Q.L...
0020: 00 00 00 00 ...
This is preventing the service from starting... any
suggestions on how to resolve this? Unfortunately I do not
know how the database got into this state
After a reboot of the server, several databases came back
listed as 'loading' (in a restore mode) for no aparent
reason... after a further reboot... this!
all suggestions greatfully recieved
cheers
KeithHi,
If the model database is in middle of restore you can start sql server in
mimimal mode or Single user mode. To over come
thisadd the trace flag "-T3608" in the startup parameters. This trace flag
will
bypass recovery of databases except master. You should be able to start SQL
Server after this. After this try to restore the model
database from a backup.
(-T3608 can be added from control panel -- Admin tools-- services -- MSSQL
Server --Stop MSSQL Service-- In the parameter give the values -T3608--
Start MSSQL Server service)
If you still have issues then; stop SQL server service and then:-
1. COpy the exising model.mdf and modellog.ldf to a safe place
2. Overwriting model.mdf and modellog.ldf with the files in SQL Server CD,
and then try to startup the service.
Thanks
Hari
MCDBA
"Keith Newton" <keith.newton@.riba-enterprises.com> wrote in message
news:1b12c01c44fe1$fa128490$a601280a@.phx
.gbl...
> I receive the following message in the Event log when
> trying to start SQLSERVER service...
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 11/06/2004
> Time: 17:45:05
> User: N/A
> Computer: NWK-S-SQL
> Description:
> 17052 :
> Database 'model' cannot be opened. It is in the middle of
> a restore.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 œB.....
> 0008: 0a 00 00 00 4e 00 57 00 ...N.W.
> 0010: 4b 00 2d 00 53 00 2d 00 K.-.S.-.
> 0018: 53 00 51 00 4c 00 00 00 S.Q.L...
> 0020: 00 00 00 00 ...
> This is preventing the service from starting... any
> suggestions on how to resolve this? Unfortunately I do not
> know how the database got into this state
> After a reboot of the server, several databases came back
> listed as 'loading' (in a restore mode) for no aparent
> reason... after a further reboot... this!
> all suggestions greatfully recieved
> cheers
> Keith|||Hi,
If the model database is in middle of restore you can start sql server in
mimimal mode or Single user mode. To over come
thisadd the trace flag "-T3608" in the startup parameters. This trace flag
will
bypass recovery of databases except master. You should be able to start SQL
Server after this. After this try to restore the model
database from a backup.
(-T3608 can be added from control panel -- Admin tools-- services -- MSSQL
Server --Stop MSSQL Service-- In the parameter give the values -T3608--
Start MSSQL Server service)
If you still have issues then; stop SQL server service and then:-
1. COpy the exising model.mdf and modellog.ldf to a safe place
2. Overwriting model.mdf and modellog.ldf with the files in SQL Server CD,
and then try to startup the service.
Thanks
Hari
MCDBA
"Keith Newton" <keith.newton@.riba-enterprises.com> wrote in message
news:1b12c01c44fe1$fa128490$a601280a@.phx
.gbl...
> I receive the following message in the Event log when
> trying to start SQLSERVER service...
> Event Type: Information
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17055
> Date: 11/06/2004
> Time: 17:45:05
> User: N/A
> Computer: NWK-S-SQL
> Description:
> 17052 :
> Database 'model' cannot be opened. It is in the middle of
> a restore.
> Data:
> 0000: 9c 42 00 00 0a 00 00 00 œB.....
> 0008: 0a 00 00 00 4e 00 57 00 ...N.W.
> 0010: 4b 00 2d 00 53 00 2d 00 K.-.S.-.
> 0018: 53 00 51 00 4c 00 00 00 S.Q.L...
> 0020: 00 00 00 00 ...
> This is preventing the service from starting... any
> suggestions on how to resolve this? Unfortunately I do not
> know how the database got into this state
> After a reboot of the server, several databases came back
> listed as 'loading' (in a restore mode) for no aparent
> reason... after a further reboot... this!
> all suggestions greatfully recieved
> cheers
> Keith

model database locked

Mobile replication

I have the following setup

Server 1: Windows 2003 inc IIS. Also on this server is SQL Server Web sync web service and it has an external IP address for internet connectivity

Server 2: Windows 2003 inc SQL Server 2005. This server has a database setup with replication so the a Window Mobile 5 device can do a merge replication.

My problem is that the replication fails when trying to send the snap shot from Server 2 to the mobile device. The device seems to get through to the replication agent, as entries in the Replication monitor are logged (see below).

I have checked all the permissions on the relevant shares required for replication (basically set "Everyone" with full access).

My initial question would be.... When the snapshot is been sent to the mobile device, does the SQL Server try to send it directly to the internet or does it go through "SQL Server Mobile Server Agent 3.0".

Please can someone help, as this is causing me some REAL problems.

Error messages:
The schema script '\\ukrt1-sql902\SQLRepl\unc\UKRT1-SQL902_EXEL_DAMAGECODESEXEL\20060810142533\DamageAction_2.sch'
could not be propagated to the subscriber. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147023570)
Get help: http://help/MSSQL_REPL-2147023570

The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization,
the merge process may have been unable to create or write to the message file. When troubleshooting,
restart the synchronization with verbose history logging and specify an output file to which to write.
(Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Get help: http://help/MSSQL_REPL-2147201001

I fixed this issue....

The snapshot directory on the datbase server didnt have the correct permissions. This is because the SQL Agent on the IIS server was setup with the default user... The IIS default...

Monday, March 19, 2012

Missing What To Start SQLServer Agent in EM

Installed Office service pack and it 'messed' up the Enterprise Manager. Af
ter reinstalling the client tools and the sp3a service pack all worked but s
cheduled jobs. It turns out that the SQL Server Agent is not running. It d
oesn't automatically start
up but can be started from DOS whereby my jobs in turn can execute with no p
roblem.
Would like to know what the proper registry setting for SQLServerAgent under
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Services\SQLServerAgent should
be for SQL Server 8.0.859 with service pack 3a as suspect that the problem m
ay be there.
Otherwise open to suggestions so that do not have to backup, uninstall, and
reinstall 10 database.....
Thanxs,
dmatta59The first thing to do here is go into the Control Panel -> Admin Tools ->
Services applet & see if the SQLAgent$[instance] service is configured t
o
auto-start. Your post doesn't indicated that you've done that, so make sure
the service's "Startup Type" property is set to "Automatic". If it still
doesn't start automatically, check the Windows Event Log to see what's
wrong.
Regards,
Greg Linwood
SQL Server MVP
"dmatta59" <anonymous@.discussions.microsoft.com> wrote in message
news:6F7A83AF-FE7A-46EF-8F44-50C94788109C@.microsoft.com...
> Installed Office service pack and it 'messed' up the Enterprise Manager.
After reinstalling the client tools and the sp3a service pack all worked but
scheduled jobs. It turns out that the SQL Server Agent is not running. It
doesn't automatically start up but can be started from DOS whereby my jobs
in turn can execute with no problem.
> Would like to know what the proper registry setting for SQLServerAgent
under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Services\SQLServerAgent
should be for SQL Server 8.0.859 with service pack 3a as suspect that the
problem may be there.
> Otherwise open to suggestions so that do not have to backup, uninstall,
and reinstall 10 database.....
> Thanxs,
> dmatta59|||The SqlServerAgent is set to automatic. There used to be an error 8344 Supe
rSocket Error but after the registers were cleaned and errors removed the e
rror no longer appears. When viewing the registry for SQLServerAgent there
was some mention in one of
the previous posts about a "dependancies" which is not present so would app
reciate what the registry would look like for MSSQLSERVER and SQLSERVERAGENT
.
Again it works fine if started from a dos command line but most inconvienent
not to have it start automatically or start from within the EM.
Any suggestions?
dmatta59|||Have resolved the problem. Used scm.exe to install the SQLServerAgent servi
ce using the instructions on the following article:
http://groups.google.com/groups?q=i...tngxa06&rnum=21
**Please note that the in this case the sqlagent -c -v was working from the
dos prompt and the jobs could run properly. The only problem was that the S
QLServerAgent was not automatically starting or couldn't be started within E
M.
Thank you,
dmatta59

Friday, March 9, 2012

missing SQL Server Agent

Hi,

I'm learning SQL 2005 and installed the express ADV edition to my pc. But I miss the Agent service.

Is this included in express? Has it another name after SQL server 2000?

thanks

majid

Looking at the edition comparison page (http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx), it looks like SQL Agent Job Scheduling Service only comes with Workgroup, Standard, and Enterprise.

Thanks,
Sam Lester (MSFT)|||

oh, I see, Thanx

majid

Saturday, February 25, 2012

missing notifications

Hello,

We are building a simple distributed application around the service broker where each queue is serviced from a windows service. We have a windows service running constantly as a "listener" on an event queue for each of what we call "request" queues. When a message is received by the request, the listener service instantiates a reader to process the request.

As we are in development, things get out of sync at times and the event queues sometimes stop getting the event notification message. I can correct this usually emptying the queues by receiving all messages from the "request" and "event" queues but sometimes it becomes necessary to drop and recreate the broker objects. Can someone tell me what are the fail points event_notification and what corrective actions are needed at these points?

For instance, if I see that a queue has a state of "Notified" in dm_broker_queue_monitors, I just do a receive to drain the appropriate queue. I have been unable to determine what state the service broker is in when I have to delete and recreate the event notification so I don't know what is causing it and how to programmatically determine when it is necessary to take this action. We would of course prefer not to get to this state but since it can happen during development, I would guess this can happen in production so I need to develop the recovery logic to detect and correct for this condition.

Jim

If you consume the notification message from the 'events' queue but you fail to launch the reader child thread/process to consume the messages from the the 'request' queue, it will end up exactly in the situation you described. Once a notification is sent, the queue monitor goes into 'Notified' state until a RECEIVE occurs on the queue that triggered the event. It does NOT continue to send notifications, otherwhise it could end up sending notifications for ever to a service that has stopped listening.

The most likely cause of the problem is that you are failing to launch the child thread/process when you receive the notification. See my reply on the previous thread ('5 times a charm' http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=202594&SiteID=1) for a sugestion on how to process messages when the processing involves some inherently unrelaible work (like launching a thread or a process).

Also, make sure to check the 'External Activator' sample at http://www.gotdotnet.com/codegallery/codegallery.aspx?id=9f7ae2af-31aa-44dd-9ee8-6b6b6d3d6319 , it does exactly what you want.

HTH,
~ Remus

|||

Hi Remus,

No, there is something else going on. When I get this condition, I manually do a receive in query analyzer until I clean out the "request" queue. When I have emptied the queue completely and then do a new send, the messages show up in the request queue but I get no notification event. If I drop and recreate the event notification, I will then see the event message on the next request message.

Jim

|||

Does any error show up in the notifications error queue [EventNotificationErrorsQueue]?

What is the state of the notification (it will be in sys.event_notifications) and od the dialog that carries the notification (it will be in sys.conversation_endpoints)?

HTH,
~ Remus

|||

Hi Remus,

I don't see a state in sys.event_notifications but all of the event notifications I created are listed there (6). As for the sys.conversation_endpoints, I do see some conversations in disconnected state but when we have our problem, I have a stored proc that goes through sys.conversation_endpoints and ends all these conversations with cleanup. Even with doing that, and all queues apparently empty I have had to recreate the event notificaiton.

I don't have a scenario to recreate this reliably so I just have to wait until we muck things up enough for it to happen and I am looking for what things I need to check. FYI, we are really using this as a monolog, the use pattern is begin dialog, send, end dialog. I have a periodic task that looks for missing task completions and just resends the request message if a task fails to complete.

Jim

|||

You need to investigate what are thos disconnected conversations. Are they initiator or targets? What 'far_service' do they have? What near service (service_id)? Are they system (is_system)? The state is 'DO' or 'DI'?

If you end the dialog that carries the notifications you are basically canceling the notification. Make sure you don't end the dialogs on the 'events' queue, that would cause the problem of having to drop and recreate the notification.

You definitely shouldn't need to have a periodic task that resends the message, that's the whole purpose of Service Broker, to avoit such problems.

One problem with the begin/send/end pattern is that you're missing any info if the message was delivered or not. In general, a better ppattern is to do begin/send and do the end on the initiator side as a response to the end from the target side.

HTH,
~ Remus

|||

Hi Remus,

No, I am not ending the dialog on the events queue, at least not directly or intentionally. Are there errors that would cause the dialog to end?

Yes, I realize that I could have used the service broker to monitor for task completion by keeping a conversation active and responding with a completion message. However, I would still need some other task responsible for deciding the task wasn't going to complete (service died, someone shut down that server, network unplugged etc) even though the message was successfully received, and generating a new request. I'm not looking for a message failure but a task failure in a service on any system connected to a Service Broker queue.

I'm relatively sure that the disconnected conversations are due us developers debugging our services and not allowing processing to complete. While debugging we are doing sends out of query analyzer manually, we are stopping and starting our code that reads the queues etc. The more we are learning, the more stable we are getting things.

So where can I find a list of things to work through when notifications stop coming? For example, I saw the state of one of my queues was NOTIFIED a couple of days ago and nothing I could do would get it back to INACTIVE. I tried clearing all conversations, made sure all of my queues were empty etc but I wound up having to drop and recreate the event notification.

Jim

PS - Aside from these little problems we are creating for ourselves, SSB is awesome!!

|||

Hi Jim,

I'm really glad you like SSB! I'm a big fan myself ;-)

Is not much I can do to help you in this case, w/o a repro case or a more precise description of the problem. Rushi might have some aditional ideas, he knows the activation machinery and queue monitors better than I do.

For your development environment, there is one big switch button that you can use:

ALTER DATABASE [dbname] SET DISABLE_BROKER;
ALTER DATABASE [dbname] SET ENABLE_BROKER;

This will basically reinitialize everything broker related in the database, including queue monitors and such. Of course, this is not a production solution, as it requires an exclusive lock on the database (no users connected).

As to investigate what's happening, try looking at these things for investigation:

- is the notification dialog still active? look in sys.event_notifications and in sys.conversation_endpoints
- is the notification message lingering on the sender's database? look in sys.transmission_queue
- check state of the notification dialog on the target side (the conversation_id is the same on both sides). Compare the send_sequence_number from the initiator with the receive_sequence_number from the target
- make sure that if the monitoring service has consumed a notification, it did launched a thread or a process that RECEIVED from that queue.

HTH,
~ Remus

|||

Jim Stallings wrote:

No, I am not ending the dialog on the events queue, at least not directly or intentionally. Are there errors that would cause the dialog to end?

I think this are all the conditions that could end the notification dialog from the target side:
- explicit END DIALOG, or END DIALOG .. WITH ERROR
- ALTER DATABASE [...] WITH ERROR_BROKER_CONVERSATIONS
- Sender service is denied SEND permission on the target service. Can only happen on the first message (so you won't get any notification at all)
- restore of target database to a point back in time when the target did not yet exist. At the next notification message sent the target will reply with an error that will end the dialog.
- END DIALOG ... WITH CLEANUP. It will wipe out the target w/o actually notfying the initiator, so the initiator will be errored out only next time it sends a notification message, same as above.

ALTER DATABASE [...] SET NEW_BROKER is a special case, it will wipe out the target w/o notifying the initiator, but since the broker is completely erased, the inittiator can never find again the old broker to deliver the message. If the initiator happens to be on the same database as the target then the initiator is wiped out as well, so there is no problem.

Just for the record, there are two more conditions that could end the dialog, but they cannot happen on notifications:
- sending an incorrectly formatted XML message, this cannot happen on notifications since notifications message bodies are outside your control
- dialog timeout, but notifications dialog have the maximum timeout, so it cannot happen until sometime in 2074.

HTH,
~ Remus

|||

Ending the dialog at the notification service: You could check the [EventNotificationsErrorQueue] to find error messages in case the dialog was closed due to some error. Also, you said that you have a stored proc that deliberately ends dialogs at the notification service; are you sure this is not being called somehow?

Programming pattern: Could you explain what the application is and why you are choosing the fire-and-forget (begin/send/end) pattern? I did not understand what you mean by 'task wasn't going to complete due to server shutdown, network unplugged, etc'. The reliable transport of service broker guarantees that messages will be delivered even if you run into such problems. The standard pattern we recommend is initiator begins dialog, sends the request and goes around with its own business (maybe accepting next request from user and doing begin/send). Sometime in the future, the message is delivered and a queue reader receives the message, processes it and sends back a response. If the intiator doesn't really need any excess information, the response could be as simple as ending the dialog. A background thread or a periodic program on the initiator side receives the end dialog response and ends the dialog on its side.

Task failures: If the request cannot be processed immediately, then we come across some interesting problems. A typical example is that the request generates an HttpRequest which could fail. You could rollback the transaction, but then you are going to get the message back almost immediately the next time you do a RECEIVE. If you rollback 5 times, your queue is going to get disabled. A common solution is that if the request cannot be processed immediately, you log it to a table and begin a conversation timer to retry the request after some X units of time.

My queue is stuck in NOTIFIED state: The NOTIFIED state indicates that we delivered that notification and now it's your job to perform a RECEIVE on the queue. A correctly written app will never orphan the queue in NOTIFIED state but always try to schedule something that will eventually come around and do that RECEIVE we've been waiting for. The RECEIVE moves the queue monitor state machine to the RECEIVES_OCCURING state. When the queue is drained and the last queue reader releases the conversation group lock (i.e. commits/rollsback a transaction doing the receive), we notice that there is nothing in the queue and take the queue monitor back to INACTIVE state. There is no way to reset the queue monitor from NOTIFIED to INACTIVE state. You can only reset from NOTIFIED to RECEIVES_OCCURING state. It's only when the queue is drained that we will go back to INACTIVE state.

INACTIVE is not EMPTY: INACTIVE does not really mean queue is empty. We could also go into INACTIVE state when all messages in the queue belong to conversation groups that are currently locked by some transaction or the other. In such a scenario, it doesn't make sense to activate a new queue reader since it will be unable to RECEIVE any messages. So INACTIVE is really the union of EMPTY and NO_UNLOCKED_MESSAGES state.

The external activator that we've released is a good example of how to write the kind of app you are trying to build. You should certainly take a look at that. We will be releasing an update to that shortly.

|||

Hi Rushi

This application uses a highly modified version of the ServiceBrokerInterface project from the activator example so yes, I have been through your examples many times including the PDC 2005.

As to what this project is, it is a print queue that gets kicked off by a periodic stored proc that examines a legacy database for new jobs. When a job is found, it is put into an active print table and two windows services receive a message to begin their processing. One does an httpRequest to an outside vendor the other creates a pdf from the data in the print table.

These may or may not be on the same server as other processes but definitely is not on the server running Service Broker. Yes I could have done a rollback/retry as you suggest but regardless, if we have a failure, we have to send this information to some controlling process to decide if it's a one time failure that should be retried, a single request that fails everytime due to bad data and should be logged or retried, whether we should send an alert to the users or sys admin etc, etc.

We also need to send the controlling process a success message when a task completes so that it can begin the next step, send to printer, archive files etc. I just elected to send completion messages directly to the controller process rather than using service broker conversation. Using a conversation, I would have to use activation for each initiator queue which would mean starting another service for each queue as I have built the application as I have my event listener windows service doing receive with WAITFOR so that they can check for shutdown and/or confguration changes between receives. Whether I use service broker conversations to encapsulate task completion or just fire and forget as you describe it, I still wind up with a controlling process listening to some queue.

With a more standard implementation as you suggest, my controller would listen to all task queues, in mine I have a dedicatcontroller queue that all the tasks report completion to. In any case, since I will have services running on multiple systems, I do need a timer thread running in my controller to see if a service has stopped processing a queue and take whatever actions are called for, alerts, redirect to another queue etc. That was it's primary function and I wanted the logic as to how to handle this not tied up in completing a conversation.

Thanks for the explanation on the queue state. When I was seeing this problem, it wasn't that the queue was inactive when I still had messages, it was that it was in Notified state and I couldn't receive from the notification queue. This can result from the developer stepping through the listener code and not completing the transaction but the lock should release either when he stopped and the connection terminated or when the command timed out so I'm at a loss as to what else to look at when this occurs.

Thanks

Jim

|||

There is a well-known race condition that can cause similar symptoms. The race occurs when the following conditions are met:

1) a given queue-reader is configured to a given max (e.g. 1)

2) there are currently max queue-readers running

3) a notification is delivered to the notification queue.

If these conditions occur while the queue reader(s) is still running, but in the process of shutting down it is quite likely that the notification queue will be drained, but the messages in the app queue will not be processed resulting in the app queue being in NOTIFIED state and the notification queue being in the RECEIVING state.

To deal with this the activating process should keep record of notifications received while the max queue readers condition is in effect and kick another off (just in case) when the # of queue readers falls below the max.

This is what the current version of our external activator sample does. (I'm not sure if this one is posted to the web yet or not).

I'm not sure if this condition is what you are seeing or not, but thought it worthy of calling out for both you and others reading this thread anyway.

-Gerald

|||

I believe that I have finally tracked down my problem. When I do an "end conversation with cleanup", my event notification gets dropped. I thought that since I still had an entry in sys.dm_broker_queue_monitors, that the event notification was active. I didn't see anything in the help for "end conversation" that led me to believe that the cleanup option should do this.

Thanks,

Jim

Missing Integration Service Template - fixed now

I have installed SQL Server 180 day evaluation as well as SQL Server Express but I cannot add a new SSIS project because the template is not there (- in the non-express instance - only Reporting Services). When I try and redo the SSIS part of setup(Add/Remove programs) the report tells me that it is already installed correctly. I have searched for others having this problem to no avail...

What do I need to do to fix it?

This may be a silly question but just wanted to make sure. Did you check the bottom option in the installation wizard for Workstation components and documentation? Also, when you look at the services, do you see the SSIS service installed?

-- Brian Knight

|||

Not a silly question but I had checked already and the SSIS service was installed and running and I had checked everything to install.

I tried to install the parts of sql that I could to D: rather than the default of C: and I installed SQL Express before the SQL 2005 EVAL (which I the realized that I needed for SSIS)

Then I posted the question and the decided to un and re-install.

I have now installed just the EVAL and it now works ok :-)

(In fact I see that there is also an Analysis Service Template there as well)

So the problem may have been with the order or the location?

I will be adding the SQL Express later so if it fails I will let you know...

Thanks anyway for the reply

|||

Not a silly question but I had checked already and the SSIS service was installed and running and I had checked everything to install.

I tried to install the parts of sql that I could to D: rather than the default of C: and I installed SQL Express before the SQL 2005 EVAL (which I the realized that I needed for SSIS)

Then I posted the question and the decided to un and re-install

I have now installed just the EVAL and it now works ok :-)

(In fact I see that there is also an Analysis Service Template there as well)

So the problem may have been with the order or the location?

I will be adding the SQL Express later so if it fails I will let you know...

Thanks anyway for the reply

|||

Your configuration should work fantastically. Not sure what gremlin reaked havok in your install but glad everything is fine now! I have your exact config and everything works well.

-- Brian Knight

Missing Integration Service Template

What do I need to do to fix it?

-- Brian Knight

|||

Not a silly question but I had checked already and the SSIS service was installed and running and I had checked everything to install.

I tried to install the parts of sql that I could to D: rather than the default of C: and I installed SQL Express before the SQL 2005 EVAL (which I the realized that I needed for SSIS)

Then I posted the question and the decided to un and re-install.

I have now installed just the EVAL and it now works ok :-)

(In fact I see that there is also an Analysis Service Template there as well)

So the problem may have been with the order or the location?

I will be adding the SQL Express later so if it fails I will let you know...

Thanks anyway for the reply

|||

Not a silly question but I had checked already and the SSIS service was installed and running and I had checked everything to install.

I tried to install the parts of sql that I could to D: rather than the default of C: and I installed SQL Express before the SQL 2005 EVAL (which I the realized that I needed for SSIS)

Then I posted the question and the decided to un and re-install

I have now installed just the EVAL and it now works ok :-)

(In fact I see that there is also an Analysis Service Template there as well)

So the problem may have been with the order or the location?

I will be adding the SQL Express later so if it fails I will let you know...

Thanks anyway for the reply

|||

Your configuration should work fantastically. Not sure what gremlin reaked havok in your install but glad everything is fine now! I have your exact config and everything works well.

-- Brian Knight

Missing INFORMATION_SCHEMA.ROUTINES

Hi all,
For some reason this view is missing from my MSSQL:
INFORMATION_SCHEMA.ROUTINES
Does anyone have any idea why?... Is it a service pack maybe?
Please let me know. Thank you!I do not think that this view was added as a service pack addition. Pleasew
verify that you are logging in with applicable permissions. This view is
created by default.
"Madestro" wrote:
> Hi all,
> For some reason this view is missing from my MSSQL:
> INFORMATION_SCHEMA.ROUTINES
> Does anyone have any idea why?... Is it a service pack maybe?
> Please let me know. Thank you!
>|||it's not available in SQLServer 7. Is that the reason?
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Database change management for SQL Server
"DBADave" wrote:
> I do not think that this view was added as a service pack addition. Pleasew
> verify that you are logging in with applicable permissions. This view is
> created by default.
> "Madestro" wrote:
> > Hi all,
> >
> > For some reason this view is missing from my MSSQL:
> >
> > INFORMATION_SCHEMA.ROUTINES
> >
> > Does anyone have any idea why?... Is it a service pack maybe?
> >
> > Please let me know. Thank you!
> >|||Thank you for replying Dave, I appreciate your help.
I am logging in as "sa", but I still don't see the ROUTINES view.
I have taken a snapshot of the available views through Enterprise Manager.
If you would like to see it, please let me know an address I can send the
snapshot to.
Any other ideas?
Thanks again!
"DBADave" wrote:
> I do not think that this view was added as a service pack addition. Pleasew
> verify that you are logging in with applicable permissions. This view is
> created by default.
> "Madestro" wrote:
> > Hi all,
> >
> > For some reason this view is missing from my MSSQL:
> >
> > INFORMATION_SCHEMA.ROUTINES
> >
> > Does anyone have any idea why?... Is it a service pack maybe?
> >
> > Please let me know. Thank you!
> >|||Madestro,
When you use the object browser to look for these views, you
will only find them in the database [master], but you can access
them from any database as
select * from INFORMATION_SCHEMA.ROUTINES
Please let us know if you receive an error when you issue this query.
Steve Kass
Drew University
Madestro wrote:
>Thank you for replying Dave, I appreciate your help.
>I am logging in as "sa", but I still don't see the ROUTINES view.
>I have taken a snapshot of the available views through Enterprise Manager.
>If you would like to see it, please let me know an address I can send the
>snapshot to.
>Any other ideas?
>Thanks again!
>"DBADave" wrote:
>
>>I do not think that this view was added as a service pack addition. Pleasew
>>verify that you are logging in with applicable permissions. This view is
>>created by default.
>>"Madestro" wrote:
>>
>>Hi all,
>>For some reason this view is missing from my MSSQL:
>>INFORMATION_SCHEMA.ROUTINES
>>Does anyone have any idea why?... Is it a service pack maybe?
>>Please let me know. Thank you!
>>|||Where are you looking? The view only exists in the master database physically, but it acts just as
it exists in any database. What happens if you execute below:
USE pubs
SELECT * FROM INFORMATION_SCHEMA.ROUTINES
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Madestro" <me_no_like_spam_juanDOTromero@.bowneDOTcom> wrote in message
news:A8F2AA45-D5C9-45A0-85A4-B75B50E4D9E6@.microsoft.com...
> Thank you for replying Dave, I appreciate your help.
> I am logging in as "sa", but I still don't see the ROUTINES view.
> I have taken a snapshot of the available views through Enterprise Manager.
> If you would like to see it, please let me know an address I can send the
> snapshot to.
> Any other ideas?
> Thanks again!
> "DBADave" wrote:
>> I do not think that this view was added as a service pack addition. Pleasew
>> verify that you are logging in with applicable permissions. This view is
>> created by default.
>> "Madestro" wrote:
>> > Hi all,
>> >
>> > For some reason this view is missing from my MSSQL:
>> >
>> > INFORMATION_SCHEMA.ROUTINES
>> >
>> > Does anyone have any idea why?... Is it a service pack maybe?
>> >
>> > Please let me know. Thank you!
>> >|||Thank you all for your replies.
You are going to laugh at this but.... it turns out this machine is running
MSSQL 7.0...
I just didn't realize it since for some reason it has the 2000 Enterprise
Manager and Query Analizer tools!!!... ?
Thanks again!
"mark baekdal" wrote:
> it's not available in SQLServer 7. Is that the reason?
>
> regards,
> Mark Baekdal
> http://www.dbghost.com
> http://www.innovartis.co.uk
> +44 (0)208 241 1762
> Database change management for SQL Server
>
>
> "DBADave" wrote:
> > I do not think that this view was added as a service pack addition. Pleasew
> > verify that you are logging in with applicable permissions. This view is
> > created by default.
> >
> > "Madestro" wrote:
> >
> > > Hi all,
> > >
> > > For some reason this view is missing from my MSSQL:
> > >
> > > INFORMATION_SCHEMA.ROUTINES
> > >
> > > Does anyone have any idea why?... Is it a service pack maybe?
> > >
> > > Please let me know. Thank you!
> > >

Monday, February 20, 2012

missing DTS connections

I am running SQL server 2000 service pack 3 on a windows XP professional
service pack 2 machine. There are four developers using the same
configuration.
All of us have missing connections in the DTS designer. All that is
available are the following:
Microsoft OLEDB provider for sql server
Text File(source)
Text File (Destination)
Microsoft datalink
We have no connections to Excel, Access Oracle etc.
When I checked the Microsoft Datalink properties dialogue there are also
missing OLEDB providers so the issue appears to be with the OLEDB drivers.
I tried re installing MDAC however XP generated an error stating that MDAC
is up to date.
I suspect that the issue is due to a windows update that was automatically
applied as I built a new machine and installed only XP ,Sql server ,office
2003 and Visual studio enterprise architect 2003. After the initial
installation all the connections were available however after applying
automatic updates the machine lost all the connections.
This fault is causing us no end of problems and we desperately need a
solution.
Thank you in advance
LLoyd Faber
You can check your MDAC installation using component
checker. You can download the tool from:
http://msdn.microsoft.com/data/downl...s/default.aspx
You can find more information on the tool in the following
article:
Component Checker: Diagnose problems and reconfigure MDAC
installations
http://support.microsoft.com/?id=307255
-Sue
On Tue, 5 Apr 2005 03:31:06 -0700, "Talonsys"
<talon@.nospam.co.uk> wrote:

>I am running SQL server 2000 service pack 3 on a windows XP professional
>service pack 2 machine. There are four developers using the same
>configuration.
>All of us have missing connections in the DTS designer. All that is
>available are the following:
>Microsoft OLEDB provider for sql server
>Text File(source)
>Text File (Destination)
>Microsoft datalink
>We have no connections to Excel, Access Oracle etc.
>When I checked the Microsoft Datalink properties dialogue there are also
>missing OLEDB providers so the issue appears to be with the OLEDB drivers.
>I tried re installing MDAC however XP generated an error stating that MDAC
>is up to date.
>I suspect that the issue is due to a windows update that was automatically
>applied as I built a new machine and installed only XP ,Sql server ,office
>2003 and Visual studio enterprise architect 2003. After the initial
>installation all the connections were available however after applying
>automatic updates the machine lost all the connections.
>This fault is causing us no end of problems and we desperately need a
>solution.
>Thank you in advance
>LLoyd Faber
|||Sue
I ran the component checker and it reports that MDAC is OK!
"Sue Hoegemeier" wrote:

> You can check your MDAC installation using component
> checker. You can download the tool from:
> http://msdn.microsoft.com/data/downl...s/default.aspx
> You can find more information on the tool in the following
> article:
> Component Checker: Diagnose problems and reconfigure MDAC
> installations
> http://support.microsoft.com/?id=307255
> -Sue
> On Tue, 5 Apr 2005 03:31:06 -0700, "Talonsys"
> <talon@.nospam.co.uk> wrote:
>
>

missing DTS connections

I am running SQL server 2000 service pack 3 on a Windows XP professional
service pack 2 machine. There are four developers using the same
configuration.
All of us have missing connections in the DTS designer. All that is
available are the following:
Microsoft OLEDB provider for sql server
Text File(source)
Text File (Destination)
Microsoft datalink
We have no connections to Excel, Access Oracle etc.
When I checked the Microsoft Datalink properties dialogue there are also
missing OLEDB providers so the issue appears to be with the OLEDB drivers.
I tried re installing MDAC however XP generated an error stating that MDAC
is up to date.
I suspect that the issue is due to a windows update that was automatically
applied as I built a new machine and installed only XP ,Sql server ,office
2003 and Visual studio enterprise architect 2003. After the initial
installation all the connections were available however after applying
automatic updates the machine lost all the connections.
This fault is causing us no end of problems and we desperately need a
solution.
Thank you in advance
LLoyd FaberYou can check your MDAC installation using component
checker. You can download the tool from:
http://msdn.microsoft.com/data/down...ls/default.aspx
You can find more information on the tool in the following
article:
Component Checker: Diagnose problems and reconfigure MDAC
installations
http://support.microsoft.com/?id=307255
-Sue
On Tue, 5 Apr 2005 03:31:06 -0700, "Talonsys"
<talon@.nospam.co.uk> wrote:

>I am running SQL server 2000 service pack 3 on a Windows XP professional
>service pack 2 machine. There are four developers using the same
>configuration.
>All of us have missing connections in the DTS designer. All that is
>available are the following:
>Microsoft OLEDB provider for sql server
>Text File(source)
>Text File (Destination)
>Microsoft datalink
>We have no connections to Excel, Access Oracle etc.
>When I checked the Microsoft Datalink properties dialogue there are also
>missing OLEDB providers so the issue appears to be with the OLEDB drivers.
>I tried re installing MDAC however XP generated an error stating that MDAC
>is up to date.
>I suspect that the issue is due to a windows update that was automatically
>applied as I built a new machine and installed only XP ,Sql server ,office
>2003 and Visual studio enterprise architect 2003. After the initial
>installation all the connections were available however after applying
>automatic updates the machine lost all the connections.
>This fault is causing us no end of problems and we desperately need a
>solution.
>Thank you in advance
>LLoyd Faber|||Sue
I ran the component checker and it reports that MDAC is OK!
"Sue Hoegemeier" wrote:

> You can check your MDAC installation using component
> checker. You can download the tool from:
> http://msdn.microsoft.com/data/down...ls/default.aspx
> You can find more information on the tool in the following
> article:
> Component Checker: Diagnose problems and reconfigure MDAC
> installations
> http://support.microsoft.com/?id=307255
> -Sue
> On Tue, 5 Apr 2005 03:31:06 -0700, "Talonsys"
> <talon@.nospam.co.uk> wrote:
>
>

Monday, March 26, 2012

model database locked

model database locked

model database locked

Mobile replication

Monday, March 19, 2012

Missing What To Start SQLServer Agent in EM

Friday, March 9, 2012

missing SQL Server Agent

Saturday, February 25, 2012

missing notifications

Missing Integration Service Template - fixed now

Missing Integration Service Template

Missing INFORMATION_SCHEMA.ROUTINES

Missing INFORMATION_SCHEMA.ROUTINES

Missing INFORMATION_SCHEMA.ROUTINES

Monday, February 20, 2012

missing DTS connections

missing DTS connections

Missing dll file

Blog Archive

About Me