Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gm
Starting Member
1 Post |
 Posted - 2010-05-05 : 13:56:01
|
| we have an SQL server 2008 server that communicates with sharepoint 2007 server.The communication between both servers works fine,except the search functionality .By investigating we found that sql server agent stopped.we cant get it to start working.The error message gives an unhandled exception with some stack errors.has anyone faced this problem before |
|
|
phendark
Starting Member
1 Post |
Posted - 2010-05-06 : 22:05:17
|
Ya...i got quite similar problem. My SQL Server Agent cannot started. How can I solve this problem? Btw, here the error log message:2010-05-07 09:42:19.88 spid53 Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.2010-05-07 09:42:19.88 spid53 FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'AKMALSQL'. -------------------------------------Because There's Always More To Learn------------------------------------- |
 |
|
|
vmenon
Starting Member
17 Posts |
Posted - 2010-05-14 : 01:30:12
|
| gm, please can I request you to post the error message here. Without the error message it is a bit difficult to provide a solution.phendark, please can you try out the below and see if this works for you.To get filestream enabled, proceed by opening the SQL Server Configuration Manager tool.Click on SQL Server Services on the left hand side of the pane.In the SQL Server Configuration Manager snap-in, locate the instance of the SQL Server on which you want to enable FILESTREAM.Right-click the instance and then click Properties.In the SQL Server Properties dialog box, click the FILESTREAM tab.Select the Enable FILESTREAM for Transact-SQL access check box.If you want to read and write FILESTREAM data from Windows, click Enable FILESTREAM for file I/O streaming access. Enter the name of the Windows share in the Windows Share Name box.If remote clients must access the FILESTREAM data that is stored on this share, select Allow remote clients to have streaming access to FILESTREAM data. Click Apply.Execute the below code in the query window on the concerned SQL isntanceEXEC sp_configure filestream_access_level, 2RECONFIGUREGO |
|
|
|
|
|
|
|
|
SQL Server Agent does not start