https://www.iotap.com/wp-content/uploads/2019/02/iotap_logo_transparent-2.png 0 0 kjawale https://www.iotap.com/wp-content/uploads/2019/02/iotap_logo_transparent-2.png kjawale2008-11-11 13:04:292019-10-14 12:02:47Cannot Connect to Windows SharePoint Services (WSS) Internal Database Microsoft##SSEE
Cannot Connect to Windows SharePoint Services (WSS) Internal Database Microsoft##SSEE
When stand-alone WSS is installed on a machine which doesn’t have SQL 2005 standard edition or higher installed, the setup installs a special embedded edition of SQL Server with an instance name Microsoft##SSEE. By default settings, this SQL server is not exposed to the outside world and you will not be able to connect to it from management studio. But there might be situations which require connecting to this embedded SQL server. Following steps explains this process.
- Open SQL Configuration Manager from Programs -> Microsoft SQL Server 2005 -> Configuration Tools.
- Expand the SQL Server 2005 Network Configuration node.
- Right, click on Protocols for the Microsoft##SSEE instance and select properties.
- From the properties window that shows up select HideInstance property and changes its value to No.
- Click OK to close the properties window.
- Restart the embedded Microsoft##SSEE SQL server instance using the Surface Area Configuration Tool.
- Now you will be able to connect to the WSS embedded Microsoft##SSEE SQL server instance from SQL server management studio using windows authentication.