Connecting SQL Server to DW
Guest
Posts: n/a
Posts: n/a
I have a project that is due shortly and I have been trying for about a week
to connect SQL Server with DW with no success. I have read about the entire
database connection problem in this forum, mine still not working. I'm in
desperate need of help...Below are the steps that I have taken to try to
connect sql server and DW. Please take a look at the step to make sure that it
is correct. Also if you have a better way please let me know. Thanks.
Manage Sites (Section)
Local Info
Site name: Test_Site
loacl root folder: C:\Website\Test_Site\
(checked "refresh local file list automatically")
Remote Info
Access: Local/Network
Remote folder: w:\wwwroot\Test_Site\
(checked "refresh local file list automatically")
Testing Server
Server model: ASP.NET VB
Access: Local/Network
Testing server folder: w:\wwwroot\Test_Site\
(checked "refresh local file list automatically")
URL perfix: http://xx.xx.xxx.x/Wwwroot/test_site/
Application (Section)
Database (Tab)
SQL Server Connection
Connection name: Conn_Test_Site
Connection string: Persist Security Info=False;
Data Source=[xx.xx.xxx.x];
(on the remote server)
Initial Catalog=[Test_Database]; (on the remote server)
When I connect the database to DW it does not show the tables. Below are some
important information.
- I use the Enterprise Manager on my desktop to connect to SQL Server, the
server ip
address is xx.xx.xxx.x
- I have IIS installed on the same box SQL Server is installed on. (Both are
on remote site)
- I?m running Windows 2000 Professional on my desktop.
- DW is installed on my desktop
Linear Mode
Posts: n/a