This is a migrated thread and some comments may be shown as answers.

Can use full install of SQL Server 2008 instead of Express version.

3 Answers 138 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Harry
Top achievements
Rank 1
Harry asked on 14 Jun 2011, 11:56 AM
Is it possible to use the full install of SQL Server 2008 for the  Telerik Sales Dashboard demo website instead of SQL EXPRESS version?

if so, what connection string do I use in the web.config file?

Thanks

3 Answers, 1 is accepted

Sort by
0
Georgi Tunev
Telerik team
answered on 14 Jun 2011, 01:13 PM
Hi Harry,

The application is configured to connect to the (local)\SQLEXPRESS instance by default.
If your SQL Server is using a different instance name update the connection string and
Open Access configuration in web.config. Since you are using SQL 2008, make sure that the connection string is set to your SQL 2008 Server name.




Greetings,
Georgi Tunev
the Telerik team

Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.

0
Harry
Top achievements
Rank 1
answered on 14 Jun 2011, 01:57 PM
Hi Georgi, thanks for your reply.

1. I have installed SQL Server Express version
2. Imported the Northwind.mdf database

But when I launch the web site I get the following error:

Server Error in '/Telerik.SalesDashboard.Web' Application.

The client was unable to establish a connection because of an error during connection initialization process before login. Possible causes include the following:  the client tried to connect to an unsupported version of SQL Server; the server was too busy to accept new connections; or there was a resource limitation (insufficient memory or maximum allowed connections) on the server. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: Telerik.OpenAccess.RT.sql.SQLException: The client was unable to establish a connection because of an error during connection initialization process before login. Possible causes include the following:  the client tried to connect to an unsupported version of SQL Server; the server was too busy to accept new connections; or there was a resource limitation (insufficient memory or maximum allowed connections) on the server. (provider: Named Pipes Provider, error: 0 - No process is on the other end of the pipe.)

Source Error: 

Line 116:			Database db = Database();
Line 117:
Line 118:			IObjectScope newScope = db.GetObjectScope();
Line 119:			return newScope;

Please can you help me solve this issue, It is really important that I evaluate these controls.

Thanks
0
Zoran
Telerik team
answered on 16 Jun 2011, 05:34 PM
Hi Harry,

 This error means that you are trying to use the Named Pipes protocol in order to comunicate with the SQL Server(This behavior is the default and correct one when you use database .mdf files that are not previously attached to the SQL Server instance). 

In order to enable the Named Pipes protocol you should use the Sql Server Configuration Manager which you can start from the start menu entry for SQL Server. You can also start it from the mmc.exe executable which you can find in the C:\Windows\SysWOW64 folder.

After starting this tool, you should expand the "Sql Server Network Configuration" node and select "Protocols for SQLEXPRESS". On the right side of the window you can set the status of Named Pipes to Enabled.

Best wishes,
Zoran
the Telerik team

Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.

Tags
General Discussions
Asked by
Harry
Top achievements
Rank 1
Answers by
Georgi Tunev
Telerik team
Harry
Top achievements
Rank 1
Zoran
Telerik team
Share this question
or