CF And SQL Server
Hey, I got a question about setting up seperate DB and CF servers. Currtnly im running SQL 7 and CF4.51 on NT/SP6 on the same machine. I wish to put SQL on its own server. My question is network traffic, as since they are on seperate machines, ALL DB activity has to go through the network, which is 100 MB. Is it better to allow it to go over the 'normal path' through the switch to the other machine? Or am I better off setting up a patch cable between the two spare NICs on the servers, hence a private network between the two machines. What routing requirements and other network issues would I have in using a private network. Could I tell NT that all request for the other server to go over the private link? I know I can do simular things with linux using routed and hosts. It seems like it would make a bunch of sense, since that traffic wouldnt have to shuffle accross the same wire that my customers come though. thanx David -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF And SQL Server
What is network utilization looking like between the CF server and switch port? Unless your utilization is peaking to higher than 75% then I wouldn't think your going to have to much of a problem. IMHO, I'd keep things simple and use the existing network. Bill -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF And SQL Server
I have done it both ways, a separate network for the sql and webservers and allowing SQL and CF to go over the "normal path". After testing and monitor, I saw no difference. We have an 100MB network between the servers and switches. But we have only 15MB of bandwidth provided to us. So this, in theory, leaves us with 85MB. Keeping SQL and CF on the same network with the internet traffic did not cause any slowdowns and network congestion. Jacob At 10:43 AM 8/14/00 -0500, you wrote: >Hey, >I got a question about setting up seperate DB and CF servers. Currtnly im >running SQL 7 and CF4.51 on NT/SP6 on the same machine. I wish to put SQL on >its own server. > >My question is network traffic, as since they are on seperate machines, >ALL DB >activity has to go through the network, which is 100 MB. > >Is it better to allow it to go over the 'normal path' through the switch >to the >other machine? Or am I better off setting up a patch cable between the two >spare NICs on the servers, hence a private network between the two machines. > >What routing requirements and other network issues would I have in using a >private network. Could I tell NT that all request for the other server to go >over the private link? I know I can do simular things with linux using routed >and hosts. > >It seems like it would make a bunch of sense, since that traffic wouldnt have >to shuffle accross the same wire that my customers come though. > >thanx >David >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF and SQL Server Cluster
Hi! Any idea how CF Ent. 4.5.1 should deal with a failover occurring on a SQL Server cluster? It seems that always after a failover, CF is loosing the ODBC connection. Only restarting CF resolves the problem. Here are the error messages: ODBC Error Code = 01000 (General warning) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send()). ODBC Error Code = 08S01 (Communication link failure) [Microsoft][ODBC SQL Server Driver]Communication link failure Additional info: . CF server is running Win2K, MDAC 2.5, Maintain database connections "yes" . SQL Server 7.0 SP2, NT4 Thanks in advace, Marcello Frutig. -- Astrolabio -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF and SQL Server split
I would really appreciate it of someone would give me a hand with this one... I have a server running IIS 4.0, CF 4.01, and SQL Server 7.0. I want to remove IIS and CF from that server and install it on a separate server. The catch is that the two servers (both NT 4) are in different domains (not trusted). Is there a way to connect the two machines so that the CF server can access the SQL data sources? Caution: I am an intermediate that has never done cross-server or cross-domain communication. Thanks, Rob -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF and SQL Server Cluster
how is your SQL Server clustered? Is it active/active, active/passive, etc? Sounds like an issue with how the cluster is set up to talk to CF - not necessarily a CF configuration issue? -Original Message- From: Marcello Frutig [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 13, 2000 4:04 PM To: [EMAIL PROTECTED] Subject: CF and SQL Server Cluster Hi! Any idea how CF Ent. 4.5.1 should deal with a failover occurring on a SQL Server cluster? It seems that always after a failover, CF is loosing the ODBC connection. Only restarting CF resolves the problem. Here are the error messages: ODBC Error Code = 01000 (General warning) [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionWrite (send()). ODBC Error Code = 08S01 (Communication link failure) [Microsoft][ODBC SQL Server Driver]Communication link failure Additional info: . CF server is running Win2K, MDAC 2.5, Maintain database connections "yes" . SQL Server 7.0 SP2, NT4 Thanks in advace, Marcello Frutig. -- Astrolabio -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: CF and SQL Server Cluster
Hi David, the configuration is active/active. Any idea or recommendation on how to set up the cluster? Thanks, Marcello. >how is your SQL Server clustered? Is it active/active, active/passive, etc? >Sounds like an issue with how the cluster is set up to talk to CF - not >necessarily a CF configuration issue? > >-Original Message- >From: Marcello Frutig [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, September 13, 2000 4:04 PM >To: [EMAIL PROTECTED] >Subject: CF and SQL Server Cluster > > >Hi! > >Any idea how CF Ent. 4.5.1 should deal with a failover occurring on a SQL >Server cluster? > >It seems that always after a failover, CF is loosing the ODBC connection. >Only restarting CF resolves the problem. Here are the error messages: > >ODBC Error Code = 01000 (General warning) [Microsoft][ODBC SQL Server >Driver][TCP/IP Sockets]ConnectionWrite (send()). >ODBC Error Code = 08S01 (Communication link failure) [Microsoft][ODBC SQL >Server Driver]Communication link failure > >Additional info: > >. CF server is running Win2K, MDAC 2.5, Maintain database connections "yes" >. SQL Server 7.0 SP2, NT4 > >Thanks in advace, >Marcello Frutig. >-- Astrolabio > > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or >send a message to [EMAIL PROTECTED] with 'unsubscribe' in >the body. > >-- >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF and SQL Server split
--9A550CA2DEBD45E5C2E080F0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi You can try to connect to SQL server as usual. On ODBC page, under sql server name, use sql server IP (xxx.xxx.xxx.xxx) instead of server name (DB1). Under username, use this format SQLDomainName\UserName and whatever the password for that user. Tinh Tran Event411.com "Robert M. Saxon, Jr." wrote: > I would really appreciate it of someone would give me a hand with this > one... > > I have a server running IIS 4.0, CF 4.01, and SQL Server 7.0. I want to > remove IIS and CF from that server and install it on a separate server. The > catch is that the two servers (both NT 4) are in different domains (not > trusted). Is there a way to connect the two machines so that the CF server > can access the SQL data sources? Caution: I am an intermediate that has > never done cross-server or cross-domain communication. > > Thanks, > > Rob > > -- > Archives: http://www.eGroups.com/list/cf-talk > To Unsubscribe visit >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a >message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --9A550CA2DEBD45E5C2E080F0 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Hi You can try to connect to SQL server as usual. On ODBC page, under sql server name, use sql server IP (xxx.xxx.xxx.xxx) instead of server name (DB1). Under username, use this format SQLDomainName\UserName and whatever the password for that user. Tinh Tran Event411.com "Robert M. Saxon, Jr." wrote: I would really appreciate it of someone would give me a hand with this one... I have a server running IIS 4.0, CF 4.01, and SQL Server 7.0. I want to remove IIS and CF from that server and install it on a separate server. The catch is that the two servers (both NT 4) are in different domains (not trusted). Is there a way to connect the two machines so that the CF server can access the SQL data sources? Caution: I am an intermediate that has never done cross-server or cross-domain communication. Thanks, Rob -- Archives: http://www.eGroups.com/list/cf-talk">http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. --9A550CA2DEBD45E5C2E080F0-- __ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger. http://im.yahoo.com -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
Re: CF and SQL Server split
Should not be a problem. Have SQL Server running on a seperate machine. In the Cold Fusion administrator, create the datasource with the ip address of the sql server. Also, create a user in sql server for cold fusion to use. For example, create the user "internet" in the SQL server logins. Use this user for cold fusion to connect to sql server when you create the datasource. Jacob At 04:44 PM 4/17/00 -0400, you wrote: >I would really appreciate it of someone would give me a hand with this >one... > >I have a server running IIS 4.0, CF 4.01, and SQL Server 7.0. I want to >remove IIS and CF from that server and install it on a separate server. The >catch is that the two servers (both NT 4) are in different domains (not >trusted). Is there a way to connect the two machines so that the CF server >can access the SQL data sources? Caution: I am an intermediate that has >never done cross-server or cross-domain communication. > >Thanks, > >Rob -- Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
CF and SQL Server Reporting Services
Hi All, Does anyone have any experience of integrating CFMX and SQL Server Reporting services. I've managed to cobble something together, but I not happy with the lack of security (from the reporting services front) Has anyone managed to achieve a happy medium or have any advice? Many thanks, Gavin ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:194060 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54