By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,413 Members | 1,594 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,413 IT Pros & Developers. It's quick & easy.

Remote server Problem in Sql server 2005

P: 49
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.

Jul 15 '09 #1
Share this Question
Share on Google+
3 Replies

P: 10
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
Jul 15 '09 #2

P: 49
Thanks.I will try now.
Jul 17 '09 #3

P: 3

i was facing the error when opening connection using sqlconnection

nw got solved


See This
Jul 22 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Browse more Microsoft SQL Server Questions on Bytes