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-01-03 : 10:03:36
|
| J.D. writes "I am hosting my website (with SQL 7) at a hosting company. The site is all ASP against SQL 7, I have Enterprise Mgr on my computer that connects to my local DB. The guys at the hosting place tell that i can direct my Enterprise Mgr to point to the SQL server DB on their Server. How do i do this? i looked it up an it gave some info but not enough to make it work.Please help.J.D." |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-01-03 : 10:10:33
|
| HiIn your ASP app you would be specifying a database.Is this (local) ? or a specific address ?If it is local, you would just specify the address of the web server when you register a server in enterprise manager, otherwise use the address you connect to in your ASP.To register a server in EM, right click in there somewhere and choose "Register SQL Server"Hope that helpsDamian |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-01-03 : 14:46:39
|
| This may not be necessary, but I like to have things named, so I use the SQL Client Network Utility to create an alias for the server. Choose TCP/IP Library, and in the Connection Properties\Server Name area, enter the IP Address of the server. The default port number for SQL Server is 1433. Then when you go to Register this server in Enterprise Manager it should show up in the list of available servers. If not, type in the alias name and proceed with the registration process.--------------------------------------------------------------1000 Posts, Here I come! I wonder what my new title will be... |
|
|
|
|
|
|
Enterprise Mgr to SQL SERVER over the web