Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chikitha5466
Starting Member
3 Posts |
 Posted - 2006-08-31 : 20:27:12
|
| Hi all, I am new to SQL Server but I'm trying to learn it.. :)I've created a database on my campus server. Now I want to configure it so that I can access the database from my laptop computer through internet. I have an account in the SQL server installed on my remote server. I can connect to the remote server through remote connection.I appreciate your help,thank you,chikitha5466 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-08-31 : 20:35:17
|
| what is the error that you get?-ec |
 |
|
|
chikitha5466
Starting Member
3 Posts |
Posted - 2006-08-31 : 20:47:28
|
| On my local system, I'm developing a ASP.NET application. I tried to add connection to the Data connections by giving the server name, server username & password and the database name. But, it shows error.The Error is as follows:An error has occured while establishing connection to the server. When connecting to SQL Server 2005, this failure may be caused due to the fact that under default settings SQL Server does not allow remote connections. (Provider Named Pipes Provider , error: 40 - could not open connection....)i have the administrator rights on my remote sql server. So, do i need to change any settings on the remote sql server?Also, this database is basically created on my local system. Then I copied this database to the server. Here is the way I copied:--Detached the database on my local server, --copied the .mdf, and .ldf files to the remote server through ftp.--Attached the database to the databasesthank you, |
|
|
|
chikitha5466
Starting Member
3 Posts |
Posted - 2006-09-01 : 16:52:41
|
quote:
Originally posted by chikitha5466
On my local system, I'm developing a ASP.NET application. I tried to add connection to the Data connections by giving the server name, server username & password and the database name. But, it shows error.The Error is as follows:An error has occured while establishing connection to the server. When connecting to SQL Server 2005, this failure may be caused due to the fact that under default settings SQL Server does not allow remote connections. (Provider Named Pipes Provider , error: 40 - could not open connection....)i have the administrator rights on my remote sql server. So, do i need to change any settings on the remote sql server?Also, this database is basically created on my local system. Then I copied this database to the server. Here is the way I copied:--Detached the database on my local server, --copied the .mdf, and .ldf files to the remote server through ftp.--Attached the database to the databasesthank you,
Can anyone please solve my problem....any help is appreciated,thank you-Chikitha5466 |
|
|
|
|
|
|
|
|
Configuring SQL Server for remote connection