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 |
|
slihp
Yak Posting Veteran
61 Posts |
 Posted - 2011-07-06 : 06:45:27
|
| 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? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2011-07-06 : 06:57:23
|
Management Studio as nothing to do with connectivity. Period.If you cannot see the SharePoint DB, it's more likely1) The remote machine doesn't have SQL Browser running2) You don't have permissions to access the server or database
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
slihp
Yak Posting Veteran
61 Posts |
Posted - 2011-07-06 : 07:39:14
|
| 1) Sql Browser is running on the server2) Im in the domain admin users groupi can connect to the sql server and even see the sql express instance that is also running on the server but can see the share point instance on it. |
|
|
|
|
|
|
Cant get access to the sharepont 2.0 database