Remote server Problem in Sql server 2005

[nagmvs]

Hai when i try to connect dataabse to my vs 2005 project it shows one error :

An error has occurred while establishing a connection to the remote server...this failure may be caused by the fact that under default settings SQL Server does not allow remote connections (error: 25 - Connection string is not valid)".

so please help me to resolve my problem as soon as possible.

Thanks,

[pankajvtcse]

Connection string is not valid: might this is because of user name or password is wrong.
To create authenticated user you need to create a LOGIN in remote server and provide permmissions for particular DATABASES.

Then follow the points on remote sql server :
1.START-> All Programs ->Sql server 2005 -> Configuration tools->
Sql Server Suface area Configurations.
2.Click Surface area configuration for features.
3.Under dtabase Engine tree Click Remote Connection and enable with any
option ( select option with both) .
4.Click OK. Then restart service.
Now try to connect to remote server using server authentication.

-Pankaj Tambe

[nagmvs]

Thanks.I will try now.

[Sumachechi]

Hi

i was facing the error when opening connection using sqlconnection

nw got solved


http://sqlservererror-info.blogspot....ablishing.html

http://aspnetmembershipprovider.blog...ablishing.html


See This