connection string

hello!

i migrated from USA server to UK server and i want to ask how the connection string must be??

i have this..

"Data Source=tcp:esql2k502.discountasp.net;Initial Catalog=SQL2005_750385_vagelis;User ID=SQL2005_750385_vagelis_user;Password=...;"

is that right??

 

...This is the recommended format, contains examples of over-riding the default and adding a VS custom.

<connectionStrings>
<clear />
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=tcp:sql.discountasp.net;Initial Catalog=SQL_numid_account;User ID=SQL_numid_user;Password=pw_here"
providerName="System.Data.SqlClient" />
<add name="SQL2005_msftwise_userConnectionString" connectionString="Data Source=tcp:sql.discountasp.net;Initial Catalog=SQL_numid_account;User ID=SQL_numid_user;Password=pw_here"
providerName="System.Data.SqlClient" />
</connectionStrings>

 

i use the connection string in global asax so it is another method
i have correctly the connection string because i see that in my localhost the conection plays
so no problem
i posted that because i have an error in the server and it doesnt tell me which error is
and i guessed that it was from connection string

 

What error are you getting on your page? we'd need to know to tell you what to do next

 

Login failed for user 'SQL2005_750385_vagelis_user'.

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: System.Data.SqlClient.SqlException: Login failed for user 'SQL2005_750385_vagelis_user'.


this is the error..

 

Solved in another thread

http://community.discountasp.net/showthread.php?t=11373