Connecting the Management Console of SQLExpress Edition of SQL Server through Management Studio:
When we install WSS 3.0 (Windows Sharepoint Services 3.0 on a Standalone machine, it installs the SQL Embedded Version of MS SQL Server to use as back end database server. When we try to connect this SQL server via Management Studio,
It gives us following error.
Reason :
Because this version of SQL server ( Embedded Edition) is installed by Sharepoint, the SQL server Management studio does not consider it as fully supported SQL server. That's why you can not connect the backend database server (SSEE) via Management Studio by simply typing the server name or its IP Address.
Solution :
To connect the Embedded version of SQL Server (installed by Sharepoint) via Management studio, you need to use named pipes address as following :
1. Open the Management studio (With Farm Admin or SA login) on the machine where Sharepoint has installed the express version of SQL Server.
2. Put exactly following Named Pipes Address in the Server Name box :
np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
3. Just click Connect and you will be able to see the Databases configured by Sharepoint on its local version of Express Edition.
4. You can carry out all required operations from here provided you have Admin access on all databases.
ENJOY !!!!!
When we install WSS 3.0 (Windows Sharepoint Services 3.0 on a Standalone machine, it installs the SQL Embedded Version of MS SQL Server to use as back end database server. When we try to connect this SQL server via Management Studio,
It gives us following error.
============
ERROR MESSAGE
============
Cannot connect to SERVER\MICROSOFT##SSEE.
===================================
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) (.Net SqlClient Data Provider)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476
------------------------------
Error Number: -1
Severity: 20
State: 0
------------------------------
Reason :
Because this version of SQL server ( Embedded Edition) is installed by Sharepoint, the SQL server Management studio does not consider it as fully supported SQL server. That's why you can not connect the backend database server (SSEE) via Management Studio by simply typing the server name or its IP Address.
Solution :
To connect the Embedded version of SQL Server (installed by Sharepoint) via Management studio, you need to use named pipes address as following :
1. Open the Management studio (With Farm Admin or SA login) on the machine where Sharepoint has installed the express version of SQL Server.
2. Put exactly following Named Pipes Address in the Server Name box :
np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
3. Just click Connect and you will be able to see the Databases configured by Sharepoint on its local version of Express Edition.
4. You can carry out all required operations from here provided you have Admin access on all databases.
ENJOY !!!!!
Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work. running track resurfacing, athletics track flooring
ReplyDelete