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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-04 : 00:41:33
|
| Mike writes "Please excuse this very 'newbie' question, but I am not a SQL DBA, I am unsure even of the correct question to ask!I have SQL 2000 installed on my local network and I have constructed a website which connects to a database on my (local) SQL server.I am now ready to go live and my provider has setup a SQl database with the same name as mine and a login and pass.It might seem stupid to you but how do I connect to this remote databse? What do I need , Just the login and pass? How do I point it to the database?Please help me.MikeTIA" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-04 : 08:39:38
|
| In addition to a login and password, you also need to indicate the IP address of the remote server that you want to connect to. If you're using ADO for data access, you'll need a connection string like this:"Provider=SQLOLEDB;Data Source=123.123.123.123;User ID=loginName;Password=password;Initial Catalog=database"The Data Source portion of the connection string is where you'd put the IP address. You also need to ensure that the remote SQL Server is using the TCP/IP netword library by default. |
 |
|
|
jackstow
Posting Yak Master
160 Posts |
Posted - 2002-02-04 : 09:19:32
|
| You're also going to need to get your tables etc up to the live database I presume. Either disconnect the database and FTP it up to the web server and then reconnect it or use the 'Copy Database Wizard' in Enterprise Manager. You'll need to register the database first so you can connect to it.Jack |
|
|
|
|
|
|
SQL 2000 over the internet