3 party application

Hey
Does anyone use the application "PROMODAG" in their
network? If so can anyone tell me how to optimize the
database the application creates on sql server?
Another question would be, before it imports from the
logs, if i remove any indexes it may have as well as
primary keys, will this affect the application? I have
tryed to look stuff up on the net but found nothing... any
advice is welcome!I don't know PROMODAG personally, but removing the PKs & indexes from any
database will degrade performance for any application. If you're performing
a regular data load & no users are on the system whilst the PKs & indexes
are removed, this might help the load process, but you'd almost certainly
need to replace those PKs & indexes after the load.
HTH
Regards,
Greg Linwood
SQL Server MVP
"" <anonymous@.discussions.microsoft.com> wrote in message
news:fe8301c411b9$97d0ec10$a601280a@.phx.gbl...
> Hey
> Does anyone use the application "PROMODAG" in their
> network? If so can anyone tell me how to optimize the
> database the application creates on sql server?
> Another question would be, before it imports from the
> logs, if i remove any indexes it may have as well as
> primary keys, will this affect the application? I have
> tryed to look stuff up on the net but found nothing... any
> advice is welcome!

26 - Error Locating Server/Instance Specified

Hi,

Have installed the club site starter kit on my pc and all it works well locally. I've used visual studio to publish my site to my third party webhost. Ive created the DB on their server and altered the connection string to:-

<

connectionStrings><!--<add name="ClubSiteDB" connectionString="Server=xx.xx.xx.xx;Database=somedatabasename;User ID=user;Password=Password;Trusted_Connection=False" providerName="System.Data.SqlClient"/>-->

</

connectionStrings>

Now its on the webhosts server i get a System.Data.SqlClient.SqlException: 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified).

This occurs when im trying to login in or register.

Can any one help.

Hi Ballantyne

This one usally means that your connection string is wrong - what to do is create a txt file on the web server and then rename it test.udl - now double click it and put in the details to the server and make sure you can connect to the database using the details your storing in your connection string.

Cheers
Gregor

|||

First make sure your connection string is correct.

CheckSQL Server Troubleshooting to set everything properly.

If problem still exists make sure no firewall blocks your connection.

Hope it helps.