July 6, 2011 at 9:21 am
Our intranet server has sharepoint service 2.0 installed on it there is also an instance of sql express installed on the server. when i try to connect to sql server using management studio from my machine i can only get visibility of the sql express instance the server dosent have anything that would allow me to connect to the sharepont db. without installing Management studio on the server how can i connect to this database?
July 6, 2011 at 9:49 am
The instance hosting the SharePoint databases may not be configured to allow remote connections.
The section titled Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition in this article may help: http://support.microsoft.com/kb/914277
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 6, 2011 at 9:56 am
ye i realized that but i cant access the instance to enable it to allow remote connections, if that is what it is.
July 6, 2011 at 10:02 am
ps_vbdev (7/6/2011)
ye i realized that but i cant access the instance to enable it to allow remote connections, if that is what it is.
You don't need to access the instance to enable remote connections. You do however need physical console access, Remote Desktop access or some kind of remote execution privileges however. Please have a look at the article I linked you to in a previous post.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 7, 2011 at 2:09 am
Sorry when i said access the instance i did of course mean through using the surface area configuration tool where you can enable remote connections. I have only got visibility of the sql express instance installed on the server when i run this tool. Unless there is another way of doing this/checking it
July 7, 2011 at 6:32 am
Are you in the sysadmin Server Role in the Express instance? And is the Windows Service running the Express instance a local administrator? If yes to both then you may be able to invoke xp_CmdShell to change settings on the server itself...this line of thinking is starting to appear as if you're trying to hack into a server...
What's wrong with asking someone for access to this server?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 7, 2011 at 7:15 am
I DO HAVE ACCESS TO THE SERVER. I dont have access to the share point DB on it. The reason i want access to it is to set up a back up strategy for the DB, which has to be done using sp's and batch files. You don't have to reply anymore as they are useless but thanks anyway.
July 7, 2011 at 8:00 am
Settle down. We're just having some terminology challenges that's all. The configuration manager will show you all instances on the machine. Just because SharePoint services is installed on a machine does not mean there is also a database instance associated with it on that same machine. If you're not seeing the instance listed in the configuration manager then you're looking on the wrong server for the databases.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply