Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

IPCC Express Version 7 SQL Access


We are trying to build a web app, in ASP .net

but are having problems connecting to the Sql Server instance on the IPCC Server.

The error appears to be related to the fact that the SQL server is not allowing remote connections.

Usually this is fixed by going into SQL server Surface area configuration manager and allowing remote connections.

This is not available on the server.

Does anyone know how to enable remote connections,or how to configure this or the connection string to use user/password etc. ?

1 ACCEPTED SOLUTION

Accepted Solutions
Super Bronze

Re: IPCC Express Version 7 SQL Access

Hi

First thing is that the SQL server is not a default instance, it's a named instance called CRSSQL. You would connect to servername\CRSSQL in this case...

Secondly it only accepts Windows authentication. This can be problematic in scenarios where the SQL server is not in a domain.

To authencate to the DB, follow the steps I outline in this post : https://supportforums.cisco.com/message/1211272#1211272

Once you have SQL Enterprise Manager installed it's quite easy to set up, if you don't have it you can google how to do it with osql (the command line SQL admin tool).

Regards

Aaron

Please rate helpful posts...

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
3 REPLIES

Re: IPCC Express Version 7 SQL Access

Install the sql 2000 enterprise manager tools in the ipcc server.

Gabriel.

Super Bronze

Re: IPCC Express Version 7 SQL Access

Hi

First thing is that the SQL server is not a default instance, it's a named instance called CRSSQL. You would connect to servername\CRSSQL in this case...

Secondly it only accepts Windows authentication. This can be problematic in scenarios where the SQL server is not in a domain.

To authencate to the DB, follow the steps I outline in this post : https://supportforums.cisco.com/message/1211272#1211272

Once you have SQL Enterprise Manager installed it's quite easy to set up, if you don't have it you can google how to do it with osql (the command line SQL admin tool).

Regards

Aaron

Please rate helpful posts...

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
New Member

Re: IPCC Express Version 7 SQL Access

Many thanks Arron,I will work on this with our Dev Guys, Thanks for the Quick response.

Richard

329
Views
0
Helpful
3
Replies