March 11, 2010 at 1:54 pm
And the agent service is unable to start, correct?
Do you have some error messages in the Security event log, failure events that correlate to when you try to start the agent service?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 1:59 pm
4data (3/11/2010)
Hi Jason, thanks for the hint towards the account used to run the services. Both services log on using the Local System Account, which I guess has no password. Is this right, or should they be logging on with a different one - maybe this is where the issue is??REALLY Grateful to everyone for your help.
4Data
4Data, don't rush go through this knowledge based article, do step by step.
http://support.microsoft.com/kb/823287
It has security settings information also.
March 11, 2010 at 2:31 pm
Hi GTR, thanks for the link.
I've been going through it, step by step.
I've got to the second part of 'method 3', where it tells me to double click the server in Enterprise Manager.
Now, I don't have Enterprise manager, but do have this Sql Server Management Studio express.
I've found it shows me the same sort of info, but when I double click on my "SERVER\Sharepoint" entry, it sits there for 15 seconds, and then comes up with
"TITLE: Microsoft SQL Server Management Studio Express
------------------------------
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Any ideas?
March 11, 2010 at 2:45 pm
Are you doing this from local machine or remote client? what is the result when you run this query?select name, status, status2 from sys.sysdatabases
March 11, 2010 at 2:51 pm
GTR (3/11/2010)
Are you doing this from local machine or remote client? what is the result when you run this query?select name, status, status2 from sys.sysdatabases
The instance is currrently not available. This query is not going to help right now. He is unable to get into the instance through SSMS for the SharePoint instance.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 2:59 pm
Now, I don't have Enterprise manager, but do have this Sql Server Management Studio express.
I've found it shows me the same sort of info, but when I double click on my "SERVER\Sharepoint" entry, it sits there for 15 seconds, and then comes up with
"TITLE: Microsoft SQL Server Management Studio Express
------------------------------
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Any ideas?
OP mentioned he can login to SSMS correct?
March 11, 2010 at 3:04 pm
GTR (3/11/2010)
Now, I don't have Enterprise manager, but do have this Sql Server Management Studio express.
I've found it shows me the same sort of info, but when I double click on my "SERVER\Sharepoint" entry, it sits there for 15 seconds, and then comes up with
"TITLE: Microsoft SQL Server Management Studio Express
------------------------------
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Any ideas?
OP mentioned he can login to SSMS correct?
He can get into SSMS, but not onto that Instance - look at the error.
He has multiple instances on this server - only the Sharepoint is not working.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 3:20 pm
In your list of Windows Services, look for the service specific to your 'SHAREPOINT' instance. It will say
SQL Server (SHAREPOINT)
If this isn't running, you won't be able to connect (as is evidenced by your post). This is the root of your problem.
To get your service running will then be the issue. As stated, check to see if the 'SQL Server Browser' service is running. It won't be instance specific.
Just a guess, but since your Sophos software is anti-virus, it could manipulate your firewall also. When you use a named instance for SQL Server, you'll communicate on a different port than the default instance. Go into SQL Server Configuration Manager, open the 'SQL Server 2005 Network Configuration' node, choose 'Protocols for SHAREPOINT', then right click the 'TCP/IP' node. Check the 'IP Addresses' tab. Scroll to the bottom and look at the 'IPAll' section. You're either using 'TCP Dynamic Ports' or a static 'TCP Port', make sure that you're not blocking the port.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
March 11, 2010 at 3:29 pm
Thanks Dan.
That is an excellent item to bring up. Sophos quite possibly altered some firewall settings (if you have Windows Firewall enabled).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 3:29 pm
CirquedeSQLeil (3/11/2010)
GTR (3/11/2010)
Now, I don't have Enterprise manager, but do have this Sql Server Management Studio express.
I've found it shows me the same sort of info, but when I double click on my "SERVER\Sharepoint" entry, it sits there for 15 seconds, and then comes up with
"TITLE: Microsoft SQL Server Management Studio Express
------------------------------
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Any ideas?
OP mentioned he can login to SSMS correct?
He can get into SSMS, but not onto that Instance - look at the error.
He has multiple instances on this server - only the Sharepoint is not working.
Ok, i think i overlooked at it. Then i think Check that instance name in services it may not be running, i was thinking only single instance on this machine, had heavy lunch.:hehe:
March 11, 2010 at 3:38 pm
GTR (3/11/2010)
Ok, i think i overlooked at it. Then i think Check that instance name in services it may not be running, i was thinking only single instance on this machine, had heavy lunch.:hehe:
Easy enough to do. 😀
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 11, 2010 at 3:40 pm
My port suggestion only makes sense if the service is running (in the Windows Service list) but can't be connected to thru SSMS.
If the service isn't running, go to the Windows Event Viewer and filter on SQLServer messages. Look for an error pertaining to why the service won't start, then post that error.
----------------------------------------------------------------------------
Sacramento SQL Server users group - http://sac.sqlpass.org
Follow me on Twitter - @SQLDCH
----------------------------------------------------------------------------
March 11, 2010 at 3:44 pm
Hey Dan, thanks for the input.
I've done as you siggest (Go into SQL Server Configuration Manager, open the 'SQL Server 2005 Network Configuration' node,) but under there I only have 'Protocols for ACT7' and 'Protocols for SOPHOS' Listed. No mention of Protocols for Sharepoint.
What does that mean? Sorry I'm so dim at all this.
I am SO greatful to all of you for this help!
4Data
March 11, 2010 at 3:46 pm
Dan H. (3/11/2010)
My port suggestion only makes sense if the service is running (in the Windows Service list) but can't be connected to thru SSMS.If the service isn't running, go to the Windows Event Viewer and filter on SQLServer messages. Look for an error pertaining to why the service won't start, then post that error.
I think OP shouls start services first, if it is not running. Then look for event logs for error messages, From there we can proceed to next steps (network settings and security settings)
March 11, 2010 at 3:51 pm
4data (3/11/2010)
Hey Dan, thanks for the input.I've done as you siggest (Go into SQL Server Configuration Manager, open the 'SQL Server 2005 Network Configuration' node,) but under there I only have 'Protocols for ACT7' and 'Protocols for SOPHOS' Listed. No mention of Protocols for Sharepoint.
What does that mean? Sorry I'm so dim at all this.
I am SO greatful to all of you for this help!
4Data
Ok, at this point call support don't waste time, did you check the services in windows as Dan mentioned.
Viewing 15 posts - 16 through 30 (of 48 total)
You must be logged in to reply to this topic. Login to reply