Connecting database to my SQL Server Enterprise manager

[pradyuman]

Hi all,

I have written many stored procedure in AbleCommerce 7.0 default database, now I want to make connection to my client's online database and want to fire all store procedure.

What I need to connect my online database to my sqlserver Enterprise manager (Sql Server Management Studio).

As connectin string is there in Database.config file in Encrypted form....

Thank You

[AbleMods]

You can find the connection string in the Security, Database menu option on the Admin side. You can also unencrypt it there so it can be read with any text editor in the database.config located in ~/App_Data/.

[pradyuman]

Can anyone tell me encryption logic for connection string....?

so can get username, password and initial catalog...

[AbleMods]

I'm unclear where you're going with your request. If you're looking to modify the existing AC7 database.config to include an additional SQL connection string, simply decrypt it on the admin side using the Security, Database decrypt option and you can then make your modifications.

After that, you can then either re-encrypt it using the same admin-side menu option or simply leave it unencrypted (not recommended but possible).

If you're looking to unencrypt the file from outside AC7 program files, I don't believe that's possible. That would rather defeat the purpose of encrypting it in the first place.

[pradyuman]

Hi
I got user name and password of my database, but when I tried to connect same database with my SQL Server Management Studion it gives Error Message........ I have made many Stored Procedures under my database, I want to fire same to my online database....

TITLE: Connect to Server
------------------------------

Cannot connect to 172.16.229.113.

------------------------------
ADDITIONAL INFORMATION:

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) (Microsoft SQL Server, Error: 53)

For help, click: http://go.microsoft.com/fwlink?ProdName ... nkId=20476

------------------------------
BUTTONS:

OK
------------------------------

[mazhar]

If you are in shared hosting then ask your hosting provider about the problem otherwise if you have local server then go to the SQL Server Configuration Wizard and then set the remote connections to both TCP/IP and named pipes.