problem in running SQL Manager - Using the VEM project - Web, Cloud & Mobile Applications Delivery and Migration Platform

.net html5 web/cloud/mobile app delivery

Search Forum Home

Forum Community Devel... Using the VEM p... problem in running SQL Manager

3/8/2007 4:16 PM

	suneelp
11 posts

problem in running SQL Manager

Hi:

I am unable to logon to VEM.

- Checked that my sql server is running
- Allowed remote connections

- Changed the connectionstring in web.config to
<sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="Provider=SQLOLEDB;Data Source=MYLAPTOP\SQLEXPRESS;Trusted_Connection=yes;User Id=;Password=" cookieless="false" timeout="20"/>

I am getting following error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Any help would be appreciated. thx

Thanx

Cheers Sunny

3/9/2007 3:05 AM

	Guy
2346 posts

Re: problem in running SQL Manager

Hi,

In order to change the connection string you should not change the session state connection. This is for changing the default session storage which we currently do not support. You should look into the Gizmox.WebGUI.SQLManager.Site\Resources\Data\SQLManager.xml configuration file which allows you to define multiple database connections combining them on the same management console. You will find in this file a connection string template which is used in-order to connect to the database.

Sincerely,
Guy

5/4/2007 2:27 PM

	zheka
5 posts

Re: problem in running SQL Manager

Guy wrote

Hi,

... You should look into the Gizmox.WebGUI.SQLManager.Site\Resources\Data\SQLManager.xml configuration file which allows you to define multiple database connections combining them on the same management console. You will find in this file a connection string template which is used in-order to connect to the database.

Sincerely,
Guy

What do I have to add to this file, Guy, to be able to login to VEM let's say to master or msdb databases.

5/5/2007 8:25 PM

	Guy
2346 posts

Re: problem in running SQL Manager

Hi,

You need to update the connection string template to include the right connection string params. You do not need to include the user name and password as it is replaced in run time with the values entered in the login screen.

Thanks,
Guy