Forum: MS SQL  Feb 19th, 2009 |
| Replies: 16 Views: 1,385 The backup is working now by restarting the SQL Server Agent.
Now I am trying to solve the windows error:
SQLVDI: Loc=CVDS::Cleanup. Desc=Release(ClientAliveMutex). ErrorCode=(288)Attempt... |
| Forum: MS SQL Feb 18th, 2009 |
| Replies: 16 Views: 1,385 My sql database I want sa to have access to. User sa can log into my database that isn't being backed up, so I am sorry but I am not following.
How about the backup? Any ideas what might have... |
| Forum: MS SQL Feb 18th, 2009 |
| Replies: 16 Views: 1,385 Logon Error: 18456, Severity: 14, State: 16
SQL Server is terminating because of a system shutdown.
The connection has been lost with microsoft Distributed Transaction Coordinator (MS... |
| Forum: MS SQL Feb 18th, 2009 |
| Replies: 16 Views: 1,385 Ok I rebooted the server. The SQL server agent still has a red circle with x through it meaning it isn't on. In the services, should I change this from manual to automatic. Is that the main sql... |
| Forum: MS SQL Feb 18th, 2009 |
| Replies: 16 Views: 1,385 Should I just shut the entire server down and restart and see what happends? i would not shut my domain down at this time. |
| Forum: MS SQL Feb 18th, 2009 |
| Replies: 16 Views: 1,385 no just sql server and d/b |
| Forum: MS SQL Feb 18th, 2009 |
| Replies: 16 Views: 1,385 All of my services are running that are set to automatic. the only thing that wasn't running that was set to manual was the directory helper and I noticed that the sql server agent wasn't running. ... |
| Forum: MS SQL Feb 18th, 2009 |
| Replies: 16 Views: 1,385 My SQL server error log messages are:
2/11 (130) SQLAgent$xxxx stopping because of windows shutdown
2/11 (165) ODBC Error: 0, Driver's SQLAllcoHandle on SQL_HANDLE_ENV failed (SQLSTATE IM004)... |
| Forum: MS SQL Feb 17th, 2009 |
| Replies: 16 Views: 1,385 I noticed that my backup of my 2005 sql server didn't work over the weekend. I don't really know where to start as I haven't dealt much with servers. But I can tell you this....
SQL Server agent... |
| Forum: MS SQL Jan 28th, 2009 |
| Replies: 27 Views: 1,789 Oh my gosh!!!! I have to give you a huge thank You for everything you have done. I am able to create maintenance plans.
Like I said, and I am sure you can tell....I am new at this, but it just... |
| Forum: MS SQL Jan 28th, 2009 |
| Replies: 27 Views: 1,789 what are client components |
| Forum: MS SQL Jan 28th, 2009 |
| Replies: 27 Views: 1,789 Ok my processor is a x86 family model etc, so I should try downloading the other file.
I know that when I tried doing the x86 sp2 it is telling me that the hotfix worked but not for this type of... |
| Forum: MS SQL Jan 28th, 2009 |
| Replies: 27 Views: 1,789 Well maybe I didn't check the type of server correctly........can you refresh my mind.
Should I be checking the main server or the sql server......i know it sounds silly, but the sql server is... |
| Forum: MS SQL Jan 28th, 2009 |
| Replies: 27 Views: 1,789 x64
The log from the update is telling me that the only thing not being updated is the tool/workstations because it wasn't upgraded to prereq 3042. I can try the update to sp2 again? |
| Forum: MS SQL Jan 28th, 2009 |
| Replies: 27 Views: 1,789 ok applied the update again........and now get the following error message...
hotfix.exe is a valid file, but just not for this type of machine.
I am using windows server 2003 r2....now what |
| Forum: MS SQL Jan 27th, 2009 |
| Replies: 27 Views: 1,789 so i need to be actually on the server, not remote? That stinks, but if it fixes.... |
| Forum: MS SQL Jan 27th, 2009 |
| Replies: 27 Views: 1,789 Yes. I have downloaded sp2 earlier today and still no change to the ssms (which is the client tools right)?
I am wondering: Could it be because I was doing remote desktop to the server?
or... |
| Forum: MS SQL Jan 27th, 2009 |
| Replies: 27 Views: 1,789 Please tell me that when I look at the server configuration manager that the analysis services should be running as well as everything else, meaning integration, full text, analysis, server,... |
| Forum: MS SQL Jan 27th, 2009 |
| Replies: 27 Views: 1,789 Also.....when I do select @@version is shows 9.00.3050.00 and when I go to help it states the studio version is 9.00.1399.00. |
| Forum: MS SQL Jan 27th, 2009 |
| Replies: 27 Views: 1,789 Ok. I went into sql server management studio and the sql server agent has the green arrow and i am able to move around and do different things. The main thing that I am concerned with right now is... |
| Forum: MS SQL Jan 27th, 2009 |
| Replies: 27 Views: 1,789 I did the first part...integration services the way you suggested. I was able to get in, but over on the right where it shows connections, there is a red x through the database. When I click on the... |
| Forum: MS SQL Jan 27th, 2009 |
| Replies: 27 Views: 1,789 Is the only way to valid that integration and agent services are installed correctly or started is through the dos prompt or can it be done through the server?
I am sorry........I am new at... |
| Forum: MS SQL Jan 26th, 2009 |
| Replies: 27 Views: 1,789 Help Please!
I am trying to create a maintenance plan in sql 2005 server. I am getting an error Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'. ... |
| Forum: MS SQL Sep 11th, 2008 |
| Replies: 3 Views: 2,299 Can the MSSMS express be used with server 2005? I am unable to install from SQL Server 2005, without an error due to the setup.rll file. Could it be because I haven't upgraded to sp2 or ???
Please... |
| Forum: MS SQL Sep 11th, 2008 |
| Replies: 3 Views: 2,299 Would someone be able to tell me by looking at this if SQL 2005 server installed correctly.....Should I also have a default database on here.....Help anyone????
SQL2008
The following... |
| Forum: MS SQL Sep 11th, 2008 |
| Replies: 3 Views: 2,299 Can anyone please help me.........I am at a loss.
I am trying to install sql 2005 server on a windows 2003 server and am getting an installation error. The error states that there was an... |
