Connecting SQL Server to DW

[Mike1500]

Hello I'm

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: [url]http://xx.xx.xxx.x/Wwwroot/test_site/[/url]

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

[CMBergin]

Check your database permissions. If you don't have SELECT permission on a
table, it won't appear in the list. Same goes for stored procedures and
EXECUTE permission. Make sure that the account you're using to connect with
in your connection string is the account that has the permissions.

If you really want to make sure it's not permissions, temporarily set the
connection string to use the 'sa' user. If you can see your tables then,
you know you have a permission problem. If not, you know there's some other
problem.

"Mike1500" <webforumsuser@macromedia.com> wrote in message
news:cv2iu4$irr$1@forums.macromedia.com...

> Hello I'm
>
> 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: [url]http://xx.xx.xxx.x/Wwwroot/test_site/[/url]
>
> 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
>
>
>